instances

Creates, updates, deletes, gets or lists an instances resource.

Overview

Name	`instances`
Type	Resource
Id	`google.looker.instances`

Fields

The following fields are returned by SELECT queries:

get
list

Name	Datatype	Description
`name`	`string`	Output only. Format: `projects/{project}/locations/{location}/instances/{instance}`.
`acceleratedSecurityPatchEnabled`	`boolean`	Optional. Accelerated security patch enabled for the instance.
`adminSettings`	`object`	Looker Instance Admin settings. (id: AdminSettings)
`catalogIntegrationOptOut`	`boolean`	Optional. Indicates whether catalog integration is disabled for the Looker instance.
`classType`	`string`	Optional. Storage class of the instance. (CLASS_TYPE_UNSPECIFIED, R1, P1)
`consumerNetwork`	`string`	Network name in the consumer project. Format: `projects/{project}/global/networks/{network}`. Note that the consumer network may be in a different GCP project than the consumer project that is hosting the Looker Instance.
`controlledEgressConfig`	`object`	Optional. Controlled egress configuration. (id: ControlledEgressConfig)
`controlledEgressEnabled`	`boolean`	Optional. Whether controlled egress is enabled on the Looker instance.
`createTime`	`string (google-datetime)`	Output only. The time when the Looker instance provisioning was first requested.
`customDomain`	`object`	Custom domain configuration for the instance. (id: CustomDomain)
`denyMaintenancePeriod`	`object`	Maintenance denial period for this instance. (id: DenyMaintenancePeriod)
`egressPublicIp`	`string`	Output only. Public Egress IP (IPv4).
`encryptionConfig`	`object`	Encryption configuration (CMEK). Only set if CMEK has been enabled on the instance. (id: EncryptionConfig)
`fipsEnabled`	`boolean`	Optional. Whether FIPS is enabled on the Looker instance.
`geminiEnabled`	`boolean`	Optional. Whether Gemini feature is enabled on the Looker instance or not.
`ingressIpAllowlistConfig`	`object`	Optional. Ingress IP allowlist configuration for the Looker instance. (id: IngressIpAllowlistConfig)
`ingressPrivateIp`	`string`	Output only. Private Ingress IP (IPv4).
`ingressPublicIp`	`string`	Output only. Public Ingress IP (IPv4).
`lastDenyMaintenancePeriod`	`object`	Output only. Last computed maintenance denial period for this instance. (id: DenyMaintenancePeriod)
`linkedLspProjectNumber`	`string (int64)`	Optional. Linked Google Cloud Project Number for Looker Studio Pro.
`lookerUri`	`string`	Output only. Looker instance URI which can be used to access the Looker Instance UI.
`lookerVersion`	`string`	Output only. The Looker version that the instance is using.
`maintenanceSchedule`	`object`	Maintenance schedule for this instance. (id: MaintenanceSchedule)
`maintenanceWindow`	`object`	Maintenance window for this instance. (id: MaintenanceWindow)
`oauthConfig`	`object`	Looker instance OAuth login settings. (id: OAuthConfig)
`periodicExportConfig`	`object`	Optional. Configuration for periodic export. (id: PeriodicExportConfig)
`platformEdition`	`string`	Platform edition. (PLATFORM_EDITION_UNSPECIFIED, LOOKER_CORE_TRIAL, LOOKER_CORE_STANDARD, LOOKER_CORE_STANDARD_ANNUAL, LOOKER_CORE_ENTERPRISE_ANNUAL, LOOKER_CORE_EMBED_ANNUAL, LOOKER_CORE_NONPROD_STANDARD_ANNUAL, LOOKER_CORE_NONPROD_ENTERPRISE_ANNUAL, LOOKER_CORE_NONPROD_EMBED_ANNUAL, LOOKER_CORE_TRIAL_STANDARD, LOOKER_CORE_TRIAL_ENTERPRISE, LOOKER_CORE_TRIAL_EMBED)
`privateIpEnabled`	`boolean`	Whether private IP is enabled on the Looker instance.
`pscConfig`	`object`	Optional. PSC configuration. Used when `psc_enabled` is true. (id: PscConfig)
`pscEnabled`	`boolean`	Optional. Whether to use Private Service Connect (PSC) for private IP connectivity. If true, neither `public_ip_enabled` nor `private_ip_enabled` can be true.
`publicIpEnabled`	`boolean`	Whether public IP is enabled on the Looker instance.
`releaseChannel`	`string`	Optional. The selected release channel for the instance. (RELEASE_CHANNEL_UNSPECIFIED, RAPID, REGULAR, STABLE)
`reservedRange`	`string`	Name of a reserved IP address range within the Instance.consumer_network, to be used for private services access connection. May or may not be specified in a create request.
`satisfiesPzi`	`boolean`	Output only. Reserved for future use.
`satisfiesPzs`	`boolean`	Output only. Reserved for future use.
`softDeleteReason`	`string`	Output only. The reason for the instance being in a soft-deleted state. (SOFT_DELETE_REASON_UNSPECIFIED, BILLING_ACCOUNT_ISSUE, TRIAL_EXPIRED, CUSTOMER_REQUEST)
`state`	`string`	Output only. The state of the instance. (STATE_UNSPECIFIED, ACTIVE, CREATING, FAILED, SUSPENDED, UPDATING, DELETING, EXPORTING, IMPORTING)
`suspendedTime`	`string (google-datetime)`	Output only. The time when the Looker instance was suspended (soft deleted).
`updateTime`	`string (google-datetime)`	Output only. The time when the Looker instance was last updated.
`userMetadata`	`object`	Optional. User metadata. (id: UserMetadata)

