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
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.
meltano add loader target-snowflake
If you are successful, you should see
Added and installed loaders 'target-snowflake' in your terminal.
.envfile in a text editor
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
$MELTANO_EXTRACTOR_NAMESPACE, which will expand to the
extractorused in the pipeline, e.g.