Schema Info
Schema Name: sfdl_dev_rds.sparefoot_sparefoot_accounts
- created: 2022-08-31 17:09:38
- disabled: False
- format: raw
- id: 2014
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_rds", "table": "sparefoot_sparefoot_accounts" } - type: rds
Schema Versions: 3
-
Version 4761393
- created: 2025-07-02 15:18:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_accounts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_accounts/2025-07-02/1751487479'\n", "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_accounts" ] - hive_path: s3://sfdl-rds-sparefoot-dev/raw/sparefoot_accounts/2025-07-02/1751487479
- id: 4761393
- 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: 2014
- schema_scan_id: 6814351
- updated: 2025-07-02 15:18:20
-
Version 4708683
- created: 2024-08-14 08:53:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_accounts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_accounts/2024-08-14/1723643630'\n", "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_accounts" ] - hive_path: s3://sfdl-rds-sparefoot-dev/raw/sparefoot_accounts/2024-08-14/1723643630
- id: 4708683
- 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: 2014
- schema_scan_id: 6564699
- updated: 2024-08-14 08:54:08
-
Version 4708018
- created: 2024-07-30 13:45:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_accounts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_accounts/2024-07-30/1722365104'\n", "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_accounts" ] - hive_path: s3://sfdl-rds-sparefoot-dev/raw/sparefoot_accounts/2024-07-30/1722365104
- id: 4708018
- 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: 2014
- schema_scan_id: 6552584
- updated: 2024-07-30 13:45:24
Schema Scans: 3
Last at 2025-07-02 15:18:05
-
Scan 6814351
- duration: 0:00:14.937846
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6814351
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-dev", "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/sparefoot_accounts/2025-07-02/1751487479", "key": "raw/sparefoot_accounts/2025-07-02/1751487479/accounts.parquet.gz" }, "schema": { "name": "sfdl_dev_rds.sparefoot_sparefoot_accounts", "type": "rds" }, "trace_context": { "parent_id": 9427706682810374187, "service_name": "sparefoot", "span_id": 9633663038617709752, "trace_id": 9427706682810374187 } } - running: False
- schema_name_id: 2014
- start_time: 2025-07-02 15:18:05
- success: True
- trace_id: 9427706682810374187
-
Scan 6564699
- duration: 0:00:14.900668
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6564699
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-dev", "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/sparefoot_accounts/2024-08-14/1723643630", "key": "raw/sparefoot_accounts/2024-08-14/1723643630/accounts.parquet.gz" }, "schema": { "name": "sfdl_dev_rds.sparefoot_sparefoot_accounts", "type": "rds" }, "trace_context": { "parent_id": 17170074991484060155, "service_name": "sparefoot", "span_id": 7178611711191655570, "trace_id": 17170074991484060155 } } - running: False
- schema_name_id: 2014
- start_time: 2024-08-14 08:53:53
- success: True
- trace_id: 17170074991484060155
-
Scan 6552584
- duration: 0:00:12.424039
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6552584
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-dev", "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/sparefoot_accounts/2024-07-30/1722365104", "key": "raw/sparefoot_accounts/2024-07-30/1722365104/accounts.parquet.gz" }, "schema": { "name": "sfdl_dev_rds.sparefoot_sparefoot_accounts", "type": "rds" }, "trace_context": { "parent_id": 14015023365581443193, "service_name": "sparefoot", "span_id": 187057698533344275, "trace_id": 14015023365581443193 } } - running: False
- schema_name_id: 2014
- start_time: 2024-07-30 13:45:12
- success: True
- trace_id: 14015023365581443193
- 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: 2025-07-02 15:18:06
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_accounts/2025-07-02/1751487479'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_accounts`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_accounts" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2022-08-31 17:09:38",
"disabled": false,
"format": "raw",
"id": 2014,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_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": "2025-07-02 15:18:06",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/sparefoot_accounts/2025-07-02/1751487479'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_sparefoot_accounts`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_sparefoot_accounts"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}