Sign in

v2

latestOpenAPI 3.1.0raw.githubusercontent.com2026-03-067997411.3 KB

Execute a SQL query against the user's data.

The endpoint provides read-only access to secure views (transactions, cards, accounts, etc.) scoped to the authenticated user's entities.

SQL Dialect: Uses Snowflake SQL syntax.

Data Freshness: Data may be up to 1 hour behind real-time.

Use SHOW TABLES to list available tables and DESCRIBE <table> to see columns.

post/analytics

Request body

querystring required

SQL query to execute against the sandbox. Supports SELECT on exposed views, SHOW TABLES, and DESCRIBE <table>.

Response

OK

columnsstring[] required

Ordered list of column names in the result set.

rowsobject[] required

Array of row objects keyed by column name.

rowCountinteger required

Total number of rows returned.

errorstring

SQL error message when the query fails.