github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/dashboard_global_and_dashboard_inputs/inputs.sp (about)

     1  
     2  query "aws_region_input" {
     3    sql = <<EOQ
     4  select
     5    title as label,
     6    region as value
     7  from
     8    aws_region
     9  where
    10    account_id = '876515858155'
    11  order by
    12    title;
    13  EOQ
    14  }
    15  
    16  query "aws_s3_buckets_by_versioning_enabled" {
    17    sql = <<-EOQ
    18      with versioning as (
    19        select
    20          case when versioning_enabled then 'Enabled' else 'Disabled' end as versioning_status,
    21          region
    22        from
    23          aws_s3_bucket
    24      )
    25      select
    26        versioning_status,
    27        count(versioning_status) as "Total"
    28      from
    29        versioning
    30      where
    31        region = $1
    32      group by
    33        versioning_status
    34  EOQ
    35    param "region" {
    36      default = "us-east-1"
    37    }
    38  }
    39  
    40  
    41  input "global1" {
    42    sql = query.aws_region_input.sql
    43    width = 3
    44  }
    45  
    46  dashboard "inputs" {
    47    title = "Inputs Test"
    48  
    49  
    50    input "region" {
    51      sql = query.aws_region_input.sql
    52      width = 3
    53    }
    54  
    55    chart {
    56      type = "donut"
    57      width = 5
    58      query = query.aws_s3_buckets_by_versioning_enabled
    59      args = {
    60        "region" = self.input.region.value
    61      }
    62      title = "AWS IAM Users MFA Status"
    63  
    64      series "Total" {
    65        point "Disabled" {
    66          color = "red"
    67        }
    68  
    69        point "Enabled" {
    70          color = "green"
    71        }
    72      }
    73    }
    74  }
    75  
    76  dashboard "inputs2" {
    77    title = "Inputs Test 2"
    78  
    79    input "region" {
    80      sql = query.aws_region_input.sql
    81      width = 3
    82    }
    83  
    84  
    85    chart {
    86      type = "donut"
    87      width = 5
    88      query = query.aws_s3_buckets_by_versioning_enabled
    89      args = {
    90        "region" = self.input.region.value
    91      }
    92      title = "AWS IAM Users MFA Status"
    93  
    94      series "Total" {
    95        point "Disabled" {
    96          color = "red"
    97        }
    98  
    99        point "Enabled" {
   100          color = "green"
   101        }
   102      }
   103    }
   104  }
   105  
   106