Geo Region has 3 symbols in enriched data and only 2 in redshift field. Why?


#1

I faced a problem that sometimes raw data after enricher are coming with GEO_REGION consisting with 3 symbols, however in Redshift schema of events, geo_region is only accept 2 symbols. Why it happens? Outdated schema in redshift? Or it is expected that 3 symbols will be trimmed to 2 during load to Redshift?


#2

@sphinks, the events table has a 2-char restriction and RDB Loader ensures the value is adjusted during shredding accordingly. I guess this is a historical restriction and the geo value is actually taken from the 3rd party database, MaxMind, once IP lookups enrichment is enabled.