Core Resources
Payment Methods
Products
Checkout
Payment Links
Billing
Capital
Connect
Reserves
Fraud
Issuing
Terminal
Treasury
Entitlements
Sigma
Reporting
Financial Connections
Tax
Identity
Crypto
Climate
Forwarding
Privacy
Webhooks

Create a Query Run 

Sigma
Query Run
Create a Query Run

Create a query run to be executed.

Parameters

  • from_saved_querystring

    The unique id of a previously saved query to be run. Note that only one of sql or from_saved_query should be provided.

  • sqlstring

    The sql statement to run. This should be a valid Trino SQL statement that can be run in Sigma. Note that only one of sql or from_saved_query should be provided.

Returns

Returns a Query Run object.

POST /v1/sigma/query_runs
curl https://api.stripe.com/v1/sigma/query_runs \
  -u "sk_test_BQokikJ...2HlWgH4olfQ2sk_test_BQokikJOvBiI2HlWgH4olfQ2:" \
  --data-urlencode sql="SELECT * FROM balance_transactions LIMIT 4"
Response
{
  "id": "qry_0R9c43589O8STxCGUZXU3I6T",
  "object": "sigma.sigma_query_run",
  "created": 1743641728,
  "error": null,
  "finalized_at": 1743641733,
  "livemode": true,
  "result": {
    "file": "file_0R9c49589O8KAxR9askNs8JQ"
  },
  "sql": "SELECT * FROM balance_transactions LIMIT 5",
  "status": "completed"
}