You can create a Snowflake Source Connector to read from multiple tables within your Snowflake, using Snowflake's key pair authentication.
To set up this Source Connector, you will need to configure key pair authentication for your Snowflake account and provide the private key. To learn more about configuring key pair authentication within Snowflake, visit:https://docs.snowflake.com/en/user-guide/key-pair-auth.html
The schema for this Source Connector is defined by the selected columns from the query.
- Private Key
- Account Name
- User Name (with appropriate privileges)
Step 1: Click New Connector
Step 2: Under the System prompt, click Snowflake
Step 3: Enter a Connector Name.
Step 4: Select Source Connector.
Step 1: Provide a private Snowflake key in PEM format as shown below:
Step 1: Provide your Snowflake account name in this format
Step 2: Enter User Name.
Step 3: Provide the name of the warehouse that will execute the query you provide below.
Provide a query to access the data in your Snowflake. You can query against multiple tables, and your query can be as complex as you need it to be.