any ideas what the mapping should be for these dat...
# troubleshoots
square-activity-64562
07/29/2021, 11:23 AMany ideas what the mapping should be for these data type errors during ingestion from a postgres database?
Copy code
- unable to map type Geography(geometry_type='POINT', srid=4326, from_text='ST_GeogFromText'
- unable to map type UUID() to metadata schema
- unable to map type OID() to metadata schema
- unable to map type Geography(geometry_type='MULTIPOLYGON', srid=4326, from_text='ST_GeogFromText', name='geography') to metadata schema
- unable to map type Geometry(from_text='ST_GeomFromEWKT', name='geometry') to metadata schema
- unable to map type INET() to metadata schemasquare-activity-64562
07/29/2021, 11:26 AMseems like postGIS columns https://postgis.net/docs/ST_GeogFromText.html
square-activity-64562
08/04/2021, 8:20 AM@gray-shoe-75895 Any suggestions where I can add these to fix this problem?
g
gray-shoe-75895
08/04/2021, 3:43 PMDoes it show up incorrectly in the UI?
gray-shoe-75895
08/04/2021, 3:44 PMIn the Postgres sql source you can add custom mappings (eg snowflake does this as an example), but we do handle this error somewhat gracefully and it should show up ok in the UI
s
square-activity-64562
08/04/2021, 3:46 PMIt shows up as
UUID()g
gray-shoe-75895
08/05/2021, 4:07 PMYep that’s the expected behavior right now - we will clean it up a bit in the future