Creating a Native Connection to Snowflake
- Look at the native connection in the Project repository.
- Find the Metadata section and locate the Snowflake icon.
Right-click and select the Create Snowflake menu
This opens the Connection definition dialog box.
Give the connection definition a Name, enter the
Account, User Id,
Password, Warehouse Name,
PUBLIC), and a Database Name.Initially the parameters are filled in manually to establish a valid connection, but it is a best practice to convert this into a Context Group with variables assigned to the connection parameters.
- Click Advanced, then ensure that the Login Timeout, Tracing, and Role settings are suitable.
The following example shows the dialog box once it has been exported as a Context Group.
Once a context group is created, test each connection to ensure validity.
It is advisable to test connections before exporting them as a context, however once the context group is created, you can set up different contexts by environment (a best practice).
- Once a valid connection is made, click Next.
Select the tables of interest then click Finish.
The result is a Snowflake connection definition usable in Talend Jobs that allows access to the selected tables. You can see these listed in the Project Repository under the connection definition.