---
title: "Metadata Inclusion"
slug: "metadata-inclusion"
description: "To facilitate data management and provide richer context, Dataddo offers the capability to append various metadata fields to ensure full control of your data."
tags: ["Data flow", "How-to guide", "Data transformation"]
updated: 2024-01-09T13:14:29Z
published: 2024-01-09T13:14:29Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Metadata Inclusion

To facilitate data management and provide richer context, you can opt to **append various metadata fields** to your data model. These metadata fields offer valuable insights and tools to streamline the handling and interpretation of your datasets, ensuring you're always in full control of your data.

## Metadata Fields

### Dataddo Extraction Timestamp

Adding the **Dataddo Extraction Timestamp** to your dataset can help you:

- Determine when a specific piece of data was fetched.
- Assess the freshness of your data.

Timestamps is also essential for [tracking Slowly Changing Dimensions (SCD)](/docs/ingestion-to-data-warehouses#need-to-track-slowly-changing-dimensions-changes-over-time) as they ensure **precise documentation and analysis** of any historical changes in data attributes.

Add the **Dataddo Extraction Timestamp** during [source creation](/docs/creating-a-data-source). Simply add the field to your other **metrics and attributes**. ![Data Transformation - Extraction timestamp](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Data%20Transformation%20-%20Extraction%20timestamp.png)

### Dataddo Hash

The **Dataddo Hash** generates a unique hash value based on dimensions within the dataset. This metadata field provides a key for recognizing data uniqueness and can help you with:

- Ensuring data consistency.
- Preventing redundancy.

This feature is invaluable in situations where [upsert](/docs/data-storages#upsert) write mode is used. You can directly utilize **the Dataddo Hash** to ensure efficient and accurate data updates and don't have to worry about which columns to include in a [composite key](/docs/data-storages#upsert).

Include the **Dataddo Hash** during ***source*** creation, under **Advanced Settings**. The hash can then be used when [creating your flow](/docs/how-to-create-a-data-flow) and selecting **upsert** as your write mode.

![Data Transformation - Dataddo Hash](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Data%20Transformation%20-%20Dataddo%20Hash.png)

Upsert inserts new rows and updates existing ones in the destination. By ensuring that the data in the table is updated if a matching record exists, or a new one is inserted, upsert prevents data duplication.