Insufficient access

Potential Causes

• The configured warehouse user does not have the required permissions.

Suggested Action(s)

Grant the required privileges to the warehouse user. To do this:

1. Log in to the Snowflake instance.

2. Click the Expand chevron (drop-down icon) at the top left.

3. From the Switch Roles list, select the role which you want to use.

   

4. In the Worksheets tab, click +Worksheet to create a new worksheet.

   

5. Paste the following script in the worksheet, and replace the sample values provided in lines 2 and 4 of the script with your own. The script creates a new role for Hevo in Snowflake, and grants only the bare minimum permissions required by Hevo to load the data in your Destination.

   Note: The values for role_name and database_name must be in upper case.

   // Replace the ROLE_NAME with the role to which you want to grant access
   set role_name = 'ROLE_NAME';
   // Replace the DB_NAME with the name of your Database
   set database_name = 'DB_NAME';
   
   -- Do not edit below this
   -- Grant HEVO access to database
   GRANT CREATE SCHEMA, MONITOR, USAGE, MODIFY
   on database identifier($database_name)
   to role identifier($role_name);
   

6. Run the script.

7. Once the script has executed successfully, you can use the credentials from lines 2 and 4 of the script to connect your Snowflake warehouse to Hevo.

Revision History