Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_page_type

created: 2022-08-18 17:23:21
disabled: False
format: raw
id: 1125
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718402

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-17/1776453397'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-17/1776453397
id: 1718402
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162194039
updated: 2026-04-17 14:16:54

Version 1718183

created: 2026-04-17 09:10:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-17/1776435037'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-17/1776435037
id: 1718183
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162178197
updated: 2026-04-17 09:10:55

Version 1717471

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-17/1776402649'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-17/1776402649
id: 1717471
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162163631
updated: 2026-04-17 00:14:07

Version 1717338

created: 2026-04-16 20:22:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-16/1776388904'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-16/1776388904
id: 1717338
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162156126
updated: 2026-04-16 20:23:11

Version 1717156

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-16/1776366906'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-16/1776366906
id: 1717156
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162138039
updated: 2026-04-16 14:15:29

Version 1716998

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-16/1776348902'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-16/1776348902
id: 1716998
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162122537
updated: 2026-04-16 09:15:21

Version 1716222

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-16/1776316444'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-16/1776316444
id: 1716222
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162107801
updated: 2026-04-16 00:14:36

Version 1716101

created: 2026-04-15 20:22:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-15/1776302517'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-15/1776302517
id: 1716101
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162100314
updated: 2026-04-15 20:22:24

Version 1715982

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-15/1776280693'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-15/1776280693
id: 1715982
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162081776
updated: 2026-04-15 14:18:30

Version 1715757

created: 2026-04-15 08:40:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-15/1776260350'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-15/1776260350
id: 1715757
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162064420
updated: 2026-04-15 08:40:28

Version 1715038

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-15/1776230471'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-15/1776230471
id: 1715038
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162052009
updated: 2026-04-15 00:21:32

Version 1714890

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-14/1776215721'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-14/1776215721
id: 1714890
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162044247
updated: 2026-04-14 20:15:37

Version 1714730

created: 2026-04-14 14:15:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-14/1776194080'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-14/1776194080
id: 1714730
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162026109
updated: 2026-04-14 14:15:23

Version 1714577

created: 2026-04-14 09:04:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-14/1776175390'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-14/1776175390
id: 1714577
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 162010850
updated: 2026-04-14 09:04:42

Version 1713807

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-14/1776143470'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_page_type/2026-04-14/1776143470
id: 1713807
processed: 1

raw_data:

{
    "page_type_id": "int32",
    "page_type_name": "string"
}

schema_attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

schema_name_id: 1125
schema_scan_id: 161996344
updated: 2026-04-14 00:11:26

Schema Scans: 15

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

Scan 162194039

duration: 0:00:14.223969

exit_message:

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

id: 162194039

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_page_type/2026-04-17/1776453397",
        "key": "raw/sparefoot_page_type/2026-04-17/1776453397/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5578436182658849160,
        "service_name": "sparefoot",
        "span_id": 7078570758406558465,
        "trace_id": 5578436182658849160
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-17 14:16:40
success: True
trace_id: 5578436182658849160

Scan 162178197

duration: 0:00:14.086357

exit_message:

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

id: 162178197

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_page_type/2026-04-17/1776435037",
        "key": "raw/sparefoot_page_type/2026-04-17/1776435037/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4630214759298211918,
        "service_name": "sparefoot",
        "span_id": 415344077226497643,
        "trace_id": 4630214759298211918
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-17 09:10:41
success: True
trace_id: 4630214759298211918

Scan 162163631

duration: 0:00:14.103743

exit_message:

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

id: 162163631

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_page_type/2026-04-17/1776402649",
        "key": "raw/sparefoot_page_type/2026-04-17/1776402649/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7791394544468559324,
        "service_name": "sparefoot",
        "span_id": 14203434056834754858,
        "trace_id": 7791394544468559324
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-17 00:13:53
success: True
trace_id: 7791394544468559324

Scan 162156126

duration: 0:00:14.107117

exit_message:

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

id: 162156126

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_page_type/2026-04-16/1776388904",
        "key": "raw/sparefoot_page_type/2026-04-16/1776388904/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13013962950382708163,
        "service_name": "sparefoot",
        "span_id": 10485352952857212053,
        "trace_id": 13013962950382708163
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-16 20:22:57
success: True
trace_id: 13013962950382708163

Scan 162138039

duration: 0:00:11.584887

exit_message:

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

id: 162138039

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_page_type/2026-04-16/1776366906",
        "key": "raw/sparefoot_page_type/2026-04-16/1776366906/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13197072423599079187,
        "service_name": "sparefoot",
        "span_id": 3046983539945949903,
        "trace_id": 13197072423599079187
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-16 14:15:18
success: True
trace_id: 13197072423599079187

Scan 162122537

duration: 0:00:11.575105

exit_message:

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

