steampipe plugin install azuresteampipe plugin install azure

Table: azure_batch_account - Query Azure Batch Accounts using SQL

Azure Batch is a cloud-based job scheduling service that parallelizes and distributes the processing of large volumes of data across many computers. It is designed to manage and run hundreds to thousands of tasks concurrently. This service reduces the time and cost associated with processing large amounts of data.

Table Usage Guide

The azure_batch_account table provides insights into Batch Accounts within Azure Batch service. As a data engineer, explore account-specific details through this table, including account name, resource group, location, and subscription ID. Utilize it to uncover information about accounts, such as those with specific locations, the resource groups they belong to, and the verification of subscription IDs.

Examples

Basic info

Explore which Azure Batch accounts are currently provisioned, along with their dedicated core quotas and regional locations. This can be particularly useful for managing resources and optimizing cloud infrastructure.

select
  name,
  id,
  type,
  provisioning_state,
  dedicated_core_quota,
  region
from
  azure_batch_account;

select
  name,
  id,
  type,
  provisioning_state,
  dedicated_core_quota,
  region
from
  azure_batch_account;

List failed batch accounts

Identify instances where Azure batch account provisioning has failed. This is useful for troubleshooting and understanding the areas where resource allocation has been unsuccessful.

select
  name,
  id,
  type,
  provisioning_state,
  dedicated_core_quota,
  region
from
  azure_batch_account
where
  provisioning_state = 'Failed';

select
  name,
  id,
  type,
  provisioning_state,
  dedicated_core_quota,
  region
from
  azure_batch_account
where
  provisioning_state = 'Failed';

Query examples

batch_accounts_for_storage_account

Control examples

Schema for azure_batch_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_endpoint	text		The account endpoint used to interact with the batch service.
active_job_and_job_schedule_quota	text		Active job and job schedule quota of the batch account.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
auto_storage	jsonb		The auto storage properties of the batch account.
cloud_environment	text		The Azure Cloud Environment.
dedicated_core_quota	bigint		The dedicated core quota of the batch account.
dedicated_core_quota_per_vm_family	jsonb		A list of the dedicated core quota per virtual machine family for the batch account.
dedicated_core_quota_per_vm_family_enforced	boolean		Batch is transitioning its core quota system for dedicated cores to be enforced per Virtual Machine family. During this transitional phase, the dedicated core quota per Virtual Machine family may not yet be enforced.
diagnostic_settings	jsonb		A list of active diagnostic settings for the batch account.
encryption	jsonb		Properties to enable customer managed key for the batch account.
id	text		The resource identifier.
identity	jsonb		The identity of the batch account.
key_vault_reference	jsonb		Key vault reference of the batch account.
low_priority_core_quota	bigint		The low priority core quota of the batch account.
name	text	=	The resource name.
pool_allocation_mode	text		The pool allocation mode of the batch account.
pool_quota	bigint		The pool quota of the batch account.
private_endpoint_connections	jsonb		The properties associated with the private endpoint connection.
provisioning_state	text		The provisioned state of the batch account.
public_network_access	text		Indicates whether or not public network access is allowed for the batch account.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
subscription_id	text		The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The resource type.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_batch_account