# View SQL

Statsig Warehouse Native runs SQL in your warehouse to generate experiment results. The queries are fully transparent and visible in the console, so you can trace any result back to its calculation, artifacts, and raw events.

The [pipeline-overview](https://docs.statsig.com/statsig-warehouse-native/analysis-tools/pipeline-overview) describes how Statsig orchestrates queries to produce experiment results. To debug or inspect details, find the experiment-specific SQL by going to the experiment’s Pulse view, then selecting view history, then view details on a specific pulse load. That page shows all jobs that contributed to that pulse load.

{% figure %}
![Pulse view SQL query details interface](https://docs.statsig.com/images/statsig-warehouse-native/guides/sql/f34e1265-e303-4705-b8cd-1a170a2af91e.png)
{% /figure %}

A few queries with a \[Health Check] prefix automatically check the health of the experiment. Go to [Monitor an Experiment](https://docs.statsig.com/statsig-warehouse-native/features/monitor-an-experiment) to learn what these queries 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.
* Pluse calculation: Generate the sample parameters that are necessary for calculating treatment effects, such as units, total, mean, standard deviation, population variance, covariance, etc.