turbot/steampipe-mod-azure-compliance

Control: Azure Cognitive Search services should use private link

Description

Azure Private Link lets you connect your virtual network to Azure services without a public IP address at the source or destination. The Private Link platform handles the connectivity between the consumer and services over the Azure backbone network. By mapping private endpoints to Azure Cognitive Search, data leakage risks are reduced.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.search_service_uses_private_link

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.search_service_uses_private_link --share

SQL

This control uses a named query:

with search_service_connection as (
select
distinct a.id
from
azure_search_service as a,
jsonb_array_elements(private_endpoint_connections) as connection
where
connection -> 'properties' -> 'privateLinkServiceConnectionState' ->> 'status' = 'Approved'
)
select
a.id as resource,
case
when c.id is null then 'alarm'
else 'ok'
end as status,
case
when c.id is null then a.title || ' not uses private link.'
else a.title || ' uses private link.'
end as reason
, a.resource_group as resource_group
, sub.display_name as subscription
from
azure_search_service as a
left join search_service_connection as c on c.id = a.id,
azure_subscription as sub
where
sub.subscription_id = a.subscription_id;

Tags