DuckDB Data Engineering Glossary
SQL Syntax
- aggregate functions
- aggregation
- ALTER TABLE statement
- analyze
- column
- Common Table Expressions (CTEs)
- ENUM
- EXPLAIN clause
- filter
- foreign key
- GROUP BY clause
- INSERT statement
- JOIN clause
- ORDER BY clause
- parameterized query
- PIVOT clause
- primary key
- schema
- SELECT statement
- SQL
- SQL analytics
- SQL function
- SQL query
- sub-query
- SUMMARIZE
- 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