azure_isv
Provision, manage, and integrate independent software vendor services on Azure.
total services: 27
total resources: 220
See also:
[SHOW] [DESCRIBE] [REGISTRY]
Installation
To pull the latest version of the azure_isv provider, run the following command:
REGISTRY PULL azure_isv;
To view previous provider versions or to pull a specific provider version, see here.
Authentication
StackQL uses Azure application credentials obtained using the az login command from the Azure SDK. For more information, see here.
Authenticating using an Azure Service Principal
To authenticate using an Azure Service Principal, set the following environment variables: AZURE_TENANT_ID, AZURE_CLIENT_ID and AZURE_CLIENT_SECRET, see creating-an-azure-service-principal.
Example Queries
Try the following queries using stackql shell, or run them from a script or CI pipeline with stackql exec.
Azure Databricks workspaces
Workspaces in the subscription with their URL, SKU, managed resource group and network posture:
SELECT name, location, workspace_url, workspace_id,
json_extract(sku, '$.name') AS sku,
managed_resource_group_id, public_network_access, is_uc_enabled,
provisioning_state
FROM azure_isv.databricks.workspaces
WHERE subscription_id = '{{ subscription_id }}'
ORDER BY location, name;
Datadog monitors
Datadog monitor resources with the linked Datadog organization, the plan, and the monitoring and Marketplace subscription status:
SELECT name, location, monitoring_status, marketplace_subscription_status,
json_extract(datadog_organization_properties, '$.name') AS datadog_organization,
json_extract(sku, '$.name') AS plan,
json_extract(user_info, '$.emailAddress') AS owner_email,
provisioning_state
FROM azure_isv.datadog.monitors
WHERE subscription_id = '{{ subscription_id }}';
Elastic monitors
Elastic Cloud deployments linked from Azure with the deployment name, Elasticsearch region and Kibana URL:
SELECT name, location, version, monitoring_status,
json_extract(elastic_properties, '$.elasticCloudDeployment.name') AS deployment,
json_extract(elastic_properties, '$.elasticCloudDeployment.elasticsearchRegion') AS elasticsearch_region,
json_extract(elastic_properties, '$.elasticCloudDeployment.kibanaServiceUrl') AS kibana_url,
json_extract(sku, '$.name') AS plan,
provisioning_state
FROM azure_isv.elastic.monitors
WHERE subscription_id = '{{ subscription_id }}';
Confluent organizations
Confluent Cloud organizations with the Marketplace plan, its fulfilment status and the owning user:
SELECT name, location, organization_id, sso_url, created_time,
json_extract(offer_detail, '$.planName') AS plan,
json_extract(offer_detail, '$.status') AS offer_status,
json_extract(user_detail, '$.emailAddress') AS owner_email,
provisioning_state
FROM azure_isv.confluent.organization
WHERE subscription_id = '{{ subscription_id }}';
MongoDB Atlas organizations
MongoDB Atlas organizations with the Atlas organization id and the Marketplace subscription status and plan:
SELECT name, location,
json_extract(partner_properties, '$.organizationName') AS atlas_organization,
json_extract(partner_properties, '$.organizationId') AS atlas_organization_id,
json_extract(marketplace, '$.subscriptionStatus') AS marketplace_status,
json_extract(marketplace, '$.offerDetails.planName') AS plan,
provisioning_state
FROM azure_isv.mongodb_atlas.organizations
WHERE subscription_id = '{{ subscription_id }}';
Observability partners in one list
Datadog, Elastic, Dynatrace and New Relic monitor resources across the subscription, labelled by vendor:
SELECT 'datadog' AS vendor, name, location, monitoring_status, provisioning_state
FROM azure_isv.datadog.monitors
WHERE subscription_id = '{{ subscription_id }}'
UNION ALL
SELECT 'elastic', name, location, monitoring_status, provisioning_state
FROM azure_isv.elastic.monitors
WHERE subscription_id = '{{ subscription_id }}'
UNION ALL
SELECT 'dynatrace', name, location, monitoring_status, provisioning_state
FROM azure_isv.dynatrace.monitors
WHERE subscription_id = '{{ subscription_id }}'
UNION ALL
SELECT 'new_relic', name, location, monitoring_status, provisioning_state
FROM azure_isv.new_relic_observability.monitors
WHERE subscription_id = '{{ subscription_id }}';
Databricks workspace provisioning
Create a Premium workspace in Hybrid compute mode (computeMode is required on create, and Hybrid mode needs a managed resource group id), then remove it:
INSERT INTO azure_isv.databricks.workspaces (
workspace_name, resource_group_name, subscription_id, location, sku, properties, tags
)
SELECT 'dbw-analytics-01', '{{ resource_group_name }}', '{{ subscription_id }}', 'eastus',
'{"name": "premium"}',
'{"computeMode": "Hybrid",
"managedResourceGroupId": "/subscriptions/{{ subscription_id }}/resourceGroups/dbw-analytics-01-managed",
"publicNetworkAccess": "Enabled"}',
'{"environment": "dev"}';
DELETE FROM azure_isv.databricks.workspaces
WHERE workspace_name = 'dbw-analytics-01'
AND resource_group_name = '{{ resource_group_name }}'
AND subscription_id = '{{ subscription_id }}';