CODEWITHSUNDEEP
loadsnowflake-cloud-data-platformwizard
Jimbo
Jimbo

Reputation: 11

Snowflake - Privileges required to load data via Web UI

Trying to setup a user to be able to use Data Loading Using the Web Interface (Limited) to load tables with a csv spreadsheet. What permissions are required to do this type of Load? Looking at Snowflake doc, it shows how to do the load, and says you can as long as you have to correct permissions, but it never says what exact permissions are required. Any help would be appreciated.

Upvotes: 1

Views: 2229

Answers (2)

Rajib Deb
Rajib Deb

Reputation: 1772

First create a role for the user and try this

GRANT ROLE <ROLE NAME> TO USER <USER NAME>;
GRANT USAGE ON DATABASE <DB NAME> TO ROLE <ROLE NAME>;
GRANT USAGE ON SCHEMA <SCHEMA NAME> TO <ROLE NAME>;
GRANT CREATE TABLE ON SCHEMA <SCHAME NAME> TO ROLE <ROLE NAME>;

Upvotes: 0

Suzy Lockwood
Suzy Lockwood

Reputation: 1180

Please note loading via the Snowflake Web UI has limitations compared to other data loading methods.

To answer your question, in this scenario (when using the Web UI), a table stage is created and automatically used. As mentioned in the documentation, to load the files onto a table stage, you must be the table owner (have the role with the OWNERSHIP privilege on the target table). https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

Upvotes: 1

Related Questions