Sources
Snowflake
Learn how to connect to a Snowflake data source.
Before You Start
Make sure that you have already set up a dedicated User
and Role
for our syncing service to access your Snowflake data warehouse.
Example User/Role Creation Template
How do I Set Up Snowflake as a Source?
Connect a Source
- Log in to your Desintation App.
- Navigate to the integrations portal.
- Click New Sync.
- Choose Snowflake.
- Input the following details:
- Display Name: A descriptive, human-readable name for this data source
- Username: This can be your personal username or you can create a dedicated user for syncing
- Password: The password for your syncing user
- Database Name: The name of the Snowflake database to sync from
- Warehouse Name: The name of the warehouse used to run syncs in Snowflake
- Role: The role name used to run syncs
- Host: Your Snowflake url (e.g.,
abc123.us-east1.gcp.snowflakecomputing.com
)
- Click Test to validate the connection.
- Click Continue.
Choose an Object to sync
- Select an Object you want to create in the Destination App from your pulled data. The Object describes the expected format of the data in the Destination App.
- Select a table to pull data from by providing the following information:
- Namespace: The dataset ID within your poject (e.g.,
my-namespace
inproject-name.my-namespace
) - Table: The name of the table in your namespace that you want to pull data from. The columns in this table will be mapped to the Object you selected.
- Namespace: The dataset ID within your poject (e.g.,
- Select Preview to see a sample of your table’s data.
- Click Continue.
Map Fields
For each field of the chosen Object, select one of the columns in your source table to map to it.