Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_booking_meta

created: 2022-08-12 12:26:33
disabled: False
format: raw
id: 1407
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_stage_rds",
    "table": "sparefoot_sparefoot_booking_meta"
}

type: rds

Schema Versions: 15

Version 906588

created: 2026-04-17 00:38:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-17/1776404304'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-17/1776404304
id: 906588
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6415156
updated: 2026-04-17 00:38:56

Version 906346

created: 2026-04-16 00:11:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-16/1776316268'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-16/1776316268
id: 906346
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6414581
updated: 2026-04-16 00:11:30

Version 906121

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-15/1776229806'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-15/1776229806
id: 906121
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6414083
updated: 2026-04-15 00:10:28

Version 905939

created: 2026-04-14 00:16:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-14/1776143743'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-14/1776143743
id: 905939
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6413607
updated: 2026-04-14 00:16:14

Version 905712

created: 2026-04-13 00:18:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-13/1776057499'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-13/1776057499
id: 905712
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6413048
updated: 2026-04-13 00:18:43

Version 905509

created: 2026-04-12 00:12:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-12/1775970748'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-12/1775970748
id: 905509
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6412661
updated: 2026-04-12 00:12:49

Version 905298

created: 2026-04-11 00:11:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-11/1775884279'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-11/1775884279
id: 905298
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6412270
updated: 2026-04-11 00:11:59

Version 905074

created: 2026-04-10 00:09:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-10/1775797745'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-10/1775797745
id: 905074
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6411755
updated: 2026-04-10 00:09:46

Version 904834

created: 2026-04-09 00:10:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-09/1775711401'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-09/1775711401
id: 904834
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6411217
updated: 2026-04-09 00:10:26

Version 904646

created: 2026-04-08 00:12:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-08/1775625105'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-08/1775625105
id: 904646
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6410743
updated: 2026-04-08 00:12:15

Version 904425

created: 2026-04-07 00:09:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-07/1775538565'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-07/1775538565
id: 904425
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6410227
updated: 2026-04-07 00:09:55

Version 904245

created: 2026-04-06 00:13:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-06/1775452407'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-06/1775452407
id: 904245
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6409718
updated: 2026-04-06 00:13:48

Version 904047

created: 2026-04-05 00:17:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-05/1775366228'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-05/1775366228
id: 904047
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6409343
updated: 2026-04-05 00:17:29

Version 903826

created: 2026-04-04 00:10:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-04/1775279439'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-04/1775279439
id: 903826
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6408942
updated: 2026-04-04 00:10:59

Version 903610

created: 2026-04-03 00:10:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-03/1775193015'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-03/1775193015
id: 903610
processed: 1

raw_data:

{
    "booking_meta_id": "int32",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int32",
    "key": "string",
    "timestamp": "timestamp[ns]",
    "value": "string"
}

schema_attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

schema_name_id: 1407
schema_scan_id: 6408444
updated: 2026-04-03 00:10:43

Schema Scans: 15

Last at 2026-04-17 00:38:44

Scan 6415156

duration: 0:00:11.963615

exit_message:

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

id: 6415156

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-17/1776404304",
        "key": "raw/sparefoot_booking_meta/2026-04-17/1776404304/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3147062525778934456,
        "service_name": "sparefoot",
        "span_id": 3170206178338816913,
        "trace_id": 3147062525778934456
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-17 00:38:44
success: True
trace_id: 3147062525778934456

Scan 6414581

duration: 0:00:14.516114

exit_message:

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

id: 6414581

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-16/1776316268",
        "key": "raw/sparefoot_booking_meta/2026-04-16/1776316268/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16010813519493456051,
        "service_name": "sparefoot",
        "span_id": 10361656199135005801,
        "trace_id": 16010813519493456051
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-16 00:11:15
success: True
trace_id: 16010813519493456051

Scan 6414083

duration: 0:00:14.277322

exit_message:

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

id: 6414083

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-15/1776229806",
        "key": "raw/sparefoot_booking_meta/2026-04-15/1776229806/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7421446294105738958,
        "service_name": "sparefoot",
        "span_id": 9962434844000273855,
        "trace_id": 7421446294105738958
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-15 00:10:14
success: True
trace_id: 7421446294105738958

Scan 6413607

duration: 0:00:14.584278

exit_message:

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

id: 6413607

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-14/1776143743",
        "key": "raw/sparefoot_booking_meta/2026-04-14/1776143743/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14221086456747581245,
        "service_name": "sparefoot",
        "span_id": 2457791719807804393,
        "trace_id": 14221086456747581245
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-14 00:15:59
success: True
trace_id: 14221086456747581245

Scan 6413048

duration: 0:00:14.470930

exit_message:

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

id: 6413048

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-13/1776057499",
        "key": "raw/sparefoot_booking_meta/2026-04-13/1776057499/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14656713891886016948,
        "service_name": "sparefoot",
        "span_id": 9879199212019188206,
        "trace_id": 14656713891886016948
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-13 00:18:29
success: True
trace_id: 14656713891886016948

Scan 6412661

duration: 0:00:14.266609

exit_message:

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

