# 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
# Installing from the Meltano UI
From the Meltano UI, you can select this Loader in Step 3 of your pipeline configuration.
Once the loader has installed, a modal will appear that'll allow you to configure your Snowflake connection.
# Installing from the Meltano CLI
- Navigate to your Meltano project in the terminal
- 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
- Open your project's
.envfile in a text editor
- 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_WAREHOUSE="" # 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_schemaextra for the extractor used in the pipeline, which defaults to the extractor's namespace, e.g.
tap-gitlab. Values are automatically converted to uppercase before they're passed on to the plugin, so