...
1/**
2 * Copyright 2022 Google LLC
3 *
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.apache.org/licenses/LICENSE-2.0
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */
16
17```hcl
18resource "google_bigquery_table" "foo" {
19 deletion_protection = false
20 dataset_id = google_bigquery_dataset.bar.dataset_id
21 table_id = "job_query_table"
22}
23
24resource "google_bigquery_dataset" "bar" {
25 dataset_id = "job_query_dataset"
26 friendly_name = "test"
27 description = "This is a test description"
28 location = "US"
29}
30
31resource "google_bigquery_job" "job" {
32 job_id = "job_query"
33
34 labels = {
35 "example-label" ="example-value"
36 }
37
38 query {
39 query = "SELECT state FROM [lookerdata:cdc.project_tycho_reports]"
40
41 destination_table {
42 project_id = google_bigquery_table.foo.project
43 dataset_id = google_bigquery_table.foo.dataset_id
44 table_id = google_bigquery_table.foo.table_id
45 }
46
47 allow_large_results = true
48 flatten_results = true
49
50 script_options {
51 key_result_statement = "LAST"
52 }
53 }
54}
55```
View as plain text