Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- description: Simple SELECT
statement: SELECT id, name FROM users;
defaultDatabase: catalog1
metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: id
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: name
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
catalog1.public.users.id: true
catalog1.public.users.name: true
predicateColumns: {}
- description: SELECT with alias
statement: SELECT u.id AS user_id, u.name FROM users u;
defaultDatabase: catalog1
metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: user_id
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: u.name
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
catalog1.public.users.id: true
catalog1.public.users.name: true
predicateColumns: {}
- description: SELECT from schema.table
statement: SELECT id, name FROM public.users;
defaultDatabase: catalog1
metadata: '{"name":"catalog1","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"id","type":"integer"},{"name":"name","type":"varchar"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: id
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: name
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
catalog1.public.users.id: true
catalog1.public.users.name: true
predicateColumns: {}