📄️ CTE in SQL
A Common Table Expression (CTE) is a temporary result set that can be used in a SQL query. You can use CTEs to break up complex queries into simpler blocks of code that can connect and build on each other.
Analytics Engineering Glossary
The Analytics Engineering Glossary is a living collection of terms & concepts commonly used in the data industry by dbt Labs. You can use and contribute to this resource to educate yourself, your team, and your stakeholders.
📄️ DDL
Data Definition Language (DDL) is a group of SQL statements that you can execute to manage database objects, including tables, views, and more.
📄️ DML
Data Manipulation Language (DML) is a class of SQL statements that are used to query, edit, add and delete row-level data from database tables or views. The main DML statements are SELECT, INSERT, DELETE, and UPDATE.
📄️ DRY
Don’t Repeat Yourself - a coding ideal to work towards that can be applied at several levels (e.g. a variable, definition of business / transformation logic, joining two models, etc.)
📄️ ELT
Extract, Load, Transform (ELT) is the process of first extracting data from different data sources, loading it into a target data warehouse, and finally transforming it.
📄️ ETL
Extract, Transform, Load (ETL)is the process of first extracting data from a data source, transforming it, and then loading it into a target data warehouse.
📄️ Idempotent
Idempotent describes a process that is independent of previous executions of that same process.
📄️ Materialization
The exact Data Definition Language (DDL) that dbt will use when creating the model’s equivalent in a data warehouse.
📄️ Subquery in SQL
A subquery is a query within another query. Subqueries are often used when you need to process data in multiple steps.
📄️ Table
In simplest terms, a table is the direct storage of data on disk in rows and columns. Think excel sheet with raw values in each of the cells.
📄️ View
A view (as opposed to a table) is a defined passthrough SQL query that can be run against a database (or data warehouse).