Search code examples
snowflake-cloud-data-platforminformation-schema

Insufficient privilege while creating custom view or table inside INFORMATION_SCHEMA in Snowflake

I am getting insufficient privilege error while trying to create custom views and tables under INFORMATION_SCHEMA even though I tried to create it with ACCOUNTADMIN role which has all the privileges on all objects across Snowflake.

I searched around Snowflake documentation but could not find satisfactory answer to it.

Is it obvious? can't I add any custom views or tables under INFORMATION_SCHEMA?

Solution

  • It is not possible to edit INFORMATION_SCHEMA.

    General Usage Notes

    Each INFORMATION_SCHEMA schema is read-only (i.e. the schema, and all the views and table functions in the schema, cannot be modified or dropped).