github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/acceptance/test_data/mods/mod_with_blank_dimension_value/query.sp (about)

     1  query "control_with_blank_dimension"{
     2      title ="query_1"
     3      description = "Simple query 1"
     4      sql = <<-EOQ
     5        select 'ok' as status, 'resource 1' as resource, 'reason 1' as reason, 'nb1' as dimension1, '' as dimension2, 'nb3' as dimension3
     6        UNION ALL
     7        select 'ok' as status, 'resource 2' as resource, 'reason 2' as reason, 'nb1' as dimension1, 'nb2' as dimension2, 'nb3' as dimension3
     8      EOQ
     9  }