- hybrid RBAC, DAC, ABAC security model - column, row level, and tag based access policies - multi-account organizations - cross-account and region data replication - data shares - external tables and specialized formats (iceberg, delta) - pipes and streams - snowpark API - streamlit integration
Things you can learn regarding Snowflake, other than the obvious (SQL, and Snowflake specific language extensions to SQL): proper table partitioning, Snowpipe (and the associated cloud messaging pipelines), and query performance tuning. (Complex queries can become a bear; identifying when its your query/partitioning or when its something on the Snowflake back end is challenging.)
There are always new additions to the Snowflake tooling ecosystem since the company is in competition with Databricks and others (e.g., Snowpark with Python).