Skip to content

Latest commit

 

History

History
69 lines (50 loc) · 3.47 KB

snowflake.md

File metadata and controls

69 lines (50 loc) · 3.47 KB
description
Snowflake Data Connector Documentation

Snowflake Data Connector

import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem';

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

{% hint style="info" %} Hint Unquoted table identifiers should be UPPERCASED in the from field. See Identifier resolution. {% endhint %}

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

{% hint style="warning" %} 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.

{% endhint %}