In this article, we're going to show you how to connect your Astrato workspace to a Snowflake database. It's designed to be a quick process, and easy to follow.
When you're setting up your data connection, you'll be asked to enter information about your database. We've listed all the items you need here.
Connection Name - think of a name to give your data connection.
Snowflake Account - you'll need to enter either the account URL, your Account and Organization or the Account, Platform and Region.
Database Credentials - the User name and Password for connecting to the database.
Database Name - the name of your database. You can also select the Role and Warehouse during setup.
Create New Connection
Select Data in the sidebar and click on Create Data to open the Create New Data Source screen (Figure 1).
Click on the Snowflake icon.
When the page Connect a Snowflake data source opens.
The default connection option is to paste your account URL into the text field.
You can also choose to enable the toggle to Configure manually with a choice of Connection Type - either use your Account Name (entering the Account and Organization) or use the Account Locator and enter your Account, Platform and Region.
Once you've entered the account information, enter your User name and Password in Database Credentials, then click Test Connection.
In the Select your database screen, select the database you're going to use from the dropdown.
You can also select a Role and a Warehouse, but these selections are optional.
If the connection is successful and the data source is created, the Data View Editor will open.
Figure 1: Create New Connection
If you click Connect and get an error about connecting to the database default Role, please check the database settings, and select another Role from the dropdown. You can find more information in our Astrato Troubleshooting Guide. If you're still getting an error, click the chat icon (bottom right) to raise a support ticket (Figure 2).
Figure 2: Astrato Chat
Astrato Data Articles
You can find more Astrato Data articles in the Data collection in the Astrato Help Center.