Insights

Notes on the decisions that get made by default

These are working notes on the parts of platform work that get settled quickly and cost time later: how change data capture handles deletes, what reconciliation does to a migration date, and how a row access policy behaves once data crosses an account boundary. We write them for the engineers who will operate the result.

12 August 20264 min read
Row access policies and the sharing boundary
A policy that filters on the current user behaves differently once the data is reached through a share. Confirm which execution context applies on every access path before relying on the policy to separate tenants.
- Governance
- Snowflake
- Security
6 August 20265 min read
Choosing a change data capture strategy
Log-based, query-based and full-refresh capture each fail in a different way. The fastest way to narrow the choice is to ask what happens in the warehouse when a row is deleted at source.
- Data Engineering
- CDC
- Pipelines
28 July 20265 min read
A migration timeline is a reconciliation timeline
Conversion work can be estimated from a count of objects. Reconciliation is estimated from the differences it turns up, and it is the work that sets the cutover date.
- Migration
- Snowflake
- Reconciliation

Notes on the decisions that get made by default

Row access policies and the sharing boundary

Choosing a change data capture strategy

A migration timeline is a reconciliation timeline