id: 162122537

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_page_type/2026-04-16/1776348902",
        "key": "raw/sparefoot_page_type/2026-04-16/1776348902/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4970676922112502927,
        "service_name": "sparefoot",
        "span_id": 6418465500043319180,
        "trace_id": 4970676922112502927
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-16 09:15:10
success: True
trace_id: 4970676922112502927

Scan 162107801

duration: 0:00:11.715314

exit_message:

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

id: 162107801

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_page_type/2026-04-16/1776316444",
        "key": "raw/sparefoot_page_type/2026-04-16/1776316444/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15295315695391477186,
        "service_name": "sparefoot",
        "span_id": 14410557579497703214,
        "trace_id": 15295315695391477186
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-16 00:14:24
success: True
trace_id: 15295315695391477186

Scan 162100314

duration: 0:00:14.076761

exit_message:

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

id: 162100314

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_page_type/2026-04-15/1776302517",
        "key": "raw/sparefoot_page_type/2026-04-15/1776302517/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1029553593724941864,
        "service_name": "sparefoot",
        "span_id": 18282097443585001317,
        "trace_id": 1029553593724941864
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-15 20:22:10
success: True
trace_id: 1029553593724941864

Scan 162081776

duration: 0:00:14.204317

exit_message:

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

id: 162081776

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_page_type/2026-04-15/1776280693",
        "key": "raw/sparefoot_page_type/2026-04-15/1776280693/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12035948191641874198,
        "service_name": "sparefoot",
        "span_id": 16073829853665597531,
        "trace_id": 12035948191641874198
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-15 14:18:16
success: True
trace_id: 12035948191641874198

Scan 162064420

duration: 0:00:11.471527

exit_message:

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

id: 162064420

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_page_type/2026-04-15/1776260350",
        "key": "raw/sparefoot_page_type/2026-04-15/1776260350/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6588562742202586454,
        "service_name": "sparefoot",
        "span_id": 8400959841800381890,
        "trace_id": 6588562742202586454
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-15 08:40:16
success: True
trace_id: 6588562742202586454

Scan 162052009

duration: 0:00:14.112358

exit_message:

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

id: 162052009

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_page_type/2026-04-15/1776230471",
        "key": "raw/sparefoot_page_type/2026-04-15/1776230471/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12529833049755314973,
        "service_name": "sparefoot",
        "span_id": 10972650769878388788,
        "trace_id": 12529833049755314973
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-15 00:21:18
success: True
trace_id: 12529833049755314973

Scan 162044247

duration: 0:00:11.583505

exit_message:

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

id: 162044247

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_page_type/2026-04-14/1776215721",
        "key": "raw/sparefoot_page_type/2026-04-14/1776215721/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15079005306839186432,
        "service_name": "sparefoot",
        "span_id": 7849484737650301094,
        "trace_id": 15079005306839186432
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-14 20:15:26
success: True
trace_id: 15079005306839186432

Scan 162026109

duration: 0:00:14.071362

exit_message:

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

id: 162026109

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_page_type/2026-04-14/1776194080",
        "key": "raw/sparefoot_page_type/2026-04-14/1776194080/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16938506767952436069,
        "service_name": "sparefoot",
        "span_id": 3014037944262739308,
        "trace_id": 16938506767952436069
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-14 14:15:09
success: True
trace_id: 16938506767952436069

Scan 162010850

duration: 0:00:11.706425

exit_message:

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

id: 162010850

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_page_type/2026-04-14/1776175390",
        "key": "raw/sparefoot_page_type/2026-04-14/1776175390/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4740738358502515017,
        "service_name": "sparefoot",
        "span_id": 14174838836528154352,
        "trace_id": 4740738358502515017
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-14 09:04:30
success: True
trace_id: 4740738358502515017

Scan 161996344

duration: 0:00:11.465276

exit_message:

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

id: 161996344

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_page_type/2026-04-14/1776143470",
        "key": "raw/sparefoot_page_type/2026-04-14/1776143470/page_type.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_page_type",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6827384509174493910,
        "service_name": "sparefoot",
        "span_id": 14442885224320219354,
        "trace_id": 6827384509174493910
    }
}

running: False
schema_name_id: 1125
start_time: 2026-04-14 00:11:15
success: True
trace_id: 6827384509174493910

Partitions:

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

Schema:

attributes:

{
    "page_type_id": "int",
    "page_type_name": "string"
}

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

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_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-17/1776453397'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
}

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:23:21",
        "disabled": false,
        "format": "raw",
        "id": 1125,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_page_type"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "page_type_id": "int",
            "page_type_name": "string"
        },
        "created": "2026-04-17 14:16:40",
        "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_page_type`\n(\n `page_type_id`  int , `page_type_name`  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_page_type/2026-04-17/1776453397'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_page_type`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_page_type"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}