Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_account_software

created: 2022-08-18 17:14:11
disabled: False
format: raw
id: 1077
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718376

created: 2026-04-17 14:10:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-17/1776453017'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-17/1776453017
id: 1718376
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162193968
updated: 2026-04-17 14:10:59

Version 1718212

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-17/1776435777'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-17/1776435777
id: 1718212
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162178308
updated: 2026-04-17 09:23:14

Version 1717436

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-17/1776402371'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-17/1776402371
id: 1717436
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162163568
updated: 2026-04-17 00:07:04

Version 1717337

created: 2026-04-16 20:19:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-16/1776388789'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-16/1776388789
id: 1717337
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162156124
updated: 2026-04-16 20:22:56

Version 1717135

created: 2026-04-16 14:13:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-16/1776366675'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-16/1776366675
id: 1717135
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162138005
updated: 2026-04-16 14:14:09

Version 1716999

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-16/1776348910'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-16/1776348910
id: 1716999
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162122538
updated: 2026-04-16 09:15:25

Version 1716196

created: 2026-04-16 00:07:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-16/1776316037'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-16/1776316037
id: 1716196
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162107755
updated: 2026-04-16 00:08:01

Version 1716090

created: 2026-04-15 20:19:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-15/1776302349'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-15/1776302349
id: 1716090
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162100298
updated: 2026-04-15 20:19:37

Version 1715945

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-15/1776280276'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-15/1776280276
id: 1715945
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162081670
updated: 2026-04-15 14:11:41

Version 1715777

created: 2026-04-15 08:43:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-15/1776260582'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-15/1776260582
id: 1715777
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162064522
updated: 2026-04-15 08:43:45

Version 1714994

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-15/1776229660'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-15/1776229660
id: 1714994
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162051921
updated: 2026-04-15 00:07:59

Version 1714874

created: 2026-04-14 20:11:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-14/1776215464'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-14/1776215464
id: 1714874
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162044222
updated: 2026-04-14 20:12:02

Version 1714749

created: 2026-04-14 14:16:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-14/1776194155'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-14/1776194155
id: 1714749
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162026138
updated: 2026-04-14 14:17:08

Version 1714584

created: 2026-04-14 09:08:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-14/1776175692'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-14/1776175692
id: 1714584
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 162010943
updated: 2026-04-14 09:08:58

Version 1713821

created: 2026-04-14 00:14:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_account_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-14/1776143633'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_account_software/2026-04-14/1776143633
id: 1713821
processed: 1

raw_data:

