Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_booking_meta

created: 2022-08-18 17:17:09
disabled: False
format: raw
id: 1092
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718400

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-17/1776453371'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-17/1776453371
id: 1718400
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: 1092
schema_scan_id: 162194031
updated: 2026-04-17 14:16:34

Version 1718200

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-17/1776435720'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-17/1776435720
id: 1718200
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: 1092
schema_scan_id: 162178296
updated: 2026-04-17 09:22:20

Version 1717465

created: 2026-04-17 00:13:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-17/1776402767'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-17/1776402767
id: 1717465
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: 1092
schema_scan_id: 162163623
updated: 2026-04-17 00:13:36

Version 1717318

created: 2026-04-16 20:16:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-16/1776388519'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-16/1776388519
id: 1717318
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: 1092
schema_scan_id: 162156045
updated: 2026-04-16 20:16:34

Version 1717181

created: 2026-04-16 14:18:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-16/1776367116'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-16/1776367116
id: 1717181
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: 1092
schema_scan_id: 162138126
updated: 2026-04-16 14:18:58

Version 1716991

created: 2026-04-16 09:12:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-16/1776348717'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-16/1776348717
id: 1716991
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: 1092
schema_scan_id: 162122518
updated: 2026-04-16 09:12:19

Version 1716213

created: 2026-04-16 00:12:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-16/1776316314'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-16/1776316314
id: 1716213
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: 1092
schema_scan_id: 162107790
updated: 2026-04-16 00:12:32

Version 1716115

created: 2026-04-15 20:25:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-15/1776302708'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-15/1776302708
id: 1716115
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: 1092
schema_scan_id: 162100333
updated: 2026-04-15 20:25:30

Version 1715967

created: 2026-04-15 14:16:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-15/1776280585'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-15/1776280585
id: 1715967
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: 1092
schema_scan_id: 162081722
updated: 2026-04-15 14:16:47

Version 1715764

created: 2026-04-15 08:41:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-15/1776260398'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-15/1776260398
id: 1715764
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: 1092
schema_scan_id: 162064463
updated: 2026-04-15 08:41:30

Version 1715033

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-15/1776230447'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-15/1776230447
id: 1715033
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: 1092
schema_scan_id: 162052004
updated: 2026-04-15 00:21:17

Version 1714896

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-14/1776215889'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-14/1776215889
id: 1714896
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: 1092
schema_scan_id: 162044293
updated: 2026-04-14 20:18:31

Version 1714763

created: 2026-04-14 14:20:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-14/1776194355'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-14/1776194355
id: 1714763
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: 1092
schema_scan_id: 162026197
updated: 2026-04-14 14:20:33

Version 1714570

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-14/1776175336'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-14/1776175336
id: 1714570
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: 1092
schema_scan_id: 162010748
updated: 2026-04-14 09:03:40

Version 1713805

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_booking_meta/2026-04-14/1776143399'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_meta/2026-04-14/1776143399
id: 1713805
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: 1092
schema_scan_id: 161996339
updated: 2026-04-14 00:10:30

Schema Scans: 15

Last at 2026-04-17 14:16:19

Scan 162194031

duration: 0:00:14.328612

exit_message:

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

id: 162194031

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_booking_meta/2026-04-17/1776453371",
        "key": "raw/sparefoot_booking_meta/2026-04-17/1776453371/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9802652495068724579,
        "service_name": "sparefoot",
        "span_id": 17959950089864539188,
        "trace_id": 9802652495068724579
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-17 14:16:19
success: True
trace_id: 9802652495068724579

Scan 162178296

duration: 0:00:11.833239

exit_message:

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

id: 162178296

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_booking_meta/2026-04-17/1776435720",
        "key": "raw/sparefoot_booking_meta/2026-04-17/1776435720/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9946478365592383858,
        "service_name": "sparefoot",
        "span_id": 5738996484917926401,
        "trace_id": 9946478365592383858
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-17 09:22:09
success: True
trace_id: 9946478365592383858

Scan 162163623

duration: 0:00:11.800293

exit_message:

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

id: 162163623

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_booking_meta/2026-04-17/1776402767",
        "key": "raw/sparefoot_booking_meta/2026-04-17/1776402767/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17244745679585826749,
        "service_name": "sparefoot",
        "span_id": 15594923224623027614,
        "trace_id": 17244745679585826749
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-17 00:13:24
success: True
trace_id: 17244745679585826749

Scan 162156045

duration: 0:00:14.403914

exit_message:

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

id: 162156045

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_booking_meta/2026-04-16/1776388519",
        "key": "raw/sparefoot_booking_meta/2026-04-16/1776388519/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8427923664249477045,
        "service_name": "sparefoot",
        "span_id": 5369028245411118554,
        "trace_id": 8427923664249477045
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-16 20:16:20
success: True
trace_id: 8427923664249477045

Scan 162138126

duration: 0:00:14.317184

exit_message:

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

