Dl/Best Practices
From stonehomewiki
Data Ingestion
Always save a copy of raw data
When you do data ingestion, you want to save the raw data for the following reasons
- Your ingestion pipeline may have bugs, saving raw data allows you to fix bugs and re-populate the data
- Raw data may not meed the data quality and you may ignore it, in case you ignore it, keep the raw data allows you to check what kind of data quality problem they are, and sometimes you can inform the data producer to have it fixed.
- Raw data is owned by data source team and they have their own retention policy -- raw data is not always accessible afterwards.
Use data connectors to manage data ingestions
- Create highly reusable "data connectors" to manage the data ingestio
- An anti pattern is to create too many one time, custome written, poorly documented data ingestion code
Data Governance
Keep good structure of your data
- raw, sometime unstructured data:
- you stage the raw data (to be ingested) here, sometimes, these data can be unstructured.
- raw, ingested data
- they are structured, e.g. in parquet format. They captured all the information you interested from raw data. They may orgnized well -- the purpose is to capture all raw information with minimum processing.
- logical data layer
- well modeled, maybe around a subject model. (a fact table with bunch of dimension tables)
See also
