databases_scans

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

Overview

Name	databases_scans
Type	Resource
Id	google.spanner.databases_scans

Fields

The following fields are returned by SELECT queries:

projects_instances_databases_get_scans

Successful response

Name	Datatype	Description
name	string	The unique name of the scan, specific to the Database service implementing this interface.
details	object	Additional information provided by the implementer.
endTime	string (google-datetime)	The upper bound for when the scan is defined.
scanData	object	Output only. Cloud Key Visualizer scan data. Note, this field is not available to the ListScans method. (id: ScanData)
startTime	string (google-datetime)	A range of time (inclusive) for when the scan is defined. The lower bound for when the scan is defined.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
projects_instances_databases_get_scans	select	projectsId, instancesId, databasesId	view, startTime, endTime	Request a specific scan with Database-specific data for Cloud Key Visualizer.

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
databasesId	string
instancesId	string
projectsId	string
endTime	string (google-datetime)
startTime	string (google-datetime)
view	string

SELECT examples

projects_instances_databases_get_scans

Request a specific scan with Database-specific data for Cloud Key Visualizer.

SELECT
name,
details,
endTime,
scanData,
startTime
FROM google.spanner.databases_scans
WHERE projectsId = '{{ projectsId }}' -- required
AND instancesId = '{{ instancesId }}' -- required
AND databasesId = '{{ databasesId }}' -- required
AND view = '{{ view }}'
AND startTime = '{{ startTime }}'
AND endTime = '{{ endTime }}';