The true power of Query Service is revealed when queries are used to generate datasets in the Data Lake to be used as input into more queries or in other services such as Data Science Workspace, Real-time Customer Profile, or Analysis Workspace.
Query Service allows the creation of datasets from the UI. Follow these steps:
After a dataset is created, it can be accessed like any other dataset in the Data Lake and used for a variety of use cases.
In a live implementation, you must apply Data Governance labels after the dataset is created.
In order to generate a dataset with a pre-defined Experience Data Model (XDM) schema, you will have to use the SQL syntax. For more information about what syntax you have to use, please read the SQL Syntax guide.
Datasets created through this functionality are generated with an ad hoc schema that matches the structure of the output data as defined in the SQL statement. Some downstream services require datasets with particular Experience Data Model (XDM) schemas. Verify the data formatting requirements for downstream services prior to writing your queries.