Schema Info

Schema Name: sfdl_prod_redshift.analytics_pl_facilities
  • created: 2019-03-02 07:04:01
  • disabled: False
  • format: raw
  • id: 660
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_redshift",
    "table": "analytics_pl_facilities"
}
  • type: redshift
Schema Versions: 15
    • created: 2026-04-17 07:13:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-17/1776427989'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-17/1776427989
    • id: 1718114
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 162173117
    • updated: 2026-04-17 07:13:49
    • created: 2026-04-16 07:21:18
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-16/1776342048'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-16/1776342048
    • id: 1716901
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 162117448
    • updated: 2026-04-16 07:21:29
    • created: 2026-04-15 07:10:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-15/1776254997'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-15/1776254997
    • id: 1715675
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 162061819
    • updated: 2026-04-15 07:11:04
    • created: 2026-04-14 07:21:42
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-14/1776169281'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-14/1776169281
    • id: 1714509
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 162006475
    • updated: 2026-04-14 07:21:54
    • created: 2026-04-13 07:28:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-13/1776083270'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-13/1776083270
    • id: 1713293
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161948474
    • updated: 2026-04-13 07:28:39
    • created: 2026-04-12 07:21:17
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-12/1775996447'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-12/1775996447
    • id: 1712104
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161899611
    • updated: 2026-04-12 07:21:31
    • created: 2026-04-11 06:03:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-11/1775905383'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-11/1775905383
    • id: 1710797
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161845242
    • updated: 2026-04-11 06:03:51
    • created: 2026-04-10 07:14:12
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-10/1775823213'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-10/1775823213
    • id: 1709696
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161792117
    • updated: 2026-04-10 07:14:26
    • created: 2026-04-09 07:17:54
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-09/1775737047'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-09/1775737047
    • id: 1708554
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161736323
    • updated: 2026-04-09 07:18:05
    • created: 2026-04-08 07:17:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-08/1775650647'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-08/1775650647
    • id: 1707380
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161681521
    • updated: 2026-04-08 07:18:13
    • created: 2026-04-07 07:16:43
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-07/1775564179'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-07/1775564179
    • id: 1706172
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161625261
    • updated: 2026-04-07 07:16:57
    • created: 2026-04-06 06:21:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-06/1775474439'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-06/1775474439
    • id: 1704878
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161565854
    • updated: 2026-04-06 06:21:41
    • created: 2026-04-05 07:26:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-05/1775391981'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-05/1775391981
    • id: 1703745
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161520054
    • updated: 2026-04-05 07:26:58
    • created: 2026-04-04 07:05:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-04/1775304310'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-04/1775304310
    • id: 1702522
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161466388
    • updated: 2026-04-04 07:05:50
    • created: 2026-04-03 07:10:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-03/1775218200'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
]
    • hive_path: s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-03/1775218200
    • id: 1701388
    • processed: 1
    • raw_data: 
      {
    "_origin": "67",
    "aaa_active": "42",
    "aaa_eligible": "43",
    "aaa_opt_in": "44",
    "account_key": "5",
    "account_manager": "8",
    "account_manager_key": "7",
    "account_pricing_model": "11",
    "active": "16",
    "amex_approved": "20",
    "api_credentials_invalid": "45",
    "approved": "18",
    "audit_id": "0",
    "avg_ppsqft_cc": "66",
    "avg_ppsqft_cc_10x10": "61",
    "avg_ppsqft_cc_10x15": "62",
    "avg_ppsqft_cc_10x20": "63",
    "avg_ppsqft_cc_10x25": "64",
    "avg_ppsqft_cc_10x30": "65",
    "avg_ppsqft_cc_5x10": "59",
    "avg_ppsqft_cc_5x15": "60",
    "avg_ppsqft_cc_5x5": "58",
    "avg_ppsqft_non_cc": "57",
    "avg_ppsqft_non_cc_10x10": "52",
    "avg_ppsqft_non_cc_10x15": "53",
    "avg_ppsqft_non_cc_10x20": "54",
    "avg_ppsqft_non_cc_10x25": "55",
    "avg_ppsqft_non_cc_10x30": "56",
    "avg_ppsqft_non_cc_5x10": "50",
    "avg_ppsqft_non_cc_5x15": "51",
    "avg_ppsqft_non_cc_5x5": "49",
    "avg_review": "47",
    "bid_percent": "40",
    "billable_entity_key": "13",
    "city": "32",
    "client_key": "3",
    "client_name": "4",
    "company_code": "6",
    "country": "37",
    "cpa": "19",
    "created_date": "22",
    "facility_date_live_key": "23",
    "facility_key": "1",
    "facility_name": "2",
    "facility_promo": "21",
    "facility_status": "14",
    "first_bid_change_timestamp": "25",
    "first_impression_timestamp": "27",
    "has_billable_entity": "12",
    "integration": "10",
    "integration_key": "9",
    "is_directory": "28",
    "is_physical_facility": "29",
    "last_bid_change_timestamp": "26",
    "last_hide_timestamp": "24",
    "latitude": "38",
    "live": "15",
    "location_key": "30",
    "longitude": "39",
    "minimum_bid": "41",
    "msa": "36",
    "num_photos": "48",
    "num_reviews": "46",
    "publish": "17",
    "state": "33",
    "street_address": "31",
    "zip": "34",
    "zip_full": "35"
}
    • schema_attributes: 
      {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
    • schema_name_id: 660
    • schema_scan_id: 161408628
    • updated: 2026-04-03 07:10:45
Schema Scans: 15
Last at 2026-04-17 07:13:33
    • duration: 0:00:15.923603
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173117
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-17/1776427989/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-17/1776427989",
        "key": "raw/pl_facilities/2026-04-17/1776427989/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13543309821495009467,
        "service_name": "redshift_unloads",
        "span_id": 10581281622405068793,
        "trace_id": 17429171178575665390
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-17 07:13:33
    • success: True
    • trace_id: 17429171178575665390
    • duration: 0:00:13.414237
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117448
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-16/1776342048/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-16/1776342048",
        "key": "raw/pl_facilities/2026-04-16/1776342048/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3357669599634021865,
        "service_name": "redshift_unloads",
        "span_id": 7723397353078673723,
        "trace_id": 7236760489162569520
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-16 07:21:16
    • success: True
    • trace_id: 7236760489162569520
    • duration: 0:00:13.318033
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061819
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-15/1776254997/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-15/1776254997",
        "key": "raw/pl_facilities/2026-04-15/1776254997/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14175163994694899918,
        "service_name": "redshift_unloads",
        "span_id": 8513358716782629905,
        "trace_id": 10662023070573739788
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-15 07:10:51
    • success: True
    • trace_id: 10662023070573739788
    • duration: 0:00:13.758016
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006475
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-14/1776169281/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-14/1776169281",
        "key": "raw/pl_facilities/2026-04-14/1776169281/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12380316969821435457,
        "service_name": "redshift_unloads",
        "span_id": 11897712041726869783,
        "trace_id": 187733384402651901
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-14 07:21:40
    • success: True
    • trace_id: 187733384402651901
    • duration: 0:00:13.312401
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948474
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-13/1776083270/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-13/1776083270",
        "key": "raw/pl_facilities/2026-04-13/1776083270/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10945500822351642035,
        "service_name": "redshift_unloads",
        "span_id": 12444543652522182308,
        "trace_id": 1126324938999242029
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-13 07:28:25
    • success: True
    • trace_id: 1126324938999242029
    • duration: 0:00:15.777332
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899611
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-12/1775996447/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-12/1775996447",
        "key": "raw/pl_facilities/2026-04-12/1775996447/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11845419175365325418,
        "service_name": "redshift_unloads",
        "span_id": 10274588207174856047,
        "trace_id": 2665029226105154936
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-12 07:21:15
    • success: True
    • trace_id: 2665029226105154936
    • duration: 0:00:15.897716
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161845242
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-11/1775905383/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-11/1775905383",
        "key": "raw/pl_facilities/2026-04-11/1775905383/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 554971304581041761,
        "service_name": "redshift_unloads",
        "span_id": 7078863194305885568,
        "trace_id": 5758795088012600769
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-11 06:03:35
    • success: True
    • trace_id: 5758795088012600769
    • duration: 0:00:15.928696
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792117
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-10/1775823213/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-10/1775823213",
        "key": "raw/pl_facilities/2026-04-10/1775823213/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11640509979179875021,
        "service_name": "redshift_unloads",
        "span_id": 8968611180943445980,
        "trace_id": 15552452176136332709
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-10 07:14:10
    • success: True
    • trace_id: 15552452176136332709
    • duration: 0:00:13.494397
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736323
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-09/1775737047/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-09/1775737047",
        "key": "raw/pl_facilities/2026-04-09/1775737047/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14149475900674844493,
        "service_name": "redshift_unloads",
        "span_id": 17685367177461963718,
        "trace_id": 2715673864798876758
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-09 07:17:52
    • success: True
    • trace_id: 2715673864798876758
    • duration: 0:00:16.001502
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681521
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-08/1775650647/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-08/1775650647",
        "key": "raw/pl_facilities/2026-04-08/1775650647/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15768025721716969240,
        "service_name": "redshift_unloads",
        "span_id": 15753101853178460571,
        "trace_id": 5627979093764090179
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-08 07:17:57
    • success: True
    • trace_id: 5627979093764090179
    • duration: 0:00:15.747439
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625261
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-07/1775564179/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-07/1775564179",
        "key": "raw/pl_facilities/2026-04-07/1775564179/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7305118098301843498,
        "service_name": "redshift_unloads",
        "span_id": 10679293657751511613,
        "trace_id": 12214831976829031791
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-07 07:16:41
    • success: True
    • trace_id: 12214831976829031791
    • duration: 0:00:13.193418
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161565854
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-06/1775474439/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-06/1775474439",
        "key": "raw/pl_facilities/2026-04-06/1775474439/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11837872001355577363,
        "service_name": "redshift_unloads",
        "span_id": 12342245426839185174,
        "trace_id": 1660294447611344328
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-06 06:21:28
    • success: True
    • trace_id: 1660294447611344328
    • duration: 0:00:13.152644
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161520054
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-05/1775391981/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-05/1775391981",
        "key": "raw/pl_facilities/2026-04-05/1775391981/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2725968893277818250,
        "service_name": "redshift_unloads",
        "span_id": 13820133632243991022,
        "trace_id": 5986676794140249994
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-05 07:26:45
    • success: True
    • trace_id: 5986676794140249994
    • duration: 0:00:15.644891
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466388
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-04/1775304310/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-04/1775304310",
        "key": "raw/pl_facilities/2026-04-04/1775304310/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6208729660754415005,
        "service_name": "redshift_unloads",
        "span_id": 1253335065525707557,
        "trace_id": 2234010455153866240
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-04 07:05:35
    • success: True
    • trace_id: 2234010455153866240
    • duration: 0:00:15.945257
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408628
    • payload: 
      {
    "datatype_dict": {
        "aaa_active": "int",
        "aaa_eligible": "int",
        "aaa_opt_in": "int",
        "account_key": "int",
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "account_pricing_model": "varchar(10)",
        "active": "int",
        "amex_approved": "int",
        "api_credentials_invalid": "int",
        "approved": "int",
        "audit_id": "bigint",
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "avg_review": "decimal(4,2)",
        "bid_percent": "decimal(6,2)",
        "billable_entity_key": "int",
        "city": "varchar(100)",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "company_code": "varchar(128)",
        "country": "varchar(2)",
        "cpa": "int",
        "created_date": "date",
        "facility_date_live_key": "int",
        "facility_key": "int",
        "facility_name": "varchar(255)",
        "facility_promo": "varchar(65535)",
        "facility_status": "varchar(40)",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "has_billable_entity": "int",
        "integration": "varchar(100)",
        "integration_key": "int",
        "is_directory": "int",
        "is_physical_facility": "int",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "latitude": "double",
        "live": "int",
        "location_key": "int",
        "longitude": "double",
        "minimum_bid": "decimal(6,2)",
        "msa": "varchar(150)",
        "num_photos": "int",
        "num_reviews": "int",
        "origin_key": "varchar",
        "publish": "int",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/pl_facilities/2026-04-03/1775218200/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-03/1775218200",
        "key": "raw/pl_facilities/2026-04-03/1775218200/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_pl_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6295283688072004203,
        "service_name": "redshift_unloads",
        "span_id": 17675632285229784201,
        "trace_id": 15855885957952295832
    }
}
    • running: False
    • schema_name_id: 660
    • start_time: 2026-04-03 07:10:30
    • success: True
    • trace_id: 15855885957952295832
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "_origin": "string",
    "aaa_active": "int",
    "aaa_eligible": "int",
    "aaa_opt_in": "int",
    "account_key": "int",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "account_pricing_model": "varchar(10)",
    "active": "int",
    "amex_approved": "int",
    "api_credentials_invalid": "int",
    "approved": "int",
    "audit_id": "bigint",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "avg_review": "decimal(4,2)",
    "bid_percent": "decimal(6,2)",
    "billable_entity_key": "int",
    "city": "varchar(100)",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "company_code": "varchar(128)",
    "country": "varchar(2)",
    "cpa": "int",
    "created_date": "date",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "facility_name": "varchar(255)",
    "facility_promo": "varchar(65535)",
    "facility_status": "varchar(40)",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "has_billable_entity": "int",
    "integration": "varchar(100)",
    "integration_key": "int",
    "is_directory": "int",
    "is_physical_facility": "int",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp",
    "latitude": "double",
    "live": "int",
    "location_key": "int",
    "longitude": "double",
    "minimum_bid": "decimal(6,2)",
    "msa": "varchar(150)",
    "num_photos": "int",
    "num_reviews": "int",
    "publish": "int",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}
  • created: 2026-04-17 07:13:35
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-17/1776427989'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2019-03-02 07:04:01",
        "disabled": false,
        "format": "raw",
        "id": 660,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_pl_facilities"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "aaa_active": "int",
            "aaa_eligible": "int",
            "aaa_opt_in": "int",
            "account_key": "int",
            "account_manager": "varchar(24)",
            "account_manager_key": "int",
            "account_pricing_model": "varchar(10)",
            "active": "int",
            "amex_approved": "int",
            "api_credentials_invalid": "int",
            "approved": "int",
            "audit_id": "bigint",
            "avg_ppsqft_cc": "decimal(5,2)",
            "avg_ppsqft_cc_10x10": "decimal(5,2)",
            "avg_ppsqft_cc_10x15": "decimal(5,2)",
            "avg_ppsqft_cc_10x20": "decimal(5,2)",
            "avg_ppsqft_cc_10x25": "decimal(5,2)",
            "avg_ppsqft_cc_10x30": "decimal(5,2)",
            "avg_ppsqft_cc_5x10": "decimal(5,2)",
            "avg_ppsqft_cc_5x15": "decimal(5,2)",
            "avg_ppsqft_cc_5x5": "decimal(5,2)",
            "avg_ppsqft_non_cc": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
            "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
            "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
            "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
            "avg_review": "decimal(4,2)",
            "bid_percent": "decimal(6,2)",
            "billable_entity_key": "int",
            "city": "varchar(100)",
            "client_key": "bigint",
            "client_name": "varchar(255)",
            "company_code": "varchar(128)",
            "country": "varchar(2)",
            "cpa": "int",
            "created_date": "date",
            "facility_date_live_key": "int",
            "facility_key": "int",
            "facility_name": "varchar(255)",
            "facility_promo": "varchar(65535)",
            "facility_status": "varchar(40)",
            "first_bid_change_timestamp": "timestamp",
            "first_impression_timestamp": "timestamp",
            "has_billable_entity": "int",
            "integration": "varchar(100)",
            "integration_key": "int",
            "is_directory": "int",
            "is_physical_facility": "int",
            "last_bid_change_timestamp": "timestamp",
            "last_hide_timestamp": "timestamp",
            "latitude": "double",
            "live": "int",
            "location_key": "int",
            "longitude": "double",
            "minimum_bid": "decimal(6,2)",
            "msa": "varchar(150)",
            "num_photos": "int",
            "num_reviews": "int",
            "publish": "int",
            "state": "varchar(2)",
            "street_address": "varchar(255)",
            "zip": "varchar(6)",
            "zip_full": "varchar(10)"
        },
        "created": "2026-04-17 07:13:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_pl_facilities`\n(\n `audit_id`  bigint , `facility_key`  int , `facility_name`  varchar(255) , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `company_code`  varchar(128) , `account_manager_key`  int , `account_manager`  varchar(24) , `integration_key`  int , `integration`  varchar(100) , `account_pricing_model`  varchar(10) , `has_billable_entity`  int , `billable_entity_key`  int , `facility_status`  varchar(40) , `live`  int , `active`  int , `publish`  int , `approved`  int , `cpa`  int , `amex_approved`  int , `facility_promo`  varchar(65535) , `created_date`  date , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `is_directory`  int , `is_physical_facility`  int , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `msa`  varchar(150) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `bid_percent`  decimal(6,2) , `minimum_bid`  decimal(6,2) , `aaa_active`  int , `aaa_eligible`  int , `aaa_opt_in`  int , `api_credentials_invalid`  int , `num_reviews`  int , `avg_review`  decimal(4,2) , `num_photos`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/pl_facilities/2026-04-17/1776427989'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_pl_facilities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_pl_facilities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform