Gtmhub can connect to your Snowflake Data Warehouses in Microsoft Azure or Amazon AWS.
The connection uses username and password over a secure channel. It is recommended that you create a new user for Gtmhub and limit its read permissions only to data you want to sync with Gtmhub. For more information on creating users in Snowflake check out this article: Snowflake Documentation | Create User. Here is a quick example:
CREATE USER gtmhubsync PASSWORD = '********' DEFAULT_ROLE = "PUBLIC" DEFAULT_WAREHOUSE = "COMPUTE_WH" MUST_CHANGE_PASSWORD = FALSE;
The above SQL statement will create gtmhubsync user with default role and warehouse. Make sure you use strong password for this user. You can generate strong passwords using https://randomkeygen.com/
How to connect
To create a connection click on the Insights drop down menu > Data sources choose Add new data source. Select Snowflake from the Database category. Provide the following information:
- User - The user account to authenticate as.
- Password - Password of the user you are authenticating as.
- Account URL - The URL to your snowflake account. E.g. if account is AWS instance it should look like https://account.region.snowflakecomputing.com.
- Warehouse - The name of your Snowflake warehouse.
- Database - The name of the database you want to connect to
- Database schema - The name of the schema to connect to.
All you need to do now is select the data you want to sync and choose the sync schedule.