Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- 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