Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_tests

created: 2022-08-12 10:59:42
disabled: False
format: raw
id: 1392
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906575

created: 2026-04-17 00:35:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-17/1776404115'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-17/1776404115
id: 906575
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6415143
updated: 2026-04-17 00:35:47

Version 906347

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-16/1776316280'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-16/1776316280
id: 906347
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6414582
updated: 2026-04-16 00:11:42

Version 906145

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-15/1776230868'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-15/1776230868
id: 906145
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6414109
updated: 2026-04-15 00:28:16

Version 905918

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-14/1776143525'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-14/1776143525
id: 905918
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6413586
updated: 2026-04-14 00:12:27

Version 905661

created: 2026-04-13 00:08:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-13/1776056904'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-13/1776056904
id: 905661
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6412989
updated: 2026-04-13 00:08:55

Version 905484

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-12/1775970522'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-12/1775970522
id: 905484
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6412634
updated: 2026-04-12 00:09:04

Version 905258

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-11/1775883922'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-11/1775883922
id: 905258
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6412226
updated: 2026-04-11 00:05:39

Version 905084

created: 2026-04-10 00:11:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-10/1775797874'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-10/1775797874
id: 905084
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6411766
updated: 2026-04-10 00:11:35

Version 904879

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-09/1775711704'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-09/1775711704
id: 904879
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6411266
updated: 2026-04-09 00:15:25

Version 904638

created: 2026-04-08 00:08:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-08/1775624873'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-08/1775624873
id: 904638
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6410733
updated: 2026-04-08 00:08:19

Version 904439

created: 2026-04-07 00:12:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-07/1775538748'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-07/1775538748
id: 904439
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6410243
updated: 2026-04-07 00:12:50

Version 904222

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-06/1775452098'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-06/1775452098
id: 904222
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6409695
updated: 2026-04-06 00:08:38

Version 903990

created: 2026-04-05 00:05:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-05/1775365533'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-05/1775365533
id: 903990
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6409284
updated: 2026-04-05 00:05:52

Version 903834

created: 2026-04-04 00:12:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-04/1775279529'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-04/1775279529
id: 903834
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6408951
updated: 2026-04-04 00:12:33

Version 903601

created: 2026-04-03 00:09:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-03/1775192960'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tests/2026-04-03/1775192960
id: 903601
processed: 1

raw_data:

{
    "end_time": "timestamp[ns]",
    "label": "string",
    "start_time": "timestamp[ns]",
    "summary": "string",
    "test_id": "int32"
}

schema_attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

schema_name_id: 1392
schema_scan_id: 6408434
updated: 2026-04-03 00:09:34

Schema Scans: 15

Last at 2026-04-17 00:35:32

Scan 6415143

duration: 0:00:14.624494

exit_message:

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

id: 6415143

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_tests/2026-04-17/1776404115",
        "key": "raw/sparefoot_tests/2026-04-17/1776404115/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11796866173161541325,
        "service_name": "sparefoot",
        "span_id": 12140625380058506129,
        "trace_id": 11796866173161541325
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-17 00:35:32
success: True
trace_id: 11796866173161541325

Scan 6414582

duration: 0:00:11.670504

exit_message:

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

id: 6414582

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_tests/2026-04-16/1776316280",
        "key": "raw/sparefoot_tests/2026-04-16/1776316280/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2787629949480026841,
        "service_name": "sparefoot",
        "span_id": 14698211668460561613,
        "trace_id": 2787629949480026841
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-16 00:11:30
success: True
trace_id: 2787629949480026841

Scan 6414109

duration: 0:00:11.622006

exit_message:

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

id: 6414109

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_tests/2026-04-15/1776230868",
        "key": "raw/sparefoot_tests/2026-04-15/1776230868/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14500293824222736542,
        "service_name": "sparefoot",
        "span_id": 7829240946321472501,
        "trace_id": 14500293824222736542
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-15 00:28:05
success: True
trace_id: 14500293824222736542

Scan 6413586

duration: 0:00:11.705207

exit_message:

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

id: 6413586

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_tests/2026-04-14/1776143525",
        "key": "raw/sparefoot_tests/2026-04-14/1776143525/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13917083165059671478,
        "service_name": "sparefoot",
        "span_id": 7610842067178371140,
        "trace_id": 13917083165059671478
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-14 00:12:15
success: True
trace_id: 13917083165059671478

Scan 6412989

duration: 0:00:14.389053

exit_message:

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

id: 6412989

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_tests/2026-04-13/1776056904",
        "key": "raw/sparefoot_tests/2026-04-13/1776056904/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10606474032901974374,
        "service_name": "sparefoot",
        "span_id": 6438178338856662079,
        "trace_id": 10606474032901974374
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-13 00:08:40
success: True
trace_id: 10606474032901974374

Scan 6412634

duration: 0:00:14.128502

exit_message:

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

