Connecting your Database
Rasgo allows you to bring your own Data Warehouse account and runs all compute inside your warehouse so that data never leaves your account.
Currently, Rasgo only works with Snowflake, but will support BigQuery and other data warehouses soon.
To use Rasgo with your own Snowflake account, you'll need to provide Rasgo with Snowflake credentials. This guide will show you how.

Connecting to Snowflake

IP Restrictions

Rasgo will always connect to your Snowflake account from these IP addresses. Make sure to whitelist them if you have networking restrictions enabled in Snowflake.
IP Address
54.84.138.60
54.84.66.109

Credentials

Rasgo needs service account user credentials to authenticate to and execute SQL queries in your account. The role you assign to this user will also need access to the source tables or views that you want to transform and visualize in Rasgo.
Here's a setup script to run in Snowflake to create the service account user, if you don't already have one:
Snowflake Setup Script
And here's a screenshot of the Data Warehouse Setup form that you'll use to give Rasgo the right Snowflake credentials.
Currently, we only support username / password authentication with Snowflake, but we are adding support for OAuth shortly!
Field
Description
Example
Account
Snowflake account identifier, as described here
abc12345.snowflakecomputing.com
Database
Snowflake database to create new views and tables in
RASGO
Warehouse
Compute warehouse to use in Snowflake to run SQL
RASGO_WH
Schema
Schema to create new views and tables in
PUBLIC
Role
Snowflake role for the user to use
RASGO
User
Snowflake username
RASGO_USER
Password
Snowflake password
i<3rasgo
Last modified 3mo ago
Copy link