Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_account_modifiers

created: 2022-08-12 10:33:18
disabled: False
format: raw
id: 1365
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906577

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-17/1776404121'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-17/1776404121
id: 906577
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6415145
updated: 2026-04-17 00:35:52

Version 906343

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-16/1776316254'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-16/1776316254
id: 906343
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6414578
updated: 2026-04-16 00:11:13

Version 906116

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-15/1776229783'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-15/1776229783
id: 906116
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6414077
updated: 2026-04-15 00:10:09

Version 905916

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-14/1776143511'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-14/1776143511
id: 905916
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6413584
updated: 2026-04-14 00:12:19

Version 905707

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-13/1776057479'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-13/1776057479
id: 905707
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6413042
updated: 2026-04-13 00:18:14

Version 905502

created: 2026-04-12 00:11:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-12/1775970676'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-12/1775970676
id: 905502
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6412654
updated: 2026-04-12 00:11:37

Version 905304

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-11/1775884359'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-11/1775884359
id: 905304
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6412277
updated: 2026-04-11 00:13:03

Version 905070

created: 2026-04-10 00:08:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-10/1775797713'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-10/1775797713
id: 905070
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6411751
updated: 2026-04-10 00:08:51

Version 904837

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-09/1775711426'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-09/1775711426
id: 904837
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6411221
updated: 2026-04-09 00:11:00

Version 904647

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-08/1775625109'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-08/1775625109
id: 904647
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6410744
updated: 2026-04-08 00:12:21

Version 904417

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-07/1775538495'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-07/1775538495
id: 904417
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6410219
updated: 2026-04-07 00:08:38

Version 904192

created: 2026-04-06 00:04:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-06/1775451882'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-06/1775451882
id: 904192
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6409663
updated: 2026-04-06 00:05:03

Version 904004

created: 2026-04-05 00:07:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-05/1775365646'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-05/1775365646
id: 904004
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6409298
updated: 2026-04-05 00:07:43

Version 903821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-04/1775279407'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-04/1775279407
id: 903821
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6408937
updated: 2026-04-04 00:10:27

Version 903597

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-03/1775192938'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_account_modifiers/2026-04-03/1775192938
id: 903597
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1365
schema_scan_id: 6408430
updated: 2026-04-03 00:09:15

Schema Scans: 15

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

Scan 6415145

duration: 0:00:14.212799

exit_message:

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

id: 6415145

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_account_modifiers/2026-04-17/1776404121",
        "key": "raw/sparefoot_account_modifiers/2026-04-17/1776404121/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16330736854341073399,
        "service_name": "sparefoot",
        "span_id": 10080688538966957023,
        "trace_id": 16330736854341073399
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-17 00:35:38
success: True
trace_id: 16330736854341073399

Scan 6414578

duration: 0:00:14.290044

exit_message:

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

id: 6414578

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_account_modifiers/2026-04-16/1776316254",
        "key": "raw/sparefoot_account_modifiers/2026-04-16/1776316254/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10758423055720936901,
        "service_name": "sparefoot",
        "span_id": 4966581424318902180,
        "trace_id": 10758423055720936901
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-16 00:10:59
success: True
trace_id: 10758423055720936901

Scan 6414077

duration: 0:00:14.316270

exit_message:

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

id: 6414077

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_account_modifiers/2026-04-15/1776229783",
        "key": "raw/sparefoot_account_modifiers/2026-04-15/1776229783/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18185678226459110051,
        "service_name": "sparefoot",
        "span_id": 6354564553235963190,
        "trace_id": 18185678226459110051
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-15 00:09:54
success: True
trace_id: 18185678226459110051

Scan 6413584

duration: 0:00:11.771156

exit_message:

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

id: 6413584

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_account_modifiers/2026-04-14/1776143511",
        "key": "raw/sparefoot_account_modifiers/2026-04-14/1776143511/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13591752930302431335,
        "service_name": "sparefoot",
        "span_id": 18325505722593126576,
        "trace_id": 13591752930302431335
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-14 00:12:07
success: True
trace_id: 13591752930302431335

Scan 6413042

duration: 0:00:11.749776

exit_message:

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

id: 6413042

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_account_modifiers/2026-04-13/1776057479",
        "key": "raw/sparefoot_account_modifiers/2026-04-13/1776057479/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17483188031616250898,
        "service_name": "sparefoot",
        "span_id": 8871464555774572681,
        "trace_id": 17483188031616250898
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-13 00:18:02
success: True
trace_id: 17483188031616250898

Scan 6412654

duration: 0:00:14.277655

exit_message:

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

