Versatile Data Kit Plugin for Snowflake Support
This plugin provides functionality, used by the Versatile Data Kit to interact with a Snowflake instance. Users of the plugin can connect to Snowflake, and execute queries against it.
Instalation
To install the plugin, open a terminal and type
pip install --upgrade vdk-snowflake
Usage
In order to use the plugin, once it has been installed, there are a few environment variables that need to be set.
The following environment variables are required:
\\ Set default database plugin to be used
VDK_DB_DEFAULT_TYPE=SNOWFLAKE
\\ Set the username that is to be used.
VDK_SNOWFLAKE_USER=<some_username>
\\ Set the password that is to be used.
VDK_SNOWFLAKE_PASSWORD=<user_password>
\\ Set the account name that is to be used.
\\ NOTE: Do NOT include the '.snoflakecomputing.com' part of the account name.
VDK_SNOWFLAKE_ACCOUNT=<account_name_provided_by_snowflake>
The following environment variables are optional, and can be overwritten from within the data job.
\\ The default warehouse to be used.
VDK_SNOWFLAKE_WAREHOUSE=<default_warehouse>
\\ The default database to be used.
VDK_SNOWFLAKE_DATABASE=<default_database>
\\ The default database schema to be used.
VDK_SNOWFLAKE_SCHEMA=<default_schema>
After configuring the environment variables, to use the plugin, create a data job, and add the queries you want to execute in .sql files. When the job executed, Versatile Data Kit will execute the queries in the order specified in the User Guide.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file vdk-snowflake-0.2.1156222304.tar.gz.
File metadata
- Download URL: vdk-snowflake-0.2.1156222304.tar.gz
- Upload date:
- Size: 5.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.2 CPython/3.10.13
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
7fdee2434c349048c4e9bfaac8aee1c372a79f8b7c3fc83066054ba4b31b415d
|
|
| MD5 |
e4cc83ea3cca7261ef4b0b9d69c0b74b
|
|
| BLAKE2b-256 |
f25b735ba192c1e4a89f393b252257251de6056634105fcf5ff4700f50474dda
|
