Error when selecting any column via SQL

Get Help
1

Hey there,

We used Stitch to import data from HubSpot into our data warehouse. The target database has private schema. I am able to select all columns by using select * from schema.table, but when I try selecting or joining on a column I keep getting the error that the column des not exist.

ERROR: column a.emailcampaignid does not exist Hint: Perhaps you meant to reference the column "a.emailCampaignId". Position: 127

2

Hi @komsinica
Without seeing your query or which database type you're querying, then it's hard to tell.
Depending on which database type you're querying, then some will fail unless casing is correct.
Since you're having problems with simple SQL, then I would expect same behavior in any other tool.