Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_user_access

created: 2022-08-18 17:21:42
disabled: False
format: raw
id: 1117
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718382

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-17/1776453169'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-17/1776453169
id: 1718382
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162193982
updated: 2026-04-17 14:13:11

Version 1718176

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-17/1776435009'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-17/1776435009
id: 1718176
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162178188
updated: 2026-04-17 09:10:30

Version 1717434

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-17/1776402396'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-17/1776402396
id: 1717434
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162163565
updated: 2026-04-17 00:07:01

Version 1717303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-16/1776388304'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-16/1776388304
id: 1717303
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162156018
updated: 2026-04-16 20:15:05

Version 1717132

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-16/1776366646'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-16/1776366646
id: 1717132
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162138000
updated: 2026-04-16 14:13:51

Version 1716963

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-16/1776348456'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-16/1776348456
id: 1716963
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162122469
updated: 2026-04-16 09:08:02

Version 1716184

created: 2026-04-16 00:05:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-16/1776315924'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-16/1776315924
id: 1716184
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162107732
updated: 2026-04-16 00:05:42

Version 1716084

created: 2026-04-15 20:18:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-15/1776302321'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-15/1776302321
id: 1716084
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162100290
updated: 2026-04-15 20:19:08

Version 1715953

created: 2026-04-15 14:12:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-15/1776280297'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-15/1776280297
id: 1715953
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162081681
updated: 2026-04-15 14:12:23

Version 1715742

created: 2026-04-15 08:37:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-15/1776260215'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-15/1776260215
id: 1715742
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162064289
updated: 2026-04-15 08:37:44

Version 1715036

created: 2026-04-15 00:21:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-15/1776230470'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-15/1776230470
id: 1715036
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162052006
updated: 2026-04-15 00:21:29

Version 1714870

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-14/1776215445'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-14/1776215445
id: 1714870
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162044214
updated: 2026-04-14 20:11:34

Version 1714707

created: 2026-04-14 14:11:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-14/1776193850'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-14/1776193850
id: 1714707
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162026080
updated: 2026-04-14 14:11:24

Version 1714563

created: 2026-04-14 09:01:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-14/1776175175'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-14/1776175175
id: 1714563
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 162010565
updated: 2026-04-14 09:02:08

Version 1713784

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_user_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-14/1776143171'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_user_access/2026-04-14/1776143171
id: 1713784
processed: 1

raw_data:

{
    "account_id": "int32",
    "agent_office": "string",
    "agent_start_date": "date32[day]",
    "agent_team_id": "int32",
    "all_facilities": "int16",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "int16",
    "gets_inquiries": "int16",
    "gets_statements": "int16",
    "howd_you_hear": "string",
    "id": "int32",
    "incontact_agent_no": "int32",
    "last_logged_in": "timestamp[ns]",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp[ns]",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp[ns]",
    "terms_version": "string",
    "user_id": "int32"
}

schema_attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

schema_name_id: 1117
schema_scan_id: 161996294
updated: 2026-04-14 00:06:38

Schema Scans: 15

Last at 2026-04-17 14:12:59

Scan 162193982

duration: 0:00:12.461404

exit_message:

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

id: 162193982

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_access/2026-04-17/1776453169",
        "key": "raw/sparefoot_user_access/2026-04-17/1776453169/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3926799926048088492,
        "service_name": "sparefoot",
        "span_id": 15956470507836326735,
        "trace_id": 3926799926048088492
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-17 14:12:59
success: True
trace_id: 3926799926048088492

Scan 162178188

duration: 0:00:12.265112

exit_message:

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

id: 162178188

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_access/2026-04-17/1776435009",
        "key": "raw/sparefoot_user_access/2026-04-17/1776435009/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8324909514374507866,
        "service_name": "sparefoot",
        "span_id": 155702516179278616,
        "trace_id": 8324909514374507866
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-17 09:10:17
success: True
trace_id: 8324909514374507866

Scan 162163565

duration: 0:00:14.719123

exit_message:

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

