azure_isv

Provision, manage, and integrate independent software vendor services on Azure.

Provider Summary

total services: 27
total resources: 220
source project: stackql-provider-azure

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 }}';

Installation​

Authentication​

Authenticating using an Azure Service Principal​

Example Queries​

Azure Databricks workspaces​

Datadog monitors​

Elastic monitors​

Confluent organizations​

MongoDB Atlas organizations​

Observability partners in one list​

Databricks workspace provisioning​

Services​