Roles and Users in Snowflake + DBT + ADF Session 2 Evening By Sai Sri from Raj Cloud Technologies
❄️Mode of Training : Online
❄️Contact 📲 +91-8105296858
❄️Website : rajinformatica.com
Or click the below link to WhatsApp
https://wa.link/zf1mnm
👉 Join Snowflake WhatsApp group: https://chat.whatsapp.com/EG44L97K1sy...
❄️Trainer Name: Sai Sri
❄️Exp: 10+ years
❄️Location: Bangalore (Currently working on Snowflake, DBT and ADF)
Snowflake Batch-1_Session-2_Material Link : https://drive.google.com/drive/folder...
Roles and User Assignment:
STEP1:
-------------------------------------Roles creation -----------------------------------------
SALES_DEV
SALES_UAT
SALES_PRD
------------------------------------Access to above role ------------------------------------
Give grant access to above role:
grant role SALES_DEV to role SALES_UAT;
grant role SALES_UAT to role SALES_PRD;
-----------------------------------Creation of object--------------------------------------
Create SALES DATABASE
Create PRODUCT SCHEMA
Create PRODUCT_ELT WAREHOUSE
Create PRODUCT ANALYSIS WAREHOUSE
---------------------------------Assign Privileges ---------------------------------------
Using above Objects give privileges to roles:
SALES_DEV --- DATABASE,SCHEMA,WAREHOUSE ANALYSIS, SELECT ON FUTURE TABLES
SALES_UAT -- WAREHOUSE ETL, INSERT ON FUTURE TABLES,CREATION TABLE AND CREATION VIEW ON FUTURE
SALES_PRD--- CREATE STAGE
---------------------------------Create Users---------------------------------------------
Create 3 user with different names
Assign users to roles
user1:SALES_DEV
user2:SALES_UAT
user3:SALES_PRD
----------------------------------------------------------------------------------------------------------------------------------------------------
show organization accounts
show regions
create ,monitor, manage user and role
create role and user
object--role--- user
warehouse,database, and other objects
Project Example:
sales
Database
schema
warehouse
--------------Commands-------------------
create database sales;
create schema customer
create warehouse customer_elt
create warehouse customer_analysis
use role securityadmin
create role sales_administrator;
create role sales_engineer
create role sales_analyst
securityadmin---saisri
grant role sales_analyst to role sales_engineer
grant role sales_engineer to role sales_administrator
Database
schema
warehouse
grant usage on database sales to role sales_analyst;
grant usage on schema sales.customer to role sales_analyst;
grant select on FUTURE TABLES in SCHEMA sales.customer to role sales_analyst;
GRANT USAGE ON WAREHOUSE CUSTOMER_ANALYSIS TO role sales_analyst;
GRANT INSERT ON FUTURE TABLES IN SCHEMA SALES.CUSTOMER TO ROLE SALES_ENGINEER
GRANT CREATE TABLE,CREATE VIEW ON SCHEMA SALES.CUSTOMER TO ROLE SALES_ENGINEER
GRANT USAGE ON WAREHOUSE CUSTOMER_ELT TO ROLE SALES_ENGINEER
SALES_ANALYST TO SALES_ENGINEER
GRANT CREATE STAGE ON SCHEMA SALES.CUSTOMER TO ROLE SALES_ADMINISTRATOR
USERS----ROLES---TABLES,VIEWS,STAGES (OBJECTS)
DATABASE---SCHEMA-- TABLES,VIEWS, STAGES
WAREHOUSE
CREATE USER ANIL;
CREATE USER HARI;
CREATE USER KIRAN;
SHOW USERS
GRANT ROLE SALES_ADMINISTRATOR TO USER ANIL;
GRANT ROLE SALES_ENGINEER TO USER HARI;
GRANT ROLE SALES_ANALYST TO USER KIRAN;
---------------------------------------------------------------------------------------------------------------
Roles:
HR: Anu,sri, sai, depu
Dev:
Tester
users
Anu,sri, sai, depu
SALES_ANALYST -- SALES_ENGINEER
SALES_ENGINEER -- SALES_ADMIN
SALES_ANALYST --- DATABASE,SCHEMA,WAREHOUSE ANALYSIS, SELECT ON FUTURE TABLES
SALES_ENGINEER -- WAREHOUSE ETL, INSERT ON FUTURE TABLES,CREATION TABLE AND CREATION VIEW ON FUTURE
SALES_ADMINISTRATOR--- ,CREATE STAGE
❄️Course Duration: 70+ Hours (45 days)
❄️Software Installation: Oracle Database 11g Express Edition, Oracle SQL Developer
❄️Trial Accounts: Snowflake, DBT (Data Build Tool), AWS and Azure
❄️Take Away: PPTs on daily basis with Sample Data Model.
Snowflake Data Warehouse Tutorials
#rajcloudtechnologies #rajcloudtech #rajinformatica #rajinformaticaonline #rajinformaticatraining
#snowflakedatawarehouse #snowflaketutorial #snowflakedatabase
#snowflaketutorial #snowflakeonline #adf #dbt
#Snowflake #WhatIsSnowflake #WhatIsSnowflakeDatawareHouse #SnowflakeTutorial #WhatIsSnowflakeDatabase #SnowflakeArchitecture #SnowflakeFeatures #SnowflakePricing #SnowflakeSchema #SnowflakeTechnology #SnowflakeDatabaseTutorial #SnowflakeTraining #SnowflakeCourse
#snowflakedemo #SnowflakeDatawarehouse #SnowflakeTraining
#SnowflakeOnlineTrainingProgram #SnowflakeTrainingCertification
#snowflakedatawarehouse #LearnSnowflake
#snowflaketutorial #snowflakearchitecture
#SnowflakeInterviewQuestions #SnowflakeInterviewQuestionsandAnswers #SnowflakeInterview #SnowflakeInterviewPreparation #SnowflakeEngineerInterviewQuestions #SnowflakeScenariobasedInterviewQuestion #SnowflakeInterviewQuestionsForExperience #snowflaketutorial