- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 03:39 PM
With respect to adding your schema as Server Side Properties in the Advanced Options, could you please provide a screenshot so that I can see what the Keys and Values look like for your schema? Maybe this is what I am missing??
I am using QGIS 3.34 (long term release version)
My Delta table in Databricks had the spatial features as a geometry type in its schema, but in QGIS it did not recognise it as geometry, with the attribute table not showing any spatial features, with "BLOB" appearing as the value for all rows in the geometry field.
What I managed to do, however, was to add a field to the Delta table of the geometry WKT and store the field as a string type. When QGIS reads in this table, I then created a virtual layer, with the query on the Delta table running a ST_GeomFromText transformation on the geometry string type field, and it displayed the spatial features that way.
While this is a workaround, I would like to think it is possible to store the geometry features in the Delta table as a geometry type, and for QGIS to recognise that field as geometry.
Please let me know about how the schema was added to the Server Side Properties ... if that doesn't work, I may have to stick with keeping the geometry as a string format in the Delta Table
Merci! 🙂