Resource Type: Azure > SQL > Database

Resource Context

Database is a part of the SQL service.

Each Database lives under a Server.

Controls

The primary controls for Azure > SQL > Database are:

• Active
• Advanced Data Security
• Approved
• Auditing
• CMDB
• Discovery
• Encryption at Rest
• ServiceNow
• Tags

It is also targeted by these controls:

• Azure > CIS v1 > 4 Database Services > 4.09 Ensure that 'Data encryption' is set to 'On' on a SQL Database (Scored)
• Azure > CIS v2.0 > 04 - Database Services > 4.01 SQL Server - Auditing > 4.01.05 - Ensure that 'Data encryption' is set to 'On' on a SQL Database
• Azure > CIS v2.0 > 05 - Logging and Monitoring > 5.05 - Ensure that SKU Basic/Consumption is not used on artifacts that need to be monitored (Particularly for Production Workloads)

Category

• Database

In Your Workspace

• Controls by Resource Type report
• Policy Settings by Resource Type report
• Resources by Resource Type report

Developers

Resource Type URI

tmod:@turbot/azure-sql#/resource/types/database

Category URI

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

GraphQL

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

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

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-sql#/resource/types/database"

Steampipe Query

Get Resource

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

Get Policy Settings (By Resource ID)

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

Get Resource Notification

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