Snowflake 架构
Emily Melhuish
Technical Curriculum Developer, Snowflake
创建数据库的查询
CREATE DATABASE snowy_peak_db;

创建架构的查询
CREATE SCHEMA snowy_peak_db.raw;


查询
SELECT * EXCLUDE(email)
FROM user_registrations
LIMIT 10;
输出

查询
SELECT table_name, row_count, bytes
FROM information_schema.tables
WHERE table_schema = 'PRODUCT';
输出

查询
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'IN_APP_PURCHASES';
输出

为 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;
用户不直接获得权限
最小权限原则
为 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;
用户不直接获得权限
最小权限原则
Snowflake 架构