Snowflake Data Connector

Snowflake Data Connector Documentation

The Snowflake Data Connector enables federated SQL queries across datasets in the Snowflake Cloud Data Warehouse.

datasets:
  - from: snowflake:DATABASE.SCHEMA.TABLE
    name: table
    params:
      snowflake_warehouse: COMPUTE_WH
      snowflake_role: accountadmin

Configuration

`from`

A Snowflake fully qualified table name (database.schema.table). For instance snowflake:SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.LINEITEM or snowflake:TAXI_DATA."2024".TAXI_TRIPS

`name`

The dataset name. This will be used as the table name within Spice.

`params`

Parameter Name	Description
`snowflake_warehouse`	Optional, specifies the Snowflake Warehouse to use
`snowflake_role`	Optional, specifies the role to use for accessing Snowflake data
`snowflake_account`	Required, specifies the Snowflake account-identifier
`snowflake_username`	Required, specifies the Snowflake username to use for accessing Snowflake data
`snowflake_password`	Optional, specifies the Snowflake password to use for accessing Snowflake data
`snowflake_private_key_path`	Optional, specifies the path to Snowflake private key
`snowflake_private_key_passphrase`	Optional, specifies the Snowflake private key passphrase

Auth

The connector supports password-based and key-pair authentication. Login requires the account identifier ('orgname-accountname' format) - use Finding the organization and account name for an account instructions.

Example

datasets:
  - from: snowflake:SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.LINEITEM
    name: lineitem
    params:
      snowflake_warehouse: COMPUTE_WH
      snowflake_role: accountadmin