Skip to main content

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.