Prerequisites 

Gtmhub can connect to your Snowflake Data Warehouses in Microsoft Azure or Amazon AWS. 

Snowflake user

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.


Did this answer your question?