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