Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_test_variations

created: 2022-08-18 17:21:12
disabled: False
format: raw
id: 1112
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718396

created: 2026-04-17 14:15:46

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-17/1776453343
id: 1718396
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: 1112
schema_scan_id: 162194012
updated: 2026-04-17 14:16:00

Version 1718188

created: 2026-04-17 09:11:18

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-17/1776435073
id: 1718188
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: 1112
schema_scan_id: 162178203
updated: 2026-04-17 09:11:32

Version 1717463

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-17/1776402776
id: 1717463
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: 1112
schema_scan_id: 162163621
updated: 2026-04-17 00:13:28

Version 1717319

created: 2026-04-16 20:16:24

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776388571
id: 1717319
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: 1112
schema_scan_id: 162156048
updated: 2026-04-16 20:16:38

Version 1717146

created: 2026-04-16 14:14:50

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776366852
id: 1717146
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: 1112
schema_scan_id: 162138024
updated: 2026-04-16 14:15:04

Version 1716968

created: 2026-04-16 09:08:35

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776348512
id: 1716968
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: 1112
schema_scan_id: 162122488
updated: 2026-04-16 09:08:46

Version 1716228

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776316479
id: 1716228
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: 1112
schema_scan_id: 162107808
updated: 2026-04-16 00:14:56

Version 1716118

created: 2026-04-15 20:25:25

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776302719
id: 1716118
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: 1112
schema_scan_id: 162100336
updated: 2026-04-15 20:25:37

Version 1715986

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776280716
id: 1715986
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: 1112
schema_scan_id: 162081795
updated: 2026-04-15 14:18:52

Version 1715751

created: 2026-04-15 08:39:14

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776260269
id: 1715751
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: 1112
schema_scan_id: 162064376
updated: 2026-04-15 08:39:28

Version 1715020

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776230185
id: 1715020
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: 1112
schema_scan_id: 162051981
updated: 2026-04-15 00:16:49

Version 1714882

created: 2026-04-14 20:12:43

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776215464
id: 1714882
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: 1112
schema_scan_id: 162044231
updated: 2026-04-14 20:12:55

Version 1714746

created: 2026-04-14 14:16:43

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776194131
id: 1714746
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: 1112
schema_scan_id: 162026134
updated: 2026-04-14 14:16:54

Version 1714565

created: 2026-04-14 09:02:27

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776175342
id: 1714565
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: 1112
schema_scan_id: 162010648
updated: 2026-04-14 09:02:41

Version 1713820

created: 2026-04-14 00:14:09

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776143644
id: 1713820
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: 1112
schema_scan_id: 161996359
updated: 2026-04-14 00:14:20

Schema Scans: 15

Last at 2026-04-17 14:15:46

Scan 162194012

duration: 0:00:14.302856

exit_message:

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

id: 162194012

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-17/1776453343",
        "key": "raw/sparefoot_test_variations/2026-04-17/1776453343/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4083349252965709398,
        "service_name": "sparefoot",
        "span_id": 13963142645976962756,
        "trace_id": 4083349252965709398
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-17 14:15:46
success: True
trace_id: 4083349252965709398

Scan 162178203

duration: 0:00:14.172945

exit_message:

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

id: 162178203

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-17/1776435073",
        "key": "raw/sparefoot_test_variations/2026-04-17/1776435073/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 561377213475359960,
        "service_name": "sparefoot",
        "span_id": 11959794153281034384,
        "trace_id": 561377213475359960
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-17 09:11:18
success: True
trace_id: 561377213475359960

Scan 162163621

duration: 0:00:11.633061

exit_message:

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

id: 162163621

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-17/1776402776",
        "key": "raw/sparefoot_test_variations/2026-04-17/1776402776/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5830699224517757823,
        "service_name": "sparefoot",
        "span_id": 15207694499892705667,
        "trace_id": 5830699224517757823
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-17 00:13:16
success: True
trace_id: 5830699224517757823

Scan 162156048

duration: 0:00:14.146023

exit_message:

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

id: 162156048

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776388571",
        "key": "raw/sparefoot_test_variations/2026-04-16/1776388571/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14093088102133890826,
        "service_name": "sparefoot",
        "span_id": 12447792383828960083,
        "trace_id": 14093088102133890826
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-16 20:16:24
success: True
trace_id: 14093088102133890826

Scan 162138024

duration: 0:00:14.167615

exit_message:

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

id: 162138024

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776366852",
        "key": "raw/sparefoot_test_variations/2026-04-16/1776366852/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9254132390145325138,
        "service_name": "sparefoot",
        "span_id": 8097761966458304418,
        "trace_id": 9254132390145325138
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-16 14:14:50
success: True
trace_id: 9254132390145325138

