Comment on page

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.
Refer to configuration to understand all configuration options of this Connector.

Step 1: Add the Connection

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.

Step 2: Configure Server

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.

Step 3: Configure Database

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.

Step 4: Use 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.

Step 5: Use the Data Source

Select the Data Source we just added, and save the Application.

Step 6: Results

Click the launch button and view the results. Observe that customer data is returned from the Snowflake database.

Files

File
Link
Security Key
Application
Snowflake Connector.xapp
SFEx-001
See the Import, Export, and Clone - XMPro article for steps to import an Application.