turbot / steampipe-plugin-gcp

Use SQL to instantly query GCP resources across regions, projects and organizations. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/gcp
Apache License 2.0
39 stars 24 forks source link

Add table gcp_composer_environment Closes #637 #649

Closed ParthaI closed 1 week ago

ParthaI commented 1 week ago

Integration test logs

Logs ``` Add passing integration test logs here ```

Example query results

Results ``` > select name, jsonb_path_query_array(web_server_network_access_control, '$.allowedIpRanges[*].value') as allowed_ip_ranges, location, project from gcp_composer_environment where web_server_network_access_control is not null; +--------------------------------------------------------------+-----------------------+-------------+------------+ | name | allowed_ip_ranges | location | project | +--------------------------------------------------------------+-----------------------+-------------+------------+ | projects/parker-aaa/locations/us-central1/environments/test1 | ["0.0.0.0/0","::0/0"] | us-central1 | parker-aaa | +--------------------------------------------------------------+-----------------------+-------------+------------+ ```