Generating a SELECT statement

Generated SELECT has different variants depending on what data to retrieve. The default SELECT option must be used in most cases, as it retrieves the latest data.

In cases where the latest variation of the data does not suffice, use the Generate SELECT with Hints (--* statements).

For more details on Hints functionality, see Query hints.

Hover over a data object or data object property.

  1. Click the ellipsis icon.
  2. Select Generate > SELECT Options.
  3. Select one of the available SELECT options.
    Clicking one of the options in the menu, generates and inserts a SELECT statement in the query editor on a new line. The generated SELECT statement is formatted, and it includes all the object property names ordered according to the object property order definition in Data Catalog.