Snowflake Config plugin pulls configuration information out of Snowflake and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v5.2.3
Type
Source
Platforms
Date Published
Loading plugin documentation
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
SNOWFLAKE_CONNECTION_STRING environment variable:kind: source
spec:
name: snowflake-config
path: cloudquery/snowflake-config
registry: cloudquery
version: "v5.2.3"
# Learn more about the configuration options at https://cql.ink/snowflake-config_source
spec:
connection_string: "${SNOWFLAKE_CONNECTION_STRING}"
# Optional parameters
# private_key: ""
# concurrency: 10000
kind: source
spec:
name: snowflake-config
# ...
spec:
connection_string: "user:pass@account"
kind: source
spec:
name: snowflake-config
# ...
spec:
connection_string: "user@account"
private_key: |
-----BEGIN PRIVATE KEY-----
MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC2ajPRIbPtbxZ1
3DONLA02eZJuCzsgIkBWov/Me5TL6cKN0gnY+mbA8OnNCH+9HSzgiU9P8XhTUrIN
85diD+rj6uK+E0sSyxGk6HG17TyR5oBq8nz2hbZlbaNi/HO9qYoHQgAgMq908YBz
...
DUmOIrBYEMf2nDTlTu/QVcKb
-----END PRIVATE KEY-----
kind: source
spec:
name: snowflake-config
# ...
spec:
connection_string: "user@account"
private_key: "${file:./private.key}"
-----BEGIN PRIVATE KEY-----
MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC2ajPRIbPtbxZ1
3DONLA02eZJuCzsgIkBWov/Me5TL6cKN0gnY+mbA8OnNCH+9HSzgiU9P8XhTUrIN
85diD+rj6uK+E0sSyxGk6HG17TyR5oBq8nz2hbZlbaNi/HO9qYoHQgAgMq908YBz
...
DUmOIrBYEMf2nDTlTu/QVcKb
-----END PRIVATE KEY-----
connection_string (string) (required)connection_string.# user[:password]@account
# or
# 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.concurrency (integer) (optional) (default: 10000)
A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.scheduler (string) (optional) (default: dfs)
The scheduler to use when determining the priority of resources to sync.
Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.