Table: azure_cdn_frontdoor_profile - Query Azure CDN Front Door Profiles using SQL

An Azure CDN Front Door Profile is a collection of settings and configurations for a content delivery network (CDN) front door, which is used to accelerate the delivery of web content to users globally.

Table Usage Guide

The azure_cdn_frontdoor_profile table provides insights into CDN Front Door Profiles within Azure. As an Infrastructure Engineer, explore detailed information about each front door profile through this table, including its endpoint configurations, origin groups, and routing rules. Use this table to manage and optimize your CDN profiles, ensuring fast and reliable content delivery for your applications.

Examples

Basic front door profile information

Retrieve basic information about your Azure CDN Front Door Profiles, including their names, locations, and provisioning states.

select
  name,
  location,
  provisioning_state
from
  azure_cdn_frontdoor_profile;

select
  name,
  location,
  provisioning_state
from
  azure_cdn_frontdoor_profile;

SKU name and kind

Explore the SKU names and kinds of your Azure CDN Front Door Profiles, which can help in understanding the pricing tiers and types of profiles in use.

select
  name,
  sku_name,
  kind
from
  azure_cdn_frontdoor_profile;

select
  name,
  sku_name,
  kind
from
  azure_cdn_frontdoor_profile;

Profiles in failed provisioning state

Retrieve information about front door profiles that are in a failed provisioning state. This can help in identifying and troubleshooting issues with profile deployment.

select
  name,
  location,
  provisioning_state
from
  azure_cdn_frontdoor_profile
where
  provisioning_state = 'Failed';

select
  name,
  location,
  provisioning_state
from
  azure_cdn_frontdoor_profile
where
  provisioning_state = 'Failed';

Front door IDs and origin response timeout

Explore the IDs of the front doors and the origin response timeout settings of your CDN profiles.

select
  name,
  front_door_id,
  origin_response_timeout_seconds
from
  azure_cdn_frontdoor_profile;

select
  name,
  front_door_id,
  origin_response_timeout_seconds
from
  azure_cdn_frontdoor_profile;

Schema for azure_cdn_frontdoor_profile

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
front_door_id	text		The ID of the front door.
id	text		The resource identifier.
kind	text		Kind of the profile. Used by portal to differentiate traditional CDN profile and new AFD profile.
location	text		The location of the CDN front door profile.
name	text	=	The name of the CDN front door profile.
origin_response_timeout_seconds	bigint		Send and receive timeout on forwarding request to the origin. When timeout is reached, the request fails and returns.
provisioning_state	text		Provisioning status of the CDN front door profile.
region	text		The Azure region where the resource is located.
resource_group	text	=	The resource group in which the resource is located.
resource_state	text		Resource status of the CDN front door profile.
sku_name	text		Name of the pricing tier.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		Tags associated with 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_cdn_frontdoor_profile