turbot/azure_insights

Query: cosmosdb_sql_database_for_cosmosdb_account

Usage

powerpipe query azure_insights.query.cosmosdb_sql_database_for_cosmosdb_account

SQL

select
lower(d.id) as sql_database_id
from
azure_cosmosdb_account a,
azure_cosmosdb_sql_database d
where
d.account_name = a.name
and lower(a.id) = $1
and a.subscription_id = split_part($1, '/', 3);