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: Union and Intersect
statement: SELECT A, B FROM T1 UNION SELECT * FROM T2 INTERSECT SELECT * FROM T3;
defaultDatabase: SNOWFLAKE
ignoreCaseSensitive: true
metadata: |-
{
"name": "SNOWFLAKE",
"schemas": [
{
"name": "PUBLIC",
"tables": [
{
"name": "T1",
"columns": [
{
"name": "A"
},
{
"name": "B"
},
{
"name": "C"
},
{
"name": "D"
}
]
},
{
"name": "T2",
"columns": [
{
"name": "A"
},
{
"name": "E"
}
]
},
{
"name": "T3",
"columns": [
{
"name": "E"
},
{
"name": "F"
}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: A
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T3
column: E
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: B
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: E
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T3
column: F
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T3
column: ""
predicatecolumns: []
- description: Union all by name merges columns by name, not by position
statement: SELECT A, B FROM T1 UNION ALL BY NAME SELECT B, A FROM T2;
defaultDatabase: SNOWFLAKE
ignoreCaseSensitive: true
metadata: |-
{
"name": "SNOWFLAKE",
"schemas": [
{
"name": "PUBLIC",
"tables": [
{
"name": "T1",
"columns": [
{
"name": "A"
},
{
"name": "B"
}
]
},
{
"name": "T2",
"columns": [
{
"name": "A"
},
{
"name": "B"
}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: A
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: A
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: B
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: B
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: ""
predicatecolumns: []
- description: UNION ALL BY NAME inside a CTE merges by column name (not positionally)
statement: WITH C AS (SELECT A, B FROM T1 UNION ALL BY NAME SELECT B, A FROM T2) SELECT * FROM C;
defaultDatabase: SNOWFLAKE
ignoreCaseSensitive: true
metadata: |-
{
"name": "SNOWFLAKE",
"schemas": [
{
"name": "PUBLIC",
"tables": [
{
"name": "T1",
"columns": [
{"name": "A"},
{"name": "B"}
]
},
{
"name": "T2",
"columns": [
{"name": "A"},
{"name": "B"}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: A
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: A
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: B
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: B
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: C
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T2
column: ""
predicatecolumns: []
- description: WITH CTEs stay visible to every set-operation operand (not just the left)
statement: WITH C AS (SELECT A FROM T1) SELECT A FROM C UNION SELECT A FROM C;
defaultDatabase: SNOWFLAKE
ignoreCaseSensitive: true
metadata: |-
{
"name": "SNOWFLAKE",
"schemas": [
{
"name": "PUBLIC",
"tables": [
{
"name": "T1",
"columns": [
{"name": "A"}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: A
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: C
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
predicatecolumns: []