Procedure
- 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
option.
This opens the Connection definition dialog box.
-
Give the connection definition a Name, enter the
Account, User Id,
Password, Warehouse Name,
Schema (typically
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.
-
Click OK.
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.
Results
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.