I'm getting `snowflake.connector.errors.ForbiddenError` when trying to create a table. What privileges are required?

Responsive Ad Header

Question

Grade: Education Subject: Support
I'm getting `snowflake.connector.errors.ForbiddenError` when trying to create a table. What privileges are required?
Asked by:
116 Viewed 116 Answers
Responsive Ad After Question

Answer (116)

Best Answer
(468)
Creating a table requires the `CREATE TABLE` privilege on the schema or database where the table will reside, and the `USAGE` privilege on the database. Additionally, the role must have ownership, or the ability to grant ownership to a role that does, which makes future table management more straightforward. Example: `GRANT CREATE TABLE ON SCHEMA . TO ROLE ;` and `GRANT USAGE ON DATABASE TO ROLE ;`