Roles and Users in Snowflake + DBT + ADF Session 2 Evening By Sai Sri from Raj Cloud Technologies

❄️Mode of Training : Online
❄️Contact 📲 [phone]
Or click the below link to WhatsApp

❄️Trainer Name: Sai Sri
❄️Exp: 10+ years
❄️Location: Bangalore (Currently working on Snowflake, DBT and ADF)

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

[unstoppablesk]

Great vedio training. Trainer is very knowledgeable.

[GireeshReddyMusturi]

Snowflake training is going good. Our trainer Saisri is explaing the concepts in the way that it is easy to understand. She is addressing all the doubts and questions. So as of now we are good with the training.