KEYSET()

All functions > METADATA > KEYSET()

Returns a reference to a keyset.

Signatures

Returns: A table representing the defined keyset

KEYSET(entity: ENTITY, query: VARCHAR) → TABLE
sql
ParameterTypeRequiredDescription
entityENTITYYesThe entity type this keyset represents
queryVARCHARYesSQL query defining how to retrieve entity keys; may contain named :parameters

Notes

  • The persisted feature name is the keyset identity
  • Keysets define collections of entity identifiers for batch processing
  • Source lineage is derived from the query; no table hints are required
  • Use named :parameters with a named ROW in @BIND_KEYSET()
Last update at: 2026/08/04 11:25:38