Resource Type: Azure > Cosmos DB > SQL Database

The SQL Database resource type is a globally distributed, multi-model database service that can be used to elastically and independently scale throughput and storage across any number of Azure regions.

Resource Context

SQL Database is a part of the Cosmos DB service.

Each SQL Database lives under a Database Account.

Controls

The primary controls for Azure > Cosmos DB > SQL Database are:

It is also targeted by these controls:

Azure > Cosmos DB > SQL Container > Discovery

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase

Category URI

tmod:@turbot/turbot#/resource/categories/database

GraphQL

query resource(id: "tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-cosmosdb#/resource/types/sqlDatabase' and notification_type in ('resource_updated', 'resource_created');