Execute Custom SQL Query

POST https://api.triplewhale.com/api/v2/orcabase/api/sql

Run custom SQL queries for structured data retrieval. The response returns the query results in a JSON format.

🚧

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 Sync

Use Data Warehouse Sync instead if you want to push data to BigQuery, Snowflake, AWS S3, or GCS on a set schedule.