Snowflake Data Warehouse

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

WARNING

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_WAREHOUSE=""  # in UPPERCASE
  • 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
Last Updated: 10/7/2019, 5:23:46 AM