DataJunction (DJ) is an open-source metrics platform that enables users to define metrics and their underlying data models using SQL. Serving as a semantic layer atop a physical data warehouse, DJ facilitates efficient retrieval of metrics data across various dimensions and filters. At its core, DJ represents metrics and their upstream abstractions as interconnected nodes. These nodes can symbolize elements such as tables in a data warehouse (source nodes), SQL transformation logic (transform nodes), dimension logic, metrics logic, and even selections of metrics, dimensions, and filters (cube nodes). By parsing each node’s SQL into an Abstract Syntax Tree (AST) and establishing dimensional links between nodes, DJ infers a graph of dependencies, enabling it to determine appropriate join paths for generating metric queries.
Tech tags:
Related shared contents:
-
project2024-12-17
-
In productions with: