Data Source Details
Use the following information when creating a data source for your Snowflake database:
The JDBC URL must be in the following format:
Basic authentication is supported. Specify
If you use native authentication inside your cloud platform (for example, Google Cloud Platform, Amazon Web Services, or Microsoft Azure), you do not have to provide the username and password.
GoodData Cloud Native (GoodData.CN) uses the driver with version 3.12.9.
If your database holds a large amount of data, consider the following practices:
Denormalize the relational data model of your database.
This helps avoid large JOIN operations. Because Snowflake is a columnar database, queries read only the required columns and each column is compressed separately.
Spin up databases/instances based on user needs.
- Users with similar needs populate data into caches that are likely reused.
- Isolate data transformation operations running in your database from the analytics generated by GoodData.CN.
Set up proper auto-scaling based on users needs.