Schema Info

Schema Name: sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips
  • created: 2018-05-17 10:52:44
  • disabled: False
  • format: raw
  • id: 924
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_redshift",
    "table": "analytics_reference_dim_super_deluxe_zips"
}
  • type: redshift
Schema Versions: 3
    • created: 2024-08-14 12:13:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
    "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/reference_dim_super_deluxe_zips/2024-08-14/1723655560'\n",
    "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-dev/raw/reference_dim_super_deluxe_zips/2024-08-14/1723655560
    • id: 4708792
    • 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: 924
    • schema_scan_id: 6565131
    • updated: 2024-08-14 12:13:15
    • created: 2024-05-14 06:11:00
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
    "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/reference_dim_super_deluxe_zips/2024-05-14/1715685023'\n",
    "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-dev/raw/reference_dim_super_deluxe_zips/2024-05-14/1715685023
    • id: 4705902
    • 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: 924
    • schema_scan_id: 6490590
    • updated: 2024-05-14 06:11:12
    • created: 2024-05-13 15:16:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
    "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/reference_dim_super_deluxe_zips/2024-05-13/1715631326'\n",
    "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips"
]
    • hive_path: s3://sfdl-redshift-analytics-dev/raw/reference_dim_super_deluxe_zips/2024-05-13/1715631326
    • id: 4705728
    • 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: 924
    • schema_scan_id: 6490069
    • updated: 2024-05-13 15:16:30
Schema Scans: 3
Last at 2024-08-14 12:13:02
    • duration: 0:00:12.973127
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6565131
    • 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-dev",
            "key": "meta/reference_dim_super_deluxe_zips/2024-08-14/1723655560/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-dev",
        "hive_path": "s3://sfdl-redshift-analytics-dev/raw/reference_dim_super_deluxe_zips/2024-08-14/1723655560",
        "key": "raw/reference_dim_super_deluxe_zips/2024-08-14/1723655560/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6604957095514083012,
        "service_name": "redshift_unloads",
        "span_id": 10167503152501542555,
        "trace_id": 4960324713437471754
    }
}
    • running: False
    • schema_name_id: 924
    • start_time: 2024-08-14 12:13:02
    • success: True
    • trace_id: 4960324713437471754
    • duration: 0:00:13.507753
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6490590
    • 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-dev",
            "key": "meta/reference_dim_super_deluxe_zips/2024-05-14/1715685023/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-dev",
        "hive_path": "s3://sfdl-redshift-analytics-dev/raw/reference_dim_super_deluxe_zips/2024-05-14/1715685023",
        "key": "raw/reference_dim_super_deluxe_zips/2024-05-14/1715685023/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1639624004889323940,
        "service_name": "redshift_unloads",
        "span_id": 2573785752319280630,
        "trace_id": 4746232683907737747
    }
}
    • running: False
    • schema_name_id: 924
    • start_time: 2024-05-14 06:10:58
    • success: True
    • trace_id: 4746232683907737747
    • duration: 0:00:12.917986
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6490069
    • 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-dev",
            "key": "meta/reference_dim_super_deluxe_zips/2024-05-13/1715631326/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-dev",
        "hive_path": "s3://sfdl-redshift-analytics-dev/raw/reference_dim_super_deluxe_zips/2024-05-13/1715631326",
        "key": "raw/reference_dim_super_deluxe_zips/2024-05-13/1715631326/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7907390030922329373,
        "service_name": "redshift_unloads",
        "span_id": 15136541358338906938,
        "trace_id": 7962491563453294453
    }
}
    • running: False
    • schema_name_id: 924
    • start_time: 2024-05-13 15:16:18
    • success: True
    • trace_id: 7962491563453294453
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: 2024-08-14 12:13:04
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/reference_dim_super_deluxe_zips/2024-08-14/1723655560'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2018-05-17 10:52:44",
        "disabled": false,
        "format": "raw",
        "id": 924,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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": "2024-08-14 12:13:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/reference_dim_super_deluxe_zips/2024-08-14/1723655560'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_reference_dim_super_deluxe_zips"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform