Example
This example Application demonstrates how to read customer information from a table in a Snowflake Database using the Snowflake Connector.
You can download the files here to try it out for yourself - adjusting the steps to use your own Snowflake credentials.
From the Properties blade of the widget to which the Snowflake Connector will be linked, a data grid in our example, select the Data Source tab.
Click the plus icon next to Data Source, then the plus icon next to Connection, and select the Snowflake Connector.
Enter a name for the Connection. In this case, set the name to SFTestConnector.
Enter the authentication details: the Organisation, Account Name, User Name, and Password. In this case, tick to use variables.
Select the database and click Save. Use the MYDB database for this example.
If there is a need to select data from multiple tables, tick the Specify SQL Query option. You would provide the query in step 4 when using the Connection.
Select the Connection that was just created, enter the Data Source name, and select the entity to read. Save the Data Source.
In this case, set the name to CustomerData and the entity to MYSCHEMA.CUSTOMER.
Note that the primary key is auto-populated once the entity is selected.
Select the Data Source we just added, and save the Application.
Click the launch button and view the results. Observe that customer data is returned from the Snowflake database.
File | Link | Security Key |
|---|---|---|
Application | Snowflake Connector.xapp | SFEx-001 |
Last modified 10mo ago