```json { "action": "final", "content": "# Complete Dataset Column Reference\n\nThis dataset contains **13 tables** with **16,874,623 total rows**. Below is a comprehensive breakdown of all columns across every table.\n\n## 1. raw.beer_ratings (14,344,128 rows)\nUser reviews and ratings of beers:\n- **rating_id** (BIGINT) - Unique rating identifier\n- **user_id** (BIGINT) - User who created the rating\n- **beer_id** (BIGINT) - Beer being rated\n- **aroma** (BIGINT) - Aroma score (0-10)\n- **flavor** (BIGINT) - Flavor score (0-10)\n- **mouthfeel** (BIGINT) - Mouthfeel score (0-5)\n- **appearance** (BIGINT) - Appearance score (0-5)\n- **overall** (BIGINT) - Overall score (0-20)\n- **total_score** (DOUBLE) - Computed rating (0.1-5.0)\n- **comments** (VARCHAR) - Review text\n- **created_at** (TIMESTAMP) - Rating creation time\n- **updated_at** (TIMESTAMP) - Last modification time\n- **description_score** (DOUBLE) - Review quality score\n- **language** (VARCHAR) - Review language\n- **availability_id** (BIGINT) - Availability reference\n- **_ingested_at** (TIMESTAMP) - Data ingestion timestamp\n- **_row_id** (BIGINT) - Internal row identifier\n- **_source_file** (VARCHAR) - Source file name\n- **_source_row** (BIGINT) - Source row number\n\n## 2. raw.beers (1,191,662 rows)\nBeer catalog with detailed attributes:\n- **beer_id** (BIGINT) - Unique beer identifier\n- **name** (VARCHAR) - Beer name\n- **brewer_id** (BIGINT) - Brewer/brewery reference\n- **style_id** (BIGINT) - Beer style reference\n- **abv** (DOUBLE) - Alcohol by volume percentage\n- **ibu** (DOUBLE) - International Bitterness Units\n- **calories** (BIGINT) - Calorie content\n- **description** (VARCHAR) - Beer description\n- **created_at** (TIMESTAMP) - Record creation time\n- **updated_at** (TIMESTAMP) - Last update time\n- **created_by** (DOUBLE) - User who created record\n- **updated_by** (DOUBLE) - User who last updated\n- **is_retired** (BOOLEAN) - Whether beer is retired\n- **is_alias** (BOOLEAN) - Whether this is an alias entry\n- **is_verified** (BOOLEAN) - Verification status\n- **Unrateable** (BOOLEAN) - Whether beer can be rated\n- **has_pic** (BOOLEAN) - Whether beer has a picture\n- **is_one_off** (BOOLEAN) - Whether this is a one-off brew\n- **rating_count** (BIGINT) - Number of ratings\n- **rating_score** (DOUBLE) - Average rating score\n- **weighted_avg** (DOUBLE) - Weighted average rating\n- **overall_score** (BIGINT) - Overall percentile score\n- **style_score** (BIGINT) - Style percentile score\n- **num_ratings** (BIGINT) - Rating count (duplicate)\n- **mean** (DOUBLE) - Mean rating\n- **weighted_mean** (DOUBLE) - Weighted mean rating\n- **num_reviews** (BIGINT) - Review count\n- **availability_id** (BIGINT) - Availability reference\n- **_ingested_at** (TIMESTAMP) - Ingestion timestamp\n- **_row_id** (BIGINT) - Internal row ID\n- **_source_file** (VARCHAR) - Source file\n- **_source_row** (BIGINT) - Source row number\n- Plus 8 additional metadata columns\n\n## 3. raw.place_ratings (385,707 rows)\nUser ratings of places (bars, restaurants, etc.):\n- **rating_id** (BIGINT) - Unique rating identifier\n- **user_id** (BIGINT) - User who rated\n- **place_id** (BIGINT) - Place being rated\n- **atmosphere** (BIGINT) - Atmosphere score\n- **service** (BIGINT) - Service score\n- **selection** (BIGINT) - Selection score\n- **food** (BIGINT) - Food score\n- **value** (BIGINT) - Value score\n- **total_score** (DOUBLE) - Computed total score\n- **comments** (VARCHAR) - Review text\n- **created_at** (TIMESTAMP) - Creation time\n- **updated_at** (TIMESTAMP) - Update time\n- **_ingested_at** (TIMESTAMP) - Ingestion timestamp\n- **_row_id** (BIGINT) - Internal row ID\n- **_source_file** (VARCHAR) - Source file\n- **_source_row** (BIGINT) - Source row\n- **_source_table** (VARCHAR) - Source table\n\n## 4. raw.beer_upcs (249,348 rows)\nUPC/barcode information for beers:\n- **beer_id** (BIGINT) - Beer reference\n- **upc** (VARCHAR) - UPC/barcode\n- **_ingested_at** (TIMESTAMP) - Ingestion time\n- **_row_id** (BIGINT) - Internal row ID\n- **_source_file** (VARCHAR) - Source file\n- **_source_row** (BIGINT) - Source row\n- **_source_table** (VARCHAR) - Source table\n\n## 5. raw.users (236,969 rows)\nUser profiles and activity:\n- **user_id** (BIGINT) - Unique user identifier\n- **username** (VARCHAR) - Username\n- **location** (VARCHAR) - User location\n- **created_at** (TIMESTAMP) - Account creation\n- **updated_at** (TIMESTAMP) - Last update\n- **beer_ratings_count** (BIGINT) - Number of beer ratings\n- **place_ratings_count** (BIGINT) - Number of place ratings\n- **beer_first_rating** (TIMESTAMP) - First beer rating time\n- **beer_last_rating** (TIMESTAMP) - Most recent beer rating\n- **place_first_rating** (TIMESTAMP) - First place rating\n- **place_last_rating** (TIMESTAMP) - Most recent place rating\n- **is_private** (BOOLEAN) - Privacy setting\n- **is_premium** (BOOLEAN) - Premium membership status\n- **_ingested_at** (TIMESTAMP) - Ingestion time\n- **_row_id** (BIGINT) - Internal row ID\n- **_source_file** (VARCHAR) - Source file\n- **_source_row** (BIGINT) - Source row\n- Plus 5 additional metadata columns\n\n## 6. raw.favorites (212,273 rows)\nUser favorite beers:\n- **user_id** (BIGINT) - User reference\n- **beer_id** (BIGINT) - Favorited beer\n- **created_at** (TIMESTAMP) - When favorited\n- **_ingested_at** (TIMESTAMP) - Ingestion time\n- **_row_id** (BIGINT) - Internal row ID\n- **_source_file** (VARCHAR) - Source file\n- **_source_row** (BIGINT) - Source row\n- **_source_table** (VARCHAR) - Source table\n- **_source_url** (VARCHAR) - Source URL\n\n## 7. raw.availability (117,424 rows)\nBeer availability information:\n- **availability_id** (BIGINT) - Unique identifier\n- **beer_id** (BIGINT) - Beer reference\n- **container_type** (VARCHAR) - Container type (bottle, can, etc.)\n- **container_size** (VARCHAR) - Size information\n- **postal_code** (