Page Comparison

account

string

Snowflake account

“abc123.australia-east.azure”

username

string

Username to log into the snowflake account, if use_private_key is true, this must be the user associated to the private key

password

string

Password to log into the snowflake account, if use_private_key is true then this is the password/passphrase to that private key, if your private key for some reason is NOT encrypted, then you can leave this blank.

information_database

string

Database where all the required tables are located, generally this is snowflake

“snowflake”

role

string

The role to access the required account_usage tables, generally this is accountadmin

“accountadmin”

warehouse

string

The warehouse to execute the queries against

“xs_analytics”

databases

list<string>

A list of databases to extract from Snowflake

[“dwh”, “adw”]

login_timeout

integer

The max amount of time in seconds allowed for the extractor to establish and authenticate a connection, generally 5 is sufficient but if you have a slow network you can increase this up to 20

5

output_path

string

Absolute path to the output location where files are to be written

“/tmp/output”

mask

boolean

To enable masking or not

true

compress

boolean

To gzip the output or not

true

use_private_key

boolean

To use private key or not

true

private_key

string

The private key value as text, inclusive of the delimiter BEGIN and END with new lines denoted with \n, see example

host

string

The host value for snowflake that was onboarded in K

“abc123.australia-east.azure.snowflakecomputing.com”