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

The Query Run object 

Sigma
Query Run
The Query Run object

Attributes

  • idstring

    Unique identifier for the object.

  • objectstring

    String representing the object’s type. Objects of the same type share the same value.

  • createdtimestamp

    Time at which the object was created. Measured in seconds since the Unix epoch.

  • finalized_atnullable timestamp

    Timestamp describing when a Query run reached the terminal status.

  • livemodeboolean

    Has the value true if the object exists in live mode or the value false if the object exists in test mode.

  • sqlstring

    The sql statement that is run.

  • statusnullable enum

    The status of the query run. Possible values are succeeded, pending, running, and failed.

The Query Run object
{
  "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 4",
  "status": "completed"
}