-- Iceberg  database: auth_type='gcp_oauth'
CREATE DATABASE demo
SETTINGS
    type = 'iceberg',
    catalog_uri = 'https://biglake.googleapis.com/iceberg/v1/restcatalog',
    catalog_type = 'rest',
    project_id = '<PROJECT_ID>',
    warehouse = 'gs://zifeng-temp',
    storage_endpoint = 'gs://zifeng-temp/demo',
    auth_type='gcp_oauth';

-- S3 external table: http_client='gcp_oauth'
CREATE EXTERNAL TABLE IF NOT EXISTS s3_out_csv
(
  id uint64,
  key string,
  payload string,
  ts datetime
)
SETTINGS
  type = 's3',
  endpoint = 'gs://zifeng-temp',
  bucket = 'zifeng-temp',
  write_to = 'example/s3_csv.csv',
  http_client='gcp_oauth',
  data_format = 'CSV';