tinybird-best-practices

Encodes Tinybird file format rules, SQL constraints, and optimization patterns for datasources, pipes, endpoints, materialized views, and deduplication. Covers the full resource lifecycle from local development to cloud deployment. Tinybird has its own templating syntax, strict SELECT-only SQL rules, and file format conventions that aren't in standard SQL or ClickHouse docs, so having the rules inline prevents constant context-switching to documentation.