Explore documentation
  1. Welcome to Warehouse 👋
  2. Ingesting data
    1. Ingesting events
    2. S3 vs NVMe hosted data
    3. Host events in your S3 bucket
  3. Querying data
    1. Querying events & time series
    2. Writing ClickHouse SQL queries
    3. Query speeds
    4. Ad-hoc SQL API
    5. Generate client-facing APIs
    6. Visualizing data
  4. Vector embeddings
    1. Introduction to embeddings
    2. Using built-in embeddings
    3. Bringing your own embeddings
    4. Data structures and indices
  5. Use cases
    1. Retrieval Augmented Generation
  6. Management
    1. Controlling costs

Generate client-facing APIs

Get client-facing APIs with JSON, CSV or TSV for your saved queries.

CleanShot 2025-10-17 at 9 .32.45.png

JSON, CSV or TSV

Simply adjust the generated URL to get a different format.

CSV export
curl "https://eu-nbg-2-connect.betterstackdata.com/query/ti1Mweu5FCyTCEIlNNRAYzm1l5rAyL9n.csv"
JSON format
curl "https://eu-nbg-2-connect.betterstackdata.com/query/ti1Mweu5FCyTCEIlNNRAYzm1l5rAyL9n.json"

Pass variables into your saved queries

Specify {{my_variable}} in your SQL query similarly to:

CleanShot 2025-10-17 at 9 .37.26.png

And set the value of ?my_variable as a GET attribute when calling the API.

Pass variable as a GET parameter
curl https://us-east-9-connect.betterstackdata.com/query/ETz5pa7597O8Sc3S3Zd9vGqilr9yrXsY.json?my_variable=my_value

Optimized for high request throughput

Better Stack Warehouse client-facing APIs are optimized for many HTTP requests. They will survive your website making it to the homepage of Reddit.

Customize cache frequency

CleanShot 2025-10-17 at 9 .42.30.png

Previous article

Querying data with Ad-hoc SQL API

Next article

Visualizing data