{
    "account_id": "int32",
    "id": "int32",
    "source_id": "int16",
    "timestamp": "timestamp[ns]",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

schema_name_id: 1077
schema_scan_id: 161996362
updated: 2026-04-14 00:14:30

Schema Scans: 15

Last at 2026-04-17 14:10:45

Scan 162193968

duration: 0:00:14.269410

exit_message:

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

id: 162193968

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_software/2026-04-17/1776453017",
        "key": "raw/sparefoot_account_software/2026-04-17/1776453017/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11652453356282054682,
        "service_name": "sparefoot",
        "span_id": 8647145368167119702,
        "trace_id": 11652453356282054682
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-17 14:10:45
success: True
trace_id: 11652453356282054682

Scan 162178308

duration: 0:00:14.408785

exit_message:

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

id: 162178308

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_software/2026-04-17/1776435777",
        "key": "raw/sparefoot_account_software/2026-04-17/1776435777/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16893639332281969741,
        "service_name": "sparefoot",
        "span_id": 15498630752229569798,
        "trace_id": 16893639332281969741
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-17 09:22:59
success: True
trace_id: 16893639332281969741

Scan 162163568

duration: 0:00:11.641797

exit_message:

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

id: 162163568

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_software/2026-04-17/1776402371",
        "key": "raw/sparefoot_account_software/2026-04-17/1776402371/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4137324843378790813,
        "service_name": "sparefoot",
        "span_id": 9707316244131821548,
        "trace_id": 4137324843378790813
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-17 00:06:53
success: True
trace_id: 4137324843378790813

Scan 162156124

duration: 0:03:04.497191

exit_message:

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

id: 162156124

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_software/2026-04-16/1776388789",
        "key": "raw/sparefoot_account_software/2026-04-16/1776388789/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1340480775194835118,
        "service_name": "sparefoot",
        "span_id": 8589260461762712364,
        "trace_id": 1340480775194835118
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-16 20:19:51
success: True
trace_id: 1340480775194835118

Scan 162138005

duration: 0:00:11.598704

exit_message:

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

id: 162138005

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_software/2026-04-16/1776366675",
        "key": "raw/sparefoot_account_software/2026-04-16/1776366675/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 219839077342692326,
        "service_name": "sparefoot",
        "span_id": 5108395228991628729,
        "trace_id": 219839077342692326
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-16 14:13:58
success: True
trace_id: 219839077342692326

Scan 162122538

duration: 0:00:11.622986

exit_message:

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

id: 162122538

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_software/2026-04-16/1776348910",
        "key": "raw/sparefoot_account_software/2026-04-16/1776348910/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15313014310040927146,
        "service_name": "sparefoot",
        "span_id": 6628856583166956979,
        "trace_id": 15313014310040927146
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-16 09:15:13
success: True
trace_id: 15313014310040927146

Scan 162107755

duration: 0:00:14.250714

exit_message:

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

id: 162107755

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_software/2026-04-16/1776316037",
        "key": "raw/sparefoot_account_software/2026-04-16/1776316037/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6003597383279583364,
        "service_name": "sparefoot",
        "span_id": 10174597498045832990,
        "trace_id": 6003597383279583364
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-16 00:07:47
success: True
trace_id: 6003597383279583364

Scan 162100298

duration: 0:00:14.229137

exit_message:

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

id: 162100298

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_software/2026-04-15/1776302349",
        "key": "raw/sparefoot_account_software/2026-04-15/1776302349/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3420941422728172936,
        "service_name": "sparefoot",
        "span_id": 3020372735595407441,
        "trace_id": 3420941422728172936
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-15 20:19:23
success: True
trace_id: 3420941422728172936

Scan 162081670

duration: 0:00:14.278851

exit_message:

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

id: 162081670

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_software/2026-04-15/1776280276",
        "key": "raw/sparefoot_account_software/2026-04-15/1776280276/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1221125898908969790,
        "service_name": "sparefoot",
        "span_id": 14124168729187573205,
        "trace_id": 1221125898908969790
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-15 14:11:27
success: True
trace_id: 1221125898908969790

Scan 162064522

duration: 0:00:11.553609

exit_message:

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

id: 162064522

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_software/2026-04-15/1776260582",
        "key": "raw/sparefoot_account_software/2026-04-15/1776260582/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17739918643815807905,
        "service_name": "sparefoot",
        "span_id": 15683283994432957452,
        "trace_id": 17739918643815807905
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-15 08:43:33
success: True
trace_id: 17739918643815807905

Scan 162051921

duration: 0:00:14.356075

exit_message:

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

id: 162051921

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_software/2026-04-15/1776229660",
        "key": "raw/sparefoot_account_software/2026-04-15/1776229660/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3168153665222799051,
        "service_name": "sparefoot",
        "span_id": 9833631076106392472,
        "trace_id": 3168153665222799051
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-15 00:07:45
success: True
trace_id: 3168153665222799051

Scan 162044222

duration: 0:00:11.758196

exit_message:

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

id: 162044222

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_software/2026-04-14/1776215464",
        "key": "raw/sparefoot_account_software/2026-04-14/1776215464/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9441893216294616943,
        "service_name": "sparefoot",
        "span_id": 8729953251940304812,
        "trace_id": 9441893216294616943
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-14 20:11:51
success: True
trace_id: 9441893216294616943

Scan 162026138

duration: 0:00:14.114104

exit_message:

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

id: 162026138

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_software/2026-04-14/1776194155",
        "key": "raw/sparefoot_account_software/2026-04-14/1776194155/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13869166022370633749,
        "service_name": "sparefoot",
        "span_id": 1534614050967487271,
        "trace_id": 13869166022370633749
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-14 14:16:54
success: True
trace_id: 13869166022370633749

Scan 162010943

duration: 0:00:14.162426

exit_message:

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

id: 162010943

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_software/2026-04-14/1776175692",
        "key": "raw/sparefoot_account_software/2026-04-14/1776175692/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10316717116124907468,
        "service_name": "sparefoot",
        "span_id": 1620074065549911646,
        "trace_id": 10316717116124907468
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-14 09:08:44
success: True
trace_id: 10316717116124907468

Scan 161996362

duration: 0:00:11.545691

exit_message:

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

id: 161996362

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_software/2026-04-14/1776143633",
        "key": "raw/sparefoot_account_software/2026-04-14/1776143633/account_software.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_account_software",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4239599354539176406,
        "service_name": "sparefoot",
        "span_id": 15788759158795108459,
        "trace_id": 4239599354539176406
    }
}

running: False
schema_name_id: 1077
start_time: 2026-04-14 00:14:18
success: True
trace_id: 4239599354539176406

Partitions:

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

Schema:

attributes:

{
    "account_id": "int",
    "id": "int",
    "source_id": "smallint",
    "timestamp": "timestamp",
    "user_id": "int"
}

created: 2026-04-17 14:10:45

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_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-17/1776453017'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
}

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:14:11",
        "disabled": false,
        "format": "raw",
        "id": 1077,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_account_software"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "id": "int",
            "source_id": "smallint",
            "timestamp": "timestamp",
            "user_id": "int"
        },
        "created": "2026-04-17 14:10:45",
        "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_software`\n(\n `account_id`  int , `id`  int , `source_id`  smallint , `timestamp`  timestamp , `user_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_account_software/2026-04-17/1776453017'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_account_software`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_account_software"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}