Schema Information

This topic provides a structured reference to assist you in working with Daton's GA4 connector.

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:

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

Field Name	Data Type
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
source	STRING
sourceMedium	STRING
activeUsers	INTEGER
sessions	INTEGER
start_date	DATE
end_date	DATE

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