forked from demisto/content
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathplaybook-Snowflake-Test.yml
185 lines (185 loc) · 3.74 KB
/
playbook-Snowflake-Test.yml
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
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
id: Snowflake-Test
version: -1
name: Snowflake-Test
starttaskid: "0"
tasks:
"0":
id: "0"
taskid: a3244a3d-eb9a-4b61-86ae-cef683fcca3a
type: start
task:
id: a3244a3d-eb9a-4b61-86ae-cef683fcca3a
version: -1
name: ""
iscommand: false
brand: ""
nexttasks:
'#none#':
- "1"
separatecontext: false
view: |-
{
"position": {
"x": 50,
"y": 50
}
}
note: false
timertriggers: []
ignoreworker: false
"1":
id: "1"
taskid: dacc063e-50f7-43d1-812f-1c1d0a433380
type: regular
task:
id: dacc063e-50f7-43d1-812f-1c1d0a433380
version: -1
name: DeleteContext
description: Delete field from context
scriptName: DeleteContext
type: regular
iscommand: false
brand: ""
nexttasks:
'#none#':
- "3"
scriptarguments:
all:
simple: "yes"
index: {}
key: {}
keysToKeep: {}
subplaybook: {}
separatecontext: false
view: |-
{
"position": {
"x": 50,
"y": 195
}
}
note: false
timertriggers: []
ignoreworker: false
"3":
id: "3"
taskid: 8694012b-4bb5-4056-8480-faef40999716
type: regular
task:
id: 8694012b-4bb5-4056-8480-faef40999716
version: -1
name: snowflake-query
description: Execute a SELECT query and retrieve the data
script: Snowflake|||snowflake-query
type: regular
iscommand: true
brand: Snowflake
nexttasks:
'#none#':
- "11"
scriptarguments:
columns: {}
database:
simple: demo_db
query:
simple: select * from test where ID = 8 and NAME = 'blah'
role:
simple: sysadmin
rows: {}
schema:
simple: public
warehouse:
simple: demo_wh
separatecontext: false
view: |-
{
"position": {
"x": 50,
"y": 370
}
}
note: false
timertriggers: []
ignoreworker: false
"8":
id: "8"
taskid: af19262d-c556-4f70-8e64-4aa726540bce
type: title
task:
id: af19262d-c556-4f70-8e64-4aa726540bce
version: -1
name: Done
type: title
iscommand: false
brand: ""
separatecontext: false
view: |-
{
"position": {
"x": 50,
"y": 720
}
}
note: false
timertriggers: []
ignoreworker: false
"11":
id: "11"
taskid: b6ec06ad-ace2-45ec-8cf8-102810f05f03
type: condition
task:
id: b6ec06ad-ace2-45ec-8cf8-102810f05f03
version: -1
name: Verify Query Output
description: Check whether the values provided in arguments are equal. If either
of the arguments are missing, no is returned.
type: condition
iscommand: false
brand: ""
nexttasks:
"yes":
- "8"
separatecontext: false
conditions:
- label: "yes"
condition:
- - operator: isEqualString
left:
value:
complex:
root: Snowflake
accessor: Result.TS
transformers:
- operator: atIndex
args:
index:
value:
simple: "0"
iscontext: true
right:
value:
simple: 2019-03-26 11:14:18.574000
view: |-
{
"position": {
"x": 50,
"y": 545
}
}
note: false
timertriggers: []
ignoreworker: false
view: |-
{
"linkLabelsPosition": {},
"paper": {
"dimensions": {
"height": 735,
"width": 380,
"x": 50,
"y": 50
}
}
}
inputs: []
outputs: []