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

     1  dashboard "with_syntax" {
     2  
     3    with "data" {
     4      query = query.data
     5    }
     6  #
     7  #  table {
     8  #    query = query.data
     9  #  }
    10  #
    11  #  table {
    12  #    args = [ with.data.rows[0].person, with.data.rows[0].server ]
    13  #    sql = <<EOQ
    14  #      select
    15  #        $1 as person,
    16  #        $2 as server
    17  #    EOQ
    18  #  }
    19  
    20    table {
    21      args = [ with.data.rows[*].person, with.data.rows[*].server ]
    22      sql = <<EOQ
    23        select
    24          $1 as person,
    25          $2 as server
    26      EOQ
    27    }
    28  
    29  }
    30  
    31  query "data" {
    32    sql = <<EOQ
    33      with data(person, server) as (
    34        values
    35          ('jon', 'mastodon.social'),
    36          ('chris', 'infosec.exchange')
    37      )
    38      select
    39        *
    40      from
    41        data
    42    EOQ
    43  }