Back to destination list
Official
Snowflake destination integration documentation
The snowflake plugin helps you sync data to your Snowflake data warehouse
Loading plugin documentation
The snowflake plugin helps you sync data to your Snowflake data warehouse
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
SNOWFLAKE_CONNECTION_STRING environment variable:kind: destination
spec:
name: snowflake
path: cloudquery/snowflake
registry: cloudquery
version: "v5.1.2"
write_mode: "append"
# Learn more about the configuration options at https://cql.ink/snowflake_destination
spec:
connection_string: "${SNOWFLAKE_CONNECTION_STRING}"
# Optional parameters
# migrate_concurrency: 1
# batch_size: 1000 # 1K entries
# batch_size_bytes: 4194304 # 4 MiB
batch_size and batch_size_bytes.kind: destination
spec:
name: snowflake
...
spec:
connection_string: "user:pass@account/db/schema?warehouse=wh"
kind: destination
spec:
name: snowflake
...
spec:
connection_string: "user@account/database/schema?warehouse=wh"
private_key: |
-----BEGIN PRIVATE KEY-----
MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC2ajPRIbPtbxZ1
3DONLA02eZJuCzsgIkBWov/Me5TL6cKN0gnY+mbA8OnNCH+9HSzgiU9P8XhTUrIN
85diD+rj6uK+E0sSyxGk6HG17TyR5oBq8nz2hbZlbaNi/HO9qYoHQgAgMq908YBz
...
DUmOIrBYEMf2nDTlTu/QVcKb
-----END PRIVATE KEY-----
kind: destination
spec:
name: snowflake
...
spec:
connection_string: "user@account/database/schema?warehouse=wh"
private_key: "${file:./private.key}"
-----BEGIN PRIVATE KEY-----
MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC2ajPRIbPtbxZ1
3DONLA02eZJuCzsgIkBWov/Me5TL6cKN0gnY+mbA8OnNCH+9HSzgiU9P8XhTUrIN
85diD+rj6uK+E0sSyxGk6HG17TyR5oBq8nz2hbZlbaNi/HO9qYoHQgAgMq908YBz
...
DUmOIrBYEMf2nDTlTu/QVcKb
-----END PRIVATE KEY-----
kind: destination
spec:
name: snowflake
...
spec:
connection_string: "user:pass@account/db/schema?warehouse=wh&authenticator=oauth&token=token"
openssl pkcs8 -topk8 -nocrypt -in enc.key -out dec.key
connection_string (string) (required)connection_string.# user[:password]@account/database/schema?warehouse=user_warehouse[¶m1=value1¶mN=valueN]
# or
# user[:password]@account/database?warehouse=user_warehouse[¶m1=value1¶mN=valueN]
# or
# user[:password]@host:port/database/schema?account=user_account&warehouse=user_warehouse[¶m1=value1¶mN=valueN]
# or
# host:port/database/schema?account=user_account&warehouse=user_warehouse[¶m1=value1¶mN=valueN]
account - Name assigned to your Snowflake account. If you are not on us-west-2 or AWS deployment, append the region and platform to the end, e.g., <account>.<region> or <account>.<region>.<platform>.private_key (string) (optional)authenticator=snowflake_jwt&privateKey=... to the connection_string but
parses, validates, and correctly encodes the key for use with snowflake.migrate_concurrency (integer) (optional) (default: 1)batch_size (integer) (optional) (default: 1000)batch_size_bytes (integer) (optional) (default: 4194304 (= 4 MiB))leave_stage_files (boolean) (optional) (default: false)number type, which can handle arbitrary precisionfloat typearray type, including both regular and fixed-size listsvariant type for semi-structured data storagetimestamp_tz (timestamp with timezone)text representation