The following Azure Resource Graph queries assist with gathering Azure tenant inventory for Azure resources related to Azure Synapse Analytics. They are intended to aid cost optimization, general inventory needs, normalizing or standardization of configuration, and more.
- RBAC 'Reader' or equivalent access to Azure Synapse related resources. See Azure Resource Graph permissions documentation for specifics.
- Access to the Azure Portal or an Azure PowerShell or CLI session.
- Navigate to the Azure Portal. Search or select the Azure Resource Graph Explorer and paste the text of the desired query into the query window. Select run query.
- Alternatively you may programmatically execute these queries programmatically via CLI or SDKs.
- Execute Azure Resource Graph queries via Azure PowerShell
- Execute Azure Resource Graph queries via Azure CLI
- Execute Azure Resource Graph queries via language specific SDK or REST API
Inventory-DedicatedSqlPool - Lists dedicated SQL pools (formerly SQL DW) visible to the executing Azure context returning the subscription, resource group, parent Azure SQL Server, current SKU, standalone or association with Azure Synapse Workspace, and more.
To be completed.
Inventory-SparkPools - Lists Spark pools (Synapse Spark) visible to the executing Azure context returning the subscription, resource group, parent Azure Synapse Analytics workspace, SKU, and more.
To be completed.
Checklist to review if errors are returned or no data is returned from these queries. If not data is returned the root cause is RBAC access to the Azure Synapse related Azure resources.