id: 162163565

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_access/2026-04-17/1776402396",
        "key": "raw/sparefoot_user_access/2026-04-17/1776402396/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11282588083890999944,
        "service_name": "sparefoot",
        "span_id": 1217279409040363740,
        "trace_id": 11282588083890999944
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-17 00:06:47
success: True
trace_id: 11282588083890999944

Scan 162156018

duration: 0:00:14.674492

exit_message:

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

id: 162156018

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_access/2026-04-16/1776388304",
        "key": "raw/sparefoot_user_access/2026-04-16/1776388304/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 328052459179789428,
        "service_name": "sparefoot",
        "span_id": 14715729617721732030,
        "trace_id": 328052459179789428
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-16 20:14:51
success: True
trace_id: 328052459179789428

Scan 162138000

duration: 0:00:12.284227

exit_message:

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

id: 162138000

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_access/2026-04-16/1776366646",
        "key": "raw/sparefoot_user_access/2026-04-16/1776366646/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14131288259303797407,
        "service_name": "sparefoot",
        "span_id": 11563101211563623364,
        "trace_id": 14131288259303797407
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-16 14:13:39
success: True
trace_id: 14131288259303797407

Scan 162122469

duration: 0:00:14.631207

exit_message:

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

id: 162122469

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_access/2026-04-16/1776348456",
        "key": "raw/sparefoot_user_access/2026-04-16/1776348456/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17335479052187155817,
        "service_name": "sparefoot",
        "span_id": 4459217025179868314,
        "trace_id": 17335479052187155817
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-16 09:07:47
success: True
trace_id: 17335479052187155817

Scan 162107732

duration: 0:00:14.741529

exit_message:

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

id: 162107732

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_access/2026-04-16/1776315924",
        "key": "raw/sparefoot_user_access/2026-04-16/1776315924/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 615354507306452392,
        "service_name": "sparefoot",
        "span_id": 8774174816175023968,
        "trace_id": 615354507306452392
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-16 00:05:27
success: True
trace_id: 615354507306452392

Scan 162100290

duration: 0:00:12.263502

exit_message:

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

id: 162100290

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_access/2026-04-15/1776302321",
        "key": "raw/sparefoot_user_access/2026-04-15/1776302321/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11252381566200991672,
        "service_name": "sparefoot",
        "span_id": 7695513136866042023,
        "trace_id": 11252381566200991672
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-15 20:18:56
success: True
trace_id: 11252381566200991672

Scan 162081681

duration: 0:00:14.801352

exit_message:

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

id: 162081681

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_access/2026-04-15/1776280297",
        "key": "raw/sparefoot_user_access/2026-04-15/1776280297/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 228171647133468147,
        "service_name": "sparefoot",
        "span_id": 14776121326550690381,
        "trace_id": 228171647133468147
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-15 14:12:08
success: True
trace_id: 228171647133468147

Scan 162064289

duration: 0:00:12.169892

exit_message:

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

id: 162064289

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_access/2026-04-15/1776260215",
        "key": "raw/sparefoot_user_access/2026-04-15/1776260215/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13998165124626119307,
        "service_name": "sparefoot",
        "span_id": 11732662470539151782,
        "trace_id": 13998165124626119307
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-15 08:37:32
success: True
trace_id: 13998165124626119307

Scan 162052006

duration: 0:00:14.651251

exit_message:

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

id: 162052006

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_access/2026-04-15/1776230470",
        "key": "raw/sparefoot_user_access/2026-04-15/1776230470/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17316823824525725638,
        "service_name": "sparefoot",
        "span_id": 8213902795543963285,
        "trace_id": 17316823824525725638
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-15 00:21:14
success: True
trace_id: 17316823824525725638

Scan 162044214

duration: 0:00:14.678358

exit_message:

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

id: 162044214

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_access/2026-04-14/1776215445",
        "key": "raw/sparefoot_user_access/2026-04-14/1776215445/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15439427605971596687,
        "service_name": "sparefoot",
        "span_id": 13278960759765170984,
        "trace_id": 15439427605971596687
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-14 20:11:19
success: True
trace_id: 15439427605971596687

