github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/pkg/steampipeconfig/testdata/mods/dashboard_runtime_deps_named_arg/report.sp (about)

     1  query "aws_region_input" {
     2    sql = <<EOQ
     3  select
     4    title as label,
     5    region as value
     6  from
     7    aws_region
     8  where
     9    account_id = '876515858155'
    10  order by
    11    title;
    12  EOQ
    13  }
    14  
    15  
    16  dashboard "dashboard_named_args" {
    17    title = "dashboard with named arguments"
    18  
    19    input "user" {
    20      title = "AWS IAM User"
    21      sql   = query.aws_region_input.sql
    22      width = 4
    23    }
    24  
    25    table {
    26      sql = "select * from aws_account where arn in ($1)"
    27      with "w1" {
    28          sql = "select * from aws_account"
    29  
    30      }
    31      args  = {
    32        "with_val" = with.w1.rows[*].arn
    33      }
    34      param "with_val" {}
    35  
    36  
    37      column "depth" {
    38        display = "none"
    39      }
    40    }
    41  }