• Documentation
  • API reference
  • SQL reference
  • Tinybird Classic
Sign InStart building
DocumentationAPI referenceSQL referenceTinybird Classic
  • Tinybird Classic

    • Quick start

      • Core concepts
      • Tinybird 101
      • Leaderboard tutorial
      • User-facing web analytics
      • Vector search recommendation engine
    • Integrations

    • Plans

      • Concepts
      • Billing
      • Limits
      • Support

    • Administration

      • Organizations
      • Workspaces
      • Tokens
      • Governance
    • Architecture
    • Compliance
  • Get data in
    • Data Sources

    • Ingest APIs

      • Data Sources API
      • Events API

    • Connectors

      • Amazon DynamoDB
      • Amazon MSK
      • Amazon S3
      • Confluent
      • Kafka
      • Redpanda

    • Table functions

      • MySQL
      • PostgreSQL
      • URL

    • Ingest guides

      • Auth0
      • AWS Kinesis
      • BigQuery using Google Cloud Storage
      • Clerk
      • CSV files
      • DynamoDB Single-Table
      • Estuary
      • GitLab
      • GitHub
      • Google Cloud Storage
      • Google Pub/Sub
      • HTTP Requests
      • Knock
      • LiteLLM
      • Mailgun
      • MongoDB
      • NDJSON data
      • Orb
      • PagerDuty
      • Postgres CDC with Redpanda Connect
      • Python logs
      • Resend
      • Dub
      • RudderStack
      • Sentry
      • Stripe
      • Snowflake using S3
      • Snowflake using Azure Blob Storage
      • Snowflake incremental updates
      • Vector.dev
      • Vercel (webhooks)
      • Vercel (log drains)
      • Vercel AI SDK

    • Migrate data in

      • Migrate from Rockset
      • Migrate from DoubleCloud
      • Migrate from Postgres

    • Data operations

      • Recover data from quarantine
      • Replace & delete data
      • Iterate a Data Source
      • Schedule data ingestion with cron
  • Work with data

    • Explore and query

      • Pipes
      • Query parameters
      • SQL best practices

      • Query guides

        • Adapt Postgres queries
        • Build a lambda architecture
        • Lambda use case: CDC
        • Rollup aggregations
        • Working with time

    • Process and copy

      • Materialized Views

        • Example (UI)
        • Example (CLI)
        • Best practices
      • Copy Pipes
      • Populate and copy data
      • Create reliable schedules with Trigger.dev

    • Optimizations

      • Optimizations 101: Detect inefficiencies
      • Optimizations 201: Fix common mistakes

    • Organize your work

      • Organize resources
      • Branches
      • Staging and production Workspaces
      • Working with version control
      • CI/CD
      • Vercel Integration

    • Strategies

      • Backfill from external sources
      • Backfill strategies for iterations
      • Deduplication strategies
      • Deployment strategies
      • Test strategies
  • Publish your data

    • API Endpoints

      • Database errors

      • Guides

        • Multi-tenant real-time APIs with Clerk and Tinybird
        • Consume APIs in a Next.js frontend
        • Consume APIs in a notebook
        • Consume APIs in Prometheus format
        • Secure APIs with Tokens
        • Share API docs with team members
        • Use advanced dynamic endpoint functions
        • Visualize APIs in Grafana

    • Charts

      • Guides

        • Add Charts to a Next.js frontend
        • Real-time dashboard with BigQuery
        • Real-time dashboard with Tremor
        • Use charts with iframes and JWT
        • User-facing analytics with Confluent

    • Sinks

      • Kafka Sink
      • S3 Sink
  • Monitor your data
    • Health checks
    • Service Data Sources
    • Monitor Workspace jobs
    • Measure endpoint latency
    • Analyze endpoint performance
    • Monitor ingestion
  • CLI documentation (v1)
  • Tinybird Forward
Changelog
Start building
Sign In
  1. Home
  2. /Work with data
  3. /Explore and query
  4. /Query guides

Tinybird Forward is live! See the Tinybird Forward docs to learn more. To migrate, see Migrate from Classic.

Querying data guides¶

Learn how to query data in Tinybird.

Each guide provides detailed instructions on how to best query data in Tinybird.

  • Adapt Postgres queries
  • Build a lambda architecture
  • Lambda use case: CDC
  • Rollup aggregations
  • Working with time
PreviousSQL best practices
NextAdapt Postgres queries
Was this page helpful?
Copyright © 2025 Tinybird. All rights reserved
|
Terms & conditionsCookiesTrust CenterCompliance HelplineThird-party credits