Different ways to validate and view data in Data cloud

 Data Explorer

Query Editor

Query API

Profile Explorer

Data Explorer :

The Data Explorer can only query a single data lake object or 

data model object and can only query up to 10 fields.

The Data Explorer can also only return up to 100 records.

Query Editor :

To get started with Query Editor you will first need to create a workspace. This workspace is a shared workspace that others can both view and use.

Query Editor can query across multiple data lake objects and data model objects and can return more fields and thousands of records.

You can also use SQL joins like inner joins and outer joins.

Note :

The timeout limit is five minutes so you will need to use some where clauses and limit clauses to filter down your records to make sure that your queries do not timeout.

Query Workspaces is a collaborative tool that allows you to query Data Model Objects, Data Lake Objects, Calculated Insights Objects, and Data Graphs.