Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_test_tracking

created: 2022-08-12 11:01:20
disabled: False
format: raw
id: 1399
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906537

created: 2026-04-17 00:15:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-17/1776402930'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-17/1776402930
id: 906537
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6415104
updated: 2026-04-17 00:16:12

Version 906341

created: 2026-04-16 00:10:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-16/1776316242'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-16/1776316242
id: 906341
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6414576
updated: 2026-04-16 00:11:04

Version 906128

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-15/1776229914'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-15/1776229914
id: 906128
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6414090
updated: 2026-04-15 00:12:22

Version 905910

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-14/1776143480'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-14/1776143480
id: 905910
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6413576
updated: 2026-04-14 00:11:38

Version 905670

created: 2026-04-13 00:12:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-13/1776057135'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-13/1776057135
id: 905670
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6413001
updated: 2026-04-13 00:12:29

Version 905492

created: 2026-04-12 00:09:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-12/1775970581'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-12/1775970581
id: 905492
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6412643
updated: 2026-04-12 00:10:03

Version 905271

created: 2026-04-11 00:08:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-11/1775884106'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-11/1775884106
id: 905271
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6412242
updated: 2026-04-11 00:08:44

Version 905080

created: 2026-04-10 00:10:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-10/1775797802'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-10/1775797802
id: 905080
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6411762
updated: 2026-04-10 00:10:29

Version 904838

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-09/1775711431'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-09/1775711431
id: 904838
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6411222
updated: 2026-04-09 00:11:08

Version 904636

created: 2026-04-08 00:07:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-08/1775624868'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-08/1775624868
id: 904636
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6410731
updated: 2026-04-08 00:08:03

Version 904453

created: 2026-04-07 00:15:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-07/1775538931'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-07/1775538931
id: 904453
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6410257
updated: 2026-04-07 00:15:46

Version 904194

created: 2026-04-06 00:05:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-06/1775451892'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-06/1775451892
id: 904194
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6409666
updated: 2026-04-06 00:05:14

Version 904016

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-05/1775365736'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-05/1775365736
id: 904016
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6409310
updated: 2026-04-05 00:09:16

Version 903832

created: 2026-04-04 00:12:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-04/1775279524'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-04/1775279524
id: 903832
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6408949
updated: 2026-04-04 00:12:23

Version 903587

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-03/1775192853'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_tracking/2026-04-03/1775192853
id: 903587
processed: 1

raw_data:

{
    "foreign_key": "string",
    "test_id": "int32",
    "timestamp": "timestamp[ns]",
    "type": "string",
    "variation_id": "int32"
}

schema_attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

schema_name_id: 1399
schema_scan_id: 6408420
updated: 2026-04-03 00:07:51

Schema Scans: 15

Last at 2026-04-17 00:15:58

Scan 6415104

duration: 0:00:14.209669

exit_message:

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

id: 6415104

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_test_tracking/2026-04-17/1776402930",
        "key": "raw/sparefoot_test_tracking/2026-04-17/1776402930/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8481165686381607999,
        "service_name": "sparefoot",
        "span_id": 7131809928003234453,
        "trace_id": 8481165686381607999
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-17 00:15:58
success: True
trace_id: 8481165686381607999

Scan 6414576

duration: 0:00:14.296587

exit_message:

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

id: 6414576

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_test_tracking/2026-04-16/1776316242",
        "key": "raw/sparefoot_test_tracking/2026-04-16/1776316242/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17166964503475580557,
        "service_name": "sparefoot",
        "span_id": 7462582297780579811,
        "trace_id": 17166964503475580557
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-16 00:10:50
success: True
trace_id: 17166964503475580557

Scan 6414090

duration: 0:00:14.251735

exit_message:

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

id: 6414090

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_test_tracking/2026-04-15/1776229914",
        "key": "raw/sparefoot_test_tracking/2026-04-15/1776229914/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12180081101730896459,
        "service_name": "sparefoot",
        "span_id": 746616129533418990,
        "trace_id": 12180081101730896459
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-15 00:12:08
success: True
trace_id: 12180081101730896459

Scan 6413576

duration: 0:00:14.194883

exit_message:

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

id: 6413576

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_test_tracking/2026-04-14/1776143480",
        "key": "raw/sparefoot_test_tracking/2026-04-14/1776143480/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5028282080108653358,
        "service_name": "sparefoot",
        "span_id": 7868585158718095443,
        "trace_id": 5028282080108653358
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-14 00:11:24
success: True
trace_id: 5028282080108653358

Scan 6413001

duration: 0:00:11.747341

exit_message:

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

id: 6413001

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_test_tracking/2026-04-13/1776057135",
        "key": "raw/sparefoot_test_tracking/2026-04-13/1776057135/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7646039713151678193,
        "service_name": "sparefoot",
        "span_id": 5952104457969203627,
        "trace_id": 7646039713151678193
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-13 00:12:18
success: True
trace_id: 7646039713151678193

Scan 6412643

duration: 0:00:14.184774

exit_message:

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

