Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_account_modifiers

created: 2022-08-18 17:15:47
disabled: False
format: raw
id: 1086
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718384

created: 2026-04-17 14:13:27

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-17/1776453200
id: 1718384
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: 1086
schema_scan_id: 162193987
updated: 2026-04-17 14:13:41

Version 1718202

created: 2026-04-17 09:22:15

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-17/1776435732
id: 1718202
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: 1086
schema_scan_id: 162178298
updated: 2026-04-17 09:22:29

Version 1717430

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-17/1776402379
id: 1717430
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: 1086
schema_scan_id: 162163561
updated: 2026-04-17 00:06:39

Version 1717312

created: 2026-04-16 20:15:35

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-16/1776388339
id: 1717312
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: 1086
schema_scan_id: 162156031
updated: 2026-04-16 20:15:49

Version 1717170

created: 2026-04-16 14:16:19

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-16/1776366959
id: 1717170
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: 1086
schema_scan_id: 162138078
updated: 2026-04-16 14:16:32

Version 1716987

created: 2026-04-16 09:11:33

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-16/1776348690
id: 1716987
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: 1086
schema_scan_id: 162122514
updated: 2026-04-16 09:11:47

Version 1716205

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-16/1776316134
id: 1716205
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: 1086
schema_scan_id: 162107781
updated: 2026-04-16 00:09:30

Version 1716105

created: 2026-04-15 20:22:28

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-15/1776302530
id: 1716105
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: 1086
schema_scan_id: 162100318
updated: 2026-04-15 20:22:40

Version 1715948

created: 2026-04-15 14:11:42

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-15/1776280285
id: 1715948
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: 1086
schema_scan_id: 162081673
updated: 2026-04-15 14:11:56

Version 1715795

created: 2026-04-15 08:45:52

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-15/1776260525
id: 1715795
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: 1086
schema_scan_id: 162064580
updated: 2026-04-15 08:46:03

Version 1714996

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-15/1776229671
id: 1714996
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: 1086
schema_scan_id: 162051928
updated: 2026-04-15 00:08:09

Version 1714877

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-14/1776215486
id: 1714877
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: 1086
schema_scan_id: 162044225
updated: 2026-04-14 20:12:20

Version 1714743

created: 2026-04-14 14:16:28

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-14/1776194149
id: 1714743
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: 1086
schema_scan_id: 162026129
updated: 2026-04-14 14:16:42

Version 1714543

created: 2026-04-14 08:54:56

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-14/1776174893
id: 1714543
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: 1086
schema_scan_id: 162009398
updated: 2026-04-14 08:55:07

Version 1713824

created: 2026-04-14 00:14:35

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_modifiers/2026-04-14/1776143671
id: 1713824
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: 1086
schema_scan_id: 161996366
updated: 2026-04-14 00:14:48

Schema Scans: 15

Last at 2026-04-17 14:13:27

Scan 162193987

duration: 0:00:14.206736

exit_message:

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

id: 162193987

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

running: False
schema_name_id: 1086
start_time: 2026-04-17 14:13:27
success: True
trace_id: 151109940833207441

Scan 162178298

duration: 0:00:14.295683

exit_message:

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

id: 162178298

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

running: False
schema_name_id: 1086
start_time: 2026-04-17 09:22:15
success: True
trace_id: 15329109096287304981

Scan 162163561

duration: 0:00:14.208192

exit_message:

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

id: 162163561

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

running: False
schema_name_id: 1086
start_time: 2026-04-17 00:06:25
success: True
trace_id: 9168963395027344028

Scan 162156031

duration: 0:00:14.539381

exit_message:

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

id: 162156031

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

running: False
schema_name_id: 1086
start_time: 2026-04-16 20:15:35
success: True
trace_id: 13875873271402231526

Scan 162138078

duration: 0:00:14.179991

exit_message:

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

id: 162138078

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

running: False
schema_name_id: 1086
start_time: 2026-04-16 14:16:18
success: True
trace_id: 17917660397128791757

Scan 162122514

duration: 0:00:14.332449

exit_message:

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

id: 162122514

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

running: False
schema_name_id: 1086
start_time: 2026-04-16 09:11:33
success: True
trace_id: 6237313313123251046

Scan 162107781

duration: 0:00:14.120511

exit_message:

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

id: 162107781

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

running: False
schema_name_id: 1086
start_time: 2026-04-16 00:09:16
success: True
trace_id: 6561497149799248115

Scan 162100318

duration: 0:00:11.593720

exit_message:

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

id: 162100318

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

running: False
schema_name_id: 1086
start_time: 2026-04-15 20:22:28
success: True
trace_id: 4196664330111311637

Scan 162081673

duration: 0:00:14.237281

exit_message:

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

id: 162081673

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

running: False
schema_name_id: 1086
start_time: 2026-04-15 14:11:41
success: True
trace_id: 11745025237368080365

Scan 162064580

duration: 0:00:11.591706

exit_message:

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

id: 162064580

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

running: False
schema_name_id: 1086
start_time: 2026-04-15 08:45:52
success: True
trace_id: 10771422987891657586

Scan 162051928

duration: 0:00:14.414182

exit_message:

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

id: 162051928

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

running: False
schema_name_id: 1086
start_time: 2026-04-15 00:07:54
success: True
trace_id: 10051900602784125253

Scan 162044225

duration: 0:00:14.279612

exit_message:

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

id: 162044225

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

running: False
schema_name_id: 1086
start_time: 2026-04-14 20:12:06
success: True
trace_id: 16935823293942811993

Scan 162026129

duration: 0:00:14.180431

exit_message:

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

id: 162026129

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

running: False
schema_name_id: 1086
start_time: 2026-04-14 14:16:28
success: True
trace_id: 3040111917838356182

Scan 162009398

duration: 0:00:11.608936

exit_message:

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

id: 162009398

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

running: False
schema_name_id: 1086
start_time: 2026-04-14 08:54:56
success: True
trace_id: 362227412637545227

Scan 161996366

duration: 0:00:14.245428

exit_message:

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

id: 161996366

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

running: False
schema_name_id: 1086
start_time: 2026-04-14 00:14:34
success: True
trace_id: 4572399910328078055

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 14:13:27

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_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-prod/raw/sparefoot_account_modifiers/2026-04-17/1776453200'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_modifiers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_modifiers"
}

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:15:47",
        "disabled": false,
        "format": "raw",
        "id": 1086,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:13:27",
        "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_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-prod/raw/sparefoot_account_modifiers/2026-04-17/1776453200'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_modifiers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_modifiers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}