Hundreds of industry leaders use Hightouch to turn Snowflake into a marketing, sales, success and operational engine
You'll need to allowlist Hightouch's IP addresses to allow our systems to contact your warehouse. Reference our docs to determine which IPs you need to allowlist.
CREATE ROLE IF NOT EXISTS ht_readonly_role COMMENT = "Read only access to select tables for Hightouch";
<>with actual values:
CREATE USER ht_user password = '<a_very_secure_password>' first_name = 'Hightouch' last_name = 'User' default_warehouse = '<warehouse>' default_namespace = '<database.schema>' default_role = '<ht_readonly_role>' comment = 'Used for Hightouch integrations'
GRANT ROLE ht_readonly_role TO ROLE SYSADMIN; GRANT USAGE ON WAREHOUSE <warehouse> TO ROLE ht_readonly_role; GRANT ROLE ht_readonly_role TO USER ht_user; GRANT USAGE ON DATABASE "<database>" TO ROLE ht_readonly_role; GRANT USAGE ON SCHEMA "<database>"."<schema>" TO ROLE ht_readonly_role; GRANT SELECT ON ALL TABLES IN SCHEMA "<database>"."<schema>" TO ROLE ht_readonly_role; GRANT SELECT ON FUTURE TABLES IN SCHEMA "<database>"."<schema>" TO ROLE ht_readonly_role; GRANT SELECT ON ALL VIEWS IN SCHEMA "<database>"."<schema>" TO ROLE ht_readonly_role; GRANT SELECT ON FUTURE VIEWS IN SCHEMA "<database>"."<schema>" TO ROLE ht_readonly_role;
roles: - ht_readonly_role: warehouses: - <warehouse> privileges: databases: read: - <database> schemas: read: - <database>.* tables: read: - <database>.*.* users: - ht_user: can_login: yes member_of: - ht_readonly_role
In Hightouch, go to Sources or click https://app.hightouch.com/sources
Click "Create Source"
For Account, enter your Snowflake account. Usually, this is in the format
<identifier>.<region>.<cloud provider>, e.g.
abc123.us-east-2.aws). See the Snowflake docs for more information.
For Database, enter your Snowflake database name.
For Username, enter your Snowflake username, e.g. ht_user
For Password, enter your Snowflake user's password.
For Role, enter the Role that Hightouch should use for queries, e.g. ht_readonly_role. Use DEFAULT to use the default role. A default role must be set for the user for this to work.
Click "Test" to test the connection. Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page
$ openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 $ openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub
alter user ht_user set rsa_public_key='MIIBIjANBgkqh...';
Authentication Methodof the Snowflake Source settings, select
RSA Private Keyand drop your private key you just generated into the
Private Key Filefield
- 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.