DataTerminology.comNEW
Also known as: ELT with Governance
An ELT approach augmented with governance controls—quality tests, lineage, and policies—to ensure compliant, trustworthy transformations at scale.
DESCRIPTION
ELTG integrates governance into ELT by embedding quality checks, lineage capture, metadata, and policy enforcement throughout pipelines. It addresses risks associated with raw landing by validating and controlling transformations in target platforms. ELTG leverages catalogs, rule engines, and audit logs for transparency and compliance. It aligns DataOps practices with regulatory needs, elevating trust and reproducibility. While ELTG is not a formal standard, it reflects the convergence of ELT and governance best practices in modern data platforms.
ALTERNATIVE DEFINITIONS
Collibra
Data governance is the process of managing the availability, usability, integrity and security of data.
Defines governance pillar central to ELTG’s controls.
Snowflake
ELT loads data into a data warehouse first and then transforms it using the warehouse’s processing power.
Establishes the ELT foundation extended by governance in ELTG.
RELATED TERMS
Governance Data Quality Lineage Data Discovery Platform DataOps Observability & Telemetry Metadata Management Testing & Validation Access Control
COMPETING TERMS
KNOWLEDGE AREAS
Data Engineering Data Governance Data Management Testing & Validation Observability & Telemetry
TARGET AUDIENCE
Data Engineer Data Governance Manager Data Steward Data Architect Chief Data Officer Analytics Engineer
EXTERNAL SOURCES
- Wikipedia - Extract, transform, load
- OpenLineage - Standard for lineage capture
- Great Expectations - Data quality testing framework
- Microsoft Purview - Governance and catalog concepts
TOP QUESTIONS
Why adopt ELTG instead of vanilla ELT?
ELTG adds systematic governance, improving trust, compliance, and reproducibility of transformations in modern platforms.
Category: Requirements
What controls does ELTG include?
Quality tests, lineage, metadata management, access policies, audit logging, and deployment validations.
Category: Example
Is ELTG a formal standard?
No; it’s a practice combining ELT with governance frameworks and tools.
Category: Misunderstanding
What are risks if ELTG is ignored?
Data issues propagate, compliance breaches occur, and teams lose trust in analytical outputs.
Category: Risk
How to implement ELTG practically?
Integrate testing frameworks, lineage standards, catalogs, and policy checks into ELT orchestration and CI/CD.
Category: Management
What is a hot topic around ELTG?
End-to-end lineage and automated policy enforcement in ELT pipelines are major trends.
Category: Topic
How does ELTG align with DataOps?
It embeds governance in automated pipelines, enabling continuous delivery of trustworthy data.
Category: Opinion
What metrics indicate healthy ELTG?
Test pass rates, lineage completeness, policy compliance, and audit trace coverage.
Category: Observability
Where to start learning ELTG?
Begin with data quality tests, adopt lineage standards like OpenLineage, and add catalog-driven policies.
Category: Requirements