Name	Datatype	Description
`name`	`string`	Output only. Format: `projects/{project}/locations/{location}/instances/{instance}`.
`acceleratedSecurityPatchEnabled`	`boolean`	Optional. Accelerated security patch enabled for the instance.
`adminSettings`	`object`	Looker Instance Admin settings. (id: AdminSettings)
`catalogIntegrationOptOut`	`boolean`	Optional. Indicates whether catalog integration is disabled for the Looker instance.
`classType`	`string`	Optional. Storage class of the instance. (CLASS_TYPE_UNSPECIFIED, R1, P1)
`consumerNetwork`	`string`	Network name in the consumer project. Format: `projects/{project}/global/networks/{network}`. Note that the consumer network may be in a different GCP project than the consumer project that is hosting the Looker Instance.
`controlledEgressConfig`	`object`	Optional. Controlled egress configuration. (id: ControlledEgressConfig)
`controlledEgressEnabled`	`boolean`	Optional. Whether controlled egress is enabled on the Looker instance.
`createTime`	`string (google-datetime)`	Output only. The time when the Looker instance provisioning was first requested.
`customDomain`	`object`	Custom domain configuration for the instance. (id: CustomDomain)
`denyMaintenancePeriod`	`object`	Maintenance denial period for this instance. (id: DenyMaintenancePeriod)
`egressPublicIp`	`string`	Output only. Public Egress IP (IPv4).
`encryptionConfig`	`object`	Encryption configuration (CMEK). Only set if CMEK has been enabled on the instance. (id: EncryptionConfig)
`fipsEnabled`	`boolean`	Optional. Whether FIPS is enabled on the Looker instance.
`geminiEnabled`	`boolean`	Optional. Whether Gemini feature is enabled on the Looker instance or not.
`ingressIpAllowlistConfig`	`object`	Optional. Ingress IP allowlist configuration for the Looker instance. (id: IngressIpAllowlistConfig)
`ingressPrivateIp`	`string`	Output only. Private Ingress IP (IPv4).
`ingressPublicIp`	`string`	Output only. Public Ingress IP (IPv4).
`lastDenyMaintenancePeriod`	`object`	Output only. Last computed maintenance denial period for this instance. (id: DenyMaintenancePeriod)
`linkedLspProjectNumber`	`string (int64)`	Optional. Linked Google Cloud Project Number for Looker Studio Pro.
`lookerUri`	`string`	Output only. Looker instance URI which can be used to access the Looker Instance UI.
`lookerVersion`	`string`	Output only. The Looker version that the instance is using.
`maintenanceSchedule`	`object`	Maintenance schedule for this instance. (id: MaintenanceSchedule)
`maintenanceWindow`	`object`	Maintenance window for this instance. (id: MaintenanceWindow)
`oauthConfig`	`object`	Looker instance OAuth login settings. (id: OAuthConfig)
`periodicExportConfig`	`object`	Optional. Configuration for periodic export. (id: PeriodicExportConfig)
`platformEdition`	`string`	Platform edition. (PLATFORM_EDITION_UNSPECIFIED, LOOKER_CORE_TRIAL, LOOKER_CORE_STANDARD, LOOKER_CORE_STANDARD_ANNUAL, LOOKER_CORE_ENTERPRISE_ANNUAL, LOOKER_CORE_EMBED_ANNUAL, LOOKER_CORE_NONPROD_STANDARD_ANNUAL, LOOKER_CORE_NONPROD_ENTERPRISE_ANNUAL, LOOKER_CORE_NONPROD_EMBED_ANNUAL, LOOKER_CORE_TRIAL_STANDARD, LOOKER_CORE_TRIAL_ENTERPRISE, LOOKER_CORE_TRIAL_EMBED)
`privateIpEnabled`	`boolean`	Whether private IP is enabled on the Looker instance.
`pscConfig`	`object`	Optional. PSC configuration. Used when `psc_enabled` is true. (id: PscConfig)
`pscEnabled`	`boolean`	Optional. Whether to use Private Service Connect (PSC) for private IP connectivity. If true, neither `public_ip_enabled` nor `private_ip_enabled` can be true.
`publicIpEnabled`	`boolean`	Whether public IP is enabled on the Looker instance.
`releaseChannel`	`string`	Optional. The selected release channel for the instance. (RELEASE_CHANNEL_UNSPECIFIED, RAPID, REGULAR, STABLE)
`reservedRange`	`string`	Name of a reserved IP address range within the Instance.consumer_network, to be used for private services access connection. May or may not be specified in a create request.
`satisfiesPzi`	`boolean`	Output only. Reserved for future use.
`satisfiesPzs`	`boolean`	Output only. Reserved for future use.
`softDeleteReason`	`string`	Output only. The reason for the instance being in a soft-deleted state. (SOFT_DELETE_REASON_UNSPECIFIED, BILLING_ACCOUNT_ISSUE, TRIAL_EXPIRED, CUSTOMER_REQUEST)
`state`	`string`	Output only. The state of the instance. (STATE_UNSPECIFIED, ACTIVE, CREATING, FAILED, SUSPENDED, UPDATING, DELETING, EXPORTING, IMPORTING)
`suspendedTime`	`string (google-datetime)`	Output only. The time when the Looker instance was suspended (soft deleted).
`updateTime`	`string (google-datetime)`	Output only. The time when the Looker instance was last updated.
`userMetadata`	`object`	Optional. User metadata. (id: UserMetadata)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
`get`	`select`	`projectsId`, `locationsId`, `instancesId`		Gets details of a single Instance.
`list`	`select`	`projectsId`, `locationsId`	`pageToken`, `showDeleted`, `pageSize`	Lists Instances in a given project and location.
`create`	`insert`	`projectsId`, `locationsId`	`instanceId`	Creates a new Instance in a given project and location.
`patch`	`update`	`projectsId`, `locationsId`, `instancesId`	`updateMask`	Update Instance.
`delete`	`delete`	`projectsId`, `locationsId`, `instancesId`	`force`	Delete instance.
`restart`	`exec`	`projectsId`, `locationsId`, `instancesId`		Restart instance.
`undelete`	`exec`	`projectsId`, `locationsId`, `instancesId`		Undeletes Looker instance.
`import`	`exec`	`projectsId`, `locationsId`, `instancesId`		Import instance.
`restore`	`exec`	`projectsId`, `locationsId`, `instancesId`		Restore Looker instance.
`export`	`exec`	`projectsId`, `locationsId`, `instancesId`		Export instance.

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
`instancesId`	`string`
`locationsId`	`string`
`projectsId`	`string`
`force`	`boolean`
`instanceId`	`string`
`pageSize`	`integer (int32)`
`pageToken`	`string`
`showDeleted`	`boolean`
`updateMask`	`string (google-fieldmask)`

