turbot / steampipe-plugin-aws

Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/aws
Apache License 2.0
189 stars 104 forks source link

Getting an empty row in table `aws_waf_web_acl` #1607

Closed khushboo9024 closed 1 year ago

khushboo9024 commented 1 year ago

Describe the bug Getting an empty row in table aws_waf_web_acl even if we have the resource in place

Steampipe version (steampipe -v) Example: v0.18.5

Plugin version (steampipe plugin list) Example: v0.92.1

To reproduce select * from aws_waf_web_acl

Expected behavior A clear and concise description of what you expected to happen.

Additional context Add any other context about the problem here.

select * from aws_waf_web_acl +------+-----+------------+----------------+-------------+-----------------------+-------+----------+-------+------+------+-----------+--------+------------+------+ | name | arn | web_acl_id | default_action | metric_name | logging_configuration | rules | tags_src | title | tags | akas | partition | region | account_id | _ctx | +------+-----+------------+----------------+-------------+-----------------------+-------+----------+-------+------+------+-----------+--------+------------+------+ +------+-----+------------+----------------+-------------+-----------------------+-------+----------+-------+------+------+-----------+--------+------------+------+

ParthaI commented 1 year ago

AWS CLI also performing the same behaviour as GO SDK behaves. Created an issue in aws-cli end. Ref: https://github.com/aws/aws-cli/issues/7710

Priyanka-Chatterjee-2000 commented 1 year ago

This query works fine

For more information, type .help
> select
  -- Required Columns
  arn as resource,
  case
    when logging_configuration is null then 'alarm'
    else 'ok'
  end as status,
  case
    when logging_configuration is null then title || ' logging disabled.'
    else title || ' logging enabled.'
  end as reason,
  -- Additional Dimensions
  region,
  account_id
from
  aws_waf_web_acl;
+-----------------------------------------------------------------------+--------+------------------------+--------+--------------+
| resource                                                              | status | reason                 | region | account_id   |
+-----------------------------------------------------------------------+--------+------------------------+--------+--------------+
| arn:aws:waf::2222222222:webacl/060dfb34-90a9-4c9a-ad8b-28359d434e51 | alarm  | test logging disabled. | global | 222222222222 |
+-----------------------------------------------------------------------+--------+------------------------+--------+--------------+

 select * from aws_waf_web_acl
+-------------+-----------------------------------------------------------------------+--------------------------------------+----------------+-------------+----------------------->
| name        | arn                                                                   | web_acl_id                           | default_action | metric_name | logging_configuration >
+-------------+-----------------------------------------------------------------------+--------------------------------------+----------------+-------------+----------------------->
| test-delete | arn:aws:waf::2222222222:webacl/11b581e9-7e1b-4d82-84e0-22a86934c84a | 11b581e9-7e1b-4d82-84e0-22a86934c84a | ALLOW          | testdelete  | <null>                >
| test        | arn:aws:waf::2222222222:webacl/060dfb34-90a9-4c9a-ad8b-28359d434e51 | 060dfb34-90a9-4c9a-ad8b-28359d434e51 | ALLOW          | test        | <null>                >
+-------------+-----------------------------------------------------------------------+--------------------------------------+----------------+-------------+----------------------->
misraved commented 1 year ago

Closing this issue as confirmed in https://github.com/aws/aws-cli/issues/7710