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_load_table"
22}
23
24resource "google_bigquery_dataset" "bar" {
25 dataset_id = "job_load_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_load"
33
34 labels = {
35 "my_job" ="load"
36 }
37
38 load {
39 source_uris = [
40 "gs://cloud-samples-data/bigquery/us-states/us-states-by-date.csv",
41 ]
42
43 destination_table {
44 project_id = google_bigquery_table.foo.project
45 dataset_id = google_bigquery_table.foo.dataset_id
46 table_id = google_bigquery_table.foo.table_id
47 }
48
49 skip_leading_rows = 1
50 schema_update_options = ["ALLOW_FIELD_RELAXATION", "ALLOW_FIELD_ADDITION"]
51
52 write_disposition = "WRITE_APPEND"
53 autodetect = true
54 }
55}
56```
View as plain text