Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_accounts

created: 2022-08-18 17:15:48
disabled: False
format: raw
id: 1087
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_accounts"
}

type: rds

Schema Versions: 15

Version 1718368

created: 2026-04-17 14:10:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776453013'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776453013
id: 1718368
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162193960
updated: 2026-04-17 14:10:30

Version 1718205

created: 2026-04-17 09:22:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776435741'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776435741
id: 1718205
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162178301
updated: 2026-04-17 09:22:38

Version 1717428

created: 2026-04-17 00:06:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776402365'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776402365
id: 1717428
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162163559
updated: 2026-04-17 00:06:34

Version 1717309

created: 2026-04-16 20:15:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776388300'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776388300
id: 1717309
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162156027
updated: 2026-04-16 20:15:33

Version 1717145

created: 2026-04-16 14:14:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776366652'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776366652
id: 1717145
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162138020
updated: 2026-04-16 14:14:59

Version 1716989

created: 2026-04-16 09:11:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776348702'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776348702
id: 1716989
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162122515
updated: 2026-04-16 09:11:59

Version 1716197

created: 2026-04-16 00:07:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776316032'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776316032
id: 1716197
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162107757
updated: 2026-04-16 00:08:04

Version 1716098

created: 2026-04-15 20:21:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776302473'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776302473
id: 1716098
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162100309
updated: 2026-04-15 20:21:31

Version 1715944

created: 2026-04-15 14:11:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776280276'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776280276
id: 1715944
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162081669
updated: 2026-04-15 14:11:39

Version 1715778

created: 2026-04-15 08:43:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776260574'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776260574
id: 1715778
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162064524
updated: 2026-04-15 08:43:54

Version 1715007

created: 2026-04-15 00:08:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776229702'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776229702
id: 1715007
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162051951
updated: 2026-04-15 00:08:45

Version 1714878

created: 2026-04-14 20:12:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776215459'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776215459
id: 1714878
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162044226
updated: 2026-04-14 20:12:27

Version 1714748

created: 2026-04-14 14:16:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776194160'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776194160
id: 1714748
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162026137
updated: 2026-04-14 14:17:05

Version 1714551

created: 2026-04-14 08:55:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776174913'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776174913
id: 1714551
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 162009447
updated: 2026-04-14 08:55:45

Version 1713822

created: 2026-04-14 00:14:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776143651'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776143651
id: 1713822
processed: 1

raw_data:

{
    "account_id": "int32",
    "allow_invoice_billing": "int16",
    "bid_by_size": "int16",
    "bid_type": "string",
    "billing_verified": "int32",
    "cpa": "int16",
    "default_insights": "int32",
    "deleted": "int16",
    "exclusive_site_id": "int32",
    "geopage": "int16",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "int16",
    "iyp_allowed": "int16",
    "location_id": "int32",
    "min_bid": "double",
    "modified_dtm": "timestamp[ns]",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int32",
    "offline_cdp_enabled": "int16",
    "opt_out_marketing": "int16",
    "payment_type": "string",
    "reservation_window": "int32",
    "residual_percent": "double",
    "sf_account_id": "int32",
    "status": "string",
    "terms_envelope_accepted": "int16",
    "terms_envelope_id": "string",
    "test_account": "int16",
    "time_created": "timestamp[ns]",
    "time_live": "timestamp[ns]",
    "twilio_phone_number": "string",
    "user_id": "int32",
    "wholesale": "int16"
}

schema_attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

schema_name_id: 1087
schema_scan_id: 161996363
updated: 2026-04-14 00:14:31

Schema Scans: 15

Last at 2026-04-17 14:10:17

Scan 162193960

duration: 0:00:12.678903

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162193960

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776453013",
        "key": "raw/sparefoot_accounts/2026-04-17/1776453013/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16858661837979675863,
        "service_name": "sparefoot",
        "span_id": 16676926271894897076,
        "trace_id": 16858661837979675863
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-17 14:10:17
success: True
trace_id: 16858661837979675863

Scan 162178301

duration: 0:00:15.127169

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162178301

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776435741",
        "key": "raw/sparefoot_accounts/2026-04-17/1776435741/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6783112718810112634,
        "service_name": "sparefoot",
        "span_id": 997961469542920532,
        "trace_id": 6783112718810112634
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-17 09:22:23
success: True
trace_id: 6783112718810112634