id: 6412661

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-12/1775970748",
        "key": "raw/sparefoot_booking_meta/2026-04-12/1775970748/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18290489963656069846,
        "service_name": "sparefoot",
        "span_id": 2071650967484159050,
        "trace_id": 18290489963656069846
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-12 00:12:35
success: True
trace_id: 18290489963656069846

Scan 6412270

duration: 0:00:14.362184

exit_message:

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

id: 6412270

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-11/1775884279",
        "key": "raw/sparefoot_booking_meta/2026-04-11/1775884279/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1751831185771944195,
        "service_name": "sparefoot",
        "span_id": 16890681134677274221,
        "trace_id": 1751831185771944195
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-11 00:11:45
success: True
trace_id: 1751831185771944195

Scan 6411755

duration: 0:00:14.312175

exit_message:

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

id: 6411755

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-10/1775797745",
        "key": "raw/sparefoot_booking_meta/2026-04-10/1775797745/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4978061619199289780,
        "service_name": "sparefoot",
        "span_id": 16998412271493586197,
        "trace_id": 4978061619199289780
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-10 00:09:32
success: True
trace_id: 4978061619199289780

Scan 6411217

duration: 0:00:14.525735

exit_message:

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

id: 6411217

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-09/1775711401",
        "key": "raw/sparefoot_booking_meta/2026-04-09/1775711401/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4969521265866914925,
        "service_name": "sparefoot",
        "span_id": 14840194073328164551,
        "trace_id": 4969521265866914925
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-09 00:10:11
success: True
trace_id: 4969521265866914925

Scan 6410743

duration: 0:00:14.452412

exit_message:

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

id: 6410743

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-08/1775625105",
        "key": "raw/sparefoot_booking_meta/2026-04-08/1775625105/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13454007244540927527,
        "service_name": "sparefoot",
        "span_id": 1100191171425028070,
        "trace_id": 13454007244540927527
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-08 00:12:01
success: True
trace_id: 13454007244540927527

Scan 6410227

duration: 0:00:14.352339

exit_message:

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

id: 6410227

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-07/1775538565",
        "key": "raw/sparefoot_booking_meta/2026-04-07/1775538565/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15616245320718027562,
        "service_name": "sparefoot",
        "span_id": 12570991114653617929,
        "trace_id": 15616245320718027562
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-07 00:09:40
success: True
trace_id: 15616245320718027562

Scan 6409718

duration: 0:00:14.329875

exit_message:

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

id: 6409718

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-06/1775452407",
        "key": "raw/sparefoot_booking_meta/2026-04-06/1775452407/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18372521381197979060,
        "service_name": "sparefoot",
        "span_id": 10531097703105576979,
        "trace_id": 18372521381197979060
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-06 00:13:34
success: True
trace_id: 18372521381197979060

Scan 6409343

duration: 0:00:14.380595

exit_message:

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

id: 6409343

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-05/1775366228",
        "key": "raw/sparefoot_booking_meta/2026-04-05/1775366228/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6128661745239258584,
        "service_name": "sparefoot",
        "span_id": 1312270811026049153,
        "trace_id": 6128661745239258584
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-05 00:17:14
success: True
trace_id: 6128661745239258584

Scan 6408942

duration: 0:00:11.779866

exit_message:

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

id: 6408942

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-04/1775279439",
        "key": "raw/sparefoot_booking_meta/2026-04-04/1775279439/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7641205999917466284,
        "service_name": "sparefoot",
        "span_id": 5153385928269896873,
        "trace_id": 7641205999917466284
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-04 00:10:47
success: True
trace_id: 7641205999917466284

Scan 6408444

duration: 0:00:14.319288

exit_message:

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

id: 6408444

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_meta/2026-04-03/1775193015",
        "key": "raw/sparefoot_booking_meta/2026-04-03/1775193015/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12394740478894734460,
        "service_name": "sparefoot",
        "span_id": 10949615747950729858,
        "trace_id": 12394740478894734460
    }
}

running: False
schema_name_id: 1407
start_time: 2026-04-03 00:10:29
success: True
trace_id: 12394740478894734460

Partitions:

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

Schema:

attributes:

{
    "booking_meta_id": "int",
    "collection_method": "string",
    "confirmation_code": "string",
    "consumer_contact_id": "int",
    "key": "string",
    "timestamp": "timestamp",
    "value": "string"
}

created: 2026-04-17 00:38:44

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-17/1776404304'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-12 12:26:33",
        "disabled": false,
        "format": "raw",
        "id": 1407,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_booking_meta"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "booking_meta_id": "int",
            "collection_method": "string",
            "confirmation_code": "string",
            "consumer_contact_id": "int",
            "key": "string",
            "timestamp": "timestamp",
            "value": "string"
        },
        "created": "2026-04-17 00:38:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_meta`\n(\n `booking_meta_id`  int , `collection_method`  string , `confirmation_code`  string , `consumer_contact_id`  int , `key`  string , `timestamp`  timestamp , `value`  string \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-stage/raw/sparefoot_booking_meta/2026-04-17/1776404304'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_meta`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_meta"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}