When you connect Snowflake to Internal, we'll generate the following for you automatically:
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.
Internal enables filtering and sorting on all columns (except ARRAY, GEOGRAPHY, OBJECT, and VARIANT columns). Every type is orderable.
Note: Internal currently only supports use of K/P Auth with encrypted and password-protected private keys.
Here's a link to setting up authorization with Key/Pair for Snowflake.
We recommend that you follow the setup guide with one caveat: Mac users need to use a different key-generation method that passes an additional flag. This will ensure that PKCS#5 v2.0 is used. It looks like this:
After you have generated a private, password-protected key, and associated your Snowflake instance with your keys, you're ready to add your credentials and keys to your Internal instance.
Navigate to "Company Settings" (you'll need to be an Admin for your Internal Instance) and select "Data & Functions" from the tabbed menu.
Click "Add Data Source"
On the resultant screen, select "Snowflake"
From there, fill out the Snowflake environmental data, and click "Key Pair" in the "Authentication Method" section of the form, upload the encrypted private key file, and input the password for the encrypted private key.
Once you've submitted the form, you'll see your Snowflake DB generate a slew of functions through the magic of Internal, and your Snowflake instance will be protected by Key/Pair authentication.