Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips
  • created: 2018-05-08 14:20:18
  • disabled: False
  • format: raw
  • id: 413
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_redshift",
    "table": "analytics_reference_dim_super_deluxe_zips"
}
  • type: redshift
Schema Versions: 15
    • created: 2026-04-17 03:18:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-17/1776413878'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-17/1776413878
    • id: 1717841
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 162167887
    • updated: 2026-04-17 03:18:24
    • created: 2026-04-16 04:10:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-16/1776330590'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-16/1776330590
    • id: 1716669
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 162113326
    • updated: 2026-04-16 04:10:15
    • created: 2026-04-15 04:02:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-15/1776243683'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-15/1776243683
    • id: 1715587
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 162057603
    • updated: 2026-04-15 04:02:37
    • created: 2026-04-14 03:58:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-14/1776157077'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-14/1776157077
    • id: 1714269
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 162001457
    • updated: 2026-04-14 03:58:59
    • created: 2026-04-13 03:54:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-13/1776070435'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-13/1776070435
    • id: 1713024
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161943081
    • updated: 2026-04-13 03:54:24
    • created: 2026-04-12 03:55:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-12/1775984109'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-12/1775984109
    • id: 1711840
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161893789
    • updated: 2026-04-12 03:55:45
    • created: 2026-04-11 04:01:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-11/1775898100'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-11/1775898100
    • id: 1710643
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161842624
    • updated: 2026-04-11 04:02:05
    • created: 2026-04-10 04:04:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-10/1775811882'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-10/1775811882
    • id: 1709477
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161787365
    • updated: 2026-04-10 04:05:05
    • created: 2026-04-09 03:46:45
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-09/1775724388'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-09/1775724388
    • id: 1708336
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161730699
    • updated: 2026-04-09 03:46:59
    • created: 2026-04-08 03:35:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-08/1775637343'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-08/1775637343
    • id: 1707111
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161675820
    • updated: 2026-04-08 03:36:04
    • created: 2026-04-07 03:32:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-07/1775550725'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-07/1775550725
    • id: 1705910
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161619675
    • updated: 2026-04-07 03:32:25
    • created: 2026-04-06 04:02:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-06/1775466131'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-06/1775466131
    • id: 1704737
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161562943
    • updated: 2026-04-06 04:02:39
    • created: 2026-04-05 04:00:51
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-05/1775379635'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-05/1775379635
    • id: 1703517
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161516194
    • updated: 2026-04-05 04:01:05
    • created: 2026-04-04 03:24:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-04/1775291066'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-04/1775291066
    • id: 1702311
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161460670
    • updated: 2026-04-04 03:24:49
    • created: 2026-04-03 03:33:51
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-03/1775205215'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-03/1775205215
    • id: 1701116
    • processed: 1
    • raw_data: 
      {
    "_origin": "52",
    "area_in_square_miles_land_area": "24",
    "area_in_square_miles_total_area": "22",
    "area_in_square_miles_water_area": "23",
    "city": "1",
    "county_fips": "11",
    "county_name": "6",
    "daylight_savings_time": "13",
    "gct_stub_display_label_geographic_area": "19",
    "gct_stub_display_label_geographic_area_2": "20",
    "geo_display_label_geography": "16",
    "geo_id": "14",
    "geo_id2": "15",
    "gmt": "12",
    "housing_unit_density_per_sqmile_land_area": "26",
    "housing_units": "21",
    "latitude": "8",
    "longitude": "9",
    "males_per_100_females_18_years_and_over": "51",
    "males_per_100_females_all_ages": "50",
    "median_age": "49",
    "mixed_city": "5",
    "mixed_county": "7",
    "occupied_housing_units": "27",
    "occupied_housing_units_average_household_size_owner": "39",
    "occupied_housing_units_average_household_size_renter": "40",
    "occupied_housing_units_avg_household_size_total": "38",
    "occupied_housing_units_owner": "36",
    "occupied_housing_units_percent_one_person_households": "42",
    "occupied_housing_units_percent_owner": "41",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "43",
    "occupied_housing_units_renter": "37",
    "occupied_housing_units_total": "35",
    "percent_of_total_population_18_to_24_years": "45",
    "percent_of_total_population_25_to_44_years": "46",
    "percent_of_total_population_45_to_64_years": "47",
    "percent_of_total_population_65_and_over": "48",
    "percent_of_total_population_under_18_years": "44",
    "pop_density_per_sqmile_land_area": "25",
    "population_in_occupied_housing_units": "34",
    "state_abbreviation": "3",
    "state_fips": "10",
    "state_name": "2",
    "target_geo_id": "17",
    "target_geo_id2": "18",
    "total_population": "4",
    "vacancy_rate_homeowner": "32",
    "vacancy_rate_rental": "33",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "31",
    "vacant_housing_units_percent_for_rent": "30",
    "vacant_housing_units_percent_for_sale_only": "29",
    "vacant_housing_units_total": "28",
    "zip_key": "0"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
    • schema_name_id: 413
    • schema_scan_id: 161402141
    • updated: 2026-04-03 03:34:05
Schema Scans: 15
Last at 2026-04-17 03:18:08
    • duration: 0:00:15.612865
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162167887
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-17/1776413878/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-17/1776413878",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-17/1776413878/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8921497161346814166,
        "service_name": "redshift_unloads",
        "span_id": 6737147178451250642,
        "trace_id": 7602835298317301589
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-17 03:18:08
    • success: True
    • trace_id: 7602835298317301589
    • duration: 0:00:13.165110
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162113326
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-16/1776330590/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-16/1776330590",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-16/1776330590/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13803230217315647104,
        "service_name": "redshift_unloads",
        "span_id": 2811889169227401689,
        "trace_id": 14864526576644755194
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-16 04:10:02
    • success: True
    • trace_id: 14864526576644755194
    • duration: 0:00:12.771574
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162057603
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-15/1776243683/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-15/1776243683",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-15/1776243683/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4573388953352110236,
        "service_name": "redshift_unloads",
        "span_id": 2460947072955476328,
        "trace_id": 4548422843983326377
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-15 04:02:24
    • success: True
    • trace_id: 4548422843983326377
    • duration: 0:00:15.543327
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162001457
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-14/1776157077/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-14/1776157077",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-14/1776157077/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 237746851829340936,
        "service_name": "redshift_unloads",
        "span_id": 1617669902591606374,
        "trace_id": 3289762058726707805
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-14 03:58:44
    • success: True
    • trace_id: 3289762058726707805
    • duration: 0:00:15.543863
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161943081
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-13/1776070435/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-13/1776070435",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-13/1776070435/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16189835650990119409,
        "service_name": "redshift_unloads",
        "span_id": 9172676413038934835,
        "trace_id": 3364605082218854069
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-13 03:54:08
    • success: True
    • trace_id: 3364605082218854069
    • duration: 0:00:15.526010
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161893789
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-12/1775984109/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-12/1775984109",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-12/1775984109/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18104395466644012839,
        "service_name": "redshift_unloads",
        "span_id": 11534719407981477479,
        "trace_id": 6854007381591933448
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-12 03:55:30
    • success: True
    • trace_id: 6854007381591933448
    • duration: 0:00:12.921377
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161842624
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-11/1775898100/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-11/1775898100",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-11/1775898100/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5811320514216014663,
        "service_name": "redshift_unloads",
        "span_id": 12983526068980366835,
        "trace_id": 17560068322077627363
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-11 04:01:52
    • success: True
    • trace_id: 17560068322077627363
    • duration: 0:00:13.067245
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161787365
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-10/1775811882/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-10/1775811882",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-10/1775811882/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13242689899066216099,
        "service_name": "redshift_unloads",
        "span_id": 13968149184923679241,
        "trace_id": 12958166462707049452
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-10 04:04:52
    • success: True
    • trace_id: 12958166462707049452
    • duration: 0:00:15.502510
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161730699
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-09/1775724388/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-09/1775724388",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-09/1775724388/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1890359147223301496,
        "service_name": "redshift_unloads",
        "span_id": 14240690838242051191,
        "trace_id": 8652971301973214348
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-09 03:46:43
    • success: True
    • trace_id: 8652971301973214348
    • duration: 0:00:13.079419
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161675820
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-08/1775637343/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-08/1775637343",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-08/1775637343/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13983209912868193515,
        "service_name": "redshift_unloads",
        "span_id": 1077050456142211214,
        "trace_id": 6620472569955948334
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-08 03:35:51
    • success: True
    • trace_id: 6620472569955948334
    • duration: 0:00:12.843168
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161619675
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-07/1775550725/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-07/1775550725",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-07/1775550725/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8695129054974146694,
        "service_name": "redshift_unloads",
        "span_id": 7983182996566369411,
        "trace_id": 3923122256980442830
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-07 03:32:13
    • success: True
    • trace_id: 3923122256980442830
    • duration: 0:00:12.909265
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161562943
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-06/1775466131/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-06/1775466131",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-06/1775466131/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18391339174205511373,
        "service_name": "redshift_unloads",
        "span_id": 10969913484369467603,
        "trace_id": 8150796283861716213
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-06 04:02:26
    • success: True
    • trace_id: 8150796283861716213
    • duration: 0:00:15.548547
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161516194
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-05/1775379635/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-05/1775379635",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-05/1775379635/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9270740087448107550,
        "service_name": "redshift_unloads",
        "span_id": 12033353294908819546,
        "trace_id": 6477502096011587561
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-05 04:00:50
    • success: True
    • trace_id: 6477502096011587561
    • duration: 0:00:15.562843
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161460670
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-04/1775291066/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-04/1775291066",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-04/1775291066/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2715750935593655606,
        "service_name": "redshift_unloads",
        "span_id": 2678701250592553185,
        "trace_id": 2438854667822728470
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-04 03:24:34
    • success: True
    • trace_id: 2438854667822728470
    • duration: 0:00:15.375874
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161402141
    • payload: 
      {
    "datatype_dict": {
        "area_in_square_miles_land_area": "decimal(18,0)",
        "area_in_square_miles_total_area": "decimal(18,0)",
        "area_in_square_miles_water_area": "decimal(18,0)",
        "city": "varchar(50)",
        "county_fips": "int",
        "county_name": "varchar(25)",
        "daylight_savings_time": "varchar(20)",
        "gct_stub_display_label_geographic_area": "varchar(256)",
        "gct_stub_display_label_geographic_area_2": "varchar(256)",
        "geo_display_label_geography": "varchar(256)",
        "geo_id": "varchar(256)",
        "geo_id2": "int",
        "gmt": "int",
        "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
        "housing_units": "int",
        "latitude": "double",
        "longitude": "double",
        "males_per_100_females_18_years_and_over": "decimal(18,0)",
        "males_per_100_females_all_ages": "decimal(18,0)",
        "median_age": "decimal(18,0)",
        "mixed_city": "varchar(200)",
        "mixed_county": "varchar(25)",
        "occupied_housing_units": "int",
        "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
        "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
        "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
        "occupied_housing_units_owner": "int",
        "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
        "occupied_housing_units_percent_owner": "decimal(18,0)",
        "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
        "occupied_housing_units_renter": "int",
        "occupied_housing_units_total": "int",
        "origin_key": "varchar",
        "percent_of_total_population_18_to_24_years": "decimal(18,0)",
        "percent_of_total_population_25_to_44_years": "decimal(18,0)",
        "percent_of_total_population_45_to_64_years": "decimal(18,0)",
        "percent_of_total_population_65_and_over": "decimal(18,0)",
        "percent_of_total_population_under_18_years": "decimal(18,0)",
        "pop_density_per_sqmile_land_area": "decimal(18,0)",
        "population_in_occupied_housing_units": "int",
        "state_abbreviation": "varchar(2)",
        "state_fips": "int",
        "state_name": "varchar(50)",
        "target_geo_id": "varchar(256)",
        "target_geo_id2": "int",
        "total_population": "int",
        "vacancy_rate_homeowner": "decimal(18,0)",
        "vacancy_rate_rental": "decimal(18,0)",
        "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
        "vacant_housing_units_percent_for_rent": "decimal(18,0)",
        "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
        "vacant_housing_units_total": "int",
        "zip_key": "varchar(5)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-03/1775205215/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-03/1775205215",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-03/1775205215/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17764891741615985943,
        "service_name": "redshift_unloads",
        "span_id": 9828170106468700179,
        "trace_id": 8784718116870730773
    }
}
    • running: False
    • schema_name_id: 413
    • start_time: 2026-04-03 03:33:50
    • success: True
    • trace_id: 8784718116870730773
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "_origin": "string",
    "area_in_square_miles_land_area": "decimal(18,0)",
    "area_in_square_miles_total_area": "decimal(18,0)",
    "area_in_square_miles_water_area": "decimal(18,0)",
    "city": "varchar(50)",
    "county_fips": "int",
    "county_name": "varchar(25)",
    "daylight_savings_time": "varchar(20)",
    "gct_stub_display_label_geographic_area": "varchar(256)",
    "gct_stub_display_label_geographic_area_2": "varchar(256)",
    "geo_display_label_geography": "varchar(256)",
    "geo_id": "varchar(256)",
    "geo_id2": "int",
    "gmt": "int",
    "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
    "housing_units": "int",
    "latitude": "double",
    "longitude": "double",
    "males_per_100_females_18_years_and_over": "decimal(18,0)",
    "males_per_100_females_all_ages": "decimal(18,0)",
    "median_age": "decimal(18,0)",
    "mixed_city": "varchar(200)",
    "mixed_county": "varchar(25)",
    "occupied_housing_units": "int",
    "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
    "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
    "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
    "occupied_housing_units_owner": "int",
    "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
    "occupied_housing_units_percent_owner": "decimal(18,0)",
    "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
    "occupied_housing_units_renter": "int",
    "occupied_housing_units_total": "int",
    "percent_of_total_population_18_to_24_years": "decimal(18,0)",
    "percent_of_total_population_25_to_44_years": "decimal(18,0)",
    "percent_of_total_population_45_to_64_years": "decimal(18,0)",
    "percent_of_total_population_65_and_over": "decimal(18,0)",
    "percent_of_total_population_under_18_years": "decimal(18,0)",
    "pop_density_per_sqmile_land_area": "decimal(18,0)",
    "population_in_occupied_housing_units": "int",
    "state_abbreviation": "varchar(2)",
    "state_fips": "int",
    "state_name": "varchar(50)",
    "target_geo_id": "varchar(256)",
    "target_geo_id2": "int",
    "total_population": "int",
    "vacancy_rate_homeowner": "decimal(18,0)",
    "vacancy_rate_rental": "decimal(18,0)",
    "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
    "vacant_housing_units_percent_for_rent": "decimal(18,0)",
    "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
    "vacant_housing_units_total": "int",
    "zip_key": "varchar(5)"
}
  • created: 2026-04-17 03:18:10
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-17/1776413878'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2018-05-08 14:20:18",
        "disabled": false,
        "format": "raw",
        "id": 413,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_dim_super_deluxe_zips"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "area_in_square_miles_land_area": "decimal(18,0)",
            "area_in_square_miles_total_area": "decimal(18,0)",
            "area_in_square_miles_water_area": "decimal(18,0)",
            "city": "varchar(50)",
            "county_fips": "int",
            "county_name": "varchar(25)",
            "daylight_savings_time": "varchar(20)",
            "gct_stub_display_label_geographic_area": "varchar(256)",
            "gct_stub_display_label_geographic_area_2": "varchar(256)",
            "geo_display_label_geography": "varchar(256)",
            "geo_id": "varchar(256)",
            "geo_id2": "int",
            "gmt": "int",
            "housing_unit_density_per_sqmile_land_area": "decimal(18,0)",
            "housing_units": "int",
            "latitude": "double",
            "longitude": "double",
            "males_per_100_females_18_years_and_over": "decimal(18,0)",
            "males_per_100_females_all_ages": "decimal(18,0)",
            "median_age": "decimal(18,0)",
            "mixed_city": "varchar(200)",
            "mixed_county": "varchar(25)",
            "occupied_housing_units": "int",
            "occupied_housing_units_average_household_size_owner": "decimal(18,0)",
            "occupied_housing_units_average_household_size_renter": "decimal(18,0)",
            "occupied_housing_units_avg_household_size_total": "decimal(18,0)",
            "occupied_housing_units_owner": "int",
            "occupied_housing_units_percent_one_person_households": "decimal(18,0)",
            "occupied_housing_units_percent_owner": "decimal(18,0)",
            "occupied_housing_units_percent_w_householder_65_years_and_over": "decimal(18,0)",
            "occupied_housing_units_renter": "int",
            "occupied_housing_units_total": "int",
            "percent_of_total_population_18_to_24_years": "decimal(18,0)",
            "percent_of_total_population_25_to_44_years": "decimal(18,0)",
            "percent_of_total_population_45_to_64_years": "decimal(18,0)",
            "percent_of_total_population_65_and_over": "decimal(18,0)",
            "percent_of_total_population_under_18_years": "decimal(18,0)",
            "pop_density_per_sqmile_land_area": "decimal(18,0)",
            "population_in_occupied_housing_units": "int",
            "state_abbreviation": "varchar(2)",
            "state_fips": "int",
            "state_name": "varchar(50)",
            "target_geo_id": "varchar(256)",
            "target_geo_id2": "int",
            "total_population": "int",
            "vacancy_rate_homeowner": "decimal(18,0)",
            "vacancy_rate_rental": "decimal(18,0)",
            "vacant_h_units_percent_seasonal_recreational_occassional_use": "decimal(18,0)",
            "vacant_housing_units_percent_for_rent": "decimal(18,0)",
            "vacant_housing_units_percent_for_sale_only": "decimal(18,0)",
            "vacant_housing_units_total": "int",
            "zip_key": "varchar(5)"
        },
        "created": "2026-04-17 03:18:10",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`\n(\n `zip_key`  varchar(5) , `city`  varchar(50) , `state_name`  varchar(50) , `state_abbreviation`  varchar(2) , `total_population`  int , `mixed_city`  varchar(200) , `county_name`  varchar(25) , `mixed_county`  varchar(25) , `latitude`  double , `longitude`  double , `state_fips`  int , `county_fips`  int , `gmt`  int , `daylight_savings_time`  varchar(20) , `geo_id`  varchar(256) , `geo_id2`  int , `geo_display_label_geography`  varchar(256) , `target_geo_id`  varchar(256) , `target_geo_id2`  int , `gct_stub_display_label_geographic_area`  varchar(256) , `gct_stub_display_label_geographic_area_2`  varchar(256) , `housing_units`  int , `area_in_square_miles_total_area`  decimal(18,0) , `area_in_square_miles_water_area`  decimal(18,0) , `area_in_square_miles_land_area`  decimal(18,0) , `pop_density_per_sqmile_land_area`  decimal(18,0) , `housing_unit_density_per_sqmile_land_area`  decimal(18,0) , `occupied_housing_units`  int , `vacant_housing_units_total`  int , `vacant_housing_units_percent_for_sale_only`  decimal(18,0) , `vacant_housing_units_percent_for_rent`  decimal(18,0) , `vacant_h_units_percent_seasonal_recreational_occassional_use`  decimal(18,0) , `vacancy_rate_homeowner`  decimal(18,0) , `vacancy_rate_rental`  decimal(18,0) , `population_in_occupied_housing_units`  int , `occupied_housing_units_total`  int , `occupied_housing_units_owner`  int , `occupied_housing_units_renter`  int , `occupied_housing_units_avg_household_size_total`  decimal(18,0) , `occupied_housing_units_average_household_size_owner`  decimal(18,0) , `occupied_housing_units_average_household_size_renter`  decimal(18,0) , `occupied_housing_units_percent_owner`  decimal(18,0) , `occupied_housing_units_percent_one_person_households`  decimal(18,0) , `occupied_housing_units_percent_w_householder_65_years_and_over`  decimal(18,0) , `percent_of_total_population_under_18_years`  decimal(18,0) , `percent_of_total_population_18_to_24_years`  decimal(18,0) , `percent_of_total_population_25_to_44_years`  decimal(18,0) , `percent_of_total_population_45_to_64_years`  decimal(18,0) , `percent_of_total_population_65_and_over`  decimal(18,0) , `median_age`  decimal(18,0) , `males_per_100_females_all_ages`  decimal(18,0) , `males_per_100_females_18_years_and_over`  decimal(18,0) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/reference_dim_super_deluxe_zips/2026-04-17/1776413878'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_super_deluxe_zips"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform