Skip to main content

Snowflake Data Connector

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

Parameters

  • 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
  • snowflake_warehouse: optional, specifies the Snowflake Warehouse to use
  • snowflake_role: optional, specifies the role to use for accessing Snowflake data

Auth

The connector supports password-based and key-pair authentication that must be configured using spice login snowflake or using Secrets Stores. Login requires the account identifier ('orgname-accountname' format) - use Finding the organization and account name for an account instructions.

Password-based

spice login snowflake -a <account-identifier> -u <username> -p <password>

Key-pair (the <private-key-passphrase> is an optional parameter and is used for encrypted private key only)

spice login snowflake -a <account-identifier> -u <username> -k <path-to-private-key> -s <private-key-passphrase>

Learn more about File Secret Store.

Example

datasets:
- from: snowflake:snowflake_sample_data.tpch_sf1.lineitem
name: lineitem
params:
snowflake_warehouse: COMPUTE_WH
snowflake_role: accountadmin
Limitations
  1. Account identifier does not support the Legacy account locator in a region format. Use Snowflake preferred name in organization format.
  2. The connector supports password-based and key-pair authentication.