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: Basic SELECT masking
statement: |
SELECT
name,
email,
phone
FROM
users
WHERE
created_at > '2020-01-01'
defaultDatabase: mydb
metadata: '{"name":"mydb","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"name","type":"varchar"},{"name":"email","type":"varchar"},{"name":"phone","type":"varchar"},{"name":"created_at","type":"timestamp"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: name
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: email
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: phone
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
mydb.public.users.created_at: true
mydb.public.users.email: true
mydb.public.users.name: true
mydb.public.users.phone: true
predicateColumns: {}
- description: Complex data types masking
statement: |
SELECT
user_id,
profile['address'] as address,
contact_info.phone as phone,
permissions[1] as first_permission
FROM
user_profiles
WHERE
profile['status'] = 'active'
defaultDatabase: mydb
metadata: '{"name":"mydb","schemas":[{"name":"public","tables":[{"name":"user_profiles","columns":[{"name":"user_id","type":"integer"},{"name":"profile","type":"map(varchar,varchar)"},{"name":"contact_info","type":"row(phone varchar)"},{"name":"permissions","type":"array(varchar)"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: user_id
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: address
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: phone
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: first_permission
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
mydb.public.user_profiles.contact_info: true
mydb.public.user_profiles.permissions: true
mydb.public.user_profiles.profile: true
mydb.public.user_profiles.user_id: true
predicateColumns: {}
- description: Join masking
statement: |
SELECT
u.name,
u.email,
o.order_id,
o.total
FROM
users u
JOIN
orders o
ON
u.user_id = o.user_id
WHERE
o.status = 'completed'
AND u.is_verified = true
defaultDatabase: mydb
metadata: '{"name":"mydb","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"name","type":"varchar"},{"name":"email","type":"varchar"},{"name":"user_id","type":"integer"},{"name":"is_verified","type":"boolean"}]},{"name":"orders","columns":[{"name":"order_id","type":"integer"},{"name":"total","type":"decimal"},{"name":"user_id","type":"integer"},{"name":"status","type":"varchar"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: u.name
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: u.email
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: o.order_id
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: o.total
sourceColumns: {}
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
mydb.public.orders.order_id: true
mydb.public.orders.status: true
mydb.public.orders.total: true
mydb.public.orders.user_id: true
mydb.public.users.email: true
mydb.public.users.is_verified: true
mydb.public.users.name: true
mydb.public.users.user_id: true
predicateColumns: {}
- description: Array function masking
statement: |
SELECT
user_id,
name,
array_contains(roles, 'admin') as is_admin
FROM
users
WHERE
cardinality(roles) > 0
AND element_at(permissions, 'edit') = true
defaultDatabase: mydb
metadata: '{"name":"mydb","schemas":[{"name":"public","tables":[{"name":"users","columns":[{"name":"user_id","type":"integer"},{"name":"name","type":"varchar"},{"name":"roles","type":"array(varchar)"},{"name":"permissions","type":"map(varchar,boolean)"}]}]}]}'
querySpan:
type:
querytype: 1
results:
- name: user_id
sourceColumns:
mydb.public.cardinality.cardinality: true
mydb.public.element_at.element_at: true
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: name
sourceColumns:
mydb.public.cardinality.cardinality: true
mydb.public.element_at.element_at: true
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
- name: is_admin
sourceColumns:
mydb.public.array_contains.array_contains: true
mydb.public.cardinality.cardinality: true
mydb.public.element_at.element_at: true
isPlainField: false
sourceFieldPaths: []
selectAsterisk: false
sourceColumns:
mydb.public.users.name: true
mydb.public.users.permissions: true
mydb.public.users.roles: true
mydb.public.users.user_id: true
predicateColumns: {}