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

Create a Sigma Query Preview

Sigma
Saved Query
Create a Sigma Query

Create a Sigma query that can be run

Parameters

  • sqlstringRequired

    The sql statement to be run. This should be a valid Trino SQL statement that can be run in Sigma.

  • namestring

    The name of the query. This will be used to identify the query.

Returns

Returns the specified Sigma Query object.

POST /v1/sigma/saved_queries
cURL
curl https://api.stripe.com/v1/sigma/saved_queries \
  -u "sk_test_BQokikJ...2HlWgH4olfQ2sk_test_BQokikJOvBiI2HlWgH4olfQ2:" \
  -H "Stripe-Version: 2025-05-28.preview" \
  --data-urlencode sql="SELECT * FROM balance_transactions LIMIT 5"
Response
{
  "id": "qfl_0R46kn589O8KAxCGtbTjfolP",
  "object": "sigma.sigma_api_query",
  "created": 1742329729,
  "livemode": true,
  "sql": "SELECT * FROM balance_transactions LIMIT 5",
  "name": "Select balance transactions"
}