`SELECT` examples

get
list

Gets details of a single Instance.

SELECT
name,
acceleratedSecurityPatchEnabled,
adminSettings,
catalogIntegrationOptOut,
classType,
consumerNetwork,
controlledEgressConfig,
controlledEgressEnabled,
createTime,
customDomain,
denyMaintenancePeriod,
egressPublicIp,
encryptionConfig,
fipsEnabled,
geminiEnabled,
ingressIpAllowlistConfig,
ingressPrivateIp,
ingressPublicIp,
lastDenyMaintenancePeriod,
linkedLspProjectNumber,
lookerUri,
lookerVersion,
maintenanceSchedule,
maintenanceWindow,
oauthConfig,
periodicExportConfig,
platformEdition,
privateIpEnabled,
pscConfig,
pscEnabled,
publicIpEnabled,
releaseChannel,
reservedRange,
satisfiesPzi,
satisfiesPzs,
softDeleteReason,
state,
suspendedTime,
updateTime,
userMetadata
FROM google.looker.instances
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND instancesId = '{{ instancesId }}' -- required
;

Lists Instances in a given project and location.

SELECT
name,
acceleratedSecurityPatchEnabled,
adminSettings,
catalogIntegrationOptOut,
classType,
consumerNetwork,
controlledEgressConfig,
controlledEgressEnabled,
createTime,
customDomain,
denyMaintenancePeriod,
egressPublicIp,
encryptionConfig,
fipsEnabled,
geminiEnabled,
ingressIpAllowlistConfig,
ingressPrivateIp,
ingressPublicIp,
lastDenyMaintenancePeriod,
linkedLspProjectNumber,
lookerUri,
lookerVersion,
maintenanceSchedule,
maintenanceWindow,
oauthConfig,
periodicExportConfig,
platformEdition,
privateIpEnabled,
pscConfig,
pscEnabled,
publicIpEnabled,
releaseChannel,
reservedRange,
satisfiesPzi,
satisfiesPzs,
softDeleteReason,
state,
suspendedTime,
updateTime,
userMetadata
FROM google.looker.instances
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageToken = '{{ pageToken }}'
AND showDeleted = '{{ showDeleted }}'
AND pageSize = '{{ pageSize }}'
;

