Skip to content

azureSqlDatabases

Retrieves a paginated list of all Azure SQL Databases.

Arguments

Argument Type Description
first Int Returns the first n elements from the list.
after String Returns the elements in the list that occur after the specified cursor.
last Int Returns the last n elements from the list.
before String Returns the elements in the list that occur before the specified cursor.
sortBy AzureSqlDatabaseSortFields Sort fields for list of Azure SQL Databases.
sortOrder SortOrder Sorts the order of results.
azureSqlDatabaseFilters AzureSqlDatabaseFilters Filters for listing Azure SQL Databases.
includeSecurityMetadata Boolean Filter to include the security metadata.

Returns

AzureSqlDatabaseDbConnection!

Sample

query {
  azureSqlDatabases(first: 10) {
    nodes {
      authorizedOperations
      backupSetupStatus
      backupStorageRedundancy
      databaseName
      elasticPoolName
      exocomputeConfigured
      id
      isEligibleForPersistentBackups
      isRelic
      maximumSizeInBytes
      name
      numWorkloadDescendants
      objectType
      onDemandSnapshotCount
      region
      rscPendingObjectPauseAssignment
      serviceObjectiveName
      serviceTier
      slaAssignment
      slaPauseStatus
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

{}

{
  "data": {
    "azureSqlDatabases": {
      "nodes": [
        [
          {
            "authorizedOperations": [
              "DELETE_SNAPSHOT"
            ],
            "backupSetupStatus": "CDC_DISABLED",
            "backupStorageRedundancy": "GRS",
            "databaseName": "example-string",
            "elasticPoolName": "example-string",
            "exocomputeConfigured": true
          }
        ]
      ],
      "pageInfo": {
        "endCursor": "example-string",
        "hasNextPage": true,
        "hasPreviousPage": true,
        "startCursor": "example-string"
      }
    }
  }
}