Marlandata

A blog to share thoughts, knowledge and techniques from the world of data.

Snowpro Advanced Architect: Snowflake Storage & Protection

Image by Pexels from Pixabay Time Travel Define Time Travel features: Data retention periods Differences between Snowflake Editions Querying historical data Impact of cloning and restoring objects Underlying ...

Snowpro Advanced Architect: Snowflake Overview & Architecture

Image by Borko Manigoda from Pixabay Snowflake Architecture: Outline key components of Snowflake’s architecture Layers Caches Differentiate Snowflake and other paradigms Shared disk Shared nothing ...

Snowpro Advanced Architect: Performance and Tuning

Image by Pexels from Pixabay Clustering Outline clustering best practices and appropriate usage Evaluate overlap and depth Data types Cardinality Policies Auto-clustering Materialized Views ...

Snowpro Advanced Architect: Data Sharing

Image by OpenClipart-Vectors from Pixabay Domain Objectives Data sharing Capabilities of data sharing Shares Create and configure shares Privileges required to work with shares Secure views So...