Table: gcp_dataplex_zone - Query GCP Dataplex Zones using SQL
GCP Dataplex Zones are logical groupings within a Dataplex Lake, designed to organize and manage data based on various criteria, such as data type, security requirements, or lifecycle management. Zones allow for granular control over data management and access within a Lake.
Table Usage Guide
The gcp_dataplex_zone
table allows data engineers and cloud administrators to query and manage Dataplex Zones within their GCP environment. You can retrieve information about the zone's configuration, status, associated lake, and more. This table is useful for monitoring and managing the state and metadata of Dataplex Zones.
Examples
Basic info
Retrieve a list of all Dataplex Zones in your GCP account to get an overview of your managed data zones.
select name, display_name, lake_name, create_time, typefrom gcp_dataplex_zone;
select name, display_name, lake_name, create_time, typefrom gcp_dataplex_zone;
Dataplex zones by type
Explore the different types of Dataplex Zones to understand how your data is organized and managed within lakes.
select type, count(*)from gcp_dataplex_zonegroup by type;
select type, count(*)from gcp_dataplex_zonegroup by type;
Get details of zones in a specific state
Retrieve Dataplex Zones in a specific state (e.g., ACTIVE
) to monitor their status.
select name, state, create_time, update_timefrom gcp_dataplex_zonewhere state = 'ACTIVE';
select name, state, create_time, update_timefrom gcp_dataplex_zonewhere state = 'ACTIVE';
Dataplex zones with their associated lakes
This is useful for understanding the relationship between zones and lakes in your Dataplex environment.
select z.name as zone_name, z.type as zone_type, z.state as zone_state, z.create_time as zone_create_time, l.name as lake_name, l.location as lake_location, l.state as lake_statefrom gcp_dataplex_zone as z join gcp_dataplex_lake as l on z.lake_name = l.name;
select z.name as zone_name, z.type as zone_type, z.state as zone_state, z.create_time as zone_create_time, l.name as lake_name, l.location as lake_location, l.state as lake_statefrom gcp_dataplex_zone as z join gcp_dataplex_lake as l on z.lake_name = l.name;
Schema for gcp_dataplex_zone
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
akas | jsonb | Array of globally unique identifier strings (also known as) for the resource. | |
asset_status | jsonb | Aggregated status of the underlying assets of the zone. | |
create_time | timestamp with time zone | The time when the zone was created. | |
description | text | Description of the zone. | |
discovery_spec | jsonb | Specification of the discovery feature applied to data in this zone. | |
display_name | text | = | User friendly display name. |
lake_name | text | = | The relative resource name of the lake. |
location | text | The GCP multi-region, region, or zone in which the resource is located. | |
name | text | = | The relative resource name of the zone. |
project | text | =, !=, ~~, ~~*, !~~, !~~* | The GCP Project in which the resource is located. |
resource_spec | jsonb | Specification of the resources that are referenced by the assets within this zone. | |
self_link | text | Server-defined URL for the resource. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
state | text | = | Current state of the zone. |
tags | jsonb | A map of tags for the resource. | |
title | text | Title of the resource. | |
type | text | The type of the zone. | |
uid | text | System generated globally unique ID for the zone. | |
update_time | timestamp with time zone | The time when the zone was last updated. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- gcp
You can pass the configuration to the command with the --config
argument:
steampipe_export_gcp --config '<your_config>' gcp_dataplex_zone