How to connect
- Display Name: Give your data source a name for use within Internal.
- Account: Name of account provided by snowflake (e.g. xy12345.us-central1.gcp)
- User: The user associated with the Snowflake account you’re using for Internal.
- Password: The password associated with the Snowflake account you’re using for Internal.
- Database: The name of the database you’re connecting (this must match the actual name of your Snowflake database).
- Warehouse: The name of the warehouse you’re connecting (this must match the actual name of your Snowflake database).
- Role: The role associated with these credentials.
What happens when you connect
When you connect Snowflake to Internal, we'll generate the following for you automatically:
- A list and get function for each table in the database (regardless of whether the connecting user account has these privileges). Think of these functions as prebuilt SQL queries, so you don't have to write queries for everything.
In some cases, you may want to create a view that combines data from various tables or updates, inserts, or deletes records in your Snowflake database. To accomplish this, create a custom SQLFunction.
Filtering and Sorting
Internal enables filtering and sorting on all columns (except ARRAY, GEOGRAPHY, OBJECT, and VARIANT columns). Every type is orderable.
Things to know about the Snowflake Integration
- NUMERIC values which are larger than what a 64bit integer can hold will show up as strings
- Internal does not support writing values to ARRAY, OBJECT, or VARIANT columns.
- Internal does not support filterng on ARRAY, GEOGRAPHY, OBJECT, and VARIANT columns.