deployments

Creates, updates, deletes, gets or lists a deployments resource.

Overview

Name	deployments
Type	Resource
Id	google.workloadmanager.deployments

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	The name of the deployment resource. The format is 'projects/{project_id}/locations/{location_id}/deployments/{deployment_id}'.
createTime	string (google-datetime)	Output only. Create time stamp.
description	string	Description of the deployment.
sapSystemS4Config	object	SAP system workload input. (id: SapSystemS4Config)
serviceAccount	string	User-specified Service Account (SA) credentials to be used for Cloud Build. Format: projects/{projectID}/serviceAccounts/{serviceAccount} The default Cloud Build SA will be used initially if this field is not set during deployment creation.
sqlServerWorkload	object	MS SQL workload input. (id: SqlServerWorkload)
state	string	Output only. Current state of the deployment. (STATE_UNSPECIFIED, CREATING, ACTIVE, UPDATING, DELETING, FAILED)
terraformVariables	object	Optional. terraform_variables represents all the Terraform variables for the deployment workload. The key is the name of the Terraform variable, and the value is the TerraformVariable. For example: { "project_id": { "input_value": { "string_value": "my-project-id" } }, "zone": { "input_value": { "string_value": "us-central1-a" } } }
updateTime	string (google-datetime)	Output only. Update time stamp.
workerPool	string	Optional. The user-specified Cloud Build worker pool resource in which the Cloud Build job will execute. Format: projects/{project}/locations/{location}/workerPools/{workerPoolId}. If this field is unspecified, the default Cloud Build worker pool will be used.
workloadType	string	Optional. Workload type of the deployment. (WORKLOAD_TYPE_UNSPECIFIED, SAP_S4, SQL_SERVER, ORACLE)

list

Name	Datatype	Description

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, deploymentsId		Gets details of a single Deployment.
list	select	projectsId, locationsId	pageToken, pageSize, orderBy, filter	Lists Deployments in a given project and location.
create	insert	projectsId, locationsId	deploymentId, requestId	Creates a new Deployment in a given project and location.
delete	delete	projectsId, locationsId, deploymentsId	force	Deletes a single Deployment.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
deploymentsId	string
locationsId	string
projectsId	string
deploymentId	string
filter	string
force	boolean
orderBy	string
pageSize	integer (int32)
pageToken	string
requestId	string

SELECT examples

get

Gets details of a single Deployment.

SELECT
name,
createTime,
description,
sapSystemS4Config,
serviceAccount,
sqlServerWorkload,
state,
terraformVariables,
updateTime,
workerPool,
workloadType
FROM google.workloadmanager.deployments
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND deploymentsId = '{{ deploymentsId }}' -- required
;

list

Lists Deployments in a given project and location.

SELECT
*
FROM google.workloadmanager.deployments
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
AND filter = '{{ filter }}'
;

INSERT examples

create

Creates a new Deployment in a given project and location.

