Control: Azure Data Factory 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 Data Factory, data leakage risks are reduced.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.data_factory_uses_private_link

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

with data_factory_connection as (
  select
    distinct a.id
  from
    azure_data_factory as a,
    jsonb_array_elements(private_endpoint_connections) as connection
  where
    connection ->> 'PrivateLinkServiceConnectionStateStatus' = '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_data_factory as a
  left join data_factory_connection as c on c.id = a.id,
  azure_subscription as sub
where
  sub.subscription_id = a.subscription_id;

Control: Azure Data Factory should use private link

Description

Usage

SQL

Tags