Hi Team, i am trying to store daily aggregated data. However i see multiple rows coming up instead of single.
Schema:
{
"schemaName": "AggregationTest",
"enableColumnBasedNullHandling": false,
"dimensionFieldSpecs": [
{
"name": "request_metadata.request.account",
"dataType": "STRING",
"notNull": false
}
],
"metricFieldSpecs": [
{
"name": "TotalCallVolume",
"dataType": "LONG",
"notNull": false
}
],
"dateTimeFieldSpecs": [
{
"name": "aggregation_created_at",
"dataType": "STRING",
"notNull": false,
"format": "1DAYSSIMPLE_DATE_FORMAT:yyyy-MM-dd",
"granularity": "1:DAYS"
}
]
}
Transform:
"aggregationConfigs": [
{
"columnName": "TotalCallVolume",
"aggregationFunction": "COUNT(*)"
}
],
"transformConfigs": [
{
"columnName": "aggregation_created_at",
"transformFunction": "DATETRUNC('DAY',DATETIMECONVERT(created_at, '1MILLISECONDSEPOCH', '1DAYSEPOCH', '1:DAYS'))"
}
]
Output that i see :