Skip to content
PHP2Shell: The PHP Bug
Akshay Thakare

Snowflake

Loading, transactions, clustering, cost control and secure data sharing.

5 notes · all topicsWarehousing & lakehouse

Start here · beginner1

  1. 1Snowflake Virtual Warehouses and Cost ControlStorage and compute are separate: how warehouses are billed, when to scale up vs out, and the settings that stop a surprise bill.

Next · intermediate2

  1. 2Time Travel and Zero-Copy Cloning in SnowflakeQuery a table as it was an hour ago, undo a bad load, and clone a production database for testing without copying data.
  2. 3Loading Data into Snowflake with COPY INTOStorage integrations, external stages, file formats, load history and loading only the files your manifest selected.

Go deeper · advanced2

  1. 4Micro-partitions, Pruning and Clustering KeysHow Snowflake skips data without indexes, how to tell whether a query prunes well, and when a clustering key is worth paying for.
  2. 5Snowflake Transactions for Atomic PublicationHow explicit transactions, DDL auto-commit and MERGE semantics affect a publish step that must update facts, history and watermarks together.