8000 Failing example queries due to syntax or time-out issues. · Issue #717 · turbot/steampipe-plugin-gcp · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Failing example queries due to syntax or time-out issues. #717

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
chandru89new opened this issue Feb 19, 2025 · 1 comment
Open

Failing example queries due to syntax or time-out issues. #717

chandru89new opened this issue Feb 19, 2025 · 1 comment
Assignees
@misraved
Labels
bug Something isn't working stale No recent activity has been detected on this issue/PR and it will be closed

Comments

@chandru89new
Copy link

I ran a test of all the example queries listed in the table documentation on hub and found these issues:

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_alloydb_instance.md
[ERROR]: select name, labels from gcp_alloydb_instance where labels -> 'environment' = 'production';
[ERROR]: Warning: query 1 of 1 failed: ERROR: invalid input syntax for type json (SQLSTATE 22P02)

[ERROR]: select name, state, availability_type, display_name from gcp_alloydb_instance;
[ERROR]: Warning: query 1 of 1 failed: ERROR: column "display_name" does not exist (SQLSTATE 42703)

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_cloud_identity_group.md
[ERROR]: select name, display_name, description, create_time, location, project from gcp_cloud_identity_group where name = 'group_name';
[ERROR]: Query timed out.

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_compute_address.md
[ERROR]: select name, address, id, jsonb_pretty(users) from gcp_compute_address where name= 'test2';
[ERROR]: Query timed out.

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_compute_route.md
[ERROR]: select name, warnings from gcp_compute_route where warnings is not null;
[ERROR]: Warning: query 1 of 1 failed: ERROR: relation "gcp_compute_route" does not exist (SQLSTATE 42P01)

[ERROR]: select name, dest_range, priority, next_hop_gateway from gcp_compute_route where priority = 1000 and dest_range = '0.0.0.0/0';
[ERROR]: Warning: query 1 of 1 failed: ERROR: relation "gcp_compute_route" does not exist (SQLSTATE 42P01)

[ERROR]: select name, id, network_name as network from gcp_compute_route where network_name <> 'default';
[ERROR]: Warning: query 1 of 1 failed: ERROR: relation "gcp_compute_route" does not exist (SQLSTATE 42P01)

[ERROR]: select name, dest_range, priority, network from gcp_compute_route;
[ERROR]: Warning: query 1 of 1 failed: ERROR: relation "gcp_compute_route" does not exist (SQLSTATE 42P01)

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_dataproc_cluster.md
[ERROR]: select cluster_name, config -> 'endpointConfig' as endpoint_config, config -> 'configBucket' as config_bucket, config -> 'shieldedInstanceConfig' as shielded_instance_config, config -> 'masterConfig' as master_config from gcp_dataproc_cluster where cluster_name = 'cluster-5824';
[ERROR]: Query timed out.

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_logging_log_entry.md
[ERROR]: select log_name, insert_id, log_entry_operation_first, log_entry_operation_last, receive_timestamp, resource_type, severity from gcp_logging_log_entry where log_name = 'projects/parker-abbb/logs/cloudaudit.googleapis.com%2Factivity';
[ERROR]: Warning: query 1 of 1 failed: ERROR: column "log_entry_operation_first" does not exist (SQLSTATE 42703)

[ERROR]: select log_name, insert_id, log_entry_operation_first, log_entry_operation_last, resource_type, span_id, text_payload from gcp_logging_log_entry where resource_type = 'audited_resource';
[ERROR]: Warning: query 1 of 1 failed: ERROR: column "log_entry_operation_first" does not exist (SQLSTATE 42703)

[ERROR]: select log_name, insert_id, log_entry_operation_first, log_entry_operation_id, receive_timestamp from gcp_logging_log_entry;
[ERROR]: Warning: query 1 of 1 failed: ERROR: column "log_entry_operation_first" does not exist (SQLSTATE 42703)

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_redis_cluster.md
[ERROR]: select name, create_time, location, maintenance_policy, maintenance_schedule from gcp_redis_cluster;
[ERROR]: Warning: query 1 of 1 failed: ERROR: column "maintenance_policy" does not exist (SQLSTATE 42703)

