Lookup Tables in Automations provide lightweight, flexible reference data to support your automations. To maintain performance and data consistency, Lookup Tables follow the limits described below.
General Lookup Table Limits
Description
Limit
Maximum number of Lookup Tables per tenant
100
Maximum number of rows per Lookup Table
50,000
Maximum number of columns per Lookup Table
20
Supported data types
Date, Text, Integer, Float
Behavior Considerations
Description
Note
Sorting large tables
Performance may reduce when approaching row/column limits.
Filtering
Filters may take longer when applied to large datasets.
Data type enforcement
Each column must follow its assigned data type; mixed types are not allowed.
Row deletion
Deleting rows does not automatically reduce table size unless fully removed.