Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_user

created: 2022-08-18 18:05:27
disabled: False
format: raw
id: 1150
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718385

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_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-17/1776453194'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-17/1776453194
id: 1718385
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162193986
updated: 2026-04-17 14:13:41

Version 1718236

created: 2026-04-17 09:27:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-17/1776436017'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-17/1776436017
id: 1718236
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162178347
updated: 2026-04-17 09:27:22

Version 1717453

created: 2026-04-17 00:12:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-17/1776402601'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-17/1776402601
id: 1717453
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162163609
updated: 2026-04-17 00:12:40

Version 1717341

created: 2026-04-16 20:23:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-16/1776388786'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-16/1776388786
id: 1717341
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162156134
updated: 2026-04-16 20:23:53

Version 1717138

created: 2026-04-16 14:14:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-16/1776366843'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-16/1776366843
id: 1717138
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162138009
updated: 2026-04-16 14:14:33

Version 1717026

created: 2026-04-16 09:31:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-16/1776349908'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-16/1776349908
id: 1717026
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162122790
updated: 2026-04-16 09:32:06

Version 1716208

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-16/1776316128'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-16/1776316128
id: 1716208
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162107784
updated: 2026-04-16 00:09:45

Version 1716102

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-15/1776302518'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-15/1776302518
id: 1716102
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162100315
updated: 2026-04-15 20:22:28

Version 1715959

created: 2026-04-15 14:14:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-15/1776280433'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-15/1776280433
id: 1715959
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162081688
updated: 2026-04-15 14:14:20

Version 1715799

created: 2026-04-15 08:48:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-15/1776260799'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-15/1776260799
id: 1715799
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162064742
updated: 2026-04-15 08:48:36

Version 1715060

created: 2026-04-15 00:40:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-15/1776231629'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-15/1776231629
id: 1715060
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162052055
updated: 2026-04-15 00:41:04

Version 1714932

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-14/1776216996'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-14/1776216996
id: 1714932
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162044377
updated: 2026-04-14 20:37:22

Version 1714770

created: 2026-04-14 14:32:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-14/1776195150'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-14/1776195150
id: 1714770
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162026397
updated: 2026-04-14 14:32:52

Version 1714624

created: 2026-04-14 09:31:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-14/1776177108'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-14/1776177108
id: 1714624
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 162011175
updated: 2026-04-14 09:32:11

Version 1713859

created: 2026-04-14 00:34:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-14/1776144873'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user/2026-04-14/1776144873
id: 1713859
processed: 1

raw_data:

{
    "about_me": "string",
    "bcrypt_password_flag": "int16",
    "dob": "timestamp[ns]",
    "email": "string",
    "email_verified": "int16",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp[ns]",
    "last_name": "string",
    "member_since": "timestamp[ns]",
    "modified_dtm": "timestamp[ns]",
    "ns_contact_id": "int32",
    "ns_cust_id": "int32",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp[ns]",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int32",
    "username": "string"
}

schema_attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

schema_name_id: 1150
schema_scan_id: 161996425
updated: 2026-04-14 00:34:54

Schema Scans: 15

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

Scan 162193986

duration: 0:00:14.828871

exit_message:

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

id: 162193986

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_user/2026-04-17/1776453194",
        "key": "raw/sparefoot_user/2026-04-17/1776453194/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15164251062200455712,
        "service_name": "sparefoot",
        "span_id": 16909790050464845488,
        "trace_id": 15164251062200455712
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-17 14:13:26
success: True
trace_id: 15164251062200455712

Scan 162178347

duration: 0:00:12.037758

exit_message:

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

id: 162178347

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_user/2026-04-17/1776436017",
        "key": "raw/sparefoot_user/2026-04-17/1776436017/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16719728241752770646,
        "service_name": "sparefoot",
        "span_id": 10126718088439208722,
        "trace_id": 16719728241752770646
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-17 09:27:10
success: True
trace_id: 16719728241752770646

Scan 162163609

duration: 0:00:12.081380

exit_message:

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

id: 162163609

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_user/2026-04-17/1776402601",
        "key": "raw/sparefoot_user/2026-04-17/1776402601/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10977910631089978473,
        "service_name": "sparefoot",
        "span_id": 18091153286812229831,
        "trace_id": 10977910631089978473
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-17 00:12:28
success: True
trace_id: 10977910631089978473

Scan 162156134

duration: 0:00:14.699167

exit_message:

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

id: 162156134

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_user/2026-04-16/1776388786",
        "key": "raw/sparefoot_user/2026-04-16/1776388786/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18513727605798956,
        "service_name": "sparefoot",
        "span_id": 16254866375758646966,
        "trace_id": 18513727605798956
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-16 20:23:38
success: True
trace_id: 18513727605798956

Scan 162138009

duration: 0:00:12.038100

exit_message:

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

id: 162138009

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_user/2026-04-16/1776366843",
        "key": "raw/sparefoot_user/2026-04-16/1776366843/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16794770473483046304,
        "service_name": "sparefoot",
        "span_id": 6824402232763538090,
        "trace_id": 16794770473483046304
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-16 14:14:21
success: True
trace_id: 16794770473483046304

Scan 162122790

duration: 0:00:12.239138

exit_message:

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

id: 162122790

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_user/2026-04-16/1776349908",
        "key": "raw/sparefoot_user/2026-04-16/1776349908/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6017450629048058971,
        "service_name": "sparefoot",
        "span_id": 2675621112049537832,
        "trace_id": 6017450629048058971
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-16 09:31:54
success: True
trace_id: 6017450629048058971

Scan 162107784

duration: 0:00:14.415324

exit_message:

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

