Snowflake
Connect & Ingest data from / to a Snowflake database
Setup
The following credentials keys are accepted:
account
(required) -> The hostname or account the instance (eg.pua90768.us-east-11
)user
(required) -> The username to access the instancedatabase
(required) -> The database name of the instancepassword
(optional) -> The password to access the instanceschema
(optional) -> The default schema to userole
(optional) -> The role to access the instancewarehouse
(optional) -> The warehouse to usepasscode
(optional) -> Specifies the passcode provided by Duo when using multi-factor authentication (MFA) for login.authenticator
(optional) -> Specifies the authenticator to use to login (e.g.snowflake_jwt
,externalbrowser
).private_key
(optional since v1.2.19) -> Specifies the private key body or file path to use.private_key_passphrase
(optional) -> Specifies the private key file passphrase.max_chunk_download_workers
(optional) -> Specifies the Maximum Number of Result Set Chunk Downloader (integer
).custom_json_decoder_enabled
(optional) -> Specifies to use the Custom JSON Decoder for Parsing Result Set (true
orfalse
).copy_method
(optional) -> Specifies to use the platform to use for loading/unloading (DEFAULT
,AWS
,AZURE
). ForAWS
orAZURE
, you'll need to provide the necessary credentials, such asaws_bucket
,aws_access_key_id
andaws_secret_access_key
, for AWS, orazure_account
,azure_container
andazure_sas_svc_url
for AZURE.
Using sling conns
sling conns
Here are examples of setting a connection named SNOWFLAKE
. We must provide the type=snowflake
property:
Environment Variable
Sling Env File YAML
See here to learn more about the sling env.yaml
file.
If you are facing issues connecting, please reach out to us at support@slingdata.io, on discord or open a Github Issue here.
Last updated