Geometry Type not converted into proper binary format when reading through Federated Catalog

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

Hi,

When reading a geometry column from a sql server into Databricks through foreign/federated catalog the tranformation of geometry type to binary type is not in proper format or I am not able to find a way I can decode that binary.

for example, for point, POINT (40.1150970058931 -8.3855249364345 30.3999996185303)
I am getting the value as 5hAAAAENrI5DhmPFIMDVFqp/uw5EQAcAAGBmZj5A whereas I am expecting AekDAADVFqp/uw5EQKyOQ4ZjxSDABwAAYGZmPkA=

The value AekDAADVFqp/uw5EQKyOQ4ZjxSDABwAAYGZmPkA=, I got when I read it using jdbc connection and querying the table as Shape.AsBinaryZM(), but in federated catalog I cannot define the query format or define a specific query.

Is there any way I can get proper binary into the geometry column

Thanks