1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148 | {
"jobId": "939fdbbaf52b45139b86c0761d6036b0",
"code": 200,
"data": {
"mode": "global",
"summary": {
"schema": 0,
"process": 1,
"database": 0,
"view": 0,
"mostRelationTables": [],
"column": 3,
"relationship": 0,
"table": 1
},
"sqlflow": {
"dbvendor": "dbvoracle",
"relationships": [],
"dbobjs": [
{
"queryHashId": "04ebc5aec1a07e1db80b0bc798742875",
"name": "QUERY INSERT-1",
"coordinates": [
{
"hashCode": "0",
"x": 1,
"y": 1
},
{
"hashCode": "0",
"x": 1,
"y": 73
}
],
"id": "8",
"type": "process"
},
{
"columns": [
{
"name": "ID",
"coordinates": [
{
"hashCode": "0",
"x": 1,
"y": 28
},
{
"hashCode": "0",
"x": 1,
"y": 30
}
],
"id": "5"
},
{
"name": "FIRST_NAME",
"coordinates": [
{
"hashCode": "0",
"x": 1,
"y": 32
},
{
"hashCode": "0",
"x": 1,
"y": 42
}
],
"id": "6"
},
{
"name": "LAST_NAME",
"coordinates": [
{
"hashCode": "0",
"x": 1,
"y": 44
},
{
"hashCode": "0",
"x": 1,
"y": 53
}
],
"id": "7"
}
],
"name": "RAW_CUSTOMERS",
"coordinates": [
{
"hashCode": "0",
"x": 1,
"y": 13
},
{
"hashCode": "0",
"x": 1,
"y": 26
}
],
"id": "4",
"type": "table"
}
]
},
"graph": {
"relationshipIdMap": {},
"elements": {
"tables": [],
"edges": []
},
"tooltip": {},
"listIdMap": {}
}
},
"sessionId": "24a4455c71fa35c0393d5747f9c23a9d99f32fa4c130a6b8da8d6a7db8d157ae_1664880305725",
"job": {
"ignoreFunction": true,
"lastExecuteTime": "2022-10-04 10:45:05",
"schedulable": false,
"parallel": false,
"ignoreRecordSet": true,
"userEmail": "guyuanhao@foxmail.com",
"persist": false,
"executeTimeMillis": 0,
"jobName": "yuanhao1",
"dataflowOfAggregateFunction": "direct",
"showTransform": false,
"sessionId": "24a4455c71fa35c0393d5747f9c23a9d99f32fa4c130a6b8da8d6a7db8d157ae_1664880305725",
"incremental": false,
"showConstantTable": false,
"userId": "auth0|6326be4047c1dfdd3bf553d0",
"showRelationType": "fdd",
"subJobs": [],
"version": "5.2.0",
"jobId": "939fdbbaf52b45139b86c0761d6036b0",
"createTime": "2022-10-04 10:45:04",
"onTop": false,
"cancelSchedule": false,
"dbVendor": "dbvoracle",
"fileNames": [
"test.sql"
],
"status": "success",
"executeTime": "0min 1sec"
}
}
|