When you export the Amplitude data into Amazon Redshift the Group Properties come out as a json object something like this as an example
{
"Account Name": {
"MadeUpCompany": {
"Plan": “Premium”,
"monthlySpend": "5.00",
}
}
}
For both user and event properties you can just call the json property in the SQL as it isn’t nested - user_properties.plan or event_properties.OSversion
However in the Group Properties function (if you have it enabled) it has the Account Name first so you can’t access the properties like this
group_properties.plan or group.monthlySpend
Any reference to those needs to contain the company name - such as
group_properties.MadeUpCompany.Plan = “Premium”
This isn’t workable in SQL as every customer has a different customer name. Is there another to extract at this level in Amazon Redshift - has anyone found a simple solution?
Best answer by Saish Redkar
View original
