Back to destination list
Official
Snowflake
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: "v4.5.4"
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)