Scheduling and Exports

Scheduling Queries

• Create a schedule from any saved query.
• Choose cadence (for example, daily at 09:00) and timezone.
• Provide parameter values if your query uses named parameters (for example, :start, :end).
• Manage schedules: pause, resume, edit, or delete from the Schedules view.

Delivery options

• Email: attachment (when small) or a secure link for large results.
• Webhook: delivers a signed notification with metadata and a secure link to results.

Webhook Payload (Example)

{
  "type": "prism.query_succeeded",
  "data": {
    "query_id": "q_123",
    "run_id": "qr_abc",
    "row_count": 1245,
    "files": [
      {
        "format": "csv",
        "url": "https://.../download?sig=...",
        "expires_at": "2025-10-21T00:00:00Z"
      }
    ],
    "started_at": "2025-10-20T08:59:00Z",
    "finished_at": "2025-10-20T09:00:03Z"
  }
}

Note: The exact payload can change; rely on the type and the presence of a file link. Validate signatures according to your organization’s settings.

Exports

• Formats: CSV and JSON; Parquet may be available on some plans.
• Large results: generated in the background and provided via a temporary download link.
• Retention: links expire after a limited time; you can rerun the query to regenerate them.

Tips

• Parameterize by date so schedules adapt (for example, last full day).
• Keep result sets manageable by aggregating rather than exporting raw rows.
• Use webhooks for automation; email for human review.

Last updated: 2025-10-20