/
GoogleBigQuery.yml
116 lines (116 loc) · 4.38 KB
/
GoogleBigQuery.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
commonfields:
id: Google BigQuery
version: -1
name: Google BigQuery
display: Google BigQuery
category: Database
description: Integration for Google BigQuery, a data warehouse for querying and analyzing large databases. In all commands, for any argument not specified, the BigQuery default value for that argument will be applied.
configuration:
- display: Google service account JSON (a credentials JSON generated from Google API Manager or from GCP console)
name: google_service_creds
defaultvalue: ""
type: 4
required: false
hidden: true
- displaypassword: Google service account JSON (a credentials JSON generated from Google API Manager or from GCP console)
name: credentials_google_service
required: false
hiddenusername: true
type: 9
- display: First fetch timestamp (<number> <time unit>. For example, 12 hours, 7 days)
name: first_fetch
defaultvalue: '1 days'
type: 0
required: false
- display: Incident type
name: incidentType
required: false
type: 13
- defaultvalue: '50'
display: Fetch Limit (Max.- 200, Recommended less than 50)
name: max_fetch
required: false
type: 0
- display: Fetch incidents
name: isFetch
required: false
type: 8
- display: Fetch query
name: fetch_query
required: false
type: 0
- display: Fetch time field
additionalinfo: Will be used for determining the time-specifying field of each row. Default is CreationTime.
name: fetch_time_field
required: false
defaultvalue: 'CreationTime'
type: 0
script:
script: ''
type: python
commands:
- name: bigquery-query
arguments:
- name: query
required: true
description: A query string (in BigQuery query syntax). For more information about the standard syntax, see the BigQuery documentation - https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax.
- name: location
description: The geographic location where the job should run. Required for locations other than US and EU.
- name: allow_large_results
auto: PREDEFINED
predefined:
- "True"
- "False"
description: Allow query results tables larger than 128 MB compressed (legacy SQL only)
- name: default_dataset
description: A string of the fully-qualified dataset ID in standard SQL format. The value must include a project ID and dataset ID, separated by periods.
- name: destination_table
description: The table to which the results are written. Default value is "None".
- name: kms_key_name
description: Custom encryption configuration for the destination table.
- name: dry_run
auto: PREDEFINED
predefined:
- "True"
- "False"
description: If "true," BigQuery doesn't run the job. Instead, if the query is valid, BigQuery returns statistics about the job, such as how many bytes would be processed. If the query is invalid, an error is returned. The default value is "false".
- name: priority
auto: PREDEFINED
predefined:
- BATCH
- INTERACTIVE
description: Priority of the query (“INTERACTIVE” or “BATCH”). A query set as INTERACTIVE will be run on-demand, at the next possible time. A query set as BATCH will start as soon as idle resources are available, and changed to INTERACTIVE priority if it wasn’t started within 24 hours. The default value is “INTERACTIVE”.
- name: use_query_cache
auto: PREDEFINED
predefined:
- "True"
- "False"
description: Whether to look for the query results in the cache.
- name: use_legacy_sql
auto: PREDEFINED
predefined:
- "True"
- "False"
description: Whether to use legacy SQL syntax.
- name: job_id
description: The ID of the job. The ID must contain only letters (a-z, A-Z), numbers (0-9), underscores (_), or dashes (-). The maximum length is 1,024 characters.
- name: write_disposition
auto: PREDEFINED
predefined:
- WRITE_EMPTY
- WRITE_TRUNCATE
- WRITE_APPEND
description: Specifies the action that occurs if the destination table already exists.
outputs:
- contextPath: BigQuery.Query
description: The query performed.
type: String
- contextPath: BigQuery.Row
description: The table rows the given query returned.
type: Unknown
description: Performs a query on BigQuery.
dockerimage: demisto/bigquery:1.0.0.61798
subtype: python3
isfetch: true
runonce: false
fromversion: 5.0.0