Snowflake Data Source

Get Snowflake Account Information

To set up a Cast Datasource for Cast.app to query your Snowflake data, you will need to provide the Snowflake account information. If you are not sure where to find this, follow the steps below:

1. In your Snowflake UI, navigate to the admin section in the left sidebar.
2. Go to the account section.
3. Copy the Snowflake account URL. It will look something like: https://jkgcowj-htb35055.snowflakecomputing.com
4. From the copied URL, you only need the string jkgcowj-htb35055 which will be used as the account information.

Creating a Snowflake Datasource

1. Navigate to the Datasets screen in Cast.app designer by clicking on “Home” at the top of the screen and selecting “Datasets”.
2. Click on “Add New Dataset”.
3. Select “Add a Data Source” and choose “Snowflake” in the popup.
   • On the datasource setup screen, provide the following details:Account Information: Enter the account string you copied earlier, such as jkgcowj-htb35055.
   • Username: Enter your Snowflake username.
   • Password: Enter your Snowflake password.
4. Provide a descriptive name for your datasource.
5. Click on “Add Configuration”.

Creating Datasets from Snowflake Datasources

1. After adding a datasource, locate the Snowflake datasource you just created. If you cannot see it, return to the Datasets screen by following Step 1 and 2 in the section above. “Creating a Snowflake Datasource”.
2. Click on the Snowflake datasource that you created in the previous step.
3. Query your Snowflake data, assign a name to the dataset, and save.

Video Tutorial