Skip to main content
POST
Check SQL

Authorizations

Authorization
string
header
required

An API key, sent as Authorization: Bearer stfy_live_…. See Authentication for how to get one and which scopes it needs.

Path Parameters

key
string
required

The integration key, such as snowflake or salesforce

Body

application/json
sql
string
required

One SELECT, in the warehouse's own dialect. It may use {START_DATE}, {END_DATE}, {START_DATE_SQL} and {END_DATE_SQL}, which each run fills with its period's dates

Required string length: 1 - 100000

Response

200 - application/json

Successful Response

errors
string[]
required
outside_allowlist
string[]
required

Tables it reads that the table allowlist does not cover

tables_referenced
string[]
required
valid
boolean
required

One SELECT that parses, and inside the table allowlist