Skip to main content
Snowflake logo

Snowflake

Overview

Snowflake is a cloud-based data platform that combines the power of a data warehouse with the flexibility of a cloud solution, enabling organizations to store, analyze, and share large volumes of data seamlessly. Using the Superblocks integration with Snowflake, teams can effortlessly build custom internal tools that leverage real-time data, streamlining workflows and enhancing operational efficiency across the organization.

Setting up Snowflake

Set up allowed IP Addresses

If you're using Superblocks Cloud, add Superblocks' IPs as allowed IPs for Snowflake. Learn how to configure this in Snowflake's guide on [Controlling network traffic with network policies](https://docs.snowflake.com/en/user-guide/network-policies

If using the Superblocks On-Premise, make sure your agent can connect to Snowflake.

Add integration

  1. In the web app, navigate to the Integrations page
  2. Click Add integration
  3. Search for Snowflake and select it from the list of available integrations
  4. Name the integration
  5. Fill out the integration configuration as follows:
    Field
    RequiredDescritpion
    Account identifiedSnowflake account identifier. The account identifier does not include the snowflakecomputing.com suffix
    UsernameLogin name for the user
    PasswordPassword for the user
    DatabaseName of the database to use
    Default warehouseName of the warehouse to use. Defaults to the user's default warehouse
    Default schemaName of the schema to use for the database. Defaults to public
    Default roleName of the role to use. Defaults to the user's default role
  6. Optionally, add more configurations to set credentials for different environments
  7. Click Test Connection to check that Superblocks can connect
  8. Click Create
success

Snowflake connected

Now you can use Snowflake in any Application, Workflow, or Scheduled Job

Using Snowflake in APIs

Once your Snowflake integration is created, you can start using Snowflake in Superblocks APIs.

Snowflake is a SQL-based integration. Learn more in our guide on Writing SQL in Superblocks.

Example usage

Application

Visualize data from Snowflake in UI components like charts, tables, and grids.

Visualize Snowflake data in applications using a grid component

Workflow

Enrich customer order data with shipping data from Snowflake.

Use a workflow to enrich customer data with shipping data from Snowflake

Scheduled Job

Send out a daily report via email of new customer bookings.

Use a scheduled job to query Snowflake and send out a daily report

Troubleshooting

If you run into issues, first see our guide on Troubleshooting Database Integrations.

Common errors

There are several common errors you may see when using Snowflake. The table below include error messages, why they happen, and how to address them.

Error message
Why it's happeningResolution
Snowflake configuration error, SQL compilation error: Object does not exist, or operation cannot be performedWhen the connection is established, the user is assuming a role that does not have access to the schema specified.Set the Default role to assume a role that has access to the selected schema.

If you are encountering an error that's not listed, or the provided steps are insufficient to resolve the error, please contact us at support@superblocks.com