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

Question

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?

INFORMATION_SCHEMA holds information about objects in that database and is part of the Snowflake "application", you can't edit it or add anything to it. — NickW
– NickW, Commented Nov 13, 2021 at 13:13
if you want to add a view, just put it under some other schema, because a view can refer to any table from any database/schema using a full qualified name, so you need to be in the same schema. — Simeon Pilgrim
– Simeon Pilgrim, Commented Nov 14, 2021 at 3:07

Lukasz Szozda · Accepted Answer · 2021-11-13 13:39:17Z

1

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

answered Nov 13, 2021 at 13:39

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related