@tinybird

Tinybird is a managed ClickHouse® service for AI-native software teams. Get ClickHouse performance without ClickHouse complexity.

tbrd.co/go
Joined April 2019
  • Tweets4.7K
  • Following312
  • Followers8.5K
1.6KMedia
Classic was Tinybird’s original experience. Forward is the next big iteration, built for teams operating data products: deployments, schema migrations, local dev, CI/CD, SDKs and Agent Skills. Free and Developer Classic workspaces must migrate by Sep 15: tinybird.co/blog/tinybird-cl…

We're sunsetting Tinybird Classic for Free and Developer workspaces | Tinybird

Free and Developer plan workspaces must migrate from Tinybird Classic to Tinybird Forward by September 15, 2026. Here's what changes, what you gain, and how to migrate.

tinybird.co
6
10,593
Materialized Views run as insert triggers. Every inserted block executes the view's transformation query. If your view JOINs another table, ClickHouse® scans that right-side table in full on every single insert. As tables grow, inserts slow to a crawl.
Tinybird Materialized View pipe pre-filtering right-side join to rows matching the inserting batch

ALT Tinybird Materialized View pipe pre-filtering right-side join to rows matching the inserting batch

1
2
309
Pre-filter the right table with a subquery on the inserting block: (tenant_id, user_id) IN (SELECT tenant_id, user_id FROM events) This confines the scan to matching rows: tinybird.co/docs/forward/cor…

Materialized views | Tinybird

Materialized views process your data at ingest time to increase the performance of your queries and endpoints.

tinybird.co
1
95
ClickHouse® MergeTree deduplicates inserted blocks by default. It keeps hashes of the last 10,000 blocks and discards identical ones. When you replay an event stream or backfill test data, that deduplication window can silently drop incoming rows.
Tinybird .datasource file with replicated_deduplication_window=0 engine setting to disable block deduplication in ClickHouse

ALT Tinybird .datasource file with replicated_deduplication_window=0 engine setting to disable block deduplication in ClickHouse

2
4
564
To ensure every block commits during replays, set replicated_deduplication_window=0 in ENGINE_SETTINGS. You can lower this setting directly in your .datasource file: tinybird.co/docs/changelog/2…

Tinybird Local on arm64 requires a 4KiB page size kernel | Tinybird

The arm64 Tinybird Local image now requires a 4KiB page size kernel. Also: secondary indexes in Data Source settings, a configurable deduplication window, and stricter SQL API and deployment valida...

tinybird.co
1
192
Hace 4 años @nmediavilla19 vino a su primera @tarugoconf en el stand de @tinybird… hoy está en el escenario con "El diseño post-ChatGPT: eliminando barreras, no trabajos". Bravo!!! #TRG26
1
4
1
10
380
Tinybird retweeted
RawTree
@rawtreedbOct 23
AI automation lands more PRs every day. Nobody watches every CI run anymore. So stream every CI run into RawTree as it finishes. One small GitHub Actions workflow, no CREATE TABLE, no cron job. Then ask it questions instead of watching it. rawtree.com/docs/guides/inge…
A GitHub Actions workflow named 'Send CI runs to RawTree'. It triggers on completed runs of the CI workflow and posts the run JSON to the RawTree insert API for table ci_workflow_runs with curl, using a RAWTREE_API_KEY secret.

ALT A GitHub Actions workflow named 'Send CI runs to RawTree'. It triggers on completed runs of the CI workflow and posts the run JSON to the RawTree insert API for table ci_workflow_runs with curl, using a RAWTREE_API_KEY secret.

1
2
137
La jefa on the stage. @nmediavilla19 @tinybird #TRG26
1
4
33
1,457
A sudden surge in heavy dashboard queries shouldn't crash your dedicated ClickHouse® cluster. Tinybird Cluster Protection automatically throttles degraded Endpoints under peak load to safeguard cluster memory and CPU.
1
3
744
Every concurrency limit transition is logged in tinybird.cluster_control_log and visible in Observability. Inspect degradation reasons, CPU ratios, and recovery timelines directly: tinybird.co/docs/forward/mon…

Service data sources | Tinybird

In addition to the data sources you upload, Tinybird provides other "Service data sources" that allow you to inspect what's going on in your account.

