Query functions for Data Lake and Compass properties

Compass provides infor functions so that you can query Data Lake and Compass details for each record.

You can use the information to select Data Lake attributes, called Synthetic properties, and Compass attributes, called Generated and Partition properties. The properties are included with each record that you query through Compass.

These additional properties are available in these ways:

  • Use infor functions to select them directly in a query.
  • You can use the include in select all query hint.

For syntax details of the hint, see Query hints.