SQL Reference

This is the reference documentation for all SQL related features currently supported in Sundial.

• SELECT queries are used for ad-hoc querying of tables in SQL Cards and also for defining data transformations in Views as a part of the ETL process.
• Functions and Operators cover both general functions and operators found across dialects, and also Sundial specific ones.
• Data Types covers all the valid data types in Sundial. It also describes how data types found in other systems are mapped to Sundial types.
• Templated Variables describes what all dynamic variables are available inside Views, in order to ensure that the same SQL can be used to produce consistent output.