GCP

# GCP 프로젝트 설정
gcloud config set project my-project-id

# Compute Engine 인스턴스 생성
gcloud compute instances create my-instance \
  --zone=asia-northeast3-a \
  --machine-type=e2-medium \
  --image-family=debian-11 \
  --image-project=debian-cloud \
  --boot-disk-size=20GB

# GKE 클러스터 생성
gcloud container clusters create my-cluster \
  --zone=asia-northeast3-a \
  --num-nodes=3 \
  --machine-type=e2-standard-4 \
  --enable-autoscaling \
  --min-nodes=1 \
  --max-nodes=5

# BigQuery에서 쿼리 실행
bq query --use_legacy_sql=false \
  'SELECT name, COUNT(*) as count
   FROM `bigquery-public-data.usa_names.usa_1910_current`
   GROUP BY name ORDER BY count DESC LIMIT 10'

# GCP 프로바이더 설정
provider "google" {
  project = "my-project-id"
  region  = "asia-northeast3"
}

# Compute Engine 인스턴스
resource "google_compute_instance" "web_server" {
  name         = "web-server"
  machine_type = "e2-medium"
  zone         = "asia-northeast3-a"

  boot_disk {
    initialize_params {
      image = "debian-cloud/debian-11"
      size  = 20
    }
  }

  network_interface {
    network = "default"
    access_config {}  # 외부 IP 할당
  }

  metadata_startup_script = "apt-get update && apt-get install -y nginx"

  tags = ["http-server", "https-server"]
}

# Cloud Storage 버킷
resource "google_storage_bucket" "data_bucket" {
  name     = "my-data-bucket-unique-id"
  location = "ASIA-NORTHEAST3"

  uniform_bucket_level_access = true

  lifecycle_rule {
    condition {
      age = 30
    }
    action {
      type = "Delete"
    }
  }
}

# Google Cloud Storage 사용 예제
from google.cloud import storage
from google.cloud import bigquery

# Cloud Storage에 파일 업로드
def upload_to_gcs(bucket_name, source_file, destination_blob):
    client = storage.Client()
    bucket = client.bucket(bucket_name)
    blob = bucket.blob(destination_blob)

    blob.upload_from_filename(source_file)
    print(f"Uploaded {source_file} to gs://{bucket_name}/{destination_blob}")

# BigQuery에서 쿼리 실행
def query_bigquery(query):
    client = bigquery.Client()
    query_job = client.query(query)

    results = query_job.result()
    for row in results:
        print(dict(row))

# 사용 예시
upload_to_gcs("my-bucket", "data.csv", "uploads/data.csv")

query = """
SELECT
    DATE(created_at) as date,
    COUNT(*) as event_count
FROM `my-project.my_dataset.events`
WHERE created_at >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7 DAY)
GROUP BY date
ORDER BY date DESC
"""
query_bigquery(query)