OpenMetadata icon indicating copy to clipboard operation
OpenMetadata copied to clipboard

Add support for PostGIS geometry type

Open geoHeil opened this issue 3 years ago • 1 comments

When ingestion a PostGIS table with a column of type Geometry OpenMetadata emits a warning:

/source/database/sql_column_handler.py:174: SAWarning: Did not recognize type 'geometry' of column 'geom'
  columns = inspector.get_columns(table_name, schema_name, db_name=db_name)

Instead of using the correct type geometry the metadata of VarChar is stored

geoHeil avatar Aug 03 '22 15:08 geoHeil

Ideally, you could parse the CRS attribute from it as well.

geoHeil avatar Aug 04 '22 18:08 geoHeil

Hello , I will work on this issue.

NiharDoshi99 avatar Sep 12 '22 07:09 NiharDoshi99