Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_booking_data

created: 2022-08-12 10:43:08
disabled: False
format: raw
id: 1371
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906546

created: 2026-04-17 00:18:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-17/1776403099'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-17/1776403099
id: 906546
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6415114
updated: 2026-04-17 00:18:53

Version 906375

created: 2026-04-16 00:47:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-16/1776318430'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-16/1776318430
id: 906375
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6414614
updated: 2026-04-16 00:47:46

Version 906136

created: 2026-04-15 00:25:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-15/1776230682'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-15/1776230682
id: 906136
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6414100
updated: 2026-04-15 00:25:29

Version 905946

created: 2026-04-14 00:43:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-14/1776145410'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-14/1776145410
id: 905946
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6413615
updated: 2026-04-14 00:43:56

Version 905730

created: 2026-04-13 00:49:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-13/1776059341'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-13/1776059341
id: 905730
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6413075
updated: 2026-04-13 00:49:29

Version 905530

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-12/1775972758'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-12/1775972758
id: 905530
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6412682
updated: 2026-04-12 00:46:34

Version 905310

created: 2026-04-11 00:25:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-11/1775885068'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-11/1775885068
id: 905310
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6412283
updated: 2026-04-11 00:25:12

Version 905110

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-10/1775799058'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-10/1775799058
id: 905110
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6411795
updated: 2026-04-10 00:31:31

Version 904893

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-09/1775712406'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-09/1775712406
id: 904893
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6411280
updated: 2026-04-09 00:27:24

Version 904666

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-08/1775625818'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-08/1775625818
id: 904666
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6410767
updated: 2026-04-08 00:24:27

Version 904464

created: 2026-04-07 00:23:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-07/1775539353'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-07/1775539353
id: 904464
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6410268
updated: 2026-04-07 00:23:13

Version 904255

created: 2026-04-06 00:31:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-06/1775453475'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-06/1775453475
id: 904255
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6409729
updated: 2026-04-06 00:31:45

Version 904052

created: 2026-04-05 00:29:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-05/1775366970'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-05/1775366970
id: 904052
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6409348
updated: 2026-04-05 00:30:09

Version 903854

created: 2026-04-04 00:45:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-04/1775281499'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-04/1775281499
id: 903854
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6408971
updated: 2026-04-04 00:45:37

Version 903637

created: 2026-04-03 00:37:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_booking_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-03/1775194639'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_booking_data/2026-04-03/1775194639
id: 903637
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "created": "timestamp[ns]",
    "key": "string",
    "value": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

schema_name_id: 1371
schema_scan_id: 6408472
updated: 2026-04-03 00:37:54

Schema Scans: 15

Last at 2026-04-17 00:18:42

Scan 6415114

duration: 0:00:11.846010

exit_message:

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

id: 6415114

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_data/2026-04-17/1776403099",
        "key": "raw/sparefoot_booking_data/2026-04-17/1776403099/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12485038910671166681,
        "service_name": "sparefoot",
        "span_id": 628050100245917271,
        "trace_id": 12485038910671166681
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-17 00:18:42
success: True
trace_id: 12485038910671166681

Scan 6414614

duration: 0:00:14.255487

exit_message:

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

id: 6414614

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_data/2026-04-16/1776318430",
        "key": "raw/sparefoot_booking_data/2026-04-16/1776318430/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8358990495655824600,
        "service_name": "sparefoot",
        "span_id": 14270770049935198864,
        "trace_id": 8358990495655824600
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-16 00:47:32
success: True
trace_id: 8358990495655824600

Scan 6414100

duration: 0:00:14.260053

exit_message:

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

id: 6414100

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_data/2026-04-15/1776230682",
        "key": "raw/sparefoot_booking_data/2026-04-15/1776230682/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7815542778808501370,
        "service_name": "sparefoot",
        "span_id": 6493944735768180235,
        "trace_id": 7815542778808501370
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-15 00:25:15
success: True
trace_id: 7815542778808501370

Scan 6413615

duration: 0:00:14.195193

exit_message:

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

id: 6413615

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_data/2026-04-14/1776145410",
        "key": "raw/sparefoot_booking_data/2026-04-14/1776145410/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7511162456214412390,
        "service_name": "sparefoot",
        "span_id": 13403632204389543725,
        "trace_id": 7511162456214412390
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-14 00:43:41
success: True
trace_id: 7511162456214412390

Scan 6413075

duration: 0:00:14.294785

exit_message:

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

id: 6413075

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_data/2026-04-13/1776059341",
        "key": "raw/sparefoot_booking_data/2026-04-13/1776059341/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17499549937023919579,
        "service_name": "sparefoot",
        "span_id": 6371488309330393546,
        "trace_id": 17499549937023919579
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-13 00:49:15
success: True
trace_id: 17499549937023919579

Scan 6412682

duration: 0:00:14.301107

exit_message:

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

