Preview local changes
Preview local changes before committing and deploying them.
Utilize the bottom drawer function to preview local changes.
The Preview Local Changes menu offers the following functionalities:
- Preview data
- View the compiled query of your asset
Shortcut: COMMAND + ENTER
To preview a partial SQL query, select the portion you want to preview (available in both Data Catalog and Code mode) and use the same shortcut as above or right click to 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.
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.
You can aggregate results and group them by specific columns in the preview. Click on the three dots of any column for more actions, navigate to the second tab with three horizontal lines (aggregations), and select
Group By <column_name>.
You can pivot the preview result set. Click on the
<n>/<m> columns label and toggle Pivot on. You can now select the Row Groups, Values, and Column Labels by dragging columns from the list.
For Snowflake-connected spaces, you can select from the available warehouses to preview data.
Shortcut: COMMAND + ALT + ENTER
To compile a partial SQL query, select the portion you want to compile (available in both Data Catalog and Code mode) and use the same shortcut as above or right click to compile.
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.