id: 6412634

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_tests/2026-04-12/1775970522",
        "key": "raw/sparefoot_tests/2026-04-12/1775970522/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14099413691283547739,
        "service_name": "sparefoot",
        "span_id": 15040955394235827266,
        "trace_id": 14099413691283547739
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-12 00:08:50
success: True
trace_id: 14099413691283547739

Scan 6412226

duration: 0:00:14.207683

exit_message:

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

id: 6412226

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_tests/2026-04-11/1775883922",
        "key": "raw/sparefoot_tests/2026-04-11/1775883922/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12363175058371376447,
        "service_name": "sparefoot",
        "span_id": 15779755871862520739,
        "trace_id": 12363175058371376447
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-11 00:05:24
success: True
trace_id: 12363175058371376447

Scan 6411766

duration: 0:00:14.214715

exit_message:

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

id: 6411766

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_tests/2026-04-10/1775797874",
        "key": "raw/sparefoot_tests/2026-04-10/1775797874/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10816996420661825631,
        "service_name": "sparefoot",
        "span_id": 14493846890914745538,
        "trace_id": 10816996420661825631
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-10 00:11:20
success: True
trace_id: 10816996420661825631

Scan 6411266

duration: 0:00:14.147738

exit_message:

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

id: 6411266

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_tests/2026-04-09/1775711704",
        "key": "raw/sparefoot_tests/2026-04-09/1775711704/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10407896923436733346,
        "service_name": "sparefoot",
        "span_id": 11844336474009979387,
        "trace_id": 10407896923436733346
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-09 00:15:11
success: True
trace_id: 10407896923436733346

Scan 6410733

duration: 0:00:14.238737

exit_message:

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

id: 6410733

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_tests/2026-04-08/1775624873",
        "key": "raw/sparefoot_tests/2026-04-08/1775624873/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9262204536007176416,
        "service_name": "sparefoot",
        "span_id": 3799013218614435238,
        "trace_id": 9262204536007176416
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-08 00:08:05
success: True
trace_id: 9262204536007176416

Scan 6410243

duration: 0:00:11.688117

exit_message:

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

id: 6410243

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_tests/2026-04-07/1775538748",
        "key": "raw/sparefoot_tests/2026-04-07/1775538748/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16337920623722199838,
        "service_name": "sparefoot",
        "span_id": 2540948177152456897,
        "trace_id": 16337920623722199838
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-07 00:12:38
success: True
trace_id: 16337920623722199838

Scan 6409695

duration: 0:00:14.191640

exit_message:

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

id: 6409695

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_tests/2026-04-06/1775452098",
        "key": "raw/sparefoot_tests/2026-04-06/1775452098/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 94028446536548045,
        "service_name": "sparefoot",
        "span_id": 17820851797900540701,
        "trace_id": 94028446536548045
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-06 00:08:23
success: True
trace_id: 94028446536548045

Scan 6409284

duration: 0:00:14.235510

exit_message:

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

id: 6409284

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_tests/2026-04-05/1775365533",
        "key": "raw/sparefoot_tests/2026-04-05/1775365533/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15048272045367535802,
        "service_name": "sparefoot",
        "span_id": 4178475346874792615,
        "trace_id": 15048272045367535802
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-05 00:05:37
success: True
trace_id: 15048272045367535802

Scan 6408951

duration: 0:00:14.318760

exit_message:

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

id: 6408951

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_tests/2026-04-04/1775279529",
        "key": "raw/sparefoot_tests/2026-04-04/1775279529/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13725135980890478247,
        "service_name": "sparefoot",
        "span_id": 13713430295167095266,
        "trace_id": 13725135980890478247
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-04 00:12:19
success: True
trace_id: 13725135980890478247

Scan 6408434

duration: 0:00:11.581088

exit_message:

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

id: 6408434

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_tests/2026-04-03/1775192960",
        "key": "raw/sparefoot_tests/2026-04-03/1775192960/tests.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_tests",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11447675272788969063,
        "service_name": "sparefoot",
        "span_id": 5250162059028978000,
        "trace_id": 11447675272788969063
    }
}

running: False
schema_name_id: 1392
start_time: 2026-04-03 00:09:23
success: True
trace_id: 11447675272788969063

Partitions:

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

Schema:

attributes:

{
    "end_time": "timestamp",
    "label": "string",
    "start_time": "timestamp",
    "summary": "string",
    "test_id": "int"
}

created: 2026-04-17 00:35:33

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_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-17/1776404115'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
}

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:59:42",
        "disabled": false,
        "format": "raw",
        "id": 1392,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_tests"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "end_time": "timestamp",
            "label": "string",
            "start_time": "timestamp",
            "summary": "string",
            "test_id": "int"
        },
        "created": "2026-04-17 00:35:33",
        "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_tests`\n(\n `end_time`  timestamp , `label`  string , `start_time`  timestamp , `summary`  string , `test_id`  int \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_tests/2026-04-17/1776404115'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tests`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tests"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}