id: 6412682

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_data/2026-04-12/1775972758",
        "key": "raw/sparefoot_booking_data/2026-04-12/1775972758/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7443458615827900207,
        "service_name": "sparefoot",
        "span_id": 3598160746729938880,
        "trace_id": 7443458615827900207
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-12 00:46:20
success: True
trace_id: 7443458615827900207

Scan 6412283

duration: 0:00:11.908458

exit_message:

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

id: 6412283

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_data/2026-04-11/1775885068",
        "key": "raw/sparefoot_booking_data/2026-04-11/1775885068/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10055457330823156548,
        "service_name": "sparefoot",
        "span_id": 17569500383506024910,
        "trace_id": 10055457330823156548
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-11 00:25:00
success: True
trace_id: 10055457330823156548

Scan 6411795

duration: 0:00:11.849786

exit_message:

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

id: 6411795

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_data/2026-04-10/1775799058",
        "key": "raw/sparefoot_booking_data/2026-04-10/1775799058/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6747173092588073857,
        "service_name": "sparefoot",
        "span_id": 6922968827193180727,
        "trace_id": 6747173092588073857
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-10 00:31:19
success: True
trace_id: 6747173092588073857

Scan 6411280

duration: 0:00:14.377941

exit_message:

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

id: 6411280

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_data/2026-04-09/1775712406",
        "key": "raw/sparefoot_booking_data/2026-04-09/1775712406/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14483519925191992288,
        "service_name": "sparefoot",
        "span_id": 7784480374555729263,
        "trace_id": 14483519925191992288
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-09 00:27:09
success: True
trace_id: 14483519925191992288

Scan 6410767

duration: 0:00:11.781050

exit_message:

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

id: 6410767

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_data/2026-04-08/1775625818",
        "key": "raw/sparefoot_booking_data/2026-04-08/1775625818/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17796600579875857226,
        "service_name": "sparefoot",
        "span_id": 806578728903727703,
        "trace_id": 17796600579875857226
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-08 00:24:15
success: True
trace_id: 17796600579875857226

Scan 6410268

duration: 0:00:12.093725

exit_message:

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

id: 6410268

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_data/2026-04-07/1775539353",
        "key": "raw/sparefoot_booking_data/2026-04-07/1775539353/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15137438305158323960,
        "service_name": "sparefoot",
        "span_id": 18351817908212072003,
        "trace_id": 15137438305158323960
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-07 00:23:01
success: True
trace_id: 15137438305158323960

Scan 6409729

duration: 0:00:11.736650

exit_message:

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

id: 6409729

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_data/2026-04-06/1775453475",
        "key": "raw/sparefoot_booking_data/2026-04-06/1775453475/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17224073827056090222,
        "service_name": "sparefoot",
        "span_id": 4708549991405095237,
        "trace_id": 17224073827056090222
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-06 00:31:34
success: True
trace_id: 17224073827056090222

Scan 6409348

duration: 0:00:11.949741

exit_message:

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

id: 6409348

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_data/2026-04-05/1775366970",
        "key": "raw/sparefoot_booking_data/2026-04-05/1775366970/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3587462901203109654,
        "service_name": "sparefoot",
        "span_id": 7706356201241434443,
        "trace_id": 3587462901203109654
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-05 00:29:57
success: True
trace_id: 3587462901203109654

Scan 6408971

duration: 0:00:14.288290

exit_message:

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

id: 6408971

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_data/2026-04-04/1775281499",
        "key": "raw/sparefoot_booking_data/2026-04-04/1775281499/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1096047009862091614,
        "service_name": "sparefoot",
        "span_id": 14151693148910552195,
        "trace_id": 1096047009862091614
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-04 00:45:23
success: True
trace_id: 1096047009862091614

Scan 6408472

duration: 0:00:14.481074

exit_message:

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

id: 6408472

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_data/2026-04-03/1775194639",
        "key": "raw/sparefoot_booking_data/2026-04-03/1775194639/booking_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_booking_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16633825747592840303,
        "service_name": "sparefoot",
        "span_id": 2560424890783842154,
        "trace_id": 16633825747592840303
    }
}

running: False
schema_name_id: 1371
start_time: 2026-04-03 00:37:40
success: True
trace_id: 16633825747592840303

Partitions:

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

Schema:

attributes:

{
    "confirmation_code": "string",
    "created": "timestamp",
    "key": "string",
    "value": "string"
}

created: 2026-04-17 00:18:42

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_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-17/1776403099'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
}

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 10:43:08",
        "disabled": false,
        "format": "raw",
        "id": 1371,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_booking_data"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "confirmation_code": "string",
            "created": "timestamp",
            "key": "string",
            "value": "string"
        },
        "created": "2026-04-17 00:18:42",
        "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_data`\n(\n `confirmation_code`  string , `created`  timestamp , `key`  string , `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_data/2026-04-17/1776403099'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_booking_data`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_booking_data"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}