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: |-
WITH CTE_01 AS (
SELECT A AS C1, B AS C2, C AS C3, 1 AS N FROM T1
UNION ALL
SELECT C1 * C2, C2 + C1, C3 * C2, N + 1 FROM CTE_01 WHERE N < 5
)
SELECT * FROM CTE_01;
defaultDatabase: SNOWFLAKE
ignoreCaseSensitive: true
metadata: |-
{
"name": "SNOWFLAKE",
"schemas": [
{
"name": "PUBLIC",
"tables": [
{
"name": "T1",
"columns": [
{
"name": "A"
},
{
"name": "B"
},
{
"name": "C"
},
{
"name": "D"
}
]
}
]
}
]
}
querySpan:
type: 1
results:
- name: C1
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: C2
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: C3
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: C
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: "N"
sourcecolumns: []
isplainfield: false
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: CTE_01
column: ""
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
predicatecolumns: []