Insufficient access

Last updated on Oct 26, 2022
Error Code 1011
Applies To Snowflake Destination
Category User credentials
Error Message Text(s) User with default role: ‘{user}’ does not have CREATE SCHEMA or OWNERSHIP privilege in database ‘{database}’.

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.

    Switch Roles

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

    Add 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

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Sep-05-2022 NA Brought this page under its respective Destination documentation folder.
Jun-21-2022 1.91 New document.

Tell us what went wrong