How to get the partitions data from Azure ADX through SQL Server emulation?

Shanmuganandha Vadivel Mahesh Kumar, FG-210 0

I'm looking for support regarding viewing my partition data in Azure ADX through the jdbc SQLServer emulation. By following this page (https://learn-microsoft-com.translate.goog/de-de/azure/data-explorer/sql-server-emulation-overview?_x_tr_sl=de&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=sc), I'm building a SQLServer emulation for my data in Azure ADX. I'm using the following query to retrieve the partition details of my table ->

select distinct PARTITION_NUMBER from SYS.DM_DB_PARTITION_STATS where object_id = OBJECT_ID(?) and partition_number > 1

But I'm getting this error

There is no table '..sys.dm_db_partition_stats'

, which I couldn't understand why. Because, the partiton exist and I can view it through the query editor of Azure ADX.

Oury Ba-MSFT 20,006 Reputation points Microsoft Employee

2025-01-16T20:03:29.6066667+00:00

@Shanmuganandha Vadivel Mahesh Kumar, FG-210 Thank you for reaching out.

I am sorry to hear about the issue you are facing with our services. The issue might be due to this feature not being supported in Azure Data Explorer’s SQL Server emulation. Azure Data Explorer’s SQL Server emulation provides a subset of SQL Server’s functionality, and some system views and functions might not be available.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-ver16

Regards,

Oury
Shanmuganandha Vadivel Mahesh Kumar, FG-210 0 Reputation points

2025-01-17T10:14:31.8133333+00:00

May I kindly know, in any way can I see the partitions of my ADX data through SQL server emulation?

Your answer