Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_test_variations

created: 2022-08-12 11:00:15
disabled: False
format: raw
id: 1395
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906528

created: 2026-04-17 00:06:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-17/1776402413'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-17/1776402413
id: 906528
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6415093
updated: 2026-04-17 00:07:08

Version 906364

created: 2026-04-16 00:13:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-16/1776316345'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-16/1776316345
id: 906364
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6414601
updated: 2026-04-16 00:13:23

Version 906129

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-15/1776229929'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-15/1776229929
id: 906129
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6414092
updated: 2026-04-15 00:12:27

Version 905922

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-14/1776143548'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-14/1776143548
id: 905922
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6413590
updated: 2026-04-14 00:12:45

Version 905660

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-13/1776056910'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-13/1776056910
id: 905660
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6412988
updated: 2026-04-13 00:08:44

Version 905476

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-12/1775970471'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-12/1775970471
id: 905476
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6412626
updated: 2026-04-12 00:08:12

Version 905270

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-11/1775884023'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-11/1775884023
id: 905270
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6412241
updated: 2026-04-11 00:07:28

Version 905078

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-10/1775797795'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-10/1775797795
id: 905078
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6411760
updated: 2026-04-10 00:10:15

Version 904885

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-09/1775711743'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-09/1775711743
id: 904885
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6411273
updated: 2026-04-09 00:16:29

Version 904633

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-08/1775624848'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-08/1775624848
id: 904633
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6410728
updated: 2026-04-08 00:07:50

Version 904442

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-07/1775538766'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-07/1775538766
id: 904442
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6410246
updated: 2026-04-07 00:13:09

Version 904223

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-06/1775452103'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-06/1775452103
id: 904223
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6409696
updated: 2026-04-06 00:08:46

Version 903992

created: 2026-04-05 00:05:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-05/1775365541'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-05/1775365541
id: 903992
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6409285
updated: 2026-04-05 00:06:00

Version 903838

created: 2026-04-04 00:12:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-04/1775279546'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-04/1775279546
id: 903838
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6408955
updated: 2026-04-04 00:12:47

Version 903602

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_test_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-03/1775192964'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_test_variations/2026-04-03/1775192964
id: 903602
processed: 1

raw_data:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int32",
    "test_id": "int32",
    "variation_id": "int32"
}

schema_attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

schema_name_id: 1395
schema_scan_id: 6408435
updated: 2026-04-03 00:09:42

Schema Scans: 15

Last at 2026-04-17 00:06:56

Scan 6415093

duration: 0:00:11.624358

exit_message:

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

id: 6415093

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_variations/2026-04-17/1776402413",
        "key": "raw/sparefoot_test_variations/2026-04-17/1776402413/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15724714417516019647,
        "service_name": "sparefoot",
        "span_id": 3413731563065617337,
        "trace_id": 15724714417516019647
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-17 00:06:56
success: True
trace_id: 15724714417516019647

Scan 6414601

duration: 0:00:14.187402

exit_message:

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

id: 6414601

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_variations/2026-04-16/1776316345",
        "key": "raw/sparefoot_test_variations/2026-04-16/1776316345/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8473343234641096083,
        "service_name": "sparefoot",
        "span_id": 14837399025529087589,
        "trace_id": 8473343234641096083
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-16 00:13:09
success: True
trace_id: 8473343234641096083

Scan 6414092

duration: 0:00:14.248404

exit_message:

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

id: 6414092

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_variations/2026-04-15/1776229929",
        "key": "raw/sparefoot_test_variations/2026-04-15/1776229929/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1950279833594880461,
        "service_name": "sparefoot",
        "span_id": 13977682958236174745,
        "trace_id": 1950279833594880461
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-15 00:12:13
success: True
trace_id: 1950279833594880461

Scan 6413590

duration: 0:00:14.157629

exit_message:

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

id: 6413590

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_variations/2026-04-14/1776143548",
        "key": "raw/sparefoot_test_variations/2026-04-14/1776143548/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5166812518269267535,
        "service_name": "sparefoot",
        "span_id": 15826719807468323030,
        "trace_id": 5166812518269267535
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-14 00:12:31
success: True
trace_id: 5166812518269267535

Scan 6412988

duration: 0:00:11.635257

exit_message:

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

id: 6412988

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_variations/2026-04-13/1776056910",
        "key": "raw/sparefoot_test_variations/2026-04-13/1776056910/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13078156745036232858,
        "service_name": "sparefoot",
        "span_id": 1614709534635402342,
        "trace_id": 13078156745036232858
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-13 00:08:32
success: True
trace_id: 13078156745036232858

Scan 6412626

duration: 0:00:11.664745

exit_message:

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

