Potencialize seus pipelines de dados e analytics em tempo real com o Tinybird – a plataforma rápida e escalável para ingerir, consultar e construir APIs sobre grandes volumes de dados de eventos. O Tinybird permite que desenvolvedores e engenheiros de dados coletem, transformem e exponham dados instantaneamente, facilitando dashboards, aplicações e automação com insights atualizados.
Com a integração do Tinybird, você pode:
- Transmitir eventos em escala: Ingerir milhões de eventos JSON por segundo de forma confiável, usando APIs HTTP com NDJSON ou JSON.
- Consultar dados com baixa latência: Executar analytics e agregações complexas baseadas em SQL em tempo real, ideais para dashboards, alertas e relatórios.
- Expor dados via APIs instantâneas: Construir e publicar endpoints de API para suas queries diretamente na UI do Tinybird ou via API.
- Automatizar fluxos de trabalho: Usar as APIs do Tinybird nas suas automações para buscar, transformar e sincronizar dados em todo o seu stack.
- Monitorar e depurar: Obter insights sobre performance de pipelines, latências de query e saúde da ingestão com monitoramento em tempo real.
- Acesso seguro: Aproveitar autenticação granular e escopo de recursos com tokens de API pessoais ou de workspace.
O Tinybird capacita equipes de engenharia, analytics e produto a entregar produtos de dados ultrarrápidos e sempre atualizados com sobrecarga operacional mínima. Vá de dados brutos de eventos a endpoints prontos para produção em minutos.
Conecte o Tinybird aos seus fluxos hoje para acelerar features orientadas a dados, automação e analytics!
Interact with Tinybird: stream JSON or NDJSON events with the Events API, run SQL with the Query API, call published Pipe API Endpoints by name with dynamic parameters, manage Data Sources by appending from a URL, truncating, or deleting rows by condition, and poll the status of asynchronous jobs.
Send events to a Tinybird Data Source using the Events API. Supports JSON and NDJSON formats with optional gzip compression.
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co or https://api.us-east.tinybird.co\) |
datasource | string | Yes | Name of the Tinybird Data Source to send events to. Example: "events_raw", "user_analytics" |
data | string | Yes | Data to send as NDJSON (newline-delimited JSON) or JSON string. Each event should be a valid JSON object. Example NDJSON: {"user_id": 1, "event": "click"}\n{"user_id": 2, "event": "view"} |
wait | boolean | No | Wait for database acknowledgment before responding. Enables safer retries but introduces latency. Defaults to false. |
format | string | No | Format of the events data: "ndjson" (default) or "json" |
compression | string | No | Compression format: "none" (default) or "gzip" |
token | string | Yes | Tinybird API Token with DATASOURCES:APPEND or DATASOURCES:CREATE scope |
| Parameter | Type | Description |
|---|
successful_rows | number | Number of rows successfully ingested |
quarantined_rows | number | Number of rows quarantined (failed validation) |
Execute SQL queries against Tinybird Pipes and Data Sources using the Query API.
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co\) |
query | string | Yes | SQL query to execute. Specify your desired output format (e.g., FORMAT JSON, FORMAT CSV, FORMAT TSV). JSON format provides structured data, while other formats return raw text. Example: "SELECT * FROM my_datasource LIMIT 100 FORMAT JSON" |
pipeline | string | No | Optional pipe name. When provided, enables SELECT * FROM _ syntax. Example: "my_pipe", "analytics_pipe" |
token | string | Yes | Tinybird API Token with PIPES:READ scope |
| Parameter | Type | Description |
|---|
data | json | Query result data. For FORMAT JSON: array of objects. For other formats (CSV, TSV, etc.): raw text string. |
meta | array | Column metadata for the result set (only available with FORMAT JSON) |
↳ name | string | Column name |
↳ type | string | Column data type |
rows | number | Number of rows returned (only available with FORMAT JSON) |
rows_before_limit_at_least | number | Minimum number of rows there would be without a LIMIT clause (only available with FORMAT JSON) |
statistics | json | Query execution statistics - elapsed time, rows read, bytes read (only available with FORMAT JSON) |
Call a published Tinybird Pipe API Endpoint by name, passing dynamic parameters and receiving structured JSON results.
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co\) |
pipe | string | Yes | Name of the published Pipe API Endpoint to call. Example: "top_pages" |
parameters | json | No | Dynamic Pipe parameters as a JSON object, sent as query-string arguments. Example: {"start_date": "2024-01-01", "limit": 10} |
q | string | No | Optional SQL to run on top of the Pipe result. Use "_" to reference the Pipe. Example: "SELECT count() FROM _" |
token | string | Yes | Tinybird API Token with PIPES:READ scope |
| Parameter | Type | Description |
|---|
data | json | Pipe result data as an array of row objects |
meta | array | Column metadata for the result set |
↳ name | string | Column name |
↳ type | string | Column data type |
rows | number | Number of rows returned |
rows_before_limit_at_least | number | Minimum number of rows there would be without a LIMIT clause |
statistics | json | Query execution statistics - elapsed time, rows read, bytes read |
↳ elapsed | number | Query execution time in seconds |
↳ rows_read | number | Number of rows processed |
↳ bytes_read | number | Number of bytes processed |
Append data to a Tinybird Data Source from a remote file URL (CSV, NDJSON, Parquet).
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co\) |
datasource | string | Yes | Name of the existing Data Source to append to. Example: "events_raw" |
url | string | Yes | Publicly accessible URL of the file to append. Example: "https://example.com/data.csv" |
format | string | No | Format of the source file: "csv" (default), "ndjson", or "parquet" |
token | string | Yes | Tinybird API Token with DATASOURCES:APPEND or DATASOURCES:CREATE scope |
| Parameter | Type | Description |
|---|
id | string | Identifier of the append operation |
import_id | string | Import identifier for the append job |
job_id | string | Job identifier used to poll import status |
job_url | string | URL to query the import job status |
status | string | Initial job status (e.g., "waiting") |
job | json | Full import job details (kind, id, status, created_at, datasource, ...) |
datasource | json | Target Data Source metadata (id, name, ...) |
Delete all rows from a Tinybird Data Source.
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co\) |
datasource | string | Yes | Name of the Data Source to truncate. Example: "events_raw" |
token | string | Yes | Tinybird API Token with DATASOURCES:CREATE scope |
| Parameter | Type | Description |
|---|
truncated | boolean | Whether the Data Source was truncated successfully |
result | json | Raw response body from the truncate endpoint, if any |
Delete rows from a Tinybird Data Source matching a SQL condition.
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co\) |
datasource | string | Yes | Name of the Data Source to delete rows from. Example: "events_raw" |
delete_condition | string | Yes | SQL WHERE-clause condition selecting the rows to delete. Example: "country = 'ES'" or "event_date < '2024-01-01'" |
dry_run | boolean | No | When true, returns how many rows would be deleted without deleting them. Defaults to false. |
token | string | Yes | Tinybird API Token with DATASOURCES:CREATE scope |
| Parameter | Type | Description |
|---|
id | string | Identifier of the delete operation |
job_id | string | Job identifier used to poll delete status |
delete_id | string | Deletion identifier |
job_url | string | URL to query the delete job status |
status | string | Current job status (e.g., "waiting", "done") |
job | json | Full delete job details (kind, id, status, delete_condition, rows_affected, ...) |
Check the status of an asynchronous Tinybird job (import, delete, etc.) by ID.
| Parameter | Type | Required | Description |
|---|
base_url | string | Yes | Tinybird API base URL (e.g., https://api.tinybird.co\) |
job_id | string | Yes | ID of the job to check, as returned by an append or delete operation |
token | string | Yes | Tinybird API Token with ADMIN scope, or the token that started the job |
| Parameter | Type | Description |
|---|
id | string | Job identifier |
job_id | string | Job identifier (same as id) |
kind | string | Job kind (e.g., "import", "delete_data", "populateview", "copy") |
status | string | Current job status: "waiting", "working", "done", "error", or "cancelled" |
job_url | string | URL to re-query this job status |
created_at | string | Timestamp the job was created |
started_at | string | Timestamp the job started running |
updated_at | string | Timestamp of the last job status update |
is_cancellable | boolean | Whether the job can still be cancelled |
error | string | Error message, present only when status is "error" |
job | json | Full raw job details, including kind-specific fields (statistics, datasource, delete_condition, etc.) |