GEO_CODE is not getting data for VERTEX (Geo Data Provider)
Summary:
Hi
The requirement is that the SQL query below returns no data in the lower pod, but returns data when executed in Production.
We ran the process below as well.
Load Geographies for US
Load Payroll Tax Information for US
SQL:
SELECT * from fusion.hz_geography_identifiers
where geo_data_provider = 'VERTEX'
AND geography_use = 'MASTER_REF'
AND identifier_subtype = 'GEO_CODE'
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):