Scan 162163559

duration: 0:00:15.140476

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163559

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776402365",
        "key": "raw/sparefoot_accounts/2026-04-17/1776402365/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14367091947138674403,
        "service_name": "sparefoot",
        "span_id": 13868714092821626140,
        "trace_id": 14367091947138674403
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-17 00:06:19
success: True
trace_id: 14367091947138674403

Scan 162156027

duration: 0:00:12.385350

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162156027

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776388300",
        "key": "raw/sparefoot_accounts/2026-04-16/1776388300/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7602210260017652064,
        "service_name": "sparefoot",
        "span_id": 12639940722623413498,
        "trace_id": 7602210260017652064
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-16 20:15:21
success: True
trace_id: 7602210260017652064

Scan 162138020

duration: 0:00:14.984604

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162138020

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776366652",
        "key": "raw/sparefoot_accounts/2026-04-16/1776366652/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18441391276662628119,
        "service_name": "sparefoot",
        "span_id": 10382949517649927969,
        "trace_id": 18441391276662628119
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-16 14:14:44
success: True
trace_id: 18441391276662628119

Scan 162122515

duration: 0:00:12.607415

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162122515

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776348702",
        "key": "raw/sparefoot_accounts/2026-04-16/1776348702/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17548226215302315132,
        "service_name": "sparefoot",
        "span_id": 2896249269450433624,
        "trace_id": 17548226215302315132
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-16 09:11:47
success: True
trace_id: 17548226215302315132

Scan 162107757

duration: 0:00:15.032215

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162107757

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-16/1776316032",
        "key": "raw/sparefoot_accounts/2026-04-16/1776316032/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12770209580211568447,
        "service_name": "sparefoot",
        "span_id": 2696079715453185751,
        "trace_id": 12770209580211568447
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-16 00:07:49
success: True
trace_id: 12770209580211568447

Scan 162100309

duration: 0:00:14.928951

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162100309

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776302473",
        "key": "raw/sparefoot_accounts/2026-04-15/1776302473/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8336927213797895336,
        "service_name": "sparefoot",
        "span_id": 7158938321949302339,
        "trace_id": 8336927213797895336
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-15 20:21:16
success: True
trace_id: 8336927213797895336

Scan 162081669

duration: 0:00:14.939515

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162081669

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776280276",
        "key": "raw/sparefoot_accounts/2026-04-15/1776280276/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14024905242722633031,
        "service_name": "sparefoot",
        "span_id": 13484611526047158555,
        "trace_id": 14024905242722633031
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-15 14:11:24
success: True
trace_id: 14024905242722633031

Scan 162064524

duration: 0:00:12.527322

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162064524

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776260574",
        "key": "raw/sparefoot_accounts/2026-04-15/1776260574/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5042248136718122750,
        "service_name": "sparefoot",
        "span_id": 15012324800413031435,
        "trace_id": 5042248136718122750
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-15 08:43:42
success: True
trace_id: 5042248136718122750

Scan 162051951

duration: 0:00:14.868813

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162051951

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-15/1776229702",
        "key": "raw/sparefoot_accounts/2026-04-15/1776229702/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4453578887873557009,
        "service_name": "sparefoot",
        "span_id": 4064882802859018436,
        "trace_id": 4453578887873557009
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-15 00:08:30
success: True
trace_id: 4453578887873557009

Scan 162044226

duration: 0:00:12.429875

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162044226

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776215459",
        "key": "raw/sparefoot_accounts/2026-04-14/1776215459/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9524914740360890113,
        "service_name": "sparefoot",
        "span_id": 16514799878789892847,
        "trace_id": 9524914740360890113
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-14 20:12:15
success: True
trace_id: 9524914740360890113

Scan 162026137

duration: 0:00:14.968206

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162026137

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776194160",
        "key": "raw/sparefoot_accounts/2026-04-14/1776194160/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17773303849148987527,
        "service_name": "sparefoot",
        "span_id": 16152466831349037094,
        "trace_id": 17773303849148987527
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-14 14:16:50
success: True
trace_id: 17773303849148987527

Scan 162009447

duration: 0:00:14.963670

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162009447

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776174913",
        "key": "raw/sparefoot_accounts/2026-04-14/1776174913/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14216198347637111926,
        "service_name": "sparefoot",
        "span_id": 8935305673014960799,
        "trace_id": 14216198347637111926
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-14 08:55:30
success: True
trace_id: 14216198347637111926

