Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_booking_data

created: 2022-08-18 17:32:14
disabled: False
format: raw
id: 1144
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718420

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-17/1776454183
id: 1718420
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: 1144
schema_scan_id: 162194176
updated: 2026-04-17 14:30:24

Version 1718268

created: 2026-04-17 09:45:19

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-17/1776437104
id: 1718268
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: 1144
schema_scan_id: 162178714
updated: 2026-04-17 09:45:30

Version 1717482

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-17/1776403244
id: 1717482
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: 1144
schema_scan_id: 162163693
updated: 2026-04-17 00:21:16

Version 1717358

created: 2026-04-16 20:32:01

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-16/1776389506
id: 1717358
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: 1144
schema_scan_id: 162156225
updated: 2026-04-16 20:32:15

Version 1717194

created: 2026-04-16 14:32:42

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-16/1776367940
id: 1717194
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: 1144
schema_scan_id: 162138246
updated: 2026-04-16 14:32:53

Version 1717020

created: 2026-04-16 09:29:16

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-16/1776349736
id: 1717020
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: 1144
schema_scan_id: 162122714
updated: 2026-04-16 09:29:27

Version 1716243

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-16/1776316876
id: 1716243
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: 1144
schema_scan_id: 162107835
updated: 2026-04-16 00:21:43

Version 1716143

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-15/1776303865
id: 1716143
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: 1144
schema_scan_id: 162100397
updated: 2026-04-15 20:45:07

Version 1716001

created: 2026-04-15 14:28:35

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-15/1776281303
id: 1716001
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: 1144
schema_scan_id: 162082030
updated: 2026-04-15 14:28:46

Version 1715817

created: 2026-04-15 09:15:44

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-15/1776262530
id: 1715817
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: 1144
schema_scan_id: 162066737
updated: 2026-04-15 09:15:57

Version 1715059

created: 2026-04-15 00:38:22

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-15/1776231486
id: 1715059
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: 1144
schema_scan_id: 162052054
updated: 2026-04-15 00:38:36

Version 1714934

created: 2026-04-14 20:41:52

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-14/1776217297
id: 1714934
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: 1144
schema_scan_id: 162044389
updated: 2026-04-14 20:42:06

Version 1714780

created: 2026-04-14 14:47:49

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-14/1776196034
id: 1714780
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: 1144
schema_scan_id: 162027185
updated: 2026-04-14 14:48:01

Version 1714585

created: 2026-04-14 09:08:55

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-14/1776175684
id: 1714585
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: 1144
schema_scan_id: 162010944
updated: 2026-04-14 09:09:06

Version 1713849

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_booking_data/2026-04-14/1776144123
id: 1713849
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: 1144
schema_scan_id: 161996398
updated: 2026-04-14 00:22:30

Schema Scans: 15

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

Scan 162194176

duration: 0:00:14.331260

exit_message:

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

id: 162194176

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

running: False
schema_name_id: 1144
start_time: 2026-04-17 14:30:10
success: True
trace_id: 7348883660313427164

Scan 162178714

duration: 0:00:11.694137

exit_message:

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

id: 162178714

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

running: False
schema_name_id: 1144
start_time: 2026-04-17 09:45:18
success: True
trace_id: 5502367896139826805

Scan 162163693

duration: 0:00:11.675323

exit_message:

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

id: 162163693

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

running: False
schema_name_id: 1144
start_time: 2026-04-17 00:21:04
success: True
trace_id: 17442609751186526552

Scan 162156225

duration: 0:00:14.435266

exit_message:

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

id: 162156225

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

running: False
schema_name_id: 1144
start_time: 2026-04-16 20:32:01
success: True
trace_id: 4638210576028973584

Scan 162138246

duration: 0:00:11.950671

exit_message:

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

id: 162138246

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

running: False
schema_name_id: 1144
start_time: 2026-04-16 14:32:41
success: True
trace_id: 17483858984667212785

Scan 162122714

duration: 0:00:11.839643

exit_message:

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

id: 162122714

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

running: False
schema_name_id: 1144
start_time: 2026-04-16 09:29:15
success: True
trace_id: 2154088399404342032

Scan 162107835

duration: 0:00:11.695319

exit_message:

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

id: 162107835

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

running: False
schema_name_id: 1144
start_time: 2026-04-16 00:21:31
success: True
trace_id: 15814275592106383220

Scan 162100397

duration: 0:00:11.781438

exit_message:

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

id: 162100397

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

running: False
schema_name_id: 1144
start_time: 2026-04-15 20:44:55
success: True
trace_id: 7093244809965869748

Scan 162082030

duration: 0:00:11.755968

exit_message:

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

id: 162082030

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

running: False
schema_name_id: 1144
start_time: 2026-04-15 14:28:34
success: True
trace_id: 13586329384459965204

Scan 162066737

duration: 0:00:14.100157

exit_message:

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

id: 162066737

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

running: False
schema_name_id: 1144
start_time: 2026-04-15 09:15:43
success: True
trace_id: 14219942803630563297

Scan 162052054

duration: 0:00:14.180104

exit_message:

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

id: 162052054

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

running: False
schema_name_id: 1144
start_time: 2026-04-15 00:38:22
success: True
trace_id: 9008370721883650701

Scan 162044389

duration: 0:00:14.344667

exit_message:

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

id: 162044389

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

running: False
schema_name_id: 1144
start_time: 2026-04-14 20:41:51
success: True
trace_id: 8479217770038785788

Scan 162027185

duration: 0:00:11.810142

exit_message:

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

id: 162027185

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

running: False
schema_name_id: 1144
start_time: 2026-04-14 14:47:49
success: True
trace_id: 7777996707247775001

Scan 162010944

duration: 0:00:11.742129

exit_message:

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

id: 162010944

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

running: False
schema_name_id: 1144
start_time: 2026-04-14 09:08:54
success: True
trace_id: 9154350223163909573

Scan 161996398

duration: 0:00:11.726422

exit_message:

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

id: 161996398

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

running: False
schema_name_id: 1144
start_time: 2026-04-14 00:22:18
success: True
trace_id: 15393606001019620576

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 14:30:10

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

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