...

Text file src/github.com/GoogleCloudPlatform/k8s-config-connector/scripts/resource-autogen/generated/samples/BigQuery-BigQueryJob-bigquery_job_query/main.tf

Documentation: github.com/GoogleCloudPlatform/k8s-config-connector/scripts/resource-autogen/generated/samples/BigQuery-BigQueryJob-bigquery_job_query

     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