Snowflake Connector

Stable Version 1.0.2 (OutSystems 11)
Published on 12 October 2020 by 
Stable Version 1.0.2 (OutSystems 11)
Published on 12 October 2020 by 
Created on 24 August 2020

Snowflake Connector

Documentation

Using the Snowflake connector you can execute Snowflake SQL statements, to read, insert, delete or update data in Snowflake.

The sample application allows you to define and store these queries including the properties to  connect to the Snowflake database.

To learn how to use this connector, you first have to setup a free trail Snowlake account.

A) SETUP A 30-DAY FREE TAIL SNOWFLAKE ACCOUNT

1. Go to https://signup.snowflake.com/, and the following form will be displayed:
2. Enter the form details and press Continue, the following form is shown:

3. Select Standard Edition, a region of your choice and enter your phone number. Check the checkbox, and press Get Started.

4. The following popup will be shown, your Snowflake account is being setup, this can take some seconds to a minute..

5. When the setup is completed the header of the popup changes, and it is time to check your email box for the registration email that Snowflake sent, my personal experience was that it took some minutes before it arrived in my mailbox, so be a little patience.

6. When the email arrived, open it and press the Click to activate button in the Snowflake registration email that you received.



B) LOGIN TO SNOWFLAKE WITH YOUR NEW ACCOUNT

Notice that after login several database do exist in your account. In the following instructions, the SNOWFLAKE_SAMPLE_DATA  database is used.

Within the database the schema TPCH_SF1 and within that the table CUSTOMER.

On the right site you can click the Select schema button to show a popup with some rela


C) ADD & EXECUTE QUERIES USING THE DEMO APPLICATION

1.  Install the Snowflake connector and demo application

2.  Start the demo application.
3. Press the + Add Query + button

4. The following screen is shown, notice you only need to fill in the mandatory fields to execute queries.

5. Fill in the properties as follows:

  • Query:  SELECT TOP 10 FROM CUSTOMER;
  • Host: the hostname shown in the browser url when you have snowflake open: http://<account>.<region>.snowflakecomputing.com
  • Database: SNOWFLAKE_SAMPLE_DATA
  • Warehouse: COMPUTE_WH
  • Scheme: TPCH_SF1
  • Account: the part of the your snowflake account between https:// and .<region>.snowflakecomputing.com]
  • Username: The username that you defined upon registration
  • Password: The password that you defined upon registration


6. Press the Execute button to execute the query, if you filled in everything correctly the following screen is shown with the query result JSON response:

7. Press the Save button to save your query so you can reuse it for execution in the future.

8. The saved query will be listed in the home screen of the demo app. 

9.  Use this button to execute the query again:

10. Use this button to copy the query definition to quickly create another one with the same database properties:

Thats it! Have fun with it.

Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Rita Tomé who created this component.
Dependencies
Snowflake Connector has no dependencies.