INSERT INTO google.workloadmanager.deployments (
data__sapSystemS4Config,
data__serviceAccount,
data__description,
data__sqlServerWorkload,
data__name,
data__workerPool,
data__workloadType,
data__terraformVariables,
projectsId,
locationsId,
deploymentId,
requestId
)
SELECT 
'{{ sapSystemS4Config }}',
'{{ serviceAccount }}',
'{{ description }}',
'{{ sqlServerWorkload }}',
'{{ name }}',
'{{ workerPool }}',
'{{ workloadType }}',
'{{ terraformVariables }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ deploymentId }}',
'{{ requestId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: deployments
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the deployments resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the deployments resource.
  - name: sapSystemS4Config
    description: |
      SAP system workload input.
    value:
      app:
        sid: "{{ sid }}"
        ascsImage: "{{ ascsImage }}"
        ersVm: "{{ ersVm }}"
        secretManagerSecret: "{{ secretManagerSecret }}"
        appVmNames:
          - "{{ appVmNames }}"
        appInstanceId: "{{ appInstanceId }}"
        ascsMachineType: "{{ ascsMachineType }}"
        ersInstanceId: "{{ ersInstanceId }}"
        ascsServiceAccount: "{{ ascsServiceAccount }}"
        sharedStorage: "{{ sharedStorage }}"
        image: "{{ image }}"
        ascsVm: "{{ ascsVm }}"
        ascsInstanceId: "{{ ascsInstanceId }}"
        vmsMultiplier: {{ vmsMultiplier }}
        machineType: "{{ machineType }}"
        appServiceAccount: "{{ appServiceAccount }}"
      version: "{{ version }}"
      gcpProjectId: "{{ gcpProjectId }}"
      deploymentModel: "{{ deploymentModel }}"
      database:
        machineType: "{{ machineType }}"
        instanceId: "{{ instanceId }}"
        diskType: "{{ diskType }}"
        image: "{{ image }}"
        secretManagerSecret: "{{ secretManagerSecret }}"
        primaryDbVm: "{{ primaryDbVm }}"
        databaseServiceAccount: "{{ databaseServiceAccount }}"
        sid: "{{ sid }}"
        secondaryDbVm: "{{ secondaryDbVm }}"
      ansibleRunnerServiceAccount: "{{ ansibleRunnerServiceAccount }}"
      allowStoppingForUpdate: {{ allowStoppingForUpdate }}
      sapBootDiskImage: "{{ sapBootDiskImage }}"
      location:
        zone2Name: "{{ zone2Name }}"
        subnetName: "{{ subnetName }}"
        dnsZone: "{{ dnsZone }}"
        deploymentDnsEnabled: {{ deploymentDnsEnabled }}
        vpcName: "{{ vpcName }}"
        dnsZoneNameSuffix: "{{ dnsZoneNameSuffix }}"
        zone1Name: "{{ zone1Name }}"
        regionName: "{{ regionName }}"
        networkProject: "{{ networkProject }}"
        createCommsFirewall: {{ createCommsFirewall }}
        customTags:
          - "{{ customTags }}"
        internetAccess: "{{ internetAccess }}"
      mediaBucketName: "{{ mediaBucketName }}"
      scalingMethod: "{{ scalingMethod }}"
      environmentType: "{{ environmentType }}"
      vmPrefix: "{{ vmPrefix }}"
  - name: serviceAccount
    value: "{{ serviceAccount }}"
    description: |
      User-specified Service Account (SA) credentials to be used for Cloud Build. Format: `projects/{projectID}/serviceAccounts/{serviceAccount}` The default Cloud Build SA will be used initially if this field is not set during deployment creation.
  - name: description
    value: "{{ description }}"
    description: |
      Description of the deployment.
  - name: sqlServerWorkload
    description: |
      MS SQL workload input.
    value:
      mediaBucket: "{{ mediaBucket }}"
      isSqlPayg: {{ isSqlPayg }}
      fciType: "{{ fciType }}"
      environmentType: "{{ environmentType }}"
      vmPrefix: "{{ vmPrefix }}"
      location:
        gcpProjectId: "{{ gcpProjectId }}"
        subnetwork: "{{ subnetwork }}"
        primaryZone: "{{ primaryZone }}"
        internetAccess: "{{ internetAccess }}"
        region: "{{ region }}"
        network: "{{ network }}"
        secondaryZone: "{{ secondaryZone }}"
        dnsZone: "{{ dnsZone }}"
        tertiaryZone: "{{ tertiaryZone }}"
      haType: "{{ haType }}"
      operatingSystemType: "{{ operatingSystemType }}"
      activeDirectory:
        dnsAddress: "{{ dnsAddress }}"
        secretManagerSecret: "{{ secretManagerSecret }}"
        domainUsername: "{{ domainUsername }}"
        type: "{{ type }}"
        domain: "{{ domain }}"
      database:
        smt: {{ smt }}
        secondarySoleTenantNode: "{{ secondarySoleTenantNode }}"
        secondarySoleTenantNodeType: "{{ secondarySoleTenantNodeType }}"
        secretManagerSecret: "{{ secretManagerSecret }}"
        soleTenantNode: "{{ soleTenantNode }}"
        floatingIpAddress: "{{ floatingIpAddress }}"
        machineType: "{{ machineType }}"
        soleTenantNodeType: "{{ soleTenantNodeType }}"
        tempdbOnSsd: {{ tempdbOnSsd }}
        tenancyModel: "{{ tenancyModel }}"
        diskType: "{{ diskType }}"
      computeEngineServiceAccount: "{{ computeEngineServiceAccount }}"
      pacemaker:
        bucketNameNodeCertificates: "{{ bucketNameNodeCertificates }}"
        pacemakerClusterSecret: "{{ pacemakerClusterSecret }}"
        sqlPacemakerUsername: "{{ sqlPacemakerUsername }}"
        sqlPacemakerSecret: "{{ sqlPacemakerSecret }}"
        pacemakerCluster: "{{ pacemakerCluster }}"
        pacemakerClusterUsername: "{{ pacemakerClusterUsername }}"
      deploymentModel: "{{ deploymentModel }}"
      sqlServerVersion: "{{ sqlServerVersion }}"
      sqlServerEdition: "{{ sqlServerEdition }}"
      osImageType: "{{ osImageType }}"
      osImage: "{{ osImage }}"
  - name: name
    value: "{{ name }}"
    description: |
      The name of the deployment resource. The format is 'projects/{project_id}/locations/{location_id}/deployments/{deployment_id}'.
  - name: workerPool
    value: "{{ workerPool }}"
    description: |
      Optional. The user-specified Cloud Build worker pool resource in which the Cloud Build job will execute. Format: `projects/{project}/locations/{location}/workerPools/{workerPoolId}`. If this field is unspecified, the default Cloud Build worker pool will be used.
  - name: workloadType
    value: "{{ workloadType }}"
    description: |
      Optional. Workload type of the deployment.
    valid_values: ['WORKLOAD_TYPE_UNSPECIFIED', 'SAP_S4', 'SQL_SERVER', 'ORACLE']
  - name: terraformVariables
    value: "{{ terraformVariables }}"
    description: |
      Optional. terraform_variables represents all the Terraform variables for the deployment workload. The key is the name of the Terraform variable, and the value is the TerraformVariable. For example: { "project_id": { "input_value": { "string_value": "my-project-id" } }, "zone": { "input_value": { "string_value": "us-central1-a" } } }
  - name: deploymentId
    value: "{{ deploymentId }}"
  - name: requestId
    value: "{{ requestId }}"

DELETE examples

delete

Deletes a single Deployment.

DELETE FROM google.workloadmanager.deployments
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND deploymentsId = '{{ deploymentsId }}' --required
AND force = '{{ force }}'
;