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.

    Accessing the created dataset in the Datasets pane

  3. Click on Preview dataset in the top right corner

    Preview dataset button located 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.

Verifying and validating ingested records using the schema hierarchy pane

NOTE
Preview dataset will only show the first few rows of the dataset. Array objects are not viewable.

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

    Copying the table name from the Dataset screen for use in a query

  3. Navigate to Queries section

  4. Click on Create query

    Accessing the query editor from the Queries section

  5. Turn the toggle for Enhanced Query Editor

    Query editor interface with the Enhanced Query Editor toggle enabled

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

    code language-sql 
    SELECT * FROM <table_name>

  7. Press the Play button.

  8. Preview the results.

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

    code language-sql 
    SELECT to_json(shippingAddress) FROM <table_name>

  10. 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