Prefect integrations for interacting with Snowflake.
Project description
prefect-snowflake
Welcome!
Prefect integrations for interacting with prefect-snowflake.
Getting Started
Python setup
Requires an installation of Python 3.7+.
We recommend using a Python virtual environment manager such as pipenv, conda or virtualenv.
These tasks are designed to work with Prefect 2.0. For more information about how to use Prefect, please refer to the Prefect documentation.
Installation
Install prefect-snowflake
with pip
:
pip install prefect-snowflake
Write and run a flow
from prefect import flow
from prefect_snowflake import SnowflakeCredentials
from prefect_snowflake.database import snowflake_query
@flow
def snowflake_query_flow():
snowflake_credentials = SnowflakeCredentials(
account="account",
user="user",
password="password",
)
result = snowflake_query(
"SELECT * FROM table WHERE id=%{id_param}s LIMIT 8;",
snowflake_credentials,
params={"id_param": 1}
)
return result
snowflake_query_flow()
Resources
If you encounter any bugs while using prefect-snowflake
, feel free to open an issue in the prefect-snowflake repository.
If you have any questions or issues while using prefect-snowflake
, you can find help in either the Prefect Discourse forum or the Prefect Slack community.
Development
If you'd like to install a version of prefect-snowflake
for development, clone the repository and perform an editable install with pip
:
git clone https://github.com/PrefectHQ/prefect-snowflake.git
cd prefect-snowflake/
pip install -e ".[dev]"
# Install linting pre-commit hooks
pre-commit install
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for prefect_snowflake-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fefa9b4818d5edee1c4bee2bcaf7b241ec2af5ac64ba10e6d6acc9f663f26ccb |
|
MD5 | 983dc283595af78b492ab77a09d6d4a3 |
|
BLAKE2b-256 | 7d063e7da2b2fe4f2442fca49f809959fcdfa673b3435cc35db57079161d44f7 |