Schema Info
Schema Name: sfdl_prod_rds.ess_esscore_users
- created: 2021-07-26 18:38:07
- disabled: False
- format: raw
- id: 942
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_rds", "table": "ess_esscore_users" } - type: rds
Schema Versions: 3
-
Version 1372693
- created: 2025-07-03 23:39:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_users`\n(\n `id` int , `username` varchar(255) , `email` varchar(255) , `password_hash` varchar(255) , `password_salt` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `account_type` varchar(32) , `site_id` int , `creator_id` int , `updater_id` int , `password_reset_token` varchar(255) , `last_logged_in_at` timestamp , `new_rental_in_progress` smallint , `owner` smallint , `phone` varchar(255) , `login_is_disabled` smallint , `login_token` varchar(255) , `login_token_updated_at` timestamp , `deleted_at` timestamp , `contact_info_requested_at` timestamp , `contact_info_updated_at` timestamp , `first_name` varchar(255) , `last_name` varchar(255) , `home_page` varchar(255) , `form_updater_id` int , `form_updated_at` timestamp , `password_reset_token_updated_at` timestamp , `failed_logins` int , `password_digest` varchar(255) , `password_set_at` timestamp , `previous_password_digests` string , `last_logged_out_at` timestamp , `sso_id` varchar(255) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-ess-prod/raw/esscore_users/2025-07-04/1751603991'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_users" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_users/2025-07-04/1751603991
- id: 1372693
- processed: 1
- raw_data:
{ "account_type": 7, "contact_info_requested_at": 20, "contact_info_updated_at": 21, "created_at": 5, "creator_id": 9, "deleted_at": 19, "email": 2, "failed_logins": 28, "first_name": 22, "form_updated_at": 26, "form_updater_id": 25, "home_page": 24, "id": 0, "last_logged_in_at": 12, "last_logged_out_at": 32, "last_name": 23, "login_is_disabled": 16, "login_token": 17, "login_token_updated_at": 18, "new_rental_in_progress": 13, "owner": 14, "password_digest": 29, "password_hash": 3, "password_reset_token": 11, "password_reset_token_updated_at": 27, "password_salt": 4, "password_set_at": 30, "phone": 15, "previous_password_digests": 31, "site_id": 8, "sso_id": 33, "updated_at": 6, "updater_id": 10, "username": 1 } - schema_attributes:
{ "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" } - schema_name_id: 942
- schema_scan_id: 145006279
- updated: 2025-07-03 23:40:07
-
Version 1332730
- created: 2025-06-02 09:52:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_users`\n(\n `id` int , `username` varchar(255) , `email` varchar(255) , `password_hash` varchar(255) , `password_salt` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `account_type` varchar(32) , `site_id` int , `creator_id` int , `updater_id` int , `password_reset_token` varchar(255) , `last_logged_in_at` timestamp , `new_rental_in_progress` smallint , `owner` smallint , `phone` varchar(255) , `login_is_disabled` smallint , `login_token` varchar(255) , `login_token_updated_at` timestamp , `deleted_at` timestamp , `contact_info_requested_at` timestamp , `contact_info_updated_at` timestamp , `first_name` varchar(255) , `last_name` varchar(255) , `home_page` varchar(255) , `form_updater_id` int , `form_updated_at` timestamp , `password_reset_token_updated_at` timestamp , `failed_logins` int , `password_digest` varchar(255) , `password_set_at` timestamp , `previous_password_digests` string , `last_logged_out_at` timestamp , `sso_id` varchar(255) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-ess-prod/raw/esscore_users/2025-06-02/1748875942'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_users" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_users/2025-06-02/1748875942
- id: 1332730
- processed: 1
- raw_data:
{ "account_type": 7, "contact_info_requested_at": 20, "contact_info_updated_at": 21, "created_at": 5, "creator_id": 9, "deleted_at": 19, "email": 2, "failed_logins": 28, "first_name": 22, "form_updated_at": 26, "form_updater_id": 25, "home_page": 24, "id": 0, "last_logged_in_at": 12, "last_logged_out_at": 32, "last_name": 23, "login_is_disabled": 16, "login_token": 17, "login_token_updated_at": 18, "new_rental_in_progress": 13, "owner": 14, "password_digest": 29, "password_hash": 3, "password_reset_token": 11, "password_reset_token_updated_at": 27, "password_salt": 4, "password_set_at": 30, "phone": 15, "previous_password_digests": 31, "site_id": 8, "sso_id": 33, "updated_at": 6, "updater_id": 10, "username": 1 } - schema_attributes:
{ "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" } - schema_name_id: 942
- schema_scan_id: 143166156
- updated: 2025-06-02 09:52:37
-
Version 1331174
- created: 2025-06-01 08:36:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_users`\n(\n `id` int , `username` varchar(255) , `email` varchar(255) , `password_hash` varchar(255) , `password_salt` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `account_type` varchar(32) , `site_id` int , `creator_id` int , `updater_id` int , `password_reset_token` varchar(255) , `last_logged_in_at` timestamp , `new_rental_in_progress` smallint , `owner` smallint , `phone` varchar(255) , `login_is_disabled` smallint , `login_token` varchar(255) , `login_token_updated_at` timestamp , `deleted_at` timestamp , `contact_info_requested_at` timestamp , `contact_info_updated_at` timestamp , `first_name` varchar(255) , `last_name` varchar(255) , `home_page` varchar(255) , `form_updater_id` int , `form_updated_at` timestamp , `password_reset_token_updated_at` timestamp , `failed_logins` int , `password_digest` varchar(255) , `password_set_at` timestamp , `previous_password_digests` string , `last_logged_out_at` timestamp , `sso_id` varchar(255) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-ess-prod/raw/esscore_users/2025-06-01/1748784952'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_users" ] - hive_path: s3://sfdl-rds-ess-prod/raw/esscore_users/2025-06-01/1748784952
- id: 1331174
- processed: 1
- raw_data:
{ "account_type": 7, "contact_info_requested_at": 20, "contact_info_updated_at": 21, "created_at": 5, "creator_id": 9, "deleted_at": 19, "email": 2, "failed_logins": 28, "first_name": 22, "form_updated_at": 26, "form_updater_id": 25, "home_page": 24, "id": 0, "last_logged_in_at": 12, "last_logged_out_at": 32, "last_name": 23, "login_is_disabled": 16, "login_token": 17, "login_token_updated_at": 18, "new_rental_in_progress": 13, "owner": 14, "password_digest": 29, "password_hash": 3, "password_reset_token": 11, "password_reset_token_updated_at": 27, "password_salt": 4, "password_set_at": 30, "phone": 15, "previous_password_digests": 31, "site_id": 8, "sso_id": 33, "updated_at": 6, "updater_id": 10, "username": 1 } - schema_attributes:
{ "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" } - schema_name_id: 942
- schema_scan_id: 143105968
- updated: 2025-06-01 08:36:13
Schema Scans: 3
Last at 2025-07-03 23:39:55
-
Scan 145006279
- duration: 0:00:11.241441
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 145006279
- payload:
{ "datatype_dict": { "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_users/2025-07-04/1751603991", "key": "raw/esscore_users/2025-07-04/1751603991/split.ess_core.users0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_users", "type": "rds" } } - running: False
- schema_name_id: 942
- start_time: 2025-07-03 23:39:55
- success: True
- trace_id: 5110627899441646498
-
Scan 143166156
- duration: 0:00:11.253999
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 143166156
- payload:
{ "datatype_dict": { "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_users/2025-06-02/1748875942", "key": "raw/esscore_users/2025-06-02/1748875942/split.ess_core.users0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_users", "type": "rds" } } - running: False
- schema_name_id: 942
- start_time: 2025-06-02 09:52:26
- success: True
- trace_id: 4902614522123607521
-
Scan 143105968
- duration: 0:00:11.288500
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 143105968
- payload:
{ "datatype_dict": { "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-ess-prod", "hive_path": "s3://sfdl-rds-ess-prod/raw/esscore_users/2025-06-01/1748784952", "key": "raw/esscore_users/2025-06-01/1748784952/split.ess_core.users0.dat.gz" }, "schema": { "name": "sfdl_prod_rds.ess_esscore_users", "type": "rds" } } - running: False
- schema_name_id: 942
- start_time: 2025-06-01 08:36:02
- success: True
- trace_id: 6484772234595202606
- attributes:
{ "account_type": "varchar(32)", "contact_info_requested_at": "timestamp", "contact_info_updated_at": "timestamp", "created_at": "timestamp", "creator_id": "int", "deleted_at": "timestamp", "email": "varchar(255)", "failed_logins": "int", "first_name": "varchar(255)", "form_updated_at": "timestamp", "form_updater_id": "int", "home_page": "varchar(255)", "id": "int", "last_logged_in_at": "timestamp", "last_logged_out_at": "timestamp", "last_name": "varchar(255)", "login_is_disabled": "smallint", "login_token": "varchar(255)", "login_token_updated_at": "timestamp", "new_rental_in_progress": "smallint", "owner": "smallint", "password_digest": "varchar(255)", "password_hash": "varchar(255)", "password_reset_token": "varchar(255)", "password_reset_token_updated_at": "timestamp", "password_salt": "varchar(255)", "password_set_at": "timestamp", "phone": "varchar(255)", "previous_password_digests": "string", "site_id": "int", "sso_id": "varchar(255)", "updated_at": "timestamp", "updater_id": "int", "username": "varchar(255)" } - created: 2025-07-03 23:39:56
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_users`\n(\n `id` int , `username` varchar(255) , `email` varchar(255) , `password_hash` varchar(255) , `password_salt` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `account_type` varchar(32) , `site_id` int , `creator_id` int , `updater_id` int , `password_reset_token` varchar(255) , `last_logged_in_at` timestamp , `new_rental_in_progress` smallint , `owner` smallint , `phone` varchar(255) , `login_is_disabled` smallint , `login_token` varchar(255) , `login_token_updated_at` timestamp , `deleted_at` timestamp , `contact_info_requested_at` timestamp , `contact_info_updated_at` timestamp , `first_name` varchar(255) , `last_name` varchar(255) , `home_page` varchar(255) , `form_updater_id` int , `form_updated_at` timestamp , `password_reset_token_updated_at` timestamp , `failed_logins` int , `password_digest` varchar(255) , `password_set_at` timestamp , `previous_password_digests` string , `last_logged_out_at` timestamp , `sso_id` varchar(255) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-ess-prod/raw/esscore_users/2025-07-04/1751603991'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_users`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_users" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2021-07-26 18:38:07",
"disabled": false,
"format": "raw",
"id": 942,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_rds",
"table": "ess_esscore_users"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"account_type": "varchar(32)",
"contact_info_requested_at": "timestamp",
"contact_info_updated_at": "timestamp",
"created_at": "timestamp",
"creator_id": "int",
"deleted_at": "timestamp",
"email": "varchar(255)",
"failed_logins": "int",
"first_name": "varchar(255)",
"form_updated_at": "timestamp",
"form_updater_id": "int",
"home_page": "varchar(255)",
"id": "int",
"last_logged_in_at": "timestamp",
"last_logged_out_at": "timestamp",
"last_name": "varchar(255)",
"login_is_disabled": "smallint",
"login_token": "varchar(255)",
"login_token_updated_at": "timestamp",
"new_rental_in_progress": "smallint",
"owner": "smallint",
"password_digest": "varchar(255)",
"password_hash": "varchar(255)",
"password_reset_token": "varchar(255)",
"password_reset_token_updated_at": "timestamp",
"password_salt": "varchar(255)",
"password_set_at": "timestamp",
"phone": "varchar(255)",
"previous_password_digests": "string",
"site_id": "int",
"sso_id": "varchar(255)",
"updated_at": "timestamp",
"updater_id": "int",
"username": "varchar(255)"
},
"created": "2025-07-03 23:39:56",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.ess_esscore_users`\n(\n `id` int , `username` varchar(255) , `email` varchar(255) , `password_hash` varchar(255) , `password_salt` varchar(255) , `created_at` timestamp , `updated_at` timestamp , `account_type` varchar(32) , `site_id` int , `creator_id` int , `updater_id` int , `password_reset_token` varchar(255) , `last_logged_in_at` timestamp , `new_rental_in_progress` smallint , `owner` smallint , `phone` varchar(255) , `login_is_disabled` smallint , `login_token` varchar(255) , `login_token_updated_at` timestamp , `deleted_at` timestamp , `contact_info_requested_at` timestamp , `contact_info_updated_at` timestamp , `first_name` varchar(255) , `last_name` varchar(255) , `home_page` varchar(255) , `form_updater_id` int , `form_updated_at` timestamp , `password_reset_token_updated_at` timestamp , `failed_logins` int , `password_digest` varchar(255) , `password_set_at` timestamp , `previous_password_digests` string , `last_logged_out_at` timestamp , `sso_id` varchar(255) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-ess-prod/raw/esscore_users/2025-07-04/1751603991'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.ess_esscore_users`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.ess_esscore_users"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}