Skip to content

Latest commit

 

History

History
21 lines (14 loc) · 1.05 KB

README.md

File metadata and controls

21 lines (14 loc) · 1.05 KB
Raw

nr-dap-dlh

This repository holds code and artifacts for the Data Analytics Platform (DAP).

The Data Lakehouse (DLH) allows for the summarization, transformation and combination of structured and semi-structured data, including the consumption of replicated data assets from the Operation Data Store (ODS), APIs and Object Storage.

File Structure

  • ETL Tools (such as Data Build Tool (DBT) projects): nr-dap-dlh/{domain}/{name of tool}/{Files}

  • Python or R Scripts nr-dap-dlh/{domain}/scripts/{Files}

  • DDL (Data Definition Language) Includes commands like CREATE, ALTER, and COMMENT that define and modify database structure. nr-dap-dlh/{domain}/ddl/{Filename = name of the table}

  • DQL (Data Query Language) / DML (Data Manipulation Language) Includes commands like SELECT, INSERT, UPDATE, and DELETE that manipulate data within the database. nr-dap-dlh/{domain}/dml/{Files}

  • DCL (Data Control Language) Includes commands like GRANT and REVOKE that control access to the data in the database. nr-dap-dlh/{domain}/dcl/{Files}