Scan 162026080

duration: 0:00:12.201229

exit_message:

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

id: 162026080

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_access/2026-04-14/1776193850",
        "key": "raw/sparefoot_user_access/2026-04-14/1776193850/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3498792061490450399,
        "service_name": "sparefoot",
        "span_id": 13681635744898624217,
        "trace_id": 3498792061490450399
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-14 14:11:12
success: True
trace_id: 3498792061490450399

Scan 162010565

duration: 0:00:14.686897

exit_message:

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

id: 162010565

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_access/2026-04-14/1776175175",
        "key": "raw/sparefoot_user_access/2026-04-14/1776175175/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4239052884180699654,
        "service_name": "sparefoot",
        "span_id": 5766660825286953402,
        "trace_id": 4239052884180699654
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-14 09:01:53
success: True
trace_id: 4239052884180699654

Scan 161996294

duration: 0:00:12.248427

exit_message:

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

id: 161996294

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_access/2026-04-14/1776143171",
        "key": "raw/sparefoot_user_access/2026-04-14/1776143171/user_access.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_user_access",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7237961348747708108,
        "service_name": "sparefoot",
        "span_id": 14464260643836570301,
        "trace_id": 7237961348747708108
    }
}

running: False
schema_name_id: 1117
start_time: 2026-04-14 00:06:25
success: True
trace_id: 7237961348747708108

Partitions:

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

Schema:

attributes:

{
    "account_id": "int",
    "agent_office": "string",
    "agent_start_date": "date",
    "agent_team_id": "int",
    "all_facilities": "smallint",
    "call_center_group": "string",
    "genesys_agent_id": "string",
    "gets_emails": "smallint",
    "gets_inquiries": "smallint",
    "gets_statements": "smallint",
    "howd_you_hear": "string",
    "id": "int",
    "incontact_agent_no": "int",
    "last_logged_in": "timestamp",
    "lily_role": "string",
    "moab_role": "string",
    "modified_dtm": "timestamp",
    "myfoot_role": "string",
    "partner_portal_role": "string",
    "pita_role": "string",
    "product_interest": "string",
    "terms_date": "timestamp",
    "terms_version": "string",
    "user_id": "int"
}

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

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_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-17/1776453169'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-18 17:21:42",
        "disabled": false,
        "format": "raw",
        "id": 1117,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_user_access"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "agent_office": "string",
            "agent_start_date": "date",
            "agent_team_id": "int",
            "all_facilities": "smallint",
            "call_center_group": "string",
            "genesys_agent_id": "string",
            "gets_emails": "smallint",
            "gets_inquiries": "smallint",
            "gets_statements": "smallint",
            "howd_you_hear": "string",
            "id": "int",
            "incontact_agent_no": "int",
            "last_logged_in": "timestamp",
            "lily_role": "string",
            "moab_role": "string",
            "modified_dtm": "timestamp",
            "myfoot_role": "string",
            "partner_portal_role": "string",
            "pita_role": "string",
            "product_interest": "string",
            "terms_date": "timestamp",
            "terms_version": "string",
            "user_id": "int"
        },
        "created": "2026-04-17 14:13:00",
        "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_access`\n(\n `account_id`  int , `agent_office`  string , `agent_start_date`  date , `agent_team_id`  int , `all_facilities`  smallint , `call_center_group`  string , `genesys_agent_id`  string , `gets_emails`  smallint , `gets_inquiries`  smallint , `gets_statements`  smallint , `howd_you_hear`  string , `id`  int , `incontact_agent_no`  int , `last_logged_in`  timestamp , `lily_role`  string , `moab_role`  string , `modified_dtm`  timestamp , `myfoot_role`  string , `partner_portal_role`  string , `pita_role`  string , `product_interest`  string , `terms_date`  timestamp , `terms_version`  string , `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_user_access/2026-04-17/1776453169'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_user_access`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_user_access"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}