The target-snowflake Singer target sends data into Snowflake data warehouse after it was pulled from a source using a Singer tap.

Alternative variants

Multiple variants of target-snowflake are available. This document describes the meltano variant.

Alternative variants are:

Standalone usage

Install the package using pip:

pip install git+https://gitlab.com/meltano/target-snowflake.git

For additional instructions, refer to the README in the repository.

Usage with Meltano

Install Meltano, create your Meltano project, and add the target to your project as a loader:

meltano add loader target-snowflake --variant meltano

For additional instructions, refer to the Meltano-specific documentation for target-snowflake.

Capabilities

Settings

account

Account Name in Snowflake (https://.snowflakecomputing.com)

username

The username you use for logging in

password

The password you use for logging in

role

Role to be used for loading the data, e.g. LOADER. Also this role is GRANTed usage to all tables and schemas created

database

The name of the Snowflake database you want to use

warehouse

The name of the Snowflake warehouse you want to use

schema

batch_size

How many records are sent to Snowflake at a time?

timestamp_column

Name of the column used for recording the timestamp when Data are uploaded to Snowflake.

Looking for help?

If you're having trouble getting target-snowflake to work by itself or with Meltano, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page?

This page is generated from a YAML file that you can contribute changes to! It is also validated against a JSON Schema used for taps and targets.