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: Unpivot
statement: SELECT * FROM T1 UNPIVOT(E FOR F IN (B, C, D));
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
isplainfield: true
sourcefieldpaths: []
selectasterisk: false
- name: F
sourcecolumns: []
isplainfield: false
sourcefieldpaths: []
selectasterisk: false
- name: E
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: B
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: C
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: D
isplainfield: false
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
predicatecolumns: []
- description: Pivot
statement: SELECT TT1.* FROM T1 PIVOT(MAX(A) FOR B IN ('a', 'b', 'c')) AS TT1
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: 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
- name: '''a'''
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
isplainfield: false
sourcefieldpaths: []
selectasterisk: false
- name: '''b'''
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
isplainfield: false
sourcefieldpaths: []
selectasterisk: false
- name: '''c'''
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: A
isplainfield: false
sourcefieldpaths: []
selectasterisk: false
sourcecolumns:
- server: ""
database: SNOWFLAKE
schema: PUBLIC
table: T1
column: ""
predicatecolumns: []