`INSERT` examples

create
Manifest

Creates a new Instance in a given project and location.

INSERT INTO google.looker.instances (
data__consumerNetwork,
data__customDomain,
data__releaseChannel,
data__controlledEgressConfig,
data__userMetadata,
data__controlledEgressEnabled,
data__ingressIpAllowlistConfig,
data__publicIpEnabled,
data__adminSettings,
data__catalogIntegrationOptOut,
data__platformEdition,
data__geminiEnabled,
data__pscEnabled,
data__linkedLspProjectNumber,
data__classType,
data__oauthConfig,
data__encryptionConfig,
data__reservedRange,
data__privateIpEnabled,
data__pscConfig,
data__periodicExportConfig,
data__denyMaintenancePeriod,
data__acceleratedSecurityPatchEnabled,
data__maintenanceWindow,
data__fipsEnabled,
data__maintenanceSchedule,
projectsId,
locationsId,
instanceId
)
SELECT 
'{{ consumerNetwork }}',
'{{ customDomain }}',
'{{ releaseChannel }}',
'{{ controlledEgressConfig }}',
'{{ userMetadata }}',
{{ controlledEgressEnabled }},
'{{ ingressIpAllowlistConfig }}',
{{ publicIpEnabled }},
'{{ adminSettings }}',
{{ catalogIntegrationOptOut }},
'{{ platformEdition }}',
{{ geminiEnabled }},
{{ pscEnabled }},
'{{ linkedLspProjectNumber }}',
'{{ classType }}',
'{{ oauthConfig }}',
'{{ encryptionConfig }}',
'{{ reservedRange }}',
{{ privateIpEnabled }},
'{{ pscConfig }}',
'{{ periodicExportConfig }}',
'{{ denyMaintenancePeriod }}',
{{ acceleratedSecurityPatchEnabled }},
'{{ maintenanceWindow }}',
{{ fipsEnabled }},
'{{ maintenanceSchedule }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ instanceId }}'
RETURNING
name,
done,
error,
metadata,
response
;

