Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips
  • created: 2018-05-09 10:53:45
  • disabled: False
  • format: raw
  • id: 523
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_redshift",
    "table": "analytics_reference_dim_super_deluxe_zips"
}
  • type: redshift
Schema Versions: 15
    • created: 2026-04-17 03:45:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-17/1776415480'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-17/1776415480
    • id: 906639
    • 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: 523
    • schema_scan_id: 6415219
    • updated: 2026-04-17 03:45:22
    • created: 2026-04-16 04:00:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-16/1776330015'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-16/1776330015
    • id: 906421
    • 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: 523
    • schema_scan_id: 6414671
    • updated: 2026-04-16 04:00:53
    • created: 2026-04-15 03:38:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-15/1776242287'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-15/1776242287
    • id: 906178
    • 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: 523
    • schema_scan_id: 6414153
    • updated: 2026-04-15 03:38:42
    • created: 2026-04-14 03:53:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-14/1776156783'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-14/1776156783
    • id: 905990
    • 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: 523
    • schema_scan_id: 6413676
    • updated: 2026-04-14 03:53:38
    • created: 2026-04-13 03:21:48
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-13/1776068491'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-13/1776068491
    • id: 905746
    • 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: 523
    • schema_scan_id: 6413100
    • updated: 2026-04-13 03:22:01
    • created: 2026-04-12 03:38:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-12/1775983077'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-12/1775983077
    • id: 905561
    • 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: 523
    • schema_scan_id: 6412724
    • updated: 2026-04-12 03:38:18
    • created: 2026-04-11 03:20:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-11/1775895637'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-11/1775895637
    • id: 905344
    • 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: 523
    • schema_scan_id: 6412328
    • updated: 2026-04-11 03:21:13
    • created: 2026-04-10 04:00:01
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-10/1775811586'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-10/1775811586
    • id: 905176
    • 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: 523
    • schema_scan_id: 6411881
    • updated: 2026-04-10 04:00:12
    • created: 2026-04-09 04:01:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-09/1775725279'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-09/1775725279
    • id: 904963
    • 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: 523
    • schema_scan_id: 6411366
    • updated: 2026-04-09 04:01:44
    • created: 2026-04-08 03:31:29
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-08/1775637065'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-08/1775637065
    • id: 904703
    • 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: 523
    • schema_scan_id: 6410824
    • updated: 2026-04-08 03:31:41
    • created: 2026-04-07 03:33:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-07/1775550773'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-07/1775550773
    • id: 904488
    • 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: 523
    • schema_scan_id: 6410311
    • updated: 2026-04-07 03:33:15
    • created: 2026-04-06 03:44:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-06/1775465020'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-06/1775465020
    • id: 904278
    • 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: 523
    • schema_scan_id: 6409772
    • updated: 2026-04-06 03:44:46
    • created: 2026-04-05 03:25:57
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-05/1775377536'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-05/1775377536
    • id: 904075
    • 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: 523
    • schema_scan_id: 6409382
    • updated: 2026-04-05 03:26:11
    • created: 2026-04-04 03:23:06
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-04/1775290944'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-04/1775290944
    • id: 903875
    • 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: 523
    • schema_scan_id: 6409003
    • updated: 2026-04-04 03:23:19
    • created: 2026-04-03 03:43:51
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-03/1775205812'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-03/1775205812
    • id: 903661
    • 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: 523
    • schema_scan_id: 6408514
    • updated: 2026-04-03 03:44:05
