DocumentationTutorialsUse Cases & Blueprints

Verification and validation

Last update: September 11, 2026

CREATED FOR:

  • Developer
  • User

Preview the dataset

  1. Click on Datasets

  2. Locate and click the dataset name that you created.

    Locating and clicking the dataset name in the Datasets pane

  3. Click on Preview dataset in the top right corner

    Preview dataset button location in the top right corner of the dataset screen

  4. Verify and validate the same records that you ingested by clicking on the left pane showing the schema hierarchy.

Dataset preview with schema hierarchy pane showing ingested records

NOTE
Preview dataset displays the most recent successful batch in this dataset. You are not able to see the previous batches. Also, complex data such as arrays and maps are not viewable today and appear as empty columns. Do not panic! To get a more comprehensive view, you need to use SQL to explore the dataset as explained below.

Query dataset

  1. Close the Preview

  2. In the Dataset screen, click the copy icon on Table name. In the example screen below, the table name is customer_account_sm

    Copy icon next to the table name in the Dataset screen

  3. Navigate to Queries section

  4. Click on Create query

    Create query button in the Queries section

  5. Copy paste the following SQL query in the Editor. Remember to replace <table_name> with the value you obtained in step 6.

    code language-sql 
    SELECT * FROM <table_name>

  6. Press the Play button.

    Query editor interface with SQL query and Play button

  7. Preview the results

  8. Also, execute the following SQL query to retrieve the XDM schema along with the data:

SELECT to_json(shippingAddress) FROM <table_name>

To access the data in the postalCode node, you can type:

SELECT shippingAddress.postalCode FROM <table_name>
TIP
Congratulations! You have successfully ingested and created a sample set of Real-Time Customer Profiles
recommendation-more-help
blueprints-learn-help-blueprints