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

Schema for azure_batch_account

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_endpointtextThe account endpoint used to interact with the batch service.
active_job_and_job_schedule_quotatextActive job and job schedule quota of the batch account.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
auto_storagejsonbThe auto storage properties of the batch account.
cloud_environmenttextThe Azure Cloud Environment.
dedicated_core_quotabigintThe dedicated core quota of the batch account.
dedicated_core_quota_per_vm_familyjsonbA list of the dedicated core quota per virtual machine family for the batch account.
dedicated_core_quota_per_vm_family_enforcedbooleanBatch 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_settingsjsonbA list of active diagnostic settings for the batch account.
encryptionjsonbProperties to enable customer managed key for the batch account.
idtextThe resource identifier.
identityjsonbThe identity of the batch account.
key_vault_referencejsonbKey vault reference of the batch account.
low_priority_core_quotabigintThe low priority core quota of the batch account.
nametext=The resource name.
pool_allocation_modetextThe pool allocation mode of the batch account.
pool_quotabigintThe pool quota of the batch account.
private_endpoint_connectionsjsonbThe properties associated with the private endpoint connection.
provisioning_statetextThe provisioned state of the batch account.
public_network_accesstextIndicates whether or not public network access is allowed for the batch account.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe 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