id: 162107784

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_user/2026-04-16/1776316128",
        "key": "raw/sparefoot_user/2026-04-16/1776316128/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17010252155081588551,
        "service_name": "sparefoot",
        "span_id": 17848957263681062700,
        "trace_id": 17010252155081588551
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-16 00:09:31
success: True
trace_id: 17010252155081588551

Scan 162100315

duration: 0:00:14.549980

exit_message:

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

id: 162100315

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_user/2026-04-15/1776302518",
        "key": "raw/sparefoot_user/2026-04-15/1776302518/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16400323924386630011,
        "service_name": "sparefoot",
        "span_id": 12959633553179562612,
        "trace_id": 16400323924386630011
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-15 20:22:13
success: True
trace_id: 16400323924386630011

Scan 162081688

duration: 0:00:14.585101

exit_message:

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

id: 162081688

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_user/2026-04-15/1776280433",
        "key": "raw/sparefoot_user/2026-04-15/1776280433/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2553584650510717103,
        "service_name": "sparefoot",
        "span_id": 16856732887560316263,
        "trace_id": 2553584650510717103
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-15 14:14:05
success: True
trace_id: 2553584650510717103

Scan 162064742

duration: 0:00:14.672126

exit_message:

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

id: 162064742

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_user/2026-04-15/1776260799",
        "key": "raw/sparefoot_user/2026-04-15/1776260799/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11784369356282695272,
        "service_name": "sparefoot",
        "span_id": 3338004435844093733,
        "trace_id": 11784369356282695272
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-15 08:48:21
success: True
trace_id: 11784369356282695272

Scan 162052055

duration: 0:00:14.656165

exit_message:

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

id: 162052055

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_user/2026-04-15/1776231629",
        "key": "raw/sparefoot_user/2026-04-15/1776231629/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8777610315491967046,
        "service_name": "sparefoot",
        "span_id": 405163886075244064,
        "trace_id": 8777610315491967046
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-15 00:40:50
success: True
trace_id: 8777610315491967046

Scan 162044377

duration: 0:00:12.177627

exit_message:

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

id: 162044377

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_user/2026-04-14/1776216996",
        "key": "raw/sparefoot_user/2026-04-14/1776216996/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10318451257873572845,
        "service_name": "sparefoot",
        "span_id": 2294874422504759485,
        "trace_id": 10318451257873572845
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-14 20:37:10
success: True
trace_id: 10318451257873572845

Scan 162026397

duration: 0:00:12.143676

exit_message:

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

id: 162026397

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_user/2026-04-14/1776195150",
        "key": "raw/sparefoot_user/2026-04-14/1776195150/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8461604082611837478,
        "service_name": "sparefoot",
        "span_id": 1982740245602708467,
        "trace_id": 8461604082611837478
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-14 14:32:40
success: True
trace_id: 8461604082611837478

Scan 162011175

duration: 0:00:14.670552

exit_message:

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

id: 162011175

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_user/2026-04-14/1776177108",
        "key": "raw/sparefoot_user/2026-04-14/1776177108/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16646332529995803578,
        "service_name": "sparefoot",
        "span_id": 14060092723330024434,
        "trace_id": 16646332529995803578
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-14 09:31:56
success: True
trace_id: 16646332529995803578

Scan 161996425

duration: 0:00:14.614582

exit_message:

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

id: 161996425

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_user/2026-04-14/1776144873",
        "key": "raw/sparefoot_user/2026-04-14/1776144873/user_4.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4508599989721507885,
        "service_name": "sparefoot",
        "span_id": 9278191096701405518,
        "trace_id": 4508599989721507885
    }
}

running: False
schema_name_id: 1150
start_time: 2026-04-14 00:34:40
success: True
trace_id: 4508599989721507885

Partitions:

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

Schema:

attributes:

{
    "about_me": "string",
    "bcrypt_password_flag": "smallint",
    "dob": "timestamp",
    "email": "string",
    "email_verified": "smallint",
    "first_name": "string",
    "language": "string",
    "last_login": "timestamp",
    "last_name": "string",
    "member_since": "timestamp",
    "modified_dtm": "timestamp",
    "ns_contact_id": "int",
    "ns_cust_id": "int",
    "password": "string",
    "password_reset_auth_key": "string",
    "password_reset_time": "timestamp",
    "phone": "string",
    "picture_ext": "string",
    "salt": "string",
    "user_id": "int",
    "username": "string"
}

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_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-17/1776453194'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
}

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 18:05:27",
        "disabled": false,
        "format": "raw",
        "id": 1150,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_user"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "about_me": "string",
            "bcrypt_password_flag": "smallint",
            "dob": "timestamp",
            "email": "string",
            "email_verified": "smallint",
            "first_name": "string",
            "language": "string",
            "last_login": "timestamp",
            "last_name": "string",
            "member_since": "timestamp",
            "modified_dtm": "timestamp",
            "ns_contact_id": "int",
            "ns_cust_id": "int",
            "password": "string",
            "password_reset_auth_key": "string",
            "password_reset_time": "timestamp",
            "phone": "string",
            "picture_ext": "string",
            "salt": "string",
            "user_id": "int",
            "username": "string"
        },
        "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_user`\n(\n `about_me`  string , `bcrypt_password_flag`  smallint , `dob`  timestamp , `email`  string , `email_verified`  smallint , `first_name`  string , `language`  string , `last_login`  timestamp , `last_name`  string , `member_since`  timestamp , `modified_dtm`  timestamp , `ns_contact_id`  int , `ns_cust_id`  int , `password`  string , `password_reset_auth_key`  string , `password_reset_time`  timestamp , `phone`  string , `picture_ext`  string , `salt`  string , `user_id`  int , `username`  string \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_user/2026-04-17/1776453194'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}