No description
No columns
SELECT "release", CAST(release_date AS "DATE") AS release_date, measure, adjustment, frequency, CAST("year" AS INTEGER) AS "year", CAST("quarter" AS INTEGER) AS "quarter", CASE WHEN ((frequency = 'quarter')) THEN (make_date(CAST("year" AS INTEGER), ((CAST("quarter" AS INTEGER) * 3) - 2), 1)) WHEN ((frequency = 'fiscal_year')) THEN (make_date(CAST("year" AS INTEGER), 4, 1)) WHEN ((frequency = 'calendar_year')) THEN (make_date(CAST("year" AS INTEGER), 1, 1)) ELSE NULL END AS period_start, item, CAST(item_level AS INTEGER) AS item_level, CAST("value" AS "DOUBLE") AS "value", unit, source_sha256, CAST(source_row AS INTEGER) AS source_row FROM {DUCKLAKE_CATALOG}.sna.raw_gdp_expenditure