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

     1  dashboard "with_dep_on_with" {
     2    title         = "With dependent on with"
     3    with "n1" {
     4      sql = <<-EOQ
     5            select 'n1'
     6          EOQ
     7    }
     8    with "n2" {
     9      sql = <<-EOQ
    10            select $1
    11          EOQ
    12      args = [ with.dependency.rows[0]]
    13    }
    14    with "dependency" {
    15      sql = <<-EOQ
    16  
    17            select 'dependency_with'
    18          EOQ
    19    }
    20  
    21    graph {
    22      title = "Relationships"
    23      width = 12
    24      type  = "graph"
    25  
    26  
    27      node "n1" {
    28        sql = <<-EOQ
    29      select
    30        $1 as id,
    31        $1 as title
    32  EOQ
    33        args = [ with.n1.rows[0]]
    34      }
    35      node "n2" {
    36        sql = <<-EOQ
    37      select
    38        $1 as id,
    39        $1 as title
    40  EOQ
    41  
    42        args = [ with.n2.rows[0]]
    43      }
    44      edge "n1_n2" {
    45        sql = <<-EOQ
    46      select
    47        $1 as from_id,
    48        $2 as to_id
    49  EOQ
    50        args = [with.n1.rows[0], with.n2.rows[0]]
    51      }
    52    }
    53  
    54  }