550021: Insufficient warehouse permissions

The credentials configured for this warehouse source lack the permissions required to run the sync. Twilio authenticated with the warehouse successfully; however, the database user cannot read the tables, views, or schemas referenced in the dataset configuration.

• The warehouse user doesn't have SELECT privileges on one or more tables or views referenced in the dataset's SQL query.
• The user lacks USAGE privileges on the schema or database that contains the referenced objects.
• Permissions were revoked after the source was first configured.
• The warehouse role assigned to the user doesn't include the necessary grants.

• Log in to your warehouse and review the privileges granted to the user or role configured for this source.
• Grant SELECT on all tables and views referenced in your dataset SQL queries and USAGE on the corresponding schemas and databases.
• Example (Snowflake):
  Copy code block

  1
  GRANT USAGE ON DATABASE *DATABASE_NAME* TO ROLE *ROLE_NAME*;
  2
  GRANT USAGE ON SCHEMA *DATABASE_NAME*.*SCHEMA_NAME* TO ROLE *ROLE_NAME*;
  3
  GRANT SELECT ON TABLE *DATABASE_NAME*.*SCHEMA_NAME*.*TABLE_NAME* TO ROLE *ROLE_NAME*;

• After you update the permissions, retry the sync from the Twilio Console.