Table: gcp_cloudiot_devices

This table shows data for GCP Cloud IoT Devices.

https://cloud.google.com/iot/docs/reference/cloudiot/rest/v1/projects.locations.registries.devices#Device (opens in a new tab)

The composite primary key for this table is (project_id, name).

Relations

This table depends on gcp_cloudiot_device_registries.

The following tables depend on gcp_cloudiot_devices:

Columns

NameType
_cq_source_nameString
_cq_sync_timeTimestamp
_cq_idUUID
_cq_parent_idUUID
project_id (PK)String
idString
name (PK)String
num_idInt
credentialsJSON
last_heartbeat_timeTimestamp
last_event_timeTimestamp
last_state_timeTimestamp
last_config_ack_timeTimestamp
last_config_send_timeTimestamp
blockedBool
last_error_timeTimestamp
last_error_statusJSON
configJSON
stateJSON
log_levelString
metadataJSON
gateway_configJSON