steampipe plugin install azuresteampipe plugin install azure

Table: azure_data_lake_analytics_account - Query Azure Data Lake Analytics Accounts using SQL

Azure Data Lake Analytics is an on-demand analytics job service that simplifies big data. Instead of deploying, configuring, and tuning hardware, you write queries to transform your data and extract valuable insights. The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need.

Table Usage Guide

The azure_data_lake_analytics_account table provides insights into the Azure Data Lake Analytics Accounts within Azure. As a Data Analyst or a Data Engineer, explore account-specific details through this table, including the current state, the level of commitment, and the associated metadata. Utilize it to uncover information about accounts, such as their provisioning state, firewall state, and the maximum degree of parallelism per job, which can aid in optimizing data processing and analytics tasks.

Examples

Basic info

Analyze the settings to understand the status and type of your Azure Data Lake Analytics accounts. This can help in managing resources and identifying any accounts that may be in an unexpected state.

select
  name,
  id,
  type,
  provisioning_state
from
  azure_data_lake_analytics_account;

select
  name,
  id,
  type,
  provisioning_state
from
  azure_data_lake_analytics_account;

List suspended data lake analytics accounts

Determine the areas in which your data lake analytics accounts are suspended. This allows you to manage resources efficiently by identifying and addressing any issues with these accounts.

select
  name,
  id,
  type,
  state,
  provisioning_state
from
  azure_data_lake_analytics_account
where
  state = 'Suspended';

select
  name,
  id,
  type,
  state,
  provisioning_state
from
  azure_data_lake_analytics_account
where
  state = 'Suspended';

List data lake analytics accounts with firewall disabled

Explore which Data Lake analytics accounts have their firewall disabled in order to identify potential security vulnerabilities. This can assist in maintaining robust security practices and preventing unauthorized access.

select
  name,
  id,
  type,
  provisioning_state
from
  azure_data_lake_analytics_account
where
  firewall_state = 'Disabled';

select
  name,
  id,
  type,
  provisioning_state
from
  azure_data_lake_analytics_account
where
  firewall_state = 'Disabled';

Control examples

Resource logs in Data Lake Analytics should be enabled

Schema for azure_data_lake_analytics_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		The unique identifier associated with this data lake analytics account.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
compute_policies	jsonb		The list of compute policies associated with this data lake analytics account.
creation_time	timestamp with time zone		The data lake analytics account creation time.
current_tier	text		The commitment tier in use for current month.
data_lake_store_accounts	jsonb		The list of data lake store accounts associated with this data lake analytics account.
default_data_lake_store_account	text		The default data lake store account associated with this data lake analytics account.
diagnostic_settings	jsonb		A list of active diagnostic settings for the data lake analytics account.
endpoint	text		The full cname endpoint for this data lake analytics account.
firewall_allow_azure_ips	jsonb		The current state of allowing or disallowing IPs originating within azure through the firewall. If the firewall is disabled, this is not enforced.
firewall_rules	jsonb		The list of firewall rules associated with this data lake analytics account.
firewall_state	text		The current state of the IP address firewall for this data lake analytics account.
id	text		The resource identifier.
last_modified_time	timestamp with time zone		The data lake analytics account last modified time.
max_degree_of_parallelism	bigint		The maximum supported degree of parallelism for this data lake analytics account.
max_degree_of_parallelism_per_job	bigint		The maximum supported degree of parallelism per job for this data lake analytics account.
max_job_count	bigint		The maximum supported jobs running under the data lake analytics account at the same time.
min_priority_per_job	bigint		The minimum supported priority per job for this data lake analytics account.
name	text	=	The resource name.
new_tier	text		The commitment tier to use for next month.
provisioning_state	text		The provisioning status of the data lake analytics account.
query_store_retention	bigint		The number of days that job metadata is retained.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
state	text		The state of the data lake analytics account.
storage_accounts	jsonb		The list of azure blob storage accounts associated with this data lake analytics account.
subscription_id	text		The Azure Subscription ID in which the resource is located.
system_max_degree_of_parallelism	bigint		The system defined maximum supported degree of parallelism for this account, which restricts the maximum value of parallelism the user can set for the data lake analytics account.
system_max_job_count	bigint		The system defined maximum supported jobs running under the account at the same time, which restricts the maximum number of running jobs the user can set for the data lake analytics account.
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_data_lake_analytics_account