tinybird.co
2
378
You can now share Explorations with your whole Workspace. Also this week: Organization Observability filters by Workspace, and viewers and guests get tighter permissions. tinybird.co/docs/changelog/2…
2
338
Changing SQL transformations or parameter filters shouldn't rely on clicking around a staging UI to check for regressions. With Tinybird Forward, you check API Endpoints against YAML fixtures in CI using tb test run.
Tinybird YAML test file defining regression test cases for an API endpoint with parameters and expected response

ALT Tinybird YAML test file defining regression test cases for an API endpoint with parameters and expected response

1
1
2
434
Define test cases in tests/<pipe>.yaml with parameters and expected JSON. Tinybird spins up a clean local environment and asserts status codes and payloads before you merge: tinybird.co/docs/forward/dev…

tb test | Tinybird

Run and update tests for your Tinybird project

tinybird.co
2
246
Tinybird retweeted
RawTree
@rawtreedbOct 20
No schema upfront doesn't mean typeless. Our LLM app's SDK v2 started sending latency_ms as "1920" instead of 1920. RawTree kept each value's type. avg() and > comparisons skip the strings and return a hint saying so. Nothing silently becomes a wrong number. rawtree.com/docs/guides/inge…
SQL on an llm_calls table where SDK v1 sends latency_ms as 1840 and SDK v2 as the string "1920". avg(latency_ms) returns 2455 with a hint that String rows were skipped. A latency_ms > 2500 filter returns 2 with a similar hint.

ALT SQL on an llm_calls table where SDK v1 sends latency_ms as 1840 and SDK v2 as the string "1920". avg(latency_ms) returns 2455 with a hint that String rows were skipped. A latency_ms > 2500 filter returns 2 with a similar hint.

1
3
384
Sending Bird webhooks to Tinybird takes one Data Source and one URL. The full webhook body lands in a JSON column, so you can query nested fields like event.data.metadata.order_id directly.
Tinybird bird_events_raw.datasource storing each Bird webhook body in a JSON column, with an append-only token

ALT Tinybird bird_events_raw.datasource storing each Bird webhook body in a JSON column, with an append-only token

1
2
303
Then create a Bird webhook that points at the Events API: /v0/events?name=bird_events_raw&format=json&wait=true&token=<token> The token can only append to this Data Source. Prefix it with your region's API host. tinybird.co/docs/forward/gui…

Send Bird webhooks to Tinybird | Tinybird

Send Bird email and messaging events to Tinybird.

tinybird.co
1
218
Exporting rollups from ClickHouse® to S3 usually involves custom cron jobs, export lambdas, and opaque errors when IAM policies reject writes. In Tinybird, define an S3 Sink pipe in SQL, set a schedule, and let Tinybird handle batch writes.
Tinybird Sink Pipe exporting completed orders to S3 in Parquet format on a scheduled interval

ALT Tinybird Sink Pipe exporting completed orders to S3 in Parquet format on a scheduled interval

1
1
5
531
Partition outputs with templates like orders_{order_date} in Parquet, CSV, or NDJSON. Failed and cancelled runs now surface in tinybird.sinks_ops_log with exact IAM permission errors: tinybird.co/docs/forward/cop…

S3 Sink | Tinybird

Offload data to S3 on a batch-based schedule using Tinybird's fully managed S3 Sink Connector.

tinybird.co
2
239
New guide in the Tinybird docs: send @messagebird webhooks to Tinybird. Point a Bird webhook at the Events API and query email, SMS, WhatsApp, and Apple Messages events with SQL. No server needed. tinybird.co/docs/forward/gui…

Send Bird webhooks to Tinybird | Tinybird

Send Bird email and messaging events to Tinybird.

tinybird.co
2
2
520
ClickHouse® table partitions and TTLs need to align. If you partition by month but set a 30-day TTL, ClickHouse has to rewrite entire part files during merges just to delete expired rows. That burns CPU and disk I/O on background cleanup.
Tinybird .datasource file with aligned partition key, TTL expression, and ttl_only_drop_parts engine setting

ALT Tinybird .datasource file with aligned partition key, TTL expression, and ttl_only_drop_parts engine setting

1
3
472
Match ENGINE_PARTITION_KEY to your TTL and set ttl_only_drop_parts=1 in ENGINE_SETTINGS. ClickHouse drops whole expired partition folders via metadata deletion with zero row rewrites: tinybird.co/docs/forward/dev…

Datasource files | Tinybird

Datasource files describe your data sources. Define the schema, engine, and other settings.

tinybird.co
278
Load more