Resource Type: Azure > SQL

The SQL service provides scalable database capacity in the Azure cloud. It allows users to launch and manage virtual databases, known as instances, that can store, retrieve, and manage data for applications and services.

Resource Types

The SQL service includes these resource types:

In Your Workspace

Developers

Resource Type URI

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

Category URI

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

GraphQL

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

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

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

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

Steampipe Query

Get Resource

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

Get Policy Settings (By Resource ID)

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

Get Resource Notification

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