# Snowflake Data Warehouse

target-snowflake is a loader that works with other extractors in order to move data into a Snowflake database.


Please note that querying in the Meltano UI is not supported, yet. You can follow the progress on this feature in this issue: meltano/meltano#428

# Info

# Installing from the Meltano UI

From the Meltano UI, you can select this Loader in Step 3 of your pipeline configuration.

# Configuration

Once the loader has installed, a modal will appear that'll allow you to configure your Snowflake connection.

# Installing from the Meltano CLI

  1. Navigate to your Meltano project in the terminal
  2. Run the following command:
meltano add loader target-snowflake

If you are successful, you should see Added and installed loaders 'target-snowflake' in your terminal.

# CLI Configuration

  1. Open your project's .env file in a text editor
  2. Add the following variables to your file:
export SF_ACCOUNT=""
export SF_USER=""
export SF_PASSWORD=""
export SF_ROLE=""       # in UPPERCASE
export SF_DATABASE=""   # in UPPERCASE
# export SF_SCHEMA=""   # override if the default (see below) is not appropriate
  • SF_ACCOUNT - This is the account name which is derived from the URL. More info can be found on the Snowflake docs
  • SF_USER - This is the username for the user that will be used for loading data
  • SF_PASSWORD - This is the password for the user that will be used for loading data
  • SF_ROLE - This is the role you want to use for your account for loading the data
  • SF_DATABASE - The name of the Snowflake database you want to use
  • SF_WAREHOUSE - The name of the Snowflake warehouse you want to use
  • SF_SCHEMA - The name of the Snowflake schema you want to use. The default value is $MELTANO_EXTRACT__LOAD_SCHEMA, which will expand to the value of the load_schema extra for the extractor used in the pipeline, which defaults to the extractor's namespace, e.g. tap_gitlab for tap-gitlab. Values are automatically converted to uppercase before they're passed on to the plugin, so tap_gitlab becomes TAP_GITLAB.