The Snowflake action pack contains the following actions:
A role is basically a group that grants specific permissions on certain resources. You may grant a role to a user or to another role (nested roles).
First, we will create a new role called GLEAN_QUERY_SNOWFLAKE_ROLE (kindly do not modify the role name). To do this, run the following queries with the ACCOUNTADMIN role or any role that can create roles and grant access to resources such as tables and Cortex:
Then, we will grant permissions to the required tables and access to Cortex. Here are some templated commands that you can use:
Finally, grant the role to specific users or roles:
You should also be able to revoke the roles you just granted. See documentation.
We will use the CREATE SECURITY INTEGRATION command to create the OAuth application. Use the ACCOUNTADMIN or any role that has permission to create a security integration:
We will now set up the Snowflake action pack and update the redirect URI in the OAuth application:
Setup is now complete. Refer to the end user documentation on how to test this action pack in the agent builder.
The Snowflake action pack contains the following actions:
A role is basically a group that grants specific permissions on certain resources. You may grant a role to a user or to another role (nested roles).
First, we will create a new role called GLEAN_QUERY_SNOWFLAKE_ROLE (kindly do not modify the role name). To do this, run the following queries with the ACCOUNTADMIN role or any role that can create roles and grant access to resources such as tables and Cortex:
Then, we will grant permissions to the required tables and access to Cortex. Here are some templated commands that you can use:
Finally, grant the role to specific users or roles:
You should also be able to revoke the roles you just granted. See documentation.
We will use the CREATE SECURITY INTEGRATION command to create the OAuth application. Use the ACCOUNTADMIN or any role that has permission to create a security integration:
We will now set up the Snowflake action pack and update the redirect URI in the OAuth application:
Setup is now complete. Refer to the end user documentation on how to test this action pack in the agent builder.