Skip to main content

Versatile Data Kit SDK plugin provides support for snowflake databases.

Project description

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

vdk-snowflake-0.2.824443273.tar.gz (5.4 kB view details)

Uploaded Source

File details

Details for the file vdk-snowflake-0.2.824443273.tar.gz.

File metadata

  • Download URL: vdk-snowflake-0.2.824443273.tar.gz
  • Upload date:
  • Size: 5.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.10

File hashes

Hashes for vdk-snowflake-0.2.824443273.tar.gz
Algorithm Hash digest
SHA256 604171e243803667a5c47abd5118c70a2cbe1e0929b1eaa7a6d7f9a6d984a60b
MD5 5757bf0e647af2a7ddae087c76687955
BLAKE2b-256 f0beb0fb2756570953a46e7f764885692318f87406c61cb6cffe3f47adac6cb3

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page