❄️Mode of Training : Online
❄️Contact 📲 +91-8105296858
❄️Website : rajinformatica.com
Or click the below link to WhatsApp
[ Ссылка ]

👉 Join Snowflake WhatsApp group: [ Ссылка ]

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

Snowflake Batch-1_Session-2_Material Link : [ Ссылка ]



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

свернуть