Scan 162122488

duration: 0:00:11.625453

exit_message:

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

id: 162122488

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776348512",
        "key": "raw/sparefoot_test_variations/2026-04-16/1776348512/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12080173898075801372,
        "service_name": "sparefoot",
        "span_id": 10424727902935303470,
        "trace_id": 12080173898075801372
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-16 09:08:35
success: True
trace_id: 12080173898075801372

Scan 162107808

duration: 0:00:14.113415

exit_message:

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

id: 162107808

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-16/1776316479",
        "key": "raw/sparefoot_test_variations/2026-04-16/1776316479/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1471894906117159953,
        "service_name": "sparefoot",
        "span_id": 9670710257499138035,
        "trace_id": 1471894906117159953
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-16 00:14:42
success: True
trace_id: 1471894906117159953

Scan 162100336

duration: 0:00:11.725081

exit_message:

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

id: 162100336

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776302719",
        "key": "raw/sparefoot_test_variations/2026-04-15/1776302719/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3732214673035397490,
        "service_name": "sparefoot",
        "span_id": 10465164472627206432,
        "trace_id": 3732214673035397490
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-15 20:25:25
success: True
trace_id: 3732214673035397490

Scan 162081795

duration: 0:00:14.079789

exit_message:

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

id: 162081795

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776280716",
        "key": "raw/sparefoot_test_variations/2026-04-15/1776280716/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1059309366499741068,
        "service_name": "sparefoot",
        "span_id": 18178509797200241692,
        "trace_id": 1059309366499741068
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-15 14:18:38
success: True
trace_id: 1059309366499741068

Scan 162064376

duration: 0:00:14.120163

exit_message:

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

id: 162064376

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776260269",
        "key": "raw/sparefoot_test_variations/2026-04-15/1776260269/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18325238969740570814,
        "service_name": "sparefoot",
        "span_id": 8192443685711899978,
        "trace_id": 18325238969740570814
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-15 08:39:14
success: True
trace_id: 18325238969740570814

Scan 162051981

duration: 0:00:14.285497

exit_message:

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

id: 162051981

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-15/1776230185",
        "key": "raw/sparefoot_test_variations/2026-04-15/1776230185/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7140035662785436515,
        "service_name": "sparefoot",
        "span_id": 1940877558500389726,
        "trace_id": 7140035662785436515
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-15 00:16:35
success: True
trace_id: 7140035662785436515

Scan 162044231

duration: 0:00:11.795695

exit_message:

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

id: 162044231

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776215464",
        "key": "raw/sparefoot_test_variations/2026-04-14/1776215464/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2517366247223921390,
        "service_name": "sparefoot",
        "span_id": 2105799790416374758,
        "trace_id": 2517366247223921390
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-14 20:12:43
success: True
trace_id: 2517366247223921390

Scan 162026134

duration: 0:00:11.717061

exit_message:

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

id: 162026134

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776194131",
        "key": "raw/sparefoot_test_variations/2026-04-14/1776194131/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1610436308754381954,
        "service_name": "sparefoot",
        "span_id": 13205231031822452230,
        "trace_id": 1610436308754381954
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-14 14:16:42
success: True
trace_id: 1610436308754381954

Scan 162010648

duration: 0:00:14.234958

exit_message:

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

id: 162010648

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776175342",
        "key": "raw/sparefoot_test_variations/2026-04-14/1776175342/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4682605097073692157,
        "service_name": "sparefoot",
        "span_id": 9217025779854797365,
        "trace_id": 4682605097073692157
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-14 09:02:27
success: True
trace_id: 4682605097073692157

Scan 161996359

duration: 0:00:11.673529

exit_message:

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

id: 161996359

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_test_variations/2026-04-14/1776143644",
        "key": "raw/sparefoot_test_variations/2026-04-14/1776143644/test_variations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_test_variations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3932239815846977192,
        "service_name": "sparefoot",
        "span_id": 16930421279187729756,
        "trace_id": 3932239815846977192
    }
}

running: False
schema_name_id: 1112
start_time: 2026-04-14 00:14:09
success: True
trace_id: 3932239815846977192

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 14:15:46

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_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-prod/raw/sparefoot_test_variations/2026-04-17/1776453343'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_test_variations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_test_variations"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:21:12",
        "disabled": false,
        "format": "raw",
        "id": 1112,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:15:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_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-prod/raw/sparefoot_test_variations/2026-04-17/1776453343'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_test_variations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_test_variations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}