DuckDB Data Engineering Glossary

SQL Syntax

Main Statements

• ALTER TABLE statement
• CREATE TABLE statement
• EXPLAIN clause
• GROUP BY clause
• INSERT statement
• JOIN clause
• ORDER BY clause
• PIVOT clause
• SELECT statement
• SUMMARIZE

Related Features and Terminology

• aggregate functions
• aggregation
• analyze
• column
• Common Table Expressions (CTEs)
• ENUM
• filter
• foreign key
• parameterized query
• primary key
• schema
• SQL
• SQL analytics
• SQL function
• SQL query
• sub-query
• summarize
• table
• view
• window functions

Other Data Engineering and Analytics Terms

• 7-Zip
• AI
• Amazon S3
• analytical database
• Apache Arrow
• Apache Superset
• API
• auto inference
• Business Intelligence (BI)
• C/C++
• chart
• CLI
• Cloud Storage
• command line
• CSV
• dashboard
• data
• data app
• data build tool (dbt)
• data engineering
• data ingestion
• data load tool (dlt)
• data model
• data pipeline
• data sources
• data type
• data visualization
• database
• DataFrame
• dataset
• dbt
• dlt
• DuckDB
• DuckDB CLI
• DuckDB CLI: Dot Commands
• ELT
• ETL
• exploratory data analysis (EDA)
• GitHub
• Go programming language
• in-memory database
• Java programming language
• JavaScript programming language
• JSON
• Julia programming language
• Jupyter notebooks
• Large Language Model (LLM)
• Linux
• metadata
• MotherDuck
• MotherDuck extension
• Online Analytical Processing (OLAP)
• pandas
• Pandas DataFrames
• Parquet
• partitions
• pipelines
• Plot.ly
• Polars
• Postgres
• PyArrow
• PyPi
• Python
• query engine
• relational API
• relational database
• relational object
• result
• row group
• Rust
• S3 bucket
• serverless
• storage
• storage layer
• Streamlit
• struct
• time series
• timestamps