# Description fields are for documentation purposes
- name: instances
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the instances resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the instances resource.
  - name: consumerNetwork
    value: "{{ consumerNetwork }}"
    description: |
      Network name in the consumer project. Format: `projects/{project}/global/networks/{network}`. Note that the consumer network may be in a different GCP project than the consumer project that is hosting the Looker Instance.
  - name: customDomain
    description: |
      Custom domain configuration for the instance.
    value:
      domain: "{{ domain }}"
      state: "{{ state }}"
  - name: releaseChannel
    value: "{{ releaseChannel }}"
    description: |
      Optional. The selected release channel for the instance.
    valid_values: ['RELEASE_CHANNEL_UNSPECIFIED', 'RAPID', 'REGULAR', 'STABLE']
  - name: controlledEgressConfig
    description: |
      Optional. Controlled egress configuration.
    value:
      webProxyIps:
        - "{{ webProxyIps }}"
      egressFqdns:
        - "{{ egressFqdns }}"
      marketplaceEnabled: {{ marketplaceEnabled }}
  - name: userMetadata
    description: |
      Optional. User metadata.
    value:
      additionalDeveloperUserCount: {{ additionalDeveloperUserCount }}
      additionalViewerUserCount: {{ additionalViewerUserCount }}
      additionalStandardUserCount: {{ additionalStandardUserCount }}
  - name: controlledEgressEnabled
    value: {{ controlledEgressEnabled }}
    description: |
      Optional. Whether controlled egress is enabled on the Looker instance.
  - name: ingressIpAllowlistConfig
    description: |
      Optional. Ingress IP allowlist configuration for the Looker instance.
    value:
      enabled: {{ enabled }}
      googleServicesEnabled: {{ googleServicesEnabled }}
      allowlistRules:
        - description: "{{ description }}"
          ipRange: "{{ ipRange }}"
  - name: publicIpEnabled
    value: {{ publicIpEnabled }}
    description: |
      Whether public IP is enabled on the Looker instance.
  - name: adminSettings
    description: |
      Looker Instance Admin settings.
    value:
      allowedEmailDomains:
        - "{{ allowedEmailDomains }}"
  - name: catalogIntegrationOptOut
    value: {{ catalogIntegrationOptOut }}
    description: |
      Optional. Indicates whether catalog integration is disabled for the Looker instance.
  - name: platformEdition
    value: "{{ platformEdition }}"
    description: |
      Platform edition.
    valid_values: ['PLATFORM_EDITION_UNSPECIFIED', 'LOOKER_CORE_TRIAL', 'LOOKER_CORE_STANDARD', 'LOOKER_CORE_STANDARD_ANNUAL', 'LOOKER_CORE_ENTERPRISE_ANNUAL', 'LOOKER_CORE_EMBED_ANNUAL', 'LOOKER_CORE_NONPROD_STANDARD_ANNUAL', 'LOOKER_CORE_NONPROD_ENTERPRISE_ANNUAL', 'LOOKER_CORE_NONPROD_EMBED_ANNUAL', 'LOOKER_CORE_TRIAL_STANDARD', 'LOOKER_CORE_TRIAL_ENTERPRISE', 'LOOKER_CORE_TRIAL_EMBED']
  - name: geminiEnabled
    value: {{ geminiEnabled }}
    description: |
      Optional. Whether Gemini feature is enabled on the Looker instance or not.
  - name: pscEnabled
    value: {{ pscEnabled }}
    description: |
      Optional. Whether to use Private Service Connect (PSC) for private IP connectivity. If true, neither `public_ip_enabled` nor `private_ip_enabled` can be true.
  - name: linkedLspProjectNumber
    value: "{{ linkedLspProjectNumber }}"
    description: |
      Optional. Linked Google Cloud Project Number for Looker Studio Pro.
  - name: classType
    value: "{{ classType }}"
    description: |
      Optional. Storage class of the instance.
    valid_values: ['CLASS_TYPE_UNSPECIFIED', 'R1', 'P1']
  - name: oauthConfig
    description: |
      Looker instance OAuth login settings.
    value:
      clientSecret: "{{ clientSecret }}"
      sharedOauthClientEnabled: {{ sharedOauthClientEnabled }}
      clientId: "{{ clientId }}"
  - name: encryptionConfig
    description: |
      Encryption configuration (CMEK). Only set if CMEK has been enabled on the instance.
    value:
      kmsKeyState: "{{ kmsKeyState }}"
      kmsKeyName: "{{ kmsKeyName }}"
      kmsKeyNameVersion: "{{ kmsKeyNameVersion }}"
  - name: reservedRange
    value: "{{ reservedRange }}"
    description: |
      Name of a reserved IP address range within the Instance.consumer_network, to be used for private services access connection. May or may not be specified in a create request.
  - name: privateIpEnabled
    value: {{ privateIpEnabled }}
    description: |
      Whether private IP is enabled on the Looker instance.
  - name: pscConfig
    description: |
      Optional. PSC configuration. Used when `psc_enabled` is true.
    value:
      serviceAttachments:
        - localFqdn: "{{ localFqdn }}"
          connectionStatus: "{{ connectionStatus }}"
          localFqdns: "{{ localFqdns }}"
          failureReason: "{{ failureReason }}"
          targetServiceAttachmentUri: "{{ targetServiceAttachmentUri }}"
      lookerServiceAttachmentUri: "{{ lookerServiceAttachmentUri }}"
      allowedVpcs:
        - "{{ allowedVpcs }}"
  - name: periodicExportConfig
    description: |
      Optional. Configuration for periodic export.
    value:
      startTime:
        minutes: {{ minutes }}
        seconds: {{ seconds }}
        hours: {{ hours }}
        nanos: {{ nanos }}
      gcsUri: "{{ gcsUri }}"
      kmsKey: "{{ kmsKey }}"
  - name: denyMaintenancePeriod
    description: |
      Maintenance denial period for this instance.
    value:
      startDate:
        month: {{ month }}
        year: {{ year }}
        day: {{ day }}
      endDate:
        month: {{ month }}
        year: {{ year }}
        day: {{ day }}
      time:
        minutes: {{ minutes }}
        seconds: {{ seconds }}
        hours: {{ hours }}
        nanos: {{ nanos }}
  - name: acceleratedSecurityPatchEnabled
    value: {{ acceleratedSecurityPatchEnabled }}
    description: |
      Optional. Accelerated security patch enabled for the instance.
  - name: maintenanceWindow
    description: |
      Maintenance window for this instance.
    value:
      dayOfWeek: "{{ dayOfWeek }}"
      startTime:
        minutes: {{ minutes }}
        seconds: {{ seconds }}
        hours: {{ hours }}
        nanos: {{ nanos }}
  - name: fipsEnabled
    value: {{ fipsEnabled }}
    description: |
      Optional. Whether FIPS is enabled on the Looker instance.
  - name: maintenanceSchedule
    description: |
      Maintenance schedule for this instance.
    value:
      startTime: "{{ startTime }}"
      endTime: "{{ endTime }}"
  - name: instanceId
    value: "{{ instanceId }}"

