 | Snowflake
For extracting data from Snowflake |
The tap-snowflake Meltano extractor pulls data from Snowflake that can then be sent to a destination using a loader.
Other Available Variants
- transferwise (default)
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 test
meltano add extractor tap-snowflakemeltano config tap-snowflake set --interactivemeltano test tap-snowflakeNext 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 fortap-snowflakeThis 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
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)
Database Name (dbname)
-
Environment variable:
TAP_SNOWFLAKE_DBNAME
Snowflake Database name
User (user)
-
Environment variable:
TAP_SNOWFLAKE_USER
Snowflake User
Password (password)
-
Environment variable:
TAP_SNOWFLAKE_PASSWORD
Snowflake Password
Warehouse (warehouse)
-
Environment variable:
TAP_SNOWFLAKE_WAREHOUSE
Snowflake virtual warehouse name
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.
Role (role)
-
Environment variable:
TAP_SNOWFLAKE_ROLE
Snowflake role to use. If not defined then the user's default role will be used.
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.
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.
Insecure Mode (insecure_mode)
-
Environment variable:
TAP_SNOWFLAKE_INSECURE_MODE -
Default Value:
false
Use insecure mode to avoid "Failed to get OCSP response" warnings.
Something missing?
This page is generated from a YAML file that you can contribute changes to.
Edit it on GitHub!Looking for help?
#plugins-generalInstall
meltano add extractor tap-snowflakeHomepage
Maintenance Status
-brightgreen){kind=icon}
Maintainer
Meltano Stats
-152-c0c0c4){kind=icon}
-19-c0c0c4){kind=icon}
Keywords