id: 162138126

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_booking_meta/2026-04-16/1776367116",
        "key": "raw/sparefoot_booking_meta/2026-04-16/1776367116/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4042438625037744811,
        "service_name": "sparefoot",
        "span_id": 13038412895477179584,
        "trace_id": 4042438625037744811
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-16 14:18:43
success: True
trace_id: 4042438625037744811

Scan 162122518

duration: 0:00:14.277957

exit_message:

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

id: 162122518

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_booking_meta/2026-04-16/1776348717",
        "key": "raw/sparefoot_booking_meta/2026-04-16/1776348717/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18026799695969301292,
        "service_name": "sparefoot",
        "span_id": 5299861939821111233,
        "trace_id": 18026799695969301292
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-16 09:12:05
success: True
trace_id: 18026799695969301292

Scan 162107790

duration: 0:00:11.830659

exit_message:

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

id: 162107790

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_booking_meta/2026-04-16/1776316314",
        "key": "raw/sparefoot_booking_meta/2026-04-16/1776316314/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17789625565481520649,
        "service_name": "sparefoot",
        "span_id": 5449310027457187892,
        "trace_id": 17789625565481520649
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-16 00:12:20
success: True
trace_id: 17789625565481520649

Scan 162100333

duration: 0:00:11.873528

exit_message:

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

id: 162100333

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_booking_meta/2026-04-15/1776302708",
        "key": "raw/sparefoot_booking_meta/2026-04-15/1776302708/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2335066926851742759,
        "service_name": "sparefoot",
        "span_id": 15175654829004407380,
        "trace_id": 2335066926851742759
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-15 20:25:19
success: True
trace_id: 2335066926851742759

Scan 162081722

duration: 0:00:14.320457

exit_message:

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

id: 162081722

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_booking_meta/2026-04-15/1776280585",
        "key": "raw/sparefoot_booking_meta/2026-04-15/1776280585/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3653973919723562684,
        "service_name": "sparefoot",
        "span_id": 12752481889938320669,
        "trace_id": 3653973919723562684
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-15 14:16:32
success: True
trace_id: 3653973919723562684

Scan 162064463

duration: 0:00:14.276843

exit_message:

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

id: 162064463

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_booking_meta/2026-04-15/1776260398",
        "key": "raw/sparefoot_booking_meta/2026-04-15/1776260398/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11155253597549917394,
        "service_name": "sparefoot",
        "span_id": 1880597471167309620,
        "trace_id": 11155253597549917394
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-15 08:41:16
success: True
trace_id: 11155253597549917394

Scan 162052004

duration: 0:00:11.745154

exit_message:

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

id: 162052004

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_booking_meta/2026-04-15/1776230447",
        "key": "raw/sparefoot_booking_meta/2026-04-15/1776230447/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15861253747647988328,
        "service_name": "sparefoot",
        "span_id": 12918839703551284310,
        "trace_id": 15861253747647988328
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-15 00:21:05
success: True
trace_id: 15861253747647988328

Scan 162044293

duration: 0:00:14.263442

exit_message:

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

id: 162044293

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_booking_meta/2026-04-14/1776215889",
        "key": "raw/sparefoot_booking_meta/2026-04-14/1776215889/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14000568905772257205,
        "service_name": "sparefoot",
        "span_id": 10126582693570115680,
        "trace_id": 14000568905772257205
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-14 20:18:17
success: True
trace_id: 14000568905772257205

Scan 162026197

duration: 0:00:11.860460

exit_message:

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

id: 162026197

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_booking_meta/2026-04-14/1776194355",
        "key": "raw/sparefoot_booking_meta/2026-04-14/1776194355/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 861742234070686805,
        "service_name": "sparefoot",
        "span_id": 7776437408418079193,
        "trace_id": 861742234070686805
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-14 14:20:21
success: True
trace_id: 861742234070686805

Scan 162010748

duration: 0:00:14.419735

exit_message:

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

id: 162010748

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_booking_meta/2026-04-14/1776175336",
        "key": "raw/sparefoot_booking_meta/2026-04-14/1776175336/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 258353886682389134,
        "service_name": "sparefoot",
        "span_id": 7343973217125872250,
        "trace_id": 258353886682389134
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-14 09:03:25
success: True
trace_id: 258353886682389134

Scan 161996339

duration: 0:00:11.760082

exit_message:

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

id: 161996339

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_booking_meta/2026-04-14/1776143399",
        "key": "raw/sparefoot_booking_meta/2026-04-14/1776143399/booking_meta_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_booking_meta",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15206637035992780844,
        "service_name": "sparefoot",
        "span_id": 18208231910587284666,
        "trace_id": 15206637035992780844
    }
}

running: False
schema_name_id: 1092
start_time: 2026-04-14 00:10:19
success: True
trace_id: 15206637035992780844

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 14:16:20

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_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-prod/raw/sparefoot_booking_meta/2026-04-17/1776453371'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
}

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:17:09",
        "disabled": false,
        "format": "raw",
        "id": 1092,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:16:20",
        "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_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-prod/raw/sparefoot_booking_meta/2026-04-17/1776453371'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_booking_meta`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_booking_meta"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}