The tap-snowflake extractor pulls data from Snowflake that can then be sent to a destination using a loader.
Alternate Implementations
Getting Started
Prerequisites
If you haven't already, follow the initial steps of the Getting Started guide:
Installation and configuration
-
Add the tap-snowflake extractor to your
project using
:meltano add -
Configure the tap-snowflake
settings using
:meltano config -
Test that extractor settings are valid using
:meltano config
meltano add extractor tap-snowflake --variant transferwisemeltano config tap-snowflake set --interactivemeltano config tap-snowflake testNext steps
Follow the remaining steps of the Getting Started guide:
If you run into any issues, learn how to get help.
Capabilities
The current capabilities for
tap-snowflake
may have been automatically set when originally added to the Hub. Please review the
capabilities when using this extractor. If you find they are out of date, please
consider updating them by making a pull request to the YAML file that defines the
capabilities for this extractor.
This plugin has the following capabilities:
- catalog
- discover
- state
You can
override these capabilities or specify additional ones
in your meltano.yml by adding the capabilities key.
Settings
The
tap-snowflake settings that are known to Meltano are documented below. To quickly
find the setting you're looking for, click on any setting name from the list:
You can also list these settings using
with the meltano configlist
subcommand:
meltano config tap-snowflake list
You can
override these settings or specify additional ones
in your meltano.yml by adding the settings key.
Please consider adding any settings you have defined locally to this definition on MeltanoHub by making a pull request to the YAML file that defines the settings for this plugin.
Account (account)
-
Environment variable:
TAP_SNOWFLAKE_ACCOUNT
Snowflake account name (i.e. rtXXXXX.eu-central-1)
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set account [value]Database Name (dbname)
-
Environment variable:
TAP_SNOWFLAKE_DBNAME
Snowflake Database name
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set dbname [value]Insecure Mode (insecure_mode)
-
Environment variable:
TAP_SNOWFLAKE_INSECURE_MODE -
Default Value:
false
Use insecure mode to avoid "Failed to get OCSP response" warnings.
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set insecure_mode [value]Password (password)
-
Environment variable:
TAP_SNOWFLAKE_PASSWORD
Snowflake Password
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set password [value]Private Key Passphrase (private_key_passphrase)
-
Environment variable:
TAP_SNOWFLAKE_PRIVATE_KEY_PASSPHRASE
The private key passphrase used for authenticating using Key Pair authentication instead of user/pass.
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set private_key_passphrase [value]Private Key Path (private_key_path)
-
Environment variable:
TAP_SNOWFLAKE_PRIVATE_KEY_PATH
A path to your private key used for authenticating using Key Pair authentication instead of user/pass.
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set private_key_path [value]Role (role)
-
Environment variable:
TAP_SNOWFLAKE_ROLE
Snowflake role to use. If not defined then the user's default role will be used.
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set role [value]Tables (tables)
-
Environment variable:
TAP_SNOWFLAKE_TABLES
A comma separated list of the table names that you want to sync. The table names should be fully qualified including the db and schema name. For example, syncing table1 and table2 would look like db.schema.table1,db.schema.table2.
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set tables [value]User (user)
-
Environment variable:
TAP_SNOWFLAKE_USER
Snowflake User
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set user [value]Warehouse (warehouse)
-
Environment variable:
TAP_SNOWFLAKE_WAREHOUSE
Snowflake virtual warehouse name
Configure this setting directly using the following Meltano command:
meltano config tap-snowflake set warehouse [value]Something missing?
This page is generated from a YAML file that you can contribute changes to.
Edit it on GitHub!Looking for help?
#plugins-general-brightgreen){kind=icon}
-3-c0c0c4){kind=icon}