[ERROR]: select name, create_time, location, node_type, size_gb, replica_count, shard_count from gcp_redis_cluster where name = 'cluster-test' and location = 'europe-west9';
[ERROR]: Query timed out.

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_sql_database.md
[ERROR]: select name, instance_name, charset, collation from gcp_sql_database;
[ERROR]: Warning: query 1 of 1 failed: ERROR: syntax error at or near "from" (SQLSTATE 42601)

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_sql_database_instance.md
[ERROR]: select name, instance_users from gcp_sql_database_instance where name='my-sql-instance';
[ERROR]: Query timed out.

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_vertex_ai_endpoint.md
[ERROR]: select name, network, predict_request_response_logging_config ->> 'Enabled' as enabled, predict_request_response_logging_config ->> 'SamplingRate' as sampling_rate, predict_request_response_logging_config ->> 'BigqueryDestination' as bigquery_destination from gcp_vertex_ai_endpoint;
[ERROR]: Query timed out.

[ERROR]: select name, create_time, encryption_spec ->> 'KmsKeyName' as kms_key_name from gcp_vertex_ai_endpoint;
[ERROR]: Query timed out.

[ERROR]: select name, display_name, network, create_time, update_time from gcp_vertex_ai_endpoint where create_time >= now() - interval '30' day;
[ERROR]: Query timed out.

[ERROR]: select name, display_name, create_time, enable_private_service_connect from gcp_vertex_ai_endpoint where enable_private_service_connect;
[ERROR]: Query timed out.

[ERROR]: select name, display_name, create_time, network from gcp_vertex_ai_endpoint;
[ERROR]: Query timed out.

---

[INFO]: Checking: ../steampipe-plugin-gcp/docs/tables/gcp_vertex_ai_model.md
[ERROR]: select name, display_name, supported_input_storage_formats from gcp_vertex_ai_model where supported_input_storage_formats ? 'csv';
[ERROR]: Query timed out.

[ERROR]: select name, display_name, d ->> 'endpoint' as endpoint, d ->> 'deployed_model_id' as deployed_model_id from gcp_vertex_ai_model, jsonb_array_elements(deployed_models) as d where d ->> 'endpoint' = 'projects/123456789/endpoints/123456789';
[ERROR]: Query timed out.

[ERROR]: select name, display_name, case when model_source_info ->> 'source_type' = '1' then 'Model Generated by AutoML' when model_source_info ->> 'source_type' = '2' then 'Model Imported from Custom' when model_source_info ->> 'source_type' = '3' then 'Model Imported from BigQuery ML' when model_source_info ->> 'source_type' = '4' then 'Model Saved from Model Garden' when model_source_info ->> 'source_type' = '5' then 'Model Saved from Genie' end as model_source from gcp_vertex_ai_model;
[ERROR]: Query timed out.

[ERROR]: select name, display_name, create_time from gcp_vertex_ai_model where create_time >= current_date - interval '30 days';
[ERROR]: Query timed out.

[ERROR]: select name, display_name, create_time, version_id, container_spec, deployed_models from gcp_vertex_ai_model;
[ERROR]: Query timed out.

The timeout was set to be 120s (2 mins).
@chandru89new chandru89new added the bug Something isn't working label Feb 19, 2025
@misraved misraved self-assigned this Mar 7, 2025
@github-actions GitHub Actions
Copy link
github-actions bot commented May 6, 2025

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

@github-actions github-actions bot added the stale No recent activity has been detected on this issue/PR and it will be closed label May 6, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@misraved misraved

Labels
bug Something isn't working stale No recent activity has been detected on this issue/PR and it will be closed
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@chandru89new @misraved
0