id: 6412626

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_variations/2026-04-12/1775970471",
        "key": "raw/sparefoot_test_variations/2026-04-12/1775970471/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7012476245019288358,
        "service_name": "sparefoot",
        "span_id": 12737886583734920387,
        "trace_id": 7012476245019288358
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-12 00:08:00
success: True
trace_id: 7012476245019288358

Scan 6412241

duration: 0:00:14.149621

exit_message:

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

id: 6412241

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_variations/2026-04-11/1775884023",
        "key": "raw/sparefoot_test_variations/2026-04-11/1775884023/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2848641000336635161,
        "service_name": "sparefoot",
        "span_id": 17011216617206879656,
        "trace_id": 2848641000336635161
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-11 00:07:14
success: True
trace_id: 2848641000336635161

Scan 6411760

duration: 0:00:11.679891

exit_message:

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

id: 6411760

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_variations/2026-04-10/1775797795",
        "key": "raw/sparefoot_test_variations/2026-04-10/1775797795/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13214313226326101580,
        "service_name": "sparefoot",
        "span_id": 4838936525462954666,
        "trace_id": 13214313226326101580
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-10 00:10:03
success: True
trace_id: 13214313226326101580

Scan 6411273

duration: 0:00:14.240450

exit_message:

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

id: 6411273

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_variations/2026-04-09/1775711743",
        "key": "raw/sparefoot_test_variations/2026-04-09/1775711743/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17686621378820437793,
        "service_name": "sparefoot",
        "span_id": 17211143584453045380,
        "trace_id": 17686621378820437793
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-09 00:16:15
success: True
trace_id: 17686621378820437793

Scan 6410728

duration: 0:00:14.186642

exit_message:

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

id: 6410728

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_variations/2026-04-08/1775624848",
        "key": "raw/sparefoot_test_variations/2026-04-08/1775624848/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2898030265332818796,
        "service_name": "sparefoot",
        "span_id": 15426493903030195059,
        "trace_id": 2898030265332818796
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-08 00:07:36
success: True
trace_id: 2898030265332818796

Scan 6410246

duration: 0:00:14.115390

exit_message:

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

id: 6410246

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_variations/2026-04-07/1775538766",
        "key": "raw/sparefoot_test_variations/2026-04-07/1775538766/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12790196007183599787,
        "service_name": "sparefoot",
        "span_id": 10091279472889642748,
        "trace_id": 12790196007183599787
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-07 00:12:55
success: True
trace_id: 12790196007183599787

Scan 6409696

duration: 0:00:14.197222

exit_message:

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

id: 6409696

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_variations/2026-04-06/1775452103",
        "key": "raw/sparefoot_test_variations/2026-04-06/1775452103/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 106871090390680394,
        "service_name": "sparefoot",
        "span_id": 4017819966791218474,
        "trace_id": 106871090390680394
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-06 00:08:31
success: True
trace_id: 106871090390680394

Scan 6409285

duration: 0:00:14.197319

exit_message:

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

id: 6409285

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_variations/2026-04-05/1775365541",
        "key": "raw/sparefoot_test_variations/2026-04-05/1775365541/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18388398964555969109,
        "service_name": "sparefoot",
        "span_id": 17500334088312139980,
        "trace_id": 18388398964555969109
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-05 00:05:46
success: True
trace_id: 18388398964555969109

Scan 6408955

duration: 0:00:14.202025

exit_message:

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

id: 6408955

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_variations/2026-04-04/1775279546",
        "key": "raw/sparefoot_test_variations/2026-04-04/1775279546/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14609735617256683147,
        "service_name": "sparefoot",
        "span_id": 10679780349822632290,
        "trace_id": 14609735617256683147
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-04 00:12:33
success: True
trace_id: 14609735617256683147

Scan 6408435

duration: 0:00:14.345542

exit_message:

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

id: 6408435

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_variations/2026-04-03/1775192964",
        "key": "raw/sparefoot_test_variations/2026-04-03/1775192964/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 618806211760598850,
        "service_name": "sparefoot",
        "span_id": 18301245602993341362,
        "trace_id": 618806211760598850
    }
}

running: False
schema_name_id: 1395
start_time: 2026-04-03 00:09:27
success: True
trace_id: 618806211760598850

Partitions:

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

Schema:

attributes:

{
    "distribution": "double",
    "label": "string",
    "phone_group_id": "int",
    "test_id": "int",
    "variation_id": "int"
}

created: 2026-04-17 00:06:57

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_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-17/1776402413'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
}

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:00:15",
        "disabled": false,
        "format": "raw",
        "id": 1395,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_test_variations"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "distribution": "double",
            "label": "string",
            "phone_group_id": "int",
            "test_id": "int",
            "variation_id": "int"
        },
        "created": "2026-04-17 00:06:57",
        "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_variations`\n(\n `distribution`  double , `label`  string , `phone_group_id`  int , `test_id`  int , `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_variations/2026-04-17/1776402413'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_test_variations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_test_variations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}