A guide to the core features of the ETLX framework.
ETL | ELT
How ETLX models, executes, and observes ETL and ELT pipelines using declarative, metadata-driven …
ETL | ELT - Validation Rules
How ETLX enables declarative data quality validation as a first-class concern of ETL / ELT execution …
Query Documentation
How ETLX models SQL queries as executable documentation to improve clarity, governance, and …
Data Quality
How ETLX models, executes, and observes data quality rules as first-class, metadata-driven …
Multi / Stacked Queries
Combine multiple structured queries into a single result set using UNION-based execution.
Exports
Handling data exports to files and templates using ETLX
Actions
Define file operations and external transfers in ETLX workflows
Scripts
Execute SQL statements for operational and maintenance tasks
Logs / Observability
ETLX logging mechanism to save logs into a database.
Notifications
Send notifications with dynamic templates from SQL query results
Requires
Load configuration dependencies from files or queries.
Advanced Features
Explore advanced ETLX features like dynamic query generation, conditional execution, and modular …
Embedding in GO
Embedding ETLX in Go applications for seamless integration.
DuckDB at the Core
SQL-first transformations and in-process analytics powered by DuckDB
Multi-Engine Execution
Run ETLX pipelines across DuckDB, PostgreSQL, SQLite, MySQL, SQL Server, and any database supported …
Beyond ETL / ELT
ETLX as a declarative specification for reporting, document generation, exports, and regulatory …
Go API & Programmatic Usage
Use ETLX as a Go library to execute pipelines, run specific stages, or embed ETLX into your own …