Google Cloudで「AthenaからS3に対してクエリ」みたいなことをやるにはどうやる？

# ローカル変数
locals {
  project_id = var.project_id
}

# Terraform プロバイダ設定
terraform {
  required_providers {
    google = {
      source  = "hashicorp/google"
      version = "~> 5.0"
    }
  }
  required_version = ">= 1.3.0"
}

provider "google" {
  project = var.project_id
  region  = var.region
}

# 変数定義
variable "project_id" {
  description = "Google Cloud Project ID"
  type        = string
}

variable "region" {
  description = "Google Cloud Region"
  type        = string
  default     = "us-central1"
}

variable "bucket_name" {
  description = "Name for the GCS bucket"
  type        = string
}

variable "dataset_id" {
  description = "ID for the BigQuery dataset"
  type        = string
}

# リソース定義
resource "google_storage_bucket" "main" {
  name          = var.bucket_name
  location      = var.region
  force_destroy = true
  storage_class = "STANDARD"
  uniform_bucket_level_access = true
}

resource "google_bigquery_dataset" "main" {
  dataset_id = var.dataset_id
  location   = var.region
}

# CSVファイルをローカルファイルから読み込んでGCSバケットにアップロード
resource "google_storage_bucket_object" "sample_data" {
  name         = "data/sample_sales.csv"
  bucket       = google_storage_bucket.main.name
  source       = "./sample_sales.csv"
  content_type = "text/csv"
}

# Google Cloud Project ID
project_id = "watanabe-koki"

# Google Cloud Region
region = "us-central1"

# GCS Bucket Name
bucket_name = "cm-watanabe-data-lake-bucket"

# BigQuery Dataset ID
dataset_id = "cm_watanabe_dataset" 

id,product_name,price,quantity,sale_date,customer_id
1,Apple iPhone 14,89800,2,2024-01-15,101
2,Samsung Galaxy S23,85000,1,2024-01-16,102
3,Google Pixel 8,72000,3,2024-01-17,103
4,Sony WH-1000XM5,45000,1,2024-01-18,101
5,AirPods Pro,35000,2,2024-01-19,104
6,MacBook Air M2,148000,1,2024-01-20,105
7,Dell XPS 13,135000,1,2024-01-21,102
8,iPad Pro,118000,2,2024-01-22,106
9,Surface Pro 9,165000,1,2024-01-23,103
10,Nintendo Switch,32000,3,2024-01-24,107
11,Lenovo ThinkPad X1,175000,1,2024-01-25,108
12,HP Spectre x360,155000,2,2024-01-26,109
13,Bose QuietComfort,42000,1,2024-01-27,110
14,Magic Mouse,9800,4,2024-01-28,105
15,Logitech MX Master,12000,2,2024-01-29,106 

# テーブル定義作成
bq mkdef --source_format=CSV --autodetect \
  gs://cm-watanabe-data-lake-bucket/data/sample_sales.csv > mytable_def

# 外部テーブル作成
bq mk --table --external_table_definition=mytable_def \
  watanabe-koki:cm_watanabe_dataset.sample_sales_external \