Using SELECT

You can use SELECT in the Data Access API to define Datasets.

Define Dataset:

val persons1:DataFrame = framework.dataAccess
    .dataset(
        new EntityDatasetBuilder()
            .ofType("configuration/entityTypes/Person")
            .select("Id")
            .select("attributes.FirstName")
            .select("attributes.LastName")
            .select("attributes.Email")
            .asTable("persons1")
        )
.build()

Run SQL query:

%sql select * from persons1

Result of SQL query execution:

ID Attributes
44044361628 {"FirstName":["Mike"],"LastName":["Ross"],"Email":[{"Type":["Business"],"Email":["mike.ross@p-litt.com"]}]}
54876905371 {"FirstName":["Harvey"],"LastName":["Specter"],"Email":[{"Type":["Home"],"Email":["harvey.specter@gmail.com"]},{"Type":["Business"],"Email":["specter@p-litt.com"]}]}