Saveen Reddy on 16 Nov 2022 20:12:39
Need to deal with a lot of mapping data.
Peri Rocha (administrator) on 02 Feb 2024 22:04:17
Hello and thanks for posting this idea. Could you give me a few scenarios where you work with Geospatial data types?
- Comments (3)
RE: Support Geospatial datatypes in Data Warehouse
+1 1) to make more compatible SQL surface area with SQL Server or Azure SQL Databases, especialy in migration scenearios 2) I know about spatial functions in Python or KQL, but if your architecture is focusing to relational DWH, is big pain to solve spatial needs (spatial datatypes, and simple spatial functions like distances, area, or intersects) outside DW,
RE: Support Geospatial datatypes in Data Warehouse
Additional two similar ideas:https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=470628aa-8f44-ef11-b4ac-6045bdbb350dhttps://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6d72e835-ba33-ef11-a295-6045bdb16ed2
RE: Support Geospatial datatypes in Data Warehouse
Consider using Fabric Real Time Analytics KQL databases that have extensive support for geospatial data and analytics: Geospatial grid system - Fabric KQL Database | Microsoft Learn: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/geospatial-grid-systems