Skip to main content

Celonis Product Documentation

Supported table and column names

Description

An overview of the table and column names we support.

  • Always surround table and column names with double quotes.

  • Table and column names are case-insensitive.

  • Table and column names can contain Unicode characters.

  • We recommend that table and column names do not contain whitespace or any other special characters apart from underscore _ and dash -. Although special characters currently work from a pure PQL point of view, they are not guaranteed to work in the future. Furthermore, these characters can have special meaning in software using PQL and make it harder or impossible to reference those tables and columns.

  • For event tables with no associated case table, we create an artificial case table with the event table name concatenated with _CASES. If such a table exists in the data model, the load will fail. We recommend that you avoid such table names.