CeloSQL Language Reference

CeloSQL is a specialized SQL dialect used for object-centric data transformations. It acts as the bridge between user-defined logic and high-performance engine execution, allowing you to build complex models without worrying about the underlying infrastructure.

Currently, CeloSQL is exclusively supported within the Objects and Events UI to define your transformation logic. The CeloSQL syntax is loosely based on Vertica SQL. This provides a familiar environment for those who regularly work with standard analytical SQL and minimizes the learning curve to start data modeling.

The most powerful aspect of CeloSQL is its portability. During the publishing and deployment phases, the system automatically transpiles your code into native Vertica SQL or Databricks SQL. In other words, CeloSQL handles the translation for you, ensuring your logic runs efficiently in these target environments. Crucially, CeloSQL is designed for functional parity, meaning the same code will produce identical results regardless of the target SQL engine.

For detailed information on supported syntax and logic, refer to the following: