Snowflake Database
Snowflake offers a cloud-based data storage and analytics service, generally termed "data-as-a-service". It allows users to store and analyze data using cloud-based hardware and software.
The Snowflake service's main features are separation of storage and compute, on-the-fly scalable compute, data sharing, data cloning, and support for third-party tools.
To create a connection to the Snowflake Database Data Source, right-click on the Data Sources group, click “Snowflake”, and then select “Snowflake Database”.
To successfully retrieve data from a Snowflake Database Data source, the following properties need to be set.
|
Name that descriptively identifies the consumer. |
|
Your Snowflake Account Name. This is the first part of your host URL. In the example, the host URL is: beszuvm-la14343.snowflakecomputing.com. The Account details will be beszuvm-la14343 |
|
Your host URL i.e. beszuvm-la14340.snowflakecomputing.com. |
|
Name of the database to be used. |
|
Your Snowflake accounts' Username. *Note - Currently the Snowflake Consumer does not support MFA. It is advised to create a purposeful service account for Flow to use to connect to Snowflake |
|
Yor Snowflake accounts' password. |
|
Permitted time to connect to the Snowflake database. The default is 15 seconds. |
|
Use a definition file to populate insert queries. |
|
Maximum concurrent connections allowed against the Snowflake database. |
|
Option to have millisecond or nanosecond resolution |