Documentation

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.

Snowflake data type Flux data type
FIXED, NUMBER int or float (depending on decimal size)
REAL, FLOAT float
TIMESTAMP_TZ, TIMESTAMP_LTZ time
BOOLEAN bool

All other Snowflake data types (including TIMESTAMP_NTZ, DATE and TIME) are converted to strings.


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.