Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_corporations

created: 2022-08-18 17:14:56
disabled: False
format: raw
id: 1080
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718369

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-17/1776453013'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

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

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162193961
updated: 2026-04-17 14:10:33

Version 1718207

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-17/1776435750'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-17/1776435750
id: 1718207
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162178303
updated: 2026-04-17 09:22:49

Version 1717432

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-17/1776402365'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

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

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162163562
updated: 2026-04-17 00:06:49

Version 1717302

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-16/1776388310'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-16/1776388310
id: 1717302
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162156017
updated: 2026-04-16 20:14:51

Version 1717131

created: 2026-04-16 14:13:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-16/1776366640'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-16/1776366640
id: 1717131
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162137999
updated: 2026-04-16 14:13:41

Version 1717001

created: 2026-04-16 09:15:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-16/1776348922'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-16/1776348922
id: 1717001
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162122546
updated: 2026-04-16 09:15:37

Version 1716192

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-16/1776315974'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-16/1776315974
id: 1716192
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162107745
updated: 2026-04-16 00:06:31

Version 1716095

created: 2026-04-15 20:20:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-15/1776302449'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-15/1776302449
id: 1716095
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162100306
updated: 2026-04-15 20:21:04

Version 1715942

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-15/1776280268'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-15/1776280268
id: 1715942
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162081665
updated: 2026-04-15 14:11:27

Version 1715780

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-15/1776260588'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-15/1776260588
id: 1715780
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162064531
updated: 2026-04-15 08:44:09

Version 1714999

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-15/1776229685'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-15/1776229685
id: 1714999
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162051937
updated: 2026-04-15 00:08:23

Version 1714893

created: 2026-04-14 20:15:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-14/1776215733'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-14/1776215733
id: 1714893
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162044253
updated: 2026-04-14 20:15:56

Version 1714751

created: 2026-04-14 14:17:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-14/1776194173'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-14/1776194173
id: 1714751
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162026148
updated: 2026-04-14 14:17:24

Version 1714589

created: 2026-04-14 09:09:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-14/1776175705'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-14/1776175705
id: 1714589
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 162010954
updated: 2026-04-14 09:09:40

Version 1713795

created: 2026-04-14 00:06:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-14/1776143202'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_corporations/2026-04-14/1776143202
id: 1713795
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1080
schema_scan_id: 161996309
updated: 2026-04-14 00:07:05

Schema Scans: 15

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

Scan 162193961

duration: 0:00:15.031148

exit_message:

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

id: 162193961

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_corporations/2026-04-17/1776453013",
        "key": "raw/sparefoot_corporations/2026-04-17/1776453013/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2608026825186653420,
        "service_name": "sparefoot",
        "span_id": 11150136202215555772,
        "trace_id": 2608026825186653420
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-17 14:10:18
success: True
trace_id: 2608026825186653420

Scan 162178303

duration: 0:00:14.761574

exit_message:

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

id: 162178303

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_corporations/2026-04-17/1776435750",
        "key": "raw/sparefoot_corporations/2026-04-17/1776435750/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3241821063963662407,
        "service_name": "sparefoot",
        "span_id": 18276560551986525609,
        "trace_id": 3241821063963662407
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-17 09:22:34
success: True
trace_id: 3241821063963662407

Scan 162163562

duration: 0:00:14.850525

exit_message:

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

id: 162163562

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_corporations/2026-04-17/1776402365",
        "key": "raw/sparefoot_corporations/2026-04-17/1776402365/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13048052095875276573,
        "service_name": "sparefoot",
        "span_id": 8068527407123787312,
        "trace_id": 13048052095875276573
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-17 00:06:34
success: True
trace_id: 13048052095875276573

Scan 162156017

duration: 0:00:12.335983

exit_message:

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

id: 162156017

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_corporations/2026-04-16/1776388310",
        "key": "raw/sparefoot_corporations/2026-04-16/1776388310/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18011307421975367549,
        "service_name": "sparefoot",
        "span_id": 16891560898110706103,
        "trace_id": 18011307421975367549
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-16 20:14:38
success: True
trace_id: 18011307421975367549

Scan 162137999

duration: 0:00:12.274423

exit_message:

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

id: 162137999

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_corporations/2026-04-16/1776366640",
        "key": "raw/sparefoot_corporations/2026-04-16/1776366640/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16316821402430374082,
        "service_name": "sparefoot",
        "span_id": 10790951186001413352,
        "trace_id": 16316821402430374082
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-16 14:13:29
success: True
trace_id: 16316821402430374082

Scan 162122546

duration: 0:00:12.427916

exit_message:

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

id: 162122546

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_corporations/2026-04-16/1776348922",
        "key": "raw/sparefoot_corporations/2026-04-16/1776348922/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11441170784921316098,
        "service_name": "sparefoot",
        "span_id": 12922886865573101820,
        "trace_id": 11441170784921316098
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-16 09:15:24
success: True
trace_id: 11441170784921316098

Scan 162107745

duration: 0:00:14.724949

exit_message:

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

