hightouch_planner. The user that Hightouch uses to connect to your warehouse must have permissions to create this schema, and create tables within it.
GRANT CREATE SCHEMA ON DATABASE <your_database> TO <hightouch_role>
bigquery.datasets.createpermission to the Hightouch user.
GRANT CREATE ON DATABASE <your_database> TO <hightouch_user>
Create the schema by running the following SQL
CREATE SCHEMA hightouch_planner
Give your GCP service account access to run jobs and list the schema by granting it the following roles:
Give your GCP service account access to manage tables within the
hightouch_plannerschema by running the following SQL
GRANT `roles/bigquery.dataViewer`, `roles/bigquery.dataEditor` ON SCHEMA hightouch_planner TO "serviceAccount:$USER@$PROJECT.iam.gserviceaccount.com"
- Connection issues with your data warehouse?
- Confusing API responses from destination systems?
- Unsupported destination objects or modes?
- Help with complex SQL queries?
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.