id: 6412654

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_account_modifiers/2026-04-12/1775970676",
        "key": "raw/sparefoot_account_modifiers/2026-04-12/1775970676/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 634577657560057380,
        "service_name": "sparefoot",
        "span_id": 6310883054744651823,
        "trace_id": 634577657560057380
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-12 00:11:22
success: True
trace_id: 634577657560057380

Scan 6412277

duration: 0:00:14.083216

exit_message:

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

id: 6412277

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_account_modifiers/2026-04-11/1775884359",
        "key": "raw/sparefoot_account_modifiers/2026-04-11/1775884359/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15143294453919782104,
        "service_name": "sparefoot",
        "span_id": 363342275676575525,
        "trace_id": 15143294453919782104
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-11 00:12:49
success: True
trace_id: 15143294453919782104

Scan 6411751

duration: 0:00:14.194980

exit_message:

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

id: 6411751

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_account_modifiers/2026-04-10/1775797713",
        "key": "raw/sparefoot_account_modifiers/2026-04-10/1775797713/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14203164804703553759,
        "service_name": "sparefoot",
        "span_id": 12458143661651108457,
        "trace_id": 14203164804703553759
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-10 00:08:37
success: True
trace_id: 14203164804703553759

Scan 6411221

duration: 0:00:11.759851

exit_message:

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

id: 6411221

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_account_modifiers/2026-04-09/1775711426",
        "key": "raw/sparefoot_account_modifiers/2026-04-09/1775711426/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2296749282971802489,
        "service_name": "sparefoot",
        "span_id": 2092513120541838299,
        "trace_id": 2296749282971802489
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-09 00:10:48
success: True
trace_id: 2296749282971802489

Scan 6410744

duration: 0:00:11.716317

exit_message:

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

id: 6410744

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_account_modifiers/2026-04-08/1775625109",
        "key": "raw/sparefoot_account_modifiers/2026-04-08/1775625109/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15533486108539352511,
        "service_name": "sparefoot",
        "span_id": 3030923519454556785,
        "trace_id": 15533486108539352511
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-08 00:12:09
success: True
trace_id: 15533486108539352511

Scan 6410219

duration: 0:00:14.106594

exit_message:

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

id: 6410219

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_account_modifiers/2026-04-07/1775538495",
        "key": "raw/sparefoot_account_modifiers/2026-04-07/1775538495/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9233802564335976894,
        "service_name": "sparefoot",
        "span_id": 8962178630856518237,
        "trace_id": 9233802564335976894
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-07 00:08:24
success: True
trace_id: 9233802564335976894

Scan 6409663

duration: 0:00:14.224454

exit_message:

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

id: 6409663

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_account_modifiers/2026-04-06/1775451882",
        "key": "raw/sparefoot_account_modifiers/2026-04-06/1775451882/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4363634340613479191,
        "service_name": "sparefoot",
        "span_id": 8369256209509328164,
        "trace_id": 4363634340613479191
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-06 00:04:48
success: True
trace_id: 4363634340613479191

Scan 6409298

duration: 0:00:11.770865

exit_message:

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

id: 6409298

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_account_modifiers/2026-04-05/1775365646",
        "key": "raw/sparefoot_account_modifiers/2026-04-05/1775365646/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5504499987231010448,
        "service_name": "sparefoot",
        "span_id": 8661797812414227038,
        "trace_id": 5504499987231010448
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-05 00:07:32
success: True
trace_id: 5504499987231010448

Scan 6408937

duration: 0:00:14.117216

exit_message:

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

id: 6408937

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_account_modifiers/2026-04-04/1775279407",
        "key": "raw/sparefoot_account_modifiers/2026-04-04/1775279407/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4254519231161990730,
        "service_name": "sparefoot",
        "span_id": 1148416649038463723,
        "trace_id": 4254519231161990730
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-04 00:10:13
success: True
trace_id: 4254519231161990730

Scan 6408430

duration: 0:00:11.672277

exit_message:

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

id: 6408430

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_account_modifiers/2026-04-03/1775192938",
        "key": "raw/sparefoot_account_modifiers/2026-04-03/1775192938/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12513538232913925582,
        "service_name": "sparefoot",
        "span_id": 4090335726882989759,
        "trace_id": 12513538232913925582
    }
}

running: False
schema_name_id: 1365
start_time: 2026-04-03 00:09:03
success: True
trace_id: 12513538232913925582

Partitions:

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

Schema:

attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

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

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_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-17/1776404121'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-12 10:33:18",
        "disabled": false,
        "format": "raw",
        "id": 1365,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_account_modifiers"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "active": "smallint",
            "created_at": "timestamp",
            "modifier_name": "string",
            "modifier_value": "double",
            "updated_at": "timestamp"
        },
        "created": "2026-04-17 00:35:39",
        "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_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  timestamp \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_account_modifiers/2026-04-17/1776404121'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_account_modifiers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_account_modifiers"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}