Set up a Snowflake data warehouse

-- 1. Create a role
CREATE ROLE IF NOT EXISTS <YOUR_ROLE>;

-- 2. Create a user and set default DB/schema
CREATE USER IF NOT EXISTS <YOUR_USER>
  PASSWORD = 'StrongPasswordHere1!'
  LOGIN_NAME = '<YOUR_USER>'
  MUST_CHANGE_PASSWORD = FALSE
  DEFAULT_ROLE = <YOUR_ROLE>
  DEFAULT_WAREHOUSE = <YOUR_WAREHOUSE>
  DEFAULT_NAMESPACE = <YOUR_DB>.<YOUR_SCHEMA>
  COMMENT = 'User for Demo';

-- 3. Grant the role to the user
GRANT ROLE <YOUR_ROLE> TO USER <YOUR_USER>;

-- 4. Grant usage on a warehouse to the role
GRANT USAGE ON WAREHOUSE <YOUR_WAREHOUSE> TO ROLE <YOUR_ROLE>;

-- 5. Create a test database and schema for the user to read/write
CREATE DATABASE IF NOT EXISTS <YOUR_DB> COMMENT = 'Database for Demo';
CREATE SCHEMA IF NOT EXISTS <YOUR_DB>.<YOUR_SCHEMA> COMMENT = 'Schema for Demo';

-- 6. Grant privileges on the new database/schema to the role
GRANT ALL PRIVILEGES ON DATABASE <YOUR_DB> TO ROLE <YOUR_ROLE>;

-- 7. Grant privileges on the schema
GRANT ALL PRIVILEGES ON SCHEMA <YOUR_DB>.<YOUR_SCHEMA> TO ROLE <YOUR_ROLE>;

-- (Optional) Grant privileges on future objects in the schema
-- so that the role automatically gets read/write privileges
-- for newly created tables or views
GRANT ALL PRIVILEGES ON FUTURE TABLES IN SCHEMA <YOUR_DB>.<YOUR_SCHEMA> TO ROLE <YOUR_ROLE>;
GRANT ALL PRIVILEGES ON FUTURE VIEWS IN SCHEMA <YOUR_DB>.<YOUR_SCHEMA> TO ROLE <YOUR_ROLE>;