Schema Scans: 15
Last at 2026-04-17 03:45:09
    • duration: 0:00:13.075102
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6415219
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-17/1776415480/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-17/1776415480",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-17/1776415480/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3937095882533788634,
        "service_name": "redshift_unloads",
        "span_id": 5636811781137618125,
        "trace_id": 15688664675358986737
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-17 03:45:09
    • success: True
    • trace_id: 15688664675358986737
    • duration: 0:00:15.451049
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414671
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-16/1776330015/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-16/1776330015",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-16/1776330015/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1297888537965854027,
        "service_name": "redshift_unloads",
        "span_id": 13615611406749189597,
        "trace_id": 17638232571696845688
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-16 04:00:38
    • success: True
    • trace_id: 17638232571696845688
    • duration: 0:00:15.605165
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414153
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-15/1776242287/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-15/1776242287",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-15/1776242287/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11960041259465982272,
        "service_name": "redshift_unloads",
        "span_id": 6895703811487143229,
        "trace_id": 16479079490172591570
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-15 03:38:27
    • success: True
    • trace_id: 16479079490172591570
    • duration: 0:00:13.109284
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413676
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-14/1776156783/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-14/1776156783",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-14/1776156783/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15795841697830002083,
        "service_name": "redshift_unloads",
        "span_id": 5125792632037733454,
        "trace_id": 7555798335485715589
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-14 03:53:25
    • success: True
    • trace_id: 7555798335485715589
    • duration: 0:00:15.582333
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413100
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-13/1776068491/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-13/1776068491",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-13/1776068491/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11596662330603060189,
        "service_name": "redshift_unloads",
        "span_id": 8983497253122322121,
        "trace_id": 2720663880319553159
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-13 03:21:46
    • success: True
    • trace_id: 2720663880319553159
    • duration: 0:00:13.108709
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412724
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-12/1775983077/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-12/1775983077",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-12/1775983077/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14595549494591751799,
        "service_name": "redshift_unloads",
        "span_id": 15678674512140629604,
        "trace_id": 6934964211094879793
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-12 03:38:05
    • success: True
    • trace_id: 6934964211094879793
    • duration: 0:00:15.555907
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412328
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-11/1775895637/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-11/1775895637",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-11/1775895637/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7139722924000675469,
        "service_name": "redshift_unloads",
        "span_id": 16031457437106697680,
        "trace_id": 13260840632703966255
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-11 03:20:57
    • success: True
    • trace_id: 13260840632703966255
    • duration: 0:00:13.492966
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411881
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-10/1775811586/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-10/1775811586",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-10/1775811586/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16103517894953438630,
        "service_name": "redshift_unloads",
        "span_id": 8595618854983486286,
        "trace_id": 15002982515388380611
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-10 03:59:59
    • success: True
    • trace_id: 15002982515388380611
    • duration: 0:00:15.655713
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411366
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-09/1775725279/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-09/1775725279",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-09/1775725279/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10091111203914768399,
        "service_name": "redshift_unloads",
        "span_id": 2248838347581123148,
        "trace_id": 9182564185374731921
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-09 04:01:29
    • success: True
    • trace_id: 9182564185374731921
    • duration: 0:00:13.022459
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410824
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-08/1775637065/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-08/1775637065",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-08/1775637065/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10796119646350291757,
        "service_name": "redshift_unloads",
        "span_id": 2218418890547385741,
        "trace_id": 18256816707889684595
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-08 03:31:28
    • success: True
    • trace_id: 18256816707889684595
    • duration: 0:00:13.124570
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410311
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-07/1775550773/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-07/1775550773",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-07/1775550773/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7196566133677534885,
        "service_name": "redshift_unloads",
        "span_id": 11302093807150674791,
        "trace_id": 13170674094625811535
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-07 03:33:02
    • success: True
    • trace_id: 13170674094625811535
    • duration: 0:00:13.216851
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409772
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-06/1775465020/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-06/1775465020",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-06/1775465020/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7430564019269679536,
        "service_name": "redshift_unloads",
        "span_id": 3374692275863674648,
        "trace_id": 18330679610909939257
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-06 03:44:33
    • success: True
    • trace_id: 18330679610909939257
    • duration: 0:00:15.681263
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409382
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-05/1775377536/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-05/1775377536",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-05/1775377536/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9157519045072240473,
        "service_name": "redshift_unloads",
        "span_id": 8509968293527252294,
        "trace_id": 3072991911399977276
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-05 03:25:55
    • success: True
    • trace_id: 3072991911399977276
    • duration: 0:00:15.612876
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409003
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-04/1775290944/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-04/1775290944",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-04/1775290944/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2321510381073641202,
        "service_name": "redshift_unloads",
        "span_id": 16073433245601848892,
        "trace_id": 4083962166495772914
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-04 03:23:04
    • success: True
    • trace_id: 4083962166495772914
    • duration: 0:00:15.569498
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408514
    • 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-stage",
            "key": "meta/reference_dim_super_deluxe_zips/2026-04-03/1775205812/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_super_deluxe_zips/2026-04-03/1775205812",
        "key": "raw/reference_dim_super_deluxe_zips/2026-04-03/1775205812/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9839235781844237264,
        "service_name": "redshift_unloads",
        "span_id": 9343001247698731975,
        "trace_id": 3172190947437599155
    }
}
    • running: False
    • schema_name_id: 523
    • start_time: 2026-04-03 03:43:50
    • success: True
    • trace_id: 3172190947437599155
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:45:10
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-17/1776415480'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2018-05-09 10:53:45",
        "disabled": false,
        "format": "raw",
        "id": 523,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:45:10",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_dim_super_deluxe_zips/2026-04-17/1776415480'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_super_deluxe_zips"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform