Snowflake

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.

HostSnowflake account locator
RoleRole to access Snowflake
WarehouseWarehouse to sync the data into
DatabaseDatabase to sync the data into
Default SchemaDefault schema
UsernameUsername to access the database
Authentication MethodAuthorization method
PasswordPassword associated with the username
JDBC URL ParamsAdditional properties to pass JDBC URL string when connecting to database
Raw Table Schema NameSchema to write raw data into
Disable Final TablesDisable / Enable writing final tables
Enable Loading Data Incrementally To Final TablesDisable / Enable to load data incrementally while the data is being synced
Data Retention PeriodNumber of days of Snowflake time travel to enable the tables