`UPDATE` examples

patch

Update Instance.

UPDATE google.looker.instances
SET 
data__consumerNetwork = '{{ consumerNetwork }}',
data__customDomain = '{{ customDomain }}',
data__releaseChannel = '{{ releaseChannel }}',
data__controlledEgressConfig = '{{ controlledEgressConfig }}',
data__userMetadata = '{{ userMetadata }}',
data__controlledEgressEnabled = {{ controlledEgressEnabled }},
data__ingressIpAllowlistConfig = '{{ ingressIpAllowlistConfig }}',
data__publicIpEnabled = {{ publicIpEnabled }},
data__adminSettings = '{{ adminSettings }}',
data__catalogIntegrationOptOut = {{ catalogIntegrationOptOut }},
data__platformEdition = '{{ platformEdition }}',
data__geminiEnabled = {{ geminiEnabled }},
data__pscEnabled = {{ pscEnabled }},
data__linkedLspProjectNumber = '{{ linkedLspProjectNumber }}',
data__classType = '{{ classType }}',
data__oauthConfig = '{{ oauthConfig }}',
data__encryptionConfig = '{{ encryptionConfig }}',
data__reservedRange = '{{ reservedRange }}',
data__privateIpEnabled = {{ privateIpEnabled }},
data__pscConfig = '{{ pscConfig }}',
data__periodicExportConfig = '{{ periodicExportConfig }}',
data__denyMaintenancePeriod = '{{ denyMaintenancePeriod }}',
data__acceleratedSecurityPatchEnabled = {{ acceleratedSecurityPatchEnabled }},
data__maintenanceWindow = '{{ maintenanceWindow }}',
data__fipsEnabled = {{ fipsEnabled }},
data__maintenanceSchedule = '{{ maintenanceSchedule }}'
WHERE 
projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND instancesId = '{{ instancesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
done,
error,
metadata,
response;

`DELETE` examples

delete

Delete instance.

DELETE FROM google.looker.instances
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND instancesId = '{{ instancesId }}' --required
AND force = '{{ force }}'
;

Lifecycle Methods

restart
undelete
import
restore
export

Restart instance.

EXEC google.looker.instances.restart 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@instancesId='{{ instancesId }}' --required
;

Undeletes Looker instance.

EXEC google.looker.instances.undelete 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@instancesId='{{ instancesId }}' --required
;

Import instance.

EXEC google.looker.instances.import 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@instancesId='{{ instancesId }}' --required 
@@json=
'{
"gcsUri": "{{ gcsUri }}"
}'
;

Restore Looker instance.

EXEC google.looker.instances.restore 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@instancesId='{{ instancesId }}' --required 
@@json=
'{
"backup": "{{ backup }}"
}'
;

Export instance.

EXEC google.looker.instances.export 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@instancesId='{{ instancesId }}' --required 
@@json=
'{
"gcsUri": "{{ gcsUri }}", 
"encryptionConfig": "{{ encryptionConfig }}"
}'
;

Overview​

Fields​

Methods​

Parameters​

SELECT examples​

INSERT examples​

UPDATE examples​

DELETE examples​

Lifecycle Methods​