Skip to main content

Check Statsig SQL

Statsig Warehouse Native runs SQL in our customers' data warehouse to generate the experiment results, and the queries are fully transparent to our customers. This means that you can trace any results you see on the Statsig console back to its calculation, artifacts, and raw events.

The pipeline-overview provides an overview of how the queries are orchestrated to produce the experiment results. If you are curious about the details or want to debug, you can find the experiment-specific SQL by going to the experiment’s Pulse view -> view history -> view details on a specific pulse load. You’ll be able to see all the jobs that went into that pulse load.

image

There are a few queries with [Health Check] as a prefix that automatically check the health of the experiment. You can view this page to understand what they do.

For experiment result calculation queries, below are one-sentence summaries of what each query does.

  • First exposure: Generate the first exposure time of this experiment at the unit level, given the assignment source.
  • Exposure summary: Summarize the first exposures at the group level and generate cumulative exposures.
  • User-level calculations: Calculate unit-level metrics at unit metric day grain.
  • Windowed rollups: Rollup unit-level metrics at different time windows.
  • Plus calculation: Generate the sample parameters that are necessary for calculating treatment effects, such as units, total, mean, standard deviation, population variance, covariance, etc.