Skip to main content

instances

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

Overview

Nameinstances
TypeResource
Idgoogle.looker.instances

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringOutput only. Format: projects/{project}/locations/{location}/instances/{instance}.
adminSettingsobjectLooker Instance Admin settings. (id: AdminSettings)
classTypestringOptional. Storage class of the instance.
consumerNetworkstringNetwork 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.
createTimestring (google-datetime)Output only. The time when the Looker instance provisioning was first requested.
customDomainobjectCustom domain configuration for the instance. (id: CustomDomain)
denyMaintenancePeriodobjectMaintenance denial period for this instance. (id: DenyMaintenancePeriod)
egressPublicIpstringOutput only. Public Egress IP (IPv4).
encryptionConfigobjectEncryption configuration (CMEK). Only set if CMEK has been enabled on the instance. (id: EncryptionConfig)
fipsEnabledbooleanOptional. Whether FIPS is enabled on the Looker instance.
geminiEnabledbooleanOptional. Whether Gemini feature is enabled on the Looker instance or not.
ingressPrivateIpstringOutput only. Private Ingress IP (IPv4).
ingressPublicIpstringOutput only. Public Ingress IP (IPv4).
lastDenyMaintenancePeriodobjectOutput only. Last computed maintenance denial period for this instance. (id: DenyMaintenancePeriod)
linkedLspProjectNumberstring (int64)Optional. Linked Google Cloud Project Number for Looker Studio Pro.
lookerUristringOutput only. Looker instance URI which can be used to access the Looker Instance UI.
lookerVersionstringOutput only. The Looker version that the instance is using.
maintenanceScheduleobjectMaintenance schedule for this instance. (id: MaintenanceSchedule)
maintenanceWindowobjectMaintenance window for this instance. (id: MaintenanceWindow)
oauthConfigobjectLooker instance OAuth login settings. (id: OAuthConfig)
platformEditionstringPlatform edition.
privateIpEnabledbooleanWhether private IP is enabled on the Looker instance.
pscConfigobjectOptional. PSC configuration. Used when psc_enabled is true. (id: PscConfig)
pscEnabledbooleanOptional. Whether to use Private Service Connect (PSC) for private IP connectivity. If true, neither public_ip_enabled nor private_ip_enabled can be true.
publicIpEnabledbooleanWhether public IP is enabled on the Looker instance.
reservedRangestringName 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.
satisfiesPzibooleanOutput only. Reserved for future use.
satisfiesPzsbooleanOutput only. Reserved for future use.
statestringOutput only. The state of the instance.
updateTimestring (google-datetime)Output only. The time when the Looker instance was last updated.
userMetadataobjectOptional. User metadata. (id: UserMetadata)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectprojectsId, locationsId, instancesIdGets details of a single Instance.
listselectprojectsId, locationsIdpageSize, pageTokenLists Instances in a given project and location.
createinsertprojectsId, locationsIdinstanceIdCreates a new Instance in a given project and location.
patchupdateprojectsId, locationsId, instancesIdupdateMaskUpdate Instance.
deletedeleteprojectsId, locationsId, instancesIdforceDelete instance.
restartexecprojectsId, locationsId, instancesIdRestart instance.
restoreexecprojectsId, locationsId, instancesIdRestore Looker instance.
importexecprojectsId, locationsId, instancesIdImport instance.
exportexecprojectsId, locationsId, instancesIdExport 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.

NameDatatypeDescription
instancesIdstring
locationsIdstring
projectsIdstring
forceboolean
instanceIdstring
pageSizeinteger (int32)
pageTokenstring
updateMaskstring (google-fieldmask)

SELECT examples

Gets details of a single Instance.

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

INSERT examples

Creates a new Instance in a given project and location.

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

UPDATE examples

Update Instance.

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

DELETE examples

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 instance.

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