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: Uncorrelated Subquery In From Clause
statement: SELECT A, B, C, D FROM (SELECT * FROM T1) T;
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: A
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: B
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: C
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: C
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: D
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: D
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
predicatecolumns: []