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 to match the requirements of the underlying data infrastructure. CeloSQL handles this translation seamlessly, ensuring your logic is optimized for all supported execution environments. Crucially, CeloSQL is designed for functional parity, ensuring consistent results across all supported processing layers.

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