# Schema Information

The schema for the GA4 integration in Daton contains the following fields:

* Daton fields (i.e.,`_daton_user_id`, `_daton_batch_runtime`, `_daton_batch_id`)
* Selected dimensions
* Selected metrics
* Start date
* End date

For instance, 

If a table is defined as per the following metrics and dimensions: 

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FThwXrAKVKHhZRxdafJUf%2FGA4%20schema.png?alt=media&#x26;token=0e9dfcaf-e2e9-4403-80a5-640c33e894ed" alt=""><figcaption></figcaption></figure>

The data will be stored incrementally based on Date in the warehouse as a table with the following fields:&#x20;

<table><thead><tr><th width="367.73728813559325">Field Name</th><th width="317">Data Type</th></tr></thead><tbody><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>source</td><td>STRING</td></tr><tr><td>sourceMedium</td><td>STRING</td></tr><tr><td>activeUsers</td><td>INTEGER</td></tr><tr><td>sessions</td><td>INTEGER</td></tr><tr><td>start_date</td><td>DATE</td></tr><tr><td>end_date</td><td>DATE</td></tr></tbody></table>

Where, the fields- `source`, `sourceMedium`, `activeUsers`, and `sessions` were defined in the custom table through metrics and dimensions, during the Daton integration.