Arhitectura Snowflake
Emily Melhuish
Technical Curriculum Developer, Snowflake
Creare bază de date
CREATE DATABASE snowy_peak_db;

Creare schemă
CREATE SCHEMA snowy_peak_db.raw;


Interogare
SELECT * EXCLUDE(email)
FROM user_registrations
LIMIT 10;
Rezultat

Interogare
SELECT table_name, row_count, bytes
FROM information_schema.tables
WHERE table_schema = 'PRODUCT';
Rezultat

Interogare
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'IN_APP_PURCHASES';
Rezultat

Acordarea accesului rolului analyst
GRANT USAGE ON DATABASE snowy_peak_db TO ROLE analyst;
GRANT USAGE ON SCHEMA product TO ROLE analyst;
GRANT SELECT ON TABLE product.in_app_purchases TO ROLE analyst;
Utilizatorii nu primesc privilegii direct
Principiul privilegiului minim
Acordarea accesului rolului analyst
GRANT USAGE ON DATABASE snowy_peak_db TO ROLE analyst;
GRANT USAGE ON SCHEMA product TO ROLE analyst;
GRANT SELECT ON TABLE product.in_app_purchases TO ROLE analyst;
Utilizatorii nu primesc privilegii direct
Principiul privilegiului minim
Arhitectura Snowflake