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
Metadata
1 maintainer
Release files for vdk-snowflake 0.2.1156222304
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| vdk-snowflake-0.2.1156222304.tar.gz | 5.4 kB | Details |
Release files / vdk-snowflake-0.2.1156222304.tar.gz
| Download URL | vdk-snowflake-0.2.1156222304.tar.gz |
|---|---|
| Size | 5.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
7fdee2434c349048c4e9bfaac8aee1c372a79f8b7c3fc83066054ba4b31b415d
|
|
BLAKE2b-256 checksum How to use checksums |
f25b735ba192c1e4a89f393b252257251de6056634105fcf5ff4700f50474dda
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.13
|
