Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.6 KB
Raw Blame
- description: Union and Intersect
  statement: |-
    WITH CTE_01 AS (
      SELECT A AS C1, B AS C2, C AS C3, 1 AS N FROM T1
      UNION ALL
      SELECT C1 * C2, C2 + C1, C3 * C2, N + 1 FROM CTE_01 WHERE N < 5
    )
    SELECT * FROM CTE_01;
  defaultDatabase: SNOWFLAKE
  ignoreCaseSensitive: true
  metadata: |-
    {
      "name":  "SNOWFLAKE",
      "schemas":  [
        {
          "name": "PUBLIC",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: C1
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: A
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C2
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: A
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C3
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: A
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: B
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: "N"
          sourcecolumns: []
          isplainfield: false
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: SNOWFLAKE
          schema: PUBLIC
          table: CTE_01
          column: ""
        - server: ""
          database: SNOWFLAKE
          schema: PUBLIC
          table: T1
          column: ""
    predicatecolumns: []