CODEWITHSUNDEEP
snowflake-cloud-data-platforminformation-schema
Neel Maheta
Neel Maheta

Reputation: 339

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?

Upvotes: 1

Views: 178

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 175706

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).

Upvotes: 1

Related Questions