説明はありません
列はありません
SELECT table_id, kind, "nullif"(series, '') AS series, CAST("year" AS INTEGER) AS "year", price, CAST("nullif"(real_base_year, '') AS INTEGER) AS real_base_year, price_basis, classification, CAST("nullif"(sector_count, '') AS INTEGER) AS sector_count, concat_ws(' ', CASE WHEN ((kind = 'national')) THEN (("year" || '年 産業連関表')) WHEN ((kind = 'extended')) THEN (((("year" || '年 延長産業連関表(') || series) || '年基準)')) ELSE (((series || '年 接続産業連関表 ') || "year") || '年') END, CASE WHEN ((price = 'real')) THEN ((('実質(' || real_base_year) || '年価格)')) ELSE NULL END, classification, CASE WHEN ((price_basis = 'producer')) THEN ('生産者価格評価') ELSE '購入者価格評価' END) AS title, "nullif"(source_unit, '') AS source_unit, source_url, source_sheet, source_sha256 FROM {DUCKLAKE_CATALOG}.japan.raw_tables