A Resource is a core concept in Retool. A Resource is a config that defines a backend data source that your Retool apps can talk to. Retool supports a variety of different kinds of backends, from databases to REST API calls, to special integrations like Stripe.
You can define a Resource once, then use it again and again in your Retool apps.
Read more about Resources in the Retool docs.
The goal of this section is to create:
- A Resource called
Snowflake UAR. This will be a reusable way to hit Snowflake as the user from Step 1.
Note: The name here is important! The app code we provide expects the Resource to have this name. (You can choose to rename it, after you've finished setting everything up.)
- On the Resources page (
/resources) in Retool, click "Create New" in the upper right. - Select the "Snowflake" resource type.
- Fill out the resource information as follows. (For more info, see our docs on Snowflake integration.)
Name: Snowflake UAR
Account name: <your account name>
Database name: SNOWFLAKE
Database schema: <your database schema>
Database warehouse: <your database warehouse>
User role: ACCOUNTADMIN (this role is required)
Authentication: Password (you must use password authentication)
Database username: <your database username from step 1>
Database password: <your database password from step 1>
- Click "Save changes".
You now have a Snowflake resource defined in Retool, named Snowflake UAR.
Reminder: The name here is important! The app code we provide expects the Resource to have this name. (You can choose to rename it, after you've finished setting everything up.)
Now, we are ready to import our app!