Query Snowflake

To query Snowflake with Flux:

1. Import the sql package.

2. Use sql.from() and provide the following parameters:

   • driverName: snowflake
   • dataSourceName: See data source name
   • query: SQL query to execute

import "sql"

sql.from(
    driverName: "snowflake",
    dataSourceName: "user:password@account/db/exampleschema?warehouse=wh",
    query: "SELECT * FROM example_table",
)

Snowflake data source name

The snowflake driver uses the following DSN syntaxes (also known as a connection string):

username[:password]@accountname/dbname/schemaname?param1=value1&paramN=valueN
username[:password]@accountname/dbname?param1=value1&paramN=valueN
username[:password]@hostname:port/dbname/schemaname?account=<your_account>&param1=value1&paramN=valueN

Snowflake to Flux data type conversion

sql.from() converts Snowflake data types to Flux data types.