If you wish to run your query using the SQL Builder interface rather than via API (e.g. for testing or data exploration), replace @startDate and @endDate (camelCase) with @start_date and @end_date (snake_case) in the SQL expression.
🚧
Best Practices
Select Specific Columns
Avoid using SELECT * in your queries. Our schema is dynamic, and using wildcard selection can lead to broken or inconsistent results as fields change. Always specify the exact columns you need.
Rate Limits
The API enforces two rate limits:
100 requests per second
600 requests per minute
If you exceed these quotas, the API will return a 429 Too Many Requests error.
🤔
Compare with Data Warehouse Export
Use Data Warehouse Export instead if you want to push data directly to BigQuery, Snowflake, AWS S3, or GCS.
Responses
400
Invalid request due to missing or malformed parameters.
403
Access forbidden due to missing or invalid access token.
429
Rate limit exceeded. Too many requests were sent in a short period.
500
Internal server error. An unexpected issue occurred on the server.
Updated 5 months ago
Language
ShellNodeRubyPHPPython
Credentials
Header
Header
Loading…
Response
Click Try It! to start a request and see the response here! Or choose an example: