Preview local changes

Preview local changes before committing and deploying them.

Overview

Utilize the bottom drawer function to preview local changes.

Exploring the options

The Preview Local Changes menu offers the following functionalities:

Preview data
View the compiled query of your asset

Data query preview

Choose to either preview the first 100 rows or opt for a full preview, which materializes the previewed query as a table inside the Data Warehouse (DWH) with a 24-hour time-to-live period.

Data query options: first 100 rows or full preview.

Utilizing the full preview feature grants you the capability to apply filters across all rows, transcending the initial 100-row limit. This becomes possible once the asset has been materialized as a table. This feature is particularly useful for verifying specific row data against your expectations before committing changes and building your asset.

Compiled query

In this section, view the compiled query utilizing the underlying data warehouse tables and views. Learn more about the naming conventions utilized for branches and assets.

products.sql

compiled_query

select
    cast(id as string) as product_id,
    created_at,
    make,
    model,
    price,
    `year` as production_year
from {{ source('airbyte-postgres', 'products') }}

Lineage Command menu