May 21, 2026: Dynamic tables documentation rewritten¶

The dynamic tables documentation now includes 30 new and updated pages covering the full lifecycle of building, optimizing, monitoring, and troubleshooting dynamic table pipelines.

Key improvements include:

• Best practices and design patterns: New quick-start best practices for production deployments and design patterns covering multi-table pipelines, controller tables, and SCD Type 1 deduplication.

• New pages: Migration from streams and tasks, dbt integration, design patterns, pipeline boundaries and data consistency, error code reference, and replication behavior.

• Expanded troubleshooting: Three dedicated troubleshooting pages covering creation issues, permission issues, and refresh issues with symptom-based navigation and diagnostic SQL.

• Optimization guidance: Detailed coverage of refresh optimization, primary keys and input data, warehouse selection, and cost management.

• Runnable examples: Every page includes complete, copy-pasteable SQL examples with expected output.

For a guided introduction, start with Tutorial: Create a dynamic table pipeline.