SQLise Examples

A BigQuery scripting block that loops over partitions and rebuilds a fact table. Lineage shows partition-by-partition flow into one mart.

A compiled dbt incremental model that appends new events. Lineage shows the source events table feeding the incremental sink with a watermark filter.

Compiled SQL from a typical dbt staging → intermediate → mart layering. Column lineage shows source freshness from source tables to mart columns.

A typical ecommerce revenue model: orders join customers and order_items, then roll up into a daily revenue view. See how each output column traces back to its source tables.

Get the top 3 most recent orders per customer using LATERAL. Lineage shows the lateral subquery as a stage between customers and the result.

First-touch attribution joining sessions, conversions, and campaigns. The lineage shows which session columns become which attribution columns.

A canonical MERGE that upserts staging rows into a dimension. Lineage exposes which target columns are sourced from which staging columns.

A long-format sales table pivoted into one column per month. Lineage shows every Jan..Dec column tracing to the same amount source.

Project typed columns out of a JSONB payload and into a clean view. Lineage tracks every typed column back to the JSONB source.

Walk a manager → employee hierarchy with WITH RECURSIVE. The lineage view treats the recursive CTE as a self-referencing stage.

Maintain a dim_customers SCD2 table from a staging snapshot. Lineage exposes both the active row and the closed-out historical row.

Compare a Snowflake table to its state 24 hours ago using AT(OFFSET ⇒ -86400). Lineage shows the historical scan as a separate source.

Snowflake stage → stream → task → warehouse table. See lineage across data-flow primitives, not just SELECTs.

A SQL Server MERGE that captures changed rows using the OUTPUT clause. Lineage covers both the target table and the audit table.

A wide survey table flattened into one row per (response_id, question). Lineage shows every wide column collapsing into one source column.

A daily revenue table turned into a running total using SUM() OVER (ORDER BY day). Lineage shows the projected running_total column tracing back to revenue.