Skip to content

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

3.3 KB
Raw Blame
- statement: SELECT * FROM t WHERE a in (SELECT c FROM t1 WHERE CONTAINS(b, 'foo'))
  defaultDatabase: db
  ignoreCaseSensitive: true
  metadata:
    - |-
      {
        "name":  "db",
        "schemas":  [
          {
            "name": "dbo",
            "tables":  [
              {
                "name":  "t",
                "columns":  [
                  {
                    "name":  "a"
                  },
                  {
                    "name":  "b"
                  }
                ]
              },
              {
                "name":  "t1",
                "columns":  [
                  {
                    "name":  "a"
                  },
                  {
                    "name":  "b"
                  },
                  {
                    "name":  "c"
                  }
                ]
              }
            ]
          }
        ]
      }
  querySpan:
    type: 1
    results:
        - name: a
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: t
              column: a
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: b
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: t
              column: b
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: db
          schema: dbo
          table: t
          column: ""
        - server: ""
          database: db
          schema: dbo
          table: t1
          column: ""
    predicatecolumns:
        - server: ""
          database: db
          schema: dbo
          table: t
          column: a
        - server: ""
          database: db
          schema: dbo
          table: t1
          column: b
        - server: ""
          database: db
          schema: dbo
          table: t1
          column: c
- statement: SELECT * FROM t WHERE a = 1
  defaultDatabase: db
  ignoreCaseSensitive: true
  metadata:
    - |-
      {
        "name":  "db",
        "schemas":  [
          {
            "name": "dbo",
            "tables":  [
              {
                "name":  "t",
                "columns":  [
                  {
                    "name":  "a"
                  },
                  {
                    "name":  "b"
                  }
                ]
              }
            ]
          }
        ]
      }
  querySpan:
    type: 1
    results:
        - name: a
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: t
              column: a
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: b
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: t
              column: b
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: db
          schema: dbo
          table: t
          column: ""
    predicatecolumns:
        - server: ""
          database: db
          schema: dbo
          table: t
          column: a