Preview data

Specific operations: Preview Data

Breadcrumb:
Navigation Tree or Diagram → Right-click on object → Preview Data

Image

Overview

The Preview Data feature in AnalyticsCreator allows you to run a live query against any selected source table, staging object, DWH entity, or transformation result. It displays a preview of the actual data—including column values and data types—fetched directly from the connected system. This function is especially useful for validating transformation logic or reviewing live data structures during modeling.

When and Why to Use This Feature

• To quickly inspect source or transformation output without deploying packages
• When validating joins, filters, or expressions during development
• To troubleshoot pipeline issues by checking actual column values and formats
• To confirm metadata alignment with the current data in source or target systems

How to Use the Preview Data Function

1. Navigate to the Navigation Tree or Diagram View in your project
2. Right-click on the object you want to inspect (e.g., source table, staging view, transformation)
3. Select Preview Data from the context menu
4. Wait for the live query to execute and sample data to appear in the preview window
5. Review the results to validate logic or investigate issues