Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstance_manager
- created: 2024-10-08 18:02:39
- disabled: False
- format: raw
- id: 2755
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookinstance_manager" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749001
- created: 2024-11-05 23:13:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866507'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866507
- id: 4749001
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6675033
- updated: 2024-11-05 23:13:28
-
Version 4748487
- created: 2024-11-05 22:48:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866429'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866429
- id: 4748487
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6674518
- updated: 2024-11-05 22:48:15
-
Version 4747806
- created: 2024-11-05 22:26:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866309'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866309
- id: 4747806
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6673836
- updated: 2024-11-05 22:26:40
-
Version 4747020
- created: 2024-11-05 04:41:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730785721'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730785721
- id: 4747020
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6672251
- updated: 2024-11-05 04:42:05
-
Version 4746442
- created: 2024-11-05 04:03:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730785124'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730785124
- id: 4746442
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6671662
- updated: 2024-11-05 04:03:29
-
Version 4745844
- created: 2024-11-05 03:40:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784819'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784819
- id: 4745844
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6671059
- updated: 2024-11-05 03:40:51
-
Version 4745165
- created: 2024-11-05 03:22:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784215'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784215
- id: 4745165
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6670382
- updated: 2024-11-05 03:22:32
-
Version 4743933
- created: 2024-11-05 02:49:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784053'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784053
- id: 4743933
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6669149
- updated: 2024-11-05 02:49:52
-
Version 4743104
- created: 2024-11-05 02:27:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783844'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783844
- id: 4743104
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6668320
- updated: 2024-11-05 02:27:59
-
Version 4742555
- created: 2024-11-05 02:13:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783767'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783767
- id: 4742555
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6667772
- updated: 2024-11-05 02:13:30
-
Version 4742010
- created: 2024-11-05 01:58:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783664'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783664
- id: 4742010
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6667225
- updated: 2024-11-05 01:58:46
-
Version 4740652
- created: 2024-11-05 01:22:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783522'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783522
- id: 4740652
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6665869
- updated: 2024-11-05 01:23:09
-
Version 4740431
- created: 2024-11-05 01:17:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783305'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783305
- id: 4740431
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6665647
- updated: 2024-11-05 01:17:20
-
Version 4739586
- created: 2024-11-05 00:54:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730782906'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730782906
- id: 4739586
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6664800
- updated: 2024-11-05 00:54:41
-
Version 4738705
- created: 2024-11-05 00:31:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730782805'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730782805
- id: 4738705
- processed: 1
- raw_data:
{ "admin_email": 32, "admin_fax": 34, "admin_phone": 33, "api_key": 3, "backup_notification_email": 51, "bom_radar_code": 12, "closing_time": 47, "created_when": 15, "date_format": 42, "email_queue_paused": 50, "emergency_phone": 35, "error_email": 37, "feature_suggestions_email": 38, "id": 2, "lat": 13, "licensing_email": 39, "login_code": 8, "login_type": 45, "long": 14, "mailing_city": 22, "mailing_country_id": 25, "mailing_postcode": 24, "mailing_state_id": 23, "mailing_street": 21, "maintenance_mode": 49, "manager_name": 41, "name": 6, "newbook_region": 0, "opening_time": 46, "physical_city": 17, "physical_country_id": 20, "physical_postcode": 19, "physical_state_id": 18, "physical_street": 16, "product_description": 10, "product_name": 9, "sales_email": 26, "sales_fax": 28, "sales_phone": 27, "secure_login": 48, "support_email": 29, "support_fax": 31, "support_phone": 30, "survey_email": 36, "system_email": 40, "tax_id": 5, "tenant": 1, "time_format": 43, "trading_name": 7, "vnb": 4, "weather_station_code": 11, "website": 44 } - schema_attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - schema_name_id: 2755
- schema_scan_id: 6663916
- updated: 2024-11-05 00:31:37
Schema Scans: 15
Last at 2024-11-05 23:13:15
-
Scan 6675033
- duration: 0:00:12.931090
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675033
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866507", "key": "raw/newbookdev_newbookinstance_manager/2024-11-05/1730866507/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1490200047272938163, "service_name": "drive-thru", "span_id": 3714760471368880515, "trace_id": 12878664440070159682 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 23:13:15
- success: True
- trace_id: 12878664440070159682
-
Scan 6674518
- duration: 0:00:12.853132
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674518
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866429", "key": "raw/newbookdev_newbookinstance_manager/2024-11-05/1730866429/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7559239903369580020, "service_name": "drive-thru", "span_id": 4861882633651518851, "trace_id": 12980544305299424863 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 22:48:02
- success: True
- trace_id: 12980544305299424863
-
Scan 6673836
- duration: 0:00:14.981096
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673836
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866309", "key": "raw/newbookdev_newbookinstance_manager/2024-11-05/1730866309/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16540480256561933585, "service_name": "drive-thru", "span_id": 17241870559009434099, "trace_id": 17751401401757861644 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 22:26:25
- success: True
- trace_id: 17751401401757861644
-
Scan 6672251
- duration: 0:00:15.432594
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672251
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730785721", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730785721/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15936858046693180756, "service_name": "drive-thru", "span_id": 17012523666036628831, "trace_id": 7582708599073494569 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 04:41:50
- success: True
- trace_id: 7582708599073494569
-
Scan 6671662
- duration: 0:00:15.391283
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671662
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730785124", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730785124/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9379904133238966225, "service_name": "drive-thru", "span_id": 4339840307456331884, "trace_id": 3972057632814964069 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 04:03:13
- success: True
- trace_id: 3972057632814964069
-
Scan 6671059
- duration: 0:00:13.011006
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671059
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784819", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730784819/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16502158769369699166, "service_name": "drive-thru", "span_id": 13272685752745211156, "trace_id": 16928579578064395704 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 03:40:38
- success: True
- trace_id: 16928579578064395704
-
Scan 6670382
- duration: 0:00:12.615889
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670382
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784215", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730784215/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9086213550213630560, "service_name": "drive-thru", "span_id": 2248160120111272170, "trace_id": 9584866100314905960 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 03:22:20
- success: True
- trace_id: 9584866100314905960
-
Scan 6669149
- duration: 0:00:15.193695
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669149
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730784053", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730784053/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5989865008799712626, "service_name": "drive-thru", "span_id": 4972364626915290555, "trace_id": 7052999083704922019 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 02:49:37
- success: True
- trace_id: 7052999083704922019
-
Scan 6668320
- duration: 0:00:15.354379
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668320
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783844", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730783844/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6872489729199264199, "service_name": "drive-thru", "span_id": 10760015088860650449, "trace_id": 13996592869626864939 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 02:27:43
- success: True
- trace_id: 13996592869626864939
-
Scan 6667772
- duration: 0:00:12.198058
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667772
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783767", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730783767/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2966451567781963232, "service_name": "drive-thru", "span_id": 14483726235937976981, "trace_id": 13256645049332069224 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 02:13:18
- success: True
- trace_id: 13256645049332069224
-
Scan 6667225
- duration: 0:00:12.671018
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667225
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783664", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730783664/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6421554395021650541, "service_name": "drive-thru", "span_id": 18223237112977473610, "trace_id": 15141161149062310566 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 01:58:33
- success: True
- trace_id: 15141161149062310566
-
Scan 6665869
- duration: 0:00:12.598598
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665869
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783522", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730783522/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7574706461051857245, "service_name": "drive-thru", "span_id": 2649723945947488929, "trace_id": 7161308216411894934 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 01:22:56
- success: True
- trace_id: 7161308216411894934
-
Scan 6665647
- duration: 0:00:12.546911
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665647
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730783305", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730783305/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1354534905793301235, "service_name": "drive-thru", "span_id": 10539945473901010084, "trace_id": 5137870857237463324 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 01:17:08
- success: True
- trace_id: 5137870857237463324
-
Scan 6664800
- duration: 0:00:12.569034
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664800
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730782906", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730782906/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11735646985379294900, "service_name": "drive-thru", "span_id": 16531082143881353045, "trace_id": 12894332204016962983 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 00:54:29
- success: True
- trace_id: 12894332204016962983
-
Scan 6663916
- duration: 0:00:15.117896
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6663916
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-04/1730782805", "key": "raw/newbookdev_newbookinstance_manager/2024-11-04/1730782805/instance_manager.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4072468728195844706, "service_name": "drive-thru", "span_id": 12453595528611604883, "trace_id": 11023917778239247188 } } - running: False
- schema_name_id: 2755
- start_time: 2024-11-05 00:31:22
- success: True
- trace_id: 11023917778239247188
- attributes:
{ "admin_email": "string", "admin_fax": "string", "admin_phone": "string", "api_key": "string", "backup_notification_email": "string", "bom_radar_code": "string", "closing_time": "string", "created_when": "string", "date_format": "string", "email_queue_paused": "string", "emergency_phone": "string", "error_email": "string", "feature_suggestions_email": "string", "id": "string", "lat": "string", "licensing_email": "string", "login_code": "string", "login_type": "string", "long": "string", "mailing_city": "string", "mailing_country_id": "string", "mailing_postcode": "string", "mailing_state_id": "string", "mailing_street": "string", "maintenance_mode": "string", "manager_name": "string", "name": "string", "newbook_region": "string", "opening_time": "string", "physical_city": "string", "physical_country_id": "string", "physical_postcode": "string", "physical_state_id": "string", "physical_street": "string", "product_description": "string", "product_name": "string", "sales_email": "string", "sales_fax": "string", "sales_phone": "string", "secure_login": "string", "support_email": "string", "support_fax": "string", "support_phone": "string", "survey_email": "string", "system_email": "string", "tax_id": "string", "tenant": "string", "time_format": "string", "trading_name": "string", "vnb": "string", "weather_station_code": "string", "website": "string" } - created: 2024-11-05 23:13:17
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866507'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-10-08 18:02:39",
"disabled": false,
"format": "raw",
"id": 2755,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookinstance_manager"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"admin_email": "string",
"admin_fax": "string",
"admin_phone": "string",
"api_key": "string",
"backup_notification_email": "string",
"bom_radar_code": "string",
"closing_time": "string",
"created_when": "string",
"date_format": "string",
"email_queue_paused": "string",
"emergency_phone": "string",
"error_email": "string",
"feature_suggestions_email": "string",
"id": "string",
"lat": "string",
"licensing_email": "string",
"login_code": "string",
"login_type": "string",
"long": "string",
"mailing_city": "string",
"mailing_country_id": "string",
"mailing_postcode": "string",
"mailing_state_id": "string",
"mailing_street": "string",
"maintenance_mode": "string",
"manager_name": "string",
"name": "string",
"newbook_region": "string",
"opening_time": "string",
"physical_city": "string",
"physical_country_id": "string",
"physical_postcode": "string",
"physical_state_id": "string",
"physical_street": "string",
"product_description": "string",
"product_name": "string",
"sales_email": "string",
"sales_fax": "string",
"sales_phone": "string",
"secure_login": "string",
"support_email": "string",
"support_fax": "string",
"support_phone": "string",
"survey_email": "string",
"system_email": "string",
"tax_id": "string",
"tenant": "string",
"time_format": "string",
"trading_name": "string",
"vnb": "string",
"weather_station_code": "string",
"website": "string"
},
"created": "2024-11-05 23:13:17",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager`\n(\n `newbook_region` string , `tenant` string , `id` string , `api_key` string , `vnb` string , `tax_id` string , `name` string , `trading_name` string , `login_code` string , `product_name` string , `product_description` string , `weather_station_code` string , `bom_radar_code` string , `lat` string , `long` string , `created_when` string , `physical_street` string , `physical_city` string , `physical_state_id` string , `physical_postcode` string , `physical_country_id` string , `mailing_street` string , `mailing_city` string , `mailing_state_id` string , `mailing_postcode` string , `mailing_country_id` string , `sales_email` string , `sales_phone` string , `sales_fax` string , `support_email` string , `support_phone` string , `support_fax` string , `admin_email` string , `admin_phone` string , `admin_fax` string , `emergency_phone` string , `survey_email` string , `error_email` string , `feature_suggestions_email` string , `licensing_email` string , `system_email` string , `manager_name` string , `date_format` string , `time_format` string , `website` string , `login_type` string , `opening_time` string , `closing_time` string , `secure_login` string , `maintenance_mode` string , `email_queue_paused` string , `backup_notification_email` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager/2024-11-05/1730866507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}