Scan 161996363

duration: 0:00:12.410504

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161996363

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-14/1776143651",
        "key": "raw/sparefoot_accounts/2026-04-14/1776143651/accounts.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_accounts",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 122695408241101841,
        "service_name": "sparefoot",
        "span_id": 1814325775318709839,
        "trace_id": 122695408241101841
    }
}

running: False
schema_name_id: 1087
start_time: 2026-04-14 00:14:19
success: True
trace_id: 122695408241101841

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "account_id": "int",
    "allow_invoice_billing": "smallint",
    "bid_by_size": "smallint",
    "bid_type": "string",
    "billing_verified": "int",
    "cpa": "smallint",
    "default_insights": "int",
    "deleted": "smallint",
    "exclusive_site_id": "int",
    "geopage": "smallint",
    "hosted_website_billing_cycle": "string",
    "hosted_website_price": "double",
    "insights": "smallint",
    "iyp_allowed": "smallint",
    "location_id": "int",
    "min_bid": "double",
    "modified_dtm": "timestamp",
    "name": "string",
    "new_facility_subscription_fee": "double",
    "notes": "string",
    "ns_vendor_id": "int",
    "offline_cdp_enabled": "smallint",
    "opt_out_marketing": "smallint",
    "payment_type": "string",
    "reservation_window": "int",
    "residual_percent": "double",
    "sf_account_id": "int",
    "status": "string",
    "terms_envelope_accepted": "smallint",
    "terms_envelope_id": "string",
    "test_account": "smallint",
    "time_created": "timestamp",
    "time_live": "timestamp",
    "twilio_phone_number": "string",
    "user_id": "int",
    "wholesale": "smallint"
}

created: 2026-04-17 14:10:18

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776453013'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:15:48",
        "disabled": false,
        "format": "raw",
        "id": 1087,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_accounts"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "allow_invoice_billing": "smallint",
            "bid_by_size": "smallint",
            "bid_type": "string",
            "billing_verified": "int",
            "cpa": "smallint",
            "default_insights": "int",
            "deleted": "smallint",
            "exclusive_site_id": "int",
            "geopage": "smallint",
            "hosted_website_billing_cycle": "string",
            "hosted_website_price": "double",
            "insights": "smallint",
            "iyp_allowed": "smallint",
            "location_id": "int",
            "min_bid": "double",
            "modified_dtm": "timestamp",
            "name": "string",
            "new_facility_subscription_fee": "double",
            "notes": "string",
            "ns_vendor_id": "int",
            "offline_cdp_enabled": "smallint",
            "opt_out_marketing": "smallint",
            "payment_type": "string",
            "reservation_window": "int",
            "residual_percent": "double",
            "sf_account_id": "int",
            "status": "string",
            "terms_envelope_accepted": "smallint",
            "terms_envelope_id": "string",
            "test_account": "smallint",
            "time_created": "timestamp",
            "time_live": "timestamp",
            "twilio_phone_number": "string",
            "user_id": "int",
            "wholesale": "smallint"
        },
        "created": "2026-04-17 14:10:18",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_accounts`\n(\n `account_id`  int , `allow_invoice_billing`  smallint , `bid_by_size`  smallint , `bid_type`  string , `billing_verified`  int , `cpa`  smallint , `default_insights`  int , `deleted`  smallint , `exclusive_site_id`  int , `geopage`  smallint , `hosted_website_billing_cycle`  string , `hosted_website_price`  double , `insights`  smallint , `iyp_allowed`  smallint , `location_id`  int , `min_bid`  double , `modified_dtm`  timestamp , `name`  string , `new_facility_subscription_fee`  double , `notes`  string , `ns_vendor_id`  int , `offline_cdp_enabled`  smallint , `opt_out_marketing`  smallint , `payment_type`  string , `reservation_window`  int , `residual_percent`  double , `sf_account_id`  int , `status`  string , `terms_envelope_accepted`  smallint , `terms_envelope_id`  string , `test_account`  smallint , `time_created`  timestamp , `time_live`  timestamp , `twilio_phone_number`  string , `user_id`  int , `wholesale`  smallint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_accounts/2026-04-17/1776453013'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_accounts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_accounts"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}