id: 6412643

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_test_tracking/2026-04-12/1775970581",
        "key": "raw/sparefoot_test_tracking/2026-04-12/1775970581/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5727273520142282523,
        "service_name": "sparefoot",
        "span_id": 17913957018720453731,
        "trace_id": 5727273520142282523
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-12 00:09:49
success: True
trace_id: 5727273520142282523

Scan 6412242

duration: 0:00:11.614253

exit_message:

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

id: 6412242

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_test_tracking/2026-04-11/1775884106",
        "key": "raw/sparefoot_test_tracking/2026-04-11/1775884106/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13774079284694261363,
        "service_name": "sparefoot",
        "span_id": 3122911478625478431,
        "trace_id": 13774079284694261363
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-11 00:08:33
success: True
trace_id: 13774079284694261363

Scan 6411762

duration: 0:00:14.176275

exit_message:

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

id: 6411762

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_test_tracking/2026-04-10/1775797802",
        "key": "raw/sparefoot_test_tracking/2026-04-10/1775797802/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2385533478780413893,
        "service_name": "sparefoot",
        "span_id": 8894094057185358592,
        "trace_id": 2385533478780413893
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-10 00:10:15
success: True
trace_id: 2385533478780413893

Scan 6411222

duration: 0:00:14.291646

exit_message:

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

id: 6411222

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_test_tracking/2026-04-09/1775711431",
        "key": "raw/sparefoot_test_tracking/2026-04-09/1775711431/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18283730507593870076,
        "service_name": "sparefoot",
        "span_id": 10480548255471784276,
        "trace_id": 18283730507593870076
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-09 00:10:54
success: True
trace_id: 18283730507593870076

Scan 6410731

duration: 0:00:11.707364

exit_message:

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

id: 6410731

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_test_tracking/2026-04-08/1775624868",
        "key": "raw/sparefoot_test_tracking/2026-04-08/1775624868/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15048073231169683493,
        "service_name": "sparefoot",
        "span_id": 10330071476008925319,
        "trace_id": 15048073231169683493
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-08 00:07:51
success: True
trace_id: 15048073231169683493

Scan 6410257

duration: 0:00:11.603300

exit_message:

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

id: 6410257

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_test_tracking/2026-04-07/1775538931",
        "key": "raw/sparefoot_test_tracking/2026-04-07/1775538931/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14947209549666195575,
        "service_name": "sparefoot",
        "span_id": 12993648308426426416,
        "trace_id": 14947209549666195575
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-07 00:15:34
success: True
trace_id: 14947209549666195575

Scan 6409666

duration: 0:00:14.260569

exit_message:

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

id: 6409666

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_test_tracking/2026-04-06/1775451892",
        "key": "raw/sparefoot_test_tracking/2026-04-06/1775451892/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1778885356192550478,
        "service_name": "sparefoot",
        "span_id": 8460400453736412983,
        "trace_id": 1778885356192550478
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-06 00:05:00
success: True
trace_id: 1778885356192550478

Scan 6409310

duration: 0:00:14.171149

exit_message:

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

id: 6409310

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_test_tracking/2026-04-05/1775365736",
        "key": "raw/sparefoot_test_tracking/2026-04-05/1775365736/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3014311576537129893,
        "service_name": "sparefoot",
        "span_id": 11999167778802862677,
        "trace_id": 3014311576537129893
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-05 00:09:02
success: True
trace_id: 3014311576537129893

Scan 6408949

duration: 0:00:14.269480

exit_message:

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

id: 6408949

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_test_tracking/2026-04-04/1775279524",
        "key": "raw/sparefoot_test_tracking/2026-04-04/1775279524/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1780135959317578578,
        "service_name": "sparefoot",
        "span_id": 14850443531123988111,
        "trace_id": 1780135959317578578
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-04 00:12:08
success: True
trace_id: 1780135959317578578

Scan 6408420

duration: 0:00:14.260604

exit_message:

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

id: 6408420

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_test_tracking/2026-04-03/1775192853",
        "key": "raw/sparefoot_test_tracking/2026-04-03/1775192853/test_tracking.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_tracking",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1544035958264487984,
        "service_name": "sparefoot",
        "span_id": 7505174112688990029,
        "trace_id": 1544035958264487984
    }
}

running: False
schema_name_id: 1399
start_time: 2026-04-03 00:07:37
success: True
trace_id: 1544035958264487984

Partitions:

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

Schema:

attributes:

{
    "foreign_key": "string",
    "test_id": "int",
    "timestamp": "timestamp",
    "type": "string",
    "variation_id": "int"
}

created: 2026-04-17 00:15:58

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_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-17/1776402930'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
}

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 11:01:20",
        "disabled": false,
        "format": "raw",
        "id": 1399,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_test_tracking"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "foreign_key": "string",
            "test_id": "int",
            "timestamp": "timestamp",
            "type": "string",
            "variation_id": "int"
        },
        "created": "2026-04-17 00:15:58",
        "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_test_tracking`\n(\n `foreign_key`  string , `test_id`  int , `timestamp`  timestamp , `type`  string , `variation_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_test_tracking/2026-04-17/1776402930'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_tracking`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_tracking"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}