version: 1.0.0
Category: Data Warehouse
Tier: 2
Type: Source, Target
Authentication:
Basic (Username and Password)
Supported Save Mode as Target:
Append
Overwrite
See: Target Connector Save Modes
Connection Properties
Name | Mandatory | Description |
---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Username | Yes | Username used for authentication |
Password | Yes | Password used for Authentication |
Account | Yes | Your Snowflake Account. See https://docs.snowflake.com/en/user-guide/admin-account-identifier |
Warehouse | Yes | The Warehouse used for the connection |
Role | No | What Role to when authenticating to Snowflake |
Reading Objects
The Connection objects are displayed with the format Database/Schema/Table
Snowflake view
Pipeline Example:
Let’s use Salesforce as a source and Snowflake as a target
Snowflake