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.

🚧
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.

🤔
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.

Language

Credentials

Header

Click Try It! to start a request and see the response here!