# Tinybird Tinybird is a data platform for data and engineering teams to solve complex real-time, operational, and user-facing analytics use cases at any scale. Tinybird makes it easy to import data from a variety of sources, use SQL to filter, aggregate, and join that data, and publish low-latency, high-concurrency RESTful API Endpoints. ## Main - [Api Reference](https://tinybird.co/docs/api-reference) - [Cli](https://tinybird.co/docs/cli) - [Community](https://tinybird.co/docs/community) - [Get Data In](https://tinybird.co/docs/get-data-in) - [Get Started](https://tinybird.co/docs/get-started) - [Live](https://tinybird.co/docs/live) - [Monitoring](https://tinybird.co/docs/monitoring) - [Opengraph Image.jpg](https://tinybird.co/docs/opengraph-image.jpg) - [Publish](https://tinybird.co/docs/publish) - [Screencasts](https://tinybird.co/docs/screencasts) - [Sql Reference](https://tinybird.co/docs/sql-reference) - [Use Cases](https://tinybird.co/docs/use-cases) - [Work With Data](https://tinybird.co/docs/work-with-data) ## Api Reference - [Analyze Api](https://tinybird.co/docs/api-reference/analyze-api) - [Datasource Api](https://tinybird.co/docs/api-reference/datasource-api) - [Environment Variables Api](https://tinybird.co/docs/api-reference/environment-variables-api) - [Events Api](https://tinybird.co/docs/api-reference/events-api) - [Jobs Api](https://tinybird.co/docs/api-reference/jobs-api) - [Pipe Api](https://tinybird.co/docs/api-reference/pipe-api) - [Query Api](https://tinybird.co/docs/api-reference/query-api) - [Sink Pipes Api](https://tinybird.co/docs/api-reference/sink-pipes-api) - [Token Api](https://tinybird.co/docs/api-reference/token-api) ### Pipe Api - [Api Endpoints](https://tinybird.co/docs/api-reference/pipe-api/api-endpoints) - [Copy Pipes Api](https://tinybird.co/docs/api-reference/pipe-api/copy-pipes-api) - [Materialized Views](https://tinybird.co/docs/api-reference/pipe-api/materialized-views) ## Cli - [Advanced Templates](https://tinybird.co/docs/cli/advanced-templates) - [Command Ref](https://tinybird.co/docs/cli/command-ref) - [Common Use Cases](https://tinybird.co/docs/cli/common-use-cases) - [Data Projects](https://tinybird.co/docs/cli/data-projects) - [Datafiles](https://tinybird.co/docs/cli/datafiles) - [Install](https://tinybird.co/docs/cli/install) - [Local Container](https://tinybird.co/docs/cli/local-container) - [Quick Start](https://tinybird.co/docs/cli/quick-start) - [Template Functions](https://tinybird.co/docs/cli/template-functions) - [Workspaces](https://tinybird.co/docs/cli/workspaces) ### Datafiles - [Datasource Files](https://tinybird.co/docs/cli/datafiles/datasource-files) - [Include Files](https://tinybird.co/docs/cli/datafiles/include-files) - [Pipe Files](https://tinybird.co/docs/cli/datafiles/pipe-files) ## Get Data In - [Connectors](https://tinybird.co/docs/get-data-in/connectors) - [Data Operations](https://tinybird.co/docs/get-data-in/data-operations) - [Data Sources](https://tinybird.co/docs/get-data-in/data-sources) - [Guides](https://tinybird.co/docs/get-data-in/guides) - [Ingest Apis](https://tinybird.co/docs/get-data-in/ingest-apis) - [Migrate](https://tinybird.co/docs/get-data-in/migrate) ### Connectors - [Bigquery](https://tinybird.co/docs/get-data-in/connectors/bigquery) - [Confluent](https://tinybird.co/docs/get-data-in/connectors/confluent) - [Dynamodb](https://tinybird.co/docs/get-data-in/connectors/dynamodb) - [Kafka](https://tinybird.co/docs/get-data-in/connectors/kafka) - [Msk](https://tinybird.co/docs/get-data-in/connectors/msk) - [Redpanda](https://tinybird.co/docs/get-data-in/connectors/redpanda) - [S3](https://tinybird.co/docs/get-data-in/connectors/s3) - [Snowflake](https://tinybird.co/docs/get-data-in/connectors/snowflake) ### Data Operations - [Iterate A Data Source](https://tinybird.co/docs/get-data-in/data-operations/iterate-a-data-source) - [Recover From Quarantine](https://tinybird.co/docs/get-data-in/data-operations/recover-from-quarantine) - [Replace And Delete Data](https://tinybird.co/docs/get-data-in/data-operations/replace-and-delete-data) - [Scheduling With Github Actions And Cron](https://tinybird.co/docs/get-data-in/data-operations/scheduling-with-github-actions-and-cron) ### Guides - [Ingest Auth0 Logs](https://tinybird.co/docs/get-data-in/guides/ingest-auth0-logs) - [Ingest From Aws Kinesis](https://tinybird.co/docs/get-data-in/guides/ingest-from-aws-kinesis) - [Ingest From Clerk](https://tinybird.co/docs/get-data-in/guides/ingest-from-clerk) - [Ingest From Csv Files](https://tinybird.co/docs/get-data-in/guides/ingest-from-csv-files) - [Ingest From Dub](https://tinybird.co/docs/get-data-in/guides/ingest-from-dub) - [Ingest From Dynamodb Single Table Design](https://tinybird.co/docs/get-data-in/guides/ingest-from-dynamodb-single-table-design) - [Ingest From Github](https://tinybird.co/docs/get-data-in/guides/ingest-from-github) - [Ingest From Gitlab](https://tinybird.co/docs/get-data-in/guides/ingest-from-gitlab) - [Ingest From Google Gcs](https://tinybird.co/docs/get-data-in/guides/ingest-from-google-gcs) - [Ingest From Google Pubsub](https://tinybird.co/docs/get-data-in/guides/ingest-from-google-pubsub) - [Ingest From Knock](https://tinybird.co/docs/get-data-in/guides/ingest-from-knock) - [Ingest From Mailgun](https://tinybird.co/docs/get-data-in/guides/ingest-from-mailgun) - [Ingest From Mongodb](https://tinybird.co/docs/get-data-in/guides/ingest-from-mongodb) - [Ingest From Orb](https://tinybird.co/docs/get-data-in/guides/ingest-from-orb) - [Ingest From Pagerduty](https://tinybird.co/docs/get-data-in/guides/ingest-from-pagerduty) - [Ingest From Resend](https://tinybird.co/docs/get-data-in/guides/ingest-from-resend) - [Ingest From Rudderstack](https://tinybird.co/docs/get-data-in/guides/ingest-from-rudderstack) - [Ingest From Sentry](https://tinybird.co/docs/get-data-in/guides/ingest-from-sentry) - [Ingest From Snowflake Via Unloading](https://tinybird.co/docs/get-data-in/guides/ingest-from-snowflake-via-unloading) - [Ingest From Stripe](https://tinybird.co/docs/get-data-in/guides/ingest-from-stripe) - [Ingest From The Events Api](https://tinybird.co/docs/get-data-in/guides/ingest-from-the-events-api) - [Ingest From Vercel](https://tinybird.co/docs/get-data-in/guides/ingest-from-vercel) - [Ingest Ndjson Data](https://tinybird.co/docs/get-data-in/guides/ingest-ndjson-data) - [Ingest Vercel Logdrains](https://tinybird.co/docs/get-data-in/guides/ingest-vercel-logdrains) - [Ingest With Estuary](https://tinybird.co/docs/get-data-in/guides/ingest-with-estuary) - [Postgres Cdc With Redpanda Connect](https://tinybird.co/docs/get-data-in/guides/postgres-cdc-with-redpanda-connect) - [Postgresql](https://tinybird.co/docs/get-data-in/guides/postgresql) - [Python Sdk](https://tinybird.co/docs/get-data-in/guides/python-sdk) ### Ingest Apis - [Datasource Api](https://tinybird.co/docs/get-data-in/ingest-apis/datasource-api) - [Events Api](https://tinybird.co/docs/get-data-in/ingest-apis/events-api) ### Migrate - [Migrate From Doublecloud](https://tinybird.co/docs/get-data-in/migrate/migrate-from-doublecloud) - [Migrate From Postgres](https://tinybird.co/docs/get-data-in/migrate/migrate-from-postgres) - [Migrate From Rockset](https://tinybird.co/docs/get-data-in/migrate/migrate-from-rockset) ## Get Started - [Administration](https://tinybird.co/docs/get-started/administration) - [Architecture](https://tinybird.co/docs/get-started/architecture) - [Compliance](https://tinybird.co/docs/get-started/compliance) - [Integrations](https://tinybird.co/docs/get-started/integrations) - [Plans](https://tinybird.co/docs/get-started/plans) - [Quick Start](https://tinybird.co/docs/get-started/quick-start) ### Administration - [Auth Tokens](https://tinybird.co/docs/get-started/administration/auth-tokens) - [Organizations](https://tinybird.co/docs/get-started/administration/organizations) - [Team Integration Governance](https://tinybird.co/docs/get-started/administration/team-integration-governance) - [Workspaces](https://tinybird.co/docs/get-started/administration/workspaces) ### Plans - [Billing](https://tinybird.co/docs/get-started/plans/billing) - [Limits](https://tinybird.co/docs/get-started/plans/limits) - [Support](https://tinybird.co/docs/get-started/plans/support) ### Quick Start - [Core Concepts](https://tinybird.co/docs/get-started/quick-start/core-concepts) - [Leaderboard](https://tinybird.co/docs/get-started/quick-start/leaderboard) - [Tinybird 101 Tutorial](https://tinybird.co/docs/get-started/quick-start/tinybird-101-tutorial) - [User Facing Web Analytics](https://tinybird.co/docs/get-started/quick-start/user-facing-web-analytics) - [Vector Search Recommendation](https://tinybird.co/docs/get-started/quick-start/vector-search-recommendation) ## Live - [Check](https://tinybird.co/docs/live/check) ## Monitoring - [Analyze Endpoints Performance](https://tinybird.co/docs/monitoring/analyze-endpoints-performance) - [Health Checks](https://tinybird.co/docs/monitoring/health-checks) - [Jobs](https://tinybird.co/docs/monitoring/jobs) - [Latency](https://tinybird.co/docs/monitoring/latency) - [Monitor Data Ingestion](https://tinybird.co/docs/monitoring/monitor-data-ingestion) - [Service Datasources](https://tinybird.co/docs/monitoring/service-datasources) ## Publish - [Api Endpoints](https://tinybird.co/docs/publish/api-endpoints) - [Charts](https://tinybird.co/docs/publish/charts) - [Sinks](https://tinybird.co/docs/publish/sinks) ### Api Endpoints - [Advanced Dynamic Endpoints Functions](https://tinybird.co/docs/publish/api-endpoints/guides/advanced-dynamic-endpoints-functions) - [Consume Api Endpoints In Grafana](https://tinybird.co/docs/publish/api-endpoints/guides/consume-api-endpoints-in-grafana) - [Consume Api Endpoints In Prometheus Format](https://tinybird.co/docs/publish/api-endpoints/guides/consume-api-endpoints-in-prometheus-format) - [Consume Apis In A Notebook](https://tinybird.co/docs/publish/api-endpoints/guides/consume-apis-in-a-notebook) - [Consume Apis Nextjs](https://tinybird.co/docs/publish/api-endpoints/guides/consume-apis-nextjs) - [Guides](https://tinybird.co/docs/publish/api-endpoints/guides) - [List Of Errors](https://tinybird.co/docs/publish/api-endpoints/list-of-errors) - [Reliable Scheduling With Trigger](https://tinybird.co/docs/publish/api-endpoints/guides/reliable-scheduling-with-trigger) - [Serverless Analytics Api](https://tinybird.co/docs/publish/api-endpoints/guides/serverless-analytics-api) - [Share Endpoint Documentation](https://tinybird.co/docs/publish/api-endpoints/guides/share-endpoint-documentation) ### Charts - [Add Charts To Nextjs](https://tinybird.co/docs/publish/charts/guides/add-charts-to-nextjs) - [Analytics With Confluent](https://tinybird.co/docs/publish/charts/guides/analytics-with-confluent) - [Bigquery Dashboard](https://tinybird.co/docs/publish/charts/guides/bigquery-dashboard) - [Charts Using Iframes And Jwt Tokens](https://tinybird.co/docs/publish/charts/guides/charts-using-iframes-and-jwt-tokens) - [Guides](https://tinybird.co/docs/publish/charts/guides) - [Real Time Dashboard](https://tinybird.co/docs/publish/charts/guides/real-time-dashboard) ### Sinks - [Kafka Sink](https://tinybird.co/docs/publish/sinks/kafka-sink) - [S3 Sink](https://tinybird.co/docs/publish/sinks/s3-sink) ## Screencasts - [Opengraph Image Cbmrif.jpeg](https://tinybird.co/docs/screencasts/opengraph-image-cbmrif.jpeg) ## Sql Reference - [Data Types](https://tinybird.co/docs/sql-reference/data-types) - [Engines](https://tinybird.co/docs/sql-reference/engines) - [Functions](https://tinybird.co/docs/sql-reference/functions) ### Data Types - [Aggregatefunction](https://tinybird.co/docs/sql-reference/data-types/aggregatefunction) - [Array](https://tinybird.co/docs/sql-reference/data-types/array) - [Boolean](https://tinybird.co/docs/sql-reference/data-types/boolean) - [Date](https://tinybird.co/docs/sql-reference/data-types/date) - [Date32](https://tinybird.co/docs/sql-reference/data-types/date32) - [Datetime](https://tinybird.co/docs/sql-reference/data-types/datetime) - [Datetime64](https://tinybird.co/docs/sql-reference/data-types/datetime64) - [Decimal](https://tinybird.co/docs/sql-reference/data-types/decimal) - [Enum](https://tinybird.co/docs/sql-reference/data-types/enum) - [Fixedstring](https://tinybird.co/docs/sql-reference/data-types/fixedstring) - [Float](https://tinybird.co/docs/sql-reference/data-types/float) - [Geo](https://tinybird.co/docs/sql-reference/data-types/geo) - [Int Uint](https://tinybird.co/docs/sql-reference/data-types/int-uint) - [Interval](https://tinybird.co/docs/sql-reference/data-types/interval) - [Ipv4](https://tinybird.co/docs/sql-reference/data-types/ipv4) - [Ipv6](https://tinybird.co/docs/sql-reference/data-types/ipv6) - [Json](https://tinybird.co/docs/sql-reference/data-types/json) - [Lowcardinality](https://tinybird.co/docs/sql-reference/data-types/lowcardinality) - [Map](https://tinybird.co/docs/sql-reference/data-types/map) - [Nothing](https://tinybird.co/docs/sql-reference/data-types/nothing) - [Nullable](https://tinybird.co/docs/sql-reference/data-types/nullable) - [Simpleaggregatefunction](https://tinybird.co/docs/sql-reference/data-types/simpleaggregatefunction) - [String](https://tinybird.co/docs/sql-reference/data-types/string) - [Tuple](https://tinybird.co/docs/sql-reference/data-types/tuple) - [Uuid](https://tinybird.co/docs/sql-reference/data-types/uuid) ### Engines - [Aggregatingmergetree](https://tinybird.co/docs/sql-reference/engines/aggregatingmergetree) - [Collapsingmergetree](https://tinybird.co/docs/sql-reference/engines/collapsingmergetree) - [Engine Settings](https://tinybird.co/docs/sql-reference/engines/engine-settings) - [Mergetree](https://tinybird.co/docs/sql-reference/engines/mergetree) - [Null](https://tinybird.co/docs/sql-reference/engines/null) - [Replacingmergetree](https://tinybird.co/docs/sql-reference/engines/replacingmergetree) - [Summingmergetree](https://tinybird.co/docs/sql-reference/engines/summingmergetree) - [Versionedcollapsingmergetree](https://tinybird.co/docs/sql-reference/engines/versionedcollapsingmergetree) ### Functions - [Aggregate Functions](https://tinybird.co/docs/sql-reference/functions/aggregate-functions) - [Arithmetic Functions](https://tinybird.co/docs/sql-reference/functions/arithmetic-functions) - [Array Functions](https://tinybird.co/docs/sql-reference/functions/array-functions) - [Array Join](https://tinybird.co/docs/sql-reference/functions/array-join) - [Bit Functions](https://tinybird.co/docs/sql-reference/functions/bit-functions) - [Bitmap Functions](https://tinybird.co/docs/sql-reference/functions/bitmap-functions) - [Comparison Functions](https://tinybird.co/docs/sql-reference/functions/comparison-functions) - [Conditional Functions](https://tinybird.co/docs/sql-reference/functions/conditional-functions) - [Date Time Functions](https://tinybird.co/docs/sql-reference/functions/date-time-functions) - [Distance Functions](https://tinybird.co/docs/sql-reference/functions/distance-functions) - [Encoding Functions](https://tinybird.co/docs/sql-reference/functions/encoding-functions) - [Encryption Functions](https://tinybird.co/docs/sql-reference/functions/encryption-functions) - [Functions For Nulls](https://tinybird.co/docs/sql-reference/functions/functions-for-nulls) - [Geo Functions](https://tinybird.co/docs/sql-reference/functions/geo-functions) - [Hash Functions](https://tinybird.co/docs/sql-reference/functions/hash-functions) - [Ip Address Functions](https://tinybird.co/docs/sql-reference/functions/ip-address-functions) - [Json Functions](https://tinybird.co/docs/sql-reference/functions/json-functions) - [Logical Functions](https://tinybird.co/docs/sql-reference/functions/logical-functions) - [Machine Learning Functions](https://tinybird.co/docs/sql-reference/functions/machine-learning-functions) - [Math Functions](https://tinybird.co/docs/sql-reference/functions/math-functions) - [Other Functions](https://tinybird.co/docs/sql-reference/functions/other-functions) - [Parametric Functions](https://tinybird.co/docs/sql-reference/functions/parametric-functions) - [Random Functions](https://tinybird.co/docs/sql-reference/functions/random-functions) - [Rounding Functions](https://tinybird.co/docs/sql-reference/functions/rounding-functions) - [Splitting Merging Functions](https://tinybird.co/docs/sql-reference/functions/splitting-merging-functions) - [String Functions](https://tinybird.co/docs/sql-reference/functions/string-functions) - [String Replace Functions](https://tinybird.co/docs/sql-reference/functions/string-replace-functions) - [String Search Functions](https://tinybird.co/docs/sql-reference/functions/string-search-functions) - [Time Series Functions](https://tinybird.co/docs/sql-reference/functions/time-series-functions) - [Time Window Functions](https://tinybird.co/docs/sql-reference/functions/time-window-functions) - [Tuple Functions](https://tinybird.co/docs/sql-reference/functions/tuple-functions) - [Tuple Map Functions](https://tinybird.co/docs/sql-reference/functions/tuple-map-functions) - [Type Conversion Functions](https://tinybird.co/docs/sql-reference/functions/type-conversion-functions) - [Ulid Functions](https://tinybird.co/docs/sql-reference/functions/ulid-functions) - [Uniqtheta Functions](https://tinybird.co/docs/sql-reference/functions/uniqtheta-functions) - [Url Functions](https://tinybird.co/docs/sql-reference/functions/url-functions) - [Uuid Functions](https://tinybird.co/docs/sql-reference/functions/uuid-functions) - [Window Functions](https://tinybird.co/docs/sql-reference/functions/window-functions) ## Use Cases - [Content Recommendation](https://tinybird.co/docs/use-cases/content-recommendation) - [Gaming Analytics](https://tinybird.co/docs/use-cases/gaming-analytics) - [Realtime Cdc](https://tinybird.co/docs/use-cases/realtime-cdc) - [Realtime Personalization](https://tinybird.co/docs/use-cases/realtime-personalization) - [Ugc Analytics](https://tinybird.co/docs/use-cases/ugc-analytics) - [User Facing Dashboards](https://tinybird.co/docs/use-cases/user-facing-dashboards) - [Vector Search](https://tinybird.co/docs/use-cases/vector-search) - [Web Analytics](https://tinybird.co/docs/use-cases/web-analytics) ## V2 - [Command Ref](https://tinybird.co/docs/v2/command-ref) - [Datafiles](https://tinybird.co/docs/v2/datafiles) - [Testing](https://tinybird.co/docs/v2/testing) ### Datafiles - [Datasource Files](https://tinybird.co/docs/v2/datafiles/datasource-files) - [Pipe Files](https://tinybird.co/docs/v2/datafiles/pipe-files) ## Work With Data - [Optimization](https://tinybird.co/docs/work-with-data/optimization) - [Organize Your Work](https://tinybird.co/docs/work-with-data/organize-your-work) - [Process And Copy](https://tinybird.co/docs/work-with-data/process-and-copy) - [Query](https://tinybird.co/docs/work-with-data/query) - [Strategies](https://tinybird.co/docs/work-with-data/strategies) ### Optimization - [Opt101 Detect Inefficiencies](https://tinybird.co/docs/work-with-data/optimization/opt101-detect-inefficiencies) - [Opt201 Fix Mistakes](https://tinybird.co/docs/work-with-data/optimization/opt201-fix-mistakes) ### Organize Your Work - [Branches](https://tinybird.co/docs/work-with-data/organize-your-work/branches) - [Continuous Integration](https://tinybird.co/docs/work-with-data/organize-your-work/continuous-integration) - [Integrating Vercel](https://tinybird.co/docs/work-with-data/organize-your-work/integrating-vercel) - [Organizing Resources](https://tinybird.co/docs/work-with-data/organize-your-work/organizing-resources) - [Staging And Production Workspaces](https://tinybird.co/docs/work-with-data/organize-your-work/staging-and-production-workspaces) - [Working With Version Control](https://tinybird.co/docs/work-with-data/organize-your-work/working-with-version-control) ### Process And Copy - [Best Practices](https://tinybird.co/docs/work-with-data/process-and-copy/materialized-views/best-practices) - [Copy Pipes](https://tinybird.co/docs/work-with-data/process-and-copy/copy-pipes) - [Example Mv Cli](https://tinybird.co/docs/work-with-data/process-and-copy/materialized-views/example-mv-cli) - [Example Mv Ui](https://tinybird.co/docs/work-with-data/process-and-copy/materialized-views/example-mv-ui) - [Materialized Views](https://tinybird.co/docs/work-with-data/process-and-copy/materialized-views) - [Populate Data](https://tinybird.co/docs/work-with-data/process-and-copy/populate-data) ### Query - [Adapt Postgres Queries](https://tinybird.co/docs/work-with-data/query/guides/adapt-postgres-queries) - [Bi Connector](https://tinybird.co/docs/work-with-data/query/bi-connector) - [Dynamic Aggregation](https://tinybird.co/docs/work-with-data/query/guides/dynamic-aggregation) - [Guides](https://tinybird.co/docs/work-with-data/query/guides) - [Lambda Architecture](https://tinybird.co/docs/work-with-data/query/guides/lambda-architecture) - [Lambda Example Cdc](https://tinybird.co/docs/work-with-data/query/guides/lambda-example-cdc) - [Pipes](https://tinybird.co/docs/work-with-data/query/pipes) - [Query Parameters](https://tinybird.co/docs/work-with-data/query/query-parameters) - [Sql Best Practices](https://tinybird.co/docs/work-with-data/query/sql-best-practices) - [Working With Time](https://tinybird.co/docs/work-with-data/query/guides/working-with-time) ### Strategies - [Backfill From External](https://tinybird.co/docs/work-with-data/strategies/backfill-from-external) - [Backfill Strategies](https://tinybird.co/docs/work-with-data/strategies/backfill-strategies) - [Deduplication Strategies](https://tinybird.co/docs/work-with-data/strategies/deduplication-strategies) - [Deployment Strategies](https://tinybird.co/docs/work-with-data/strategies/deployment-strategies) - [Implementing Test Strategies](https://tinybird.co/docs/work-with-data/strategies/implementing-test-strategies)