Does Azure SQL Hyperscale SKU supports Spatial data or GEOM columns

Question

Does Azure SQL Hyperscale SKU supports Spatial data or GEOM columns

NATH, DEEPAK 0

Hello Team,

My application has 20TB+ data.

At present we are using IAAS SQL to host our application data

The features in AZSQL hyperscale SKU look promising to my day to day problems.

I created a AZSQL Hyperscale DB but looks like issue while moving spatial data into it.

My question - Is AZSQL Hyperscale SKU supports spatial data ? If yes any documents that I refer for detail ?

Shraddha Pore 525 Reputation points Microsoft External Staff Moderator

2025-06-03T16:12:32.2666667+00:00

Hi @NATH, DEEPAK, We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
NATH, DEEPAK 0 Reputation points

2025-06-03T16:52:20.2566667+00:00

Thanks Shraddha. We have taken the reference from this shared information and discussing further internally.
Shraddha Pore 525 Reputation points Microsoft External Staff Moderator

2025-06-03T19:03:35.78+00:00

Hi @NATH, DEEPAK Please do not forget to click "Accept the answer” and Yes wherever the information provided helps you, this can be beneficial to other community members.

If you have any other questions or still running into more issues, let me know in the "comments" and I would be happy to help you.
Balmukund 176 Reputation points Microsoft Employee

2025-06-05T12:39:49.6866667+00:00

@NATH, DEEPAK - given that spatial type is supported, I am eager to learn more about below

I created a AZSQL Hyperscale DB but looks like issue while moving spatial data into it.

1 answer

Your answer

Shraddha Pore 525 Reputation points Microsoft External Staff Moderator

2025-06-03T16:12:32.2666667+00:00

Hi @NATH, DEEPAK, We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
NATH, DEEPAK 0 Reputation points

2025-06-03T16:52:20.2566667+00:00

Thanks Shraddha. We have taken the reference from this shared information and discussing further internally.
Shraddha Pore 525 Reputation points Microsoft External Staff Moderator

2025-06-03T19:03:35.78+00:00

Hi @NATH, DEEPAK Please do not forget to click "Accept the answer” and Yes wherever the information provided helps you, this can be beneficial to other community members.

If you have any other questions or still running into more issues, let me know in the "comments" and I would be happy to help you.
Balmukund 176 Reputation points Microsoft Employee

2025-06-05T12:39:49.6866667+00:00

@NATH, DEEPAK - given that spatial type is supported, I am eager to learn more about below

I created a AZSQL Hyperscale DB but looks like issue while moving spatial data into it.

Answer 1

Hi @NATH, DEEPAK Thank you so much for your query.

Azure SQL Database Hyperscale tier does indeed support spatial data types, including geometry and geography. This capability is essential for applications dealing with large-scale spatial data, such as your 20TB+ dataset. Below is a comprehensive overview to assist you in leveraging spatial data within Azure SQL Database

Hyperscale. Azure SQL Database supports two primary spatial data types:
geometry: Represents planar (flat-earth) spatial data.
geography: Represents geodetic (round-earth) spatial data.

Both types support various spatial objects, including Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, GeometryCollection.

Many modern applications depend heavily on spatial data for purposes like mapping, tracking locations, geographic analysis, and more. When dealing with massive datasets that contain millions or even billions of spatial points, lines, and polygons, it becomes essential to have efficient storage and fast querying capabilities.
Azure SQL Database Hyperscale is designed to handle these demanding requirements because: It can scale storage seamlessly to accommodate very large volumes of spatial data without compromising performance. It supports quick backups and restores, helping to reduce downtime during maintenance. It allows the use of advanced indexing techniques, including spatial indexes, which keep queries running efficiently as the data grows. It fully supports all the standard SQL Server spatial data types and functions, so your spatial queries and operations work just like they would on a traditional SQL Server.

You can refer Documentation Also, This Documentation

I hope this has been helpful! Kindly consider upvoting the Answer if the information provided is helpful. This can assist other community members in resolving similar issues. Happy to help you.

Shraddha Pore 525 Reputation points Microsoft External Staff Moderator

2025-06-06T14:57:13.9733333+00:00

Hi @NATH, DEEPAK Thank you so much for your query. Please do not forget to click "Accept the answer” and Yes wherever the information provided helps you, this can be beneficial to other community members.

If you have any other questions or still running into more issues, let me know in the "comments" and I would be happy to help you.

Share via

Does Azure SQL Hyperscale SKU supports Spatial data or GEOM columns

1 answer

Your answer