sql_integrations

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

Overview

Name	sql_integrations
Type	Resource
Id	google.managedidentities.sql_integrations

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	The unique name of the SQL integration in the form of projects/{project_id}/locations/global/domains/{domain_name}/sqlIntegrations/{sql_integration}
createTime	string (google-datetime)	Output only. The time the SQL integration was created.
sqlInstance	string	The full resource name of an integrated SQL instance
state	string	Output only. The current state of the SQL integration.
updateTime	string (google-datetime)	Output only. The time the SQL integration was updated.

list

Name	Datatype	Description
name	string	The unique name of the SQL integration in the form of projects/{project_id}/locations/global/domains/{domain_name}/sqlIntegrations/{sql_integration}
createTime	string (google-datetime)	Output only. The time the SQL integration was created.
sqlInstance	string	The full resource name of an integrated SQL instance
state	string	Output only. The current state of the SQL integration.
updateTime	string (google-datetime)	Output only. The time the SQL integration was updated.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, domainsId, sqlIntegrationsId		Gets details of a single sqlIntegration.
list	select	projectsId, domainsId	pageSize, pageToken, filter, orderBy	Lists SqlIntegrations in a given domain.

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
domainsId	string
projectsId	string
sqlIntegrationsId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string

SELECT examples

get

Gets details of a single sqlIntegration.

SELECT
name,
createTime,
sqlInstance,
state,
updateTime
FROM google.managedidentities.sql_integrations
WHERE projectsId = '{{ projectsId }}' -- required
AND domainsId = '{{ domainsId }}' -- required
AND sqlIntegrationsId = '{{ sqlIntegrationsId }}' -- required
;

list

Lists SqlIntegrations in a given domain.

SELECT
name,
createTime,
sqlInstance,
state,
updateTime
FROM google.managedidentities.sql_integrations
WHERE projectsId = '{{ projectsId }}' -- required
AND domainsId = '{{ domainsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
;