id: 162107745

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_corporations/2026-04-16/1776315974",
        "key": "raw/sparefoot_corporations/2026-04-16/1776315974/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17563718473764695768,
        "service_name": "sparefoot",
        "span_id": 16779585087339311283,
        "trace_id": 17563718473764695768
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-16 00:06:16
success: True
trace_id: 17563718473764695768

Scan 162100306

duration: 0:00:12.233876

exit_message:

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

id: 162100306

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_corporations/2026-04-15/1776302449",
        "key": "raw/sparefoot_corporations/2026-04-15/1776302449/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9447493739734021937,
        "service_name": "sparefoot",
        "span_id": 13977518385201143321,
        "trace_id": 9447493739734021937
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-15 20:20:52
success: True
trace_id: 9447493739734021937

Scan 162081665

duration: 0:00:14.854465

exit_message:

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

id: 162081665

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_corporations/2026-04-15/1776280268",
        "key": "raw/sparefoot_corporations/2026-04-15/1776280268/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11103673829086200441,
        "service_name": "sparefoot",
        "span_id": 3898054388212282368,
        "trace_id": 11103673829086200441
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-15 14:11:12
success: True
trace_id: 11103673829086200441

Scan 162064531

duration: 0:00:14.648309

exit_message:

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

id: 162064531

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_corporations/2026-04-15/1776260588",
        "key": "raw/sparefoot_corporations/2026-04-15/1776260588/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11530709925074137802,
        "service_name": "sparefoot",
        "span_id": 1429505403967827023,
        "trace_id": 11530709925074137802
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-15 08:43:54
success: True
trace_id: 11530709925074137802

Scan 162051937

duration: 0:00:14.876080

exit_message:

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

id: 162051937

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_corporations/2026-04-15/1776229685",
        "key": "raw/sparefoot_corporations/2026-04-15/1776229685/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7944218772754301087,
        "service_name": "sparefoot",
        "span_id": 7096798751277553825,
        "trace_id": 7944218772754301087
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-15 00:08:09
success: True
trace_id: 7944218772754301087

Scan 162044253

duration: 0:00:12.336582

exit_message:

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

id: 162044253

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_corporations/2026-04-14/1776215733",
        "key": "raw/sparefoot_corporations/2026-04-14/1776215733/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15868685819829643634,
        "service_name": "sparefoot",
        "span_id": 3817345053351730594,
        "trace_id": 15868685819829643634
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-14 20:15:43
success: True
trace_id: 15868685819829643634

Scan 162026148

duration: 0:00:12.138759

exit_message:

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

id: 162026148

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_corporations/2026-04-14/1776194173",
        "key": "raw/sparefoot_corporations/2026-04-14/1776194173/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4441193815989086930,
        "service_name": "sparefoot",
        "span_id": 7328990710296667992,
        "trace_id": 4441193815989086930
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-14 14:17:12
success: True
trace_id: 4441193815989086930

Scan 162010954

duration: 0:00:14.792772

exit_message:

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

id: 162010954

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_corporations/2026-04-14/1776175705",
        "key": "raw/sparefoot_corporations/2026-04-14/1776175705/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14171448622514298530,
        "service_name": "sparefoot",
        "span_id": 18308392604648025015,
        "trace_id": 14171448622514298530
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-14 09:09:25
success: True
trace_id: 14171448622514298530

Scan 161996309

duration: 0:00:12.138839

exit_message:

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

id: 161996309

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_corporations/2026-04-14/1776143202",
        "key": "raw/sparefoot_corporations/2026-04-14/1776143202/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 588453596436385428,
        "service_name": "sparefoot",
        "span_id": 7584877729895249532,
        "trace_id": 588453596436385428
    }
}

running: False
schema_name_id: 1080
start_time: 2026-04-14 00:06:53
success: True
trace_id: 588453596436385428

Partitions:

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

Schema:

attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

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

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_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-17/1776453013'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
}

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:14:56",
        "disabled": false,
        "format": "raw",
        "id": 1080,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_corporations"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "api_password": "string",
            "api_username": "string",
            "cdp_disabled": "smallint",
            "centershift_channel": "int",
            "centershift_endpoint": "string",
            "centershift_inquiry_source_id": "int",
            "centershift_org_id": "string",
            "centershift_signature": "string",
            "corporation_id": "int",
            "domico_client_id": "string",
            "domico_web_service_key": "string",
            "mig_billing_verified": "int",
            "mig_id": "int",
            "mig_location_id": "int",
            "mig_payment_type": "string",
            "mig_time_live": "timestamp",
            "mig_type": "string",
            "mig_user_id": "int",
            "name": "string",
            "pull_promos": "smallint",
            "quikstor_wsdl": "string",
            "rate_type": "string",
            "reservation_type": "string",
            "sitelink_corp_code": "string",
            "source_id": "int",
            "time_created": "timestamp",
            "time_modified": "timestamp"
        },
        "created": "2026-04-17 14:10:19",
        "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_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \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_corporations/2026-04-17/1776453013'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_corporations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_corporations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}