To set up data lake, users can follow the same steps mentioned to create AWS S3, Azure Blob or GCS.
To set up Snowflake as data warehouse, you need to follow below steps
1. Navigate to Settings.
2. Click on Destination
3. Click on Setup Data Warehouse.
4. Insert all the data warehouse specific credentials, along with a name and description for the connection.
5. Click on Validate
and then Create
to save the data warehouse connection.
Host | Snowflake account locator |
Role | Role to access Snowflake |
Warehouse | Warehouse to sync the data into |
Database | Database to sync the data into |
Default Schema | Default schema |
Username | Username to access the database |
Authentication Method | Authorization method |
Password | Password associated with the username |
JDBC URL Params | Additional properties to pass JDBC URL string when connecting to database |
Raw Table Schema Name | Schema to write raw data into |
Disable Final Tables | Disable / Enable writing final tables |
Enable Loading Data Incrementally To Final Tables | Disable / Enable to load data incrementally while the data is being synced |
Data Retention Period | Number of days of Snowflake time travel to enable the tables |