Control: CosmosDB accounts 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 your CosmosDB account, data leakage risks are reduced.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.cosmosdb_account_uses_private_link

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

with cosmosdb_private_connection as (
  select
    distinct a.id
  from
    azure_cosmosdb_account 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.name || ' not uses private link.'
    else a.name || ' uses private link.'
  end as reason
  
  , a.resource_group as resource_group
  , sub.display_name as subscription
from
  azure_cosmosdb_account as a
  left join cosmosdb_private_connection as c on c.id = a.id,
  azure_subscription as sub
where
  sub.subscription_id = a.subscription_id;

Control: CosmosDB accounts should use private link

Description

Usage

SQL

Tags