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

Schema for azure_data_lake_analytics_account

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtextThe unique identifier associated with this data lake analytics account.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
compute_policiesjsonbThe list of compute policies associated with this data lake analytics account.
creation_timetimestamp with time zoneThe data lake analytics account creation time.
current_tiertextThe commitment tier in use for current month.
data_lake_store_accountsjsonbThe list of data lake store accounts associated with this data lake analytics account.
default_data_lake_store_accounttextThe default data lake store account associated with this data lake analytics account.
diagnostic_settingsjsonbA list of active diagnostic settings for the data lake analytics account.
endpointtextThe full cname endpoint for this data lake analytics account.
firewall_allow_azure_ipsjsonbThe current state of allowing or disallowing IPs originating within azure through the firewall. If the firewall is disabled, this is not enforced.
firewall_rulesjsonbThe list of firewall rules associated with this data lake analytics account.
firewall_statetextThe current state of the IP address firewall for this data lake analytics account.
idtextThe resource identifier.
last_modified_timetimestamp with time zoneThe data lake analytics account last modified time.
max_degree_of_parallelismbigintThe maximum supported degree of parallelism for this data lake analytics account.
max_degree_of_parallelism_per_jobbigintThe maximum supported degree of parallelism per job for this data lake analytics account.
max_job_countbigintThe maximum supported jobs running under the data lake analytics account at the same time.
min_priority_per_jobbigintThe minimum supported priority per job for this data lake analytics account.
nametext=The resource name.
new_tiertextThe commitment tier to use for next month.
provisioning_statetextThe provisioning status of the data lake analytics account.
query_store_retentionbigintThe number of days that job metadata is retained.
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.
statetextThe state of the data lake analytics account.
storage_accountsjsonbThe list of azure blob storage accounts associated with this data lake analytics account.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
system_max_degree_of_parallelismbigintThe 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_countbigintThe 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.
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_data_lake_analytics_account