Skip to main content

ETL Reference

This reference guide covers all aspects of Extract, Transform, Load (ETL) operations in Sundial, including data sources, transformations, and data management.

  • Tables - Manage data in tables with schemas
    • Sources - represent tables in external data sources
    • Views - define data transformations using SQL
  • Materialization - pre-compute frequently used data in a table, for faster and cheaper reads
  • Data Quality Testing - write and run table-level tests to ensure data validity
  • Data Lineage - review and track auto-generated lineage of your data, based on transformations
  • Scheduling and Triggers - refresh your data at regular intervals or based on a trigger
  • Backfills - recreate complete or partial historical data for any of your tables