Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions
- created: 2024-10-08 18:01:48
- disabled: False
- format: raw
- id: 2747
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookinstance_manager_actions" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748766
- created: 2024-11-05 23:00:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-05/1730866508'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-05/1730866508
- id: 4748766
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6674798
- updated: 2024-11-05 23:00:29
-
Version 4748405
- created: 2024-11-05 22:45:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-05/1730866429'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-05/1730866429
- id: 4748405
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6674437
- updated: 2024-11-05 22:45:21
-
Version 4747791
- created: 2024-11-05 22:26:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-05/1730866309'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-05/1730866309
- id: 4747791
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6673823
- updated: 2024-11-05 22:26:17
-
Version 4747027
- created: 2024-11-05 04:42:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730785721'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730785721
- id: 4747027
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6672259
- updated: 2024-11-05 04:42:43
-
Version 4746465
- created: 2024-11-05 04:04:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730785125'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730785125
- id: 4746465
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6671686
- updated: 2024-11-05 04:04:33
-
Version 4745450
- created: 2024-11-05 03:29:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730784819'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730784819
- id: 4745450
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6670666
- updated: 2024-11-05 03:29:55
-
Version 4745161
- created: 2024-11-05 03:22:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730784216'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730784216
- id: 4745161
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6670378
- updated: 2024-11-05 03:22:24
-
Version 4743632
- created: 2024-11-05 02:41:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730783899'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783899
- id: 4743632
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6668848
- updated: 2024-11-05 02:41:56
-
Version 4743368
- created: 2024-11-05 02:34:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730784054'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730784054
- id: 4743368
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6668585
- updated: 2024-11-05 02:35:00
-
Version 4742632
- created: 2024-11-05 02:15:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730783767'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783767
- id: 4742632
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6667849
- updated: 2024-11-05 02:15:32
-
Version 4741806
- created: 2024-11-05 01:53:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730783664'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783664
- id: 4741806
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6667023
- updated: 2024-11-05 01:53:29
-
Version 4741212
- created: 2024-11-05 01:37:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730783523'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783523
- id: 4741212
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6666429
- updated: 2024-11-05 01:37:55
-
Version 4740422
- created: 2024-11-05 01:16:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730783305'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783305
- id: 4740422
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6665638
- updated: 2024-11-05 01:17:06
-
Version 4739350
- created: 2024-11-05 00:48:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730782906'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730782906
- id: 4739350
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6664564
- updated: 2024-11-05 00:48:34
-
Version 4738843
- created: 2024-11-05 00:35:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-04/1730782805'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730782805
- id: 4738843
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 23, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "sort_label": 7, "supports_custom_time": 20, "supports_report_schedule": 21, "supports_report_worker": 22, "tab_configuration": 17, "tenant": 1, "title": 5 } - schema_attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - schema_name_id: 2747
- schema_scan_id: 6664056
- updated: 2024-11-05 00:35:18
Schema Scans: 15
Last at 2024-11-05 23:00:14
-
Scan 6674798
- duration: 0:00:14.890854
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674798
- 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_actions/2024-11-05/1730866508", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-05/1730866508/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6180838165513915435, "service_name": "drive-thru", "span_id": 14509885588566892577, "trace_id": 7643251491502438841 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 23:00:14
- success: True
- trace_id: 7643251491502438841
-
Scan 6674437
- duration: 0:00:12.057438
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674437
- 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_actions/2024-11-05/1730866429", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-05/1730866429/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11471577173715923713, "service_name": "drive-thru", "span_id": 6429129999196163603, "trace_id": 8812053750429407295 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 22:45:09
- success: True
- trace_id: 8812053750429407295
-
Scan 6673823
- duration: 0:00:14.511155
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673823
- 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_actions/2024-11-05/1730866309", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-05/1730866309/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7475054194046373320, "service_name": "drive-thru", "span_id": 11170744734710636048, "trace_id": 4488590090742319605 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 22:26:02
- success: True
- trace_id: 4488590090742319605
-
Scan 6672259
- duration: 0:00:12.123594
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672259
- 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_actions/2024-11-04/1730785721", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730785721/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8329868276923349430, "service_name": "drive-thru", "span_id": 10384259920836688119, "trace_id": 6190600276340939311 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 04:42:31
- success: True
- trace_id: 6190600276340939311
-
Scan 6671686
- duration: 0:00:14.629079
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671686
- 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_actions/2024-11-04/1730785125", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730785125/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10811564116661064776, "service_name": "drive-thru", "span_id": 10593135382971757552, "trace_id": 291710698120394337 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 04:04:18
- success: True
- trace_id: 291710698120394337
-
Scan 6670666
- duration: 0:00:11.926765
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670666
- 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_actions/2024-11-04/1730784819", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730784819/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18256360569092759288, "service_name": "drive-thru", "span_id": 11984971451995798645, "trace_id": 1130431969891718912 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 03:29:43
- success: True
- trace_id: 1130431969891718912
-
Scan 6670378
- duration: 0:00:11.808950
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670378
- 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_actions/2024-11-04/1730784216", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730784216/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10913601405493760959, "service_name": "drive-thru", "span_id": 11620282055977441293, "trace_id": 1302832366339142836 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 03:22:12
- success: True
- trace_id: 1302832366339142836
-
Scan 6668848
- duration: 0:00:11.982519
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668848
- 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_actions/2024-11-04/1730783899", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783899/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7316365726394386169, "service_name": "drive-thru", "span_id": 7162500475935497193, "trace_id": 17045439869370252107 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 02:41:44
- success: True
- trace_id: 17045439869370252107
-
Scan 6668585
- duration: 0:00:14.646282
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668585
- 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_actions/2024-11-04/1730784054", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730784054/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 230610184164256375, "service_name": "drive-thru", "span_id": 8842174274821117709, "trace_id": 729857146503257138 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 02:34:45
- success: True
- trace_id: 729857146503257138
-
Scan 6667849
- duration: 0:00:11.905703
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667849
- 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_actions/2024-11-04/1730783767", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783767/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4833923363385124031, "service_name": "drive-thru", "span_id": 7095454747169640160, "trace_id": 8572721791386009684 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 02:15:20
- success: True
- trace_id: 8572721791386009684
-
Scan 6667023
- duration: 0:00:12.060621
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667023
- 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_actions/2024-11-04/1730783664", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783664/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4271947146727445197, "service_name": "drive-thru", "span_id": 7431965967241095441, "trace_id": 2486064325187049143 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 01:53:17
- success: True
- trace_id: 2486064325187049143
-
Scan 6666429
- duration: 0:00:14.399733
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666429
- 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_actions/2024-11-04/1730783523", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783523/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7450654817880983018, "service_name": "drive-thru", "span_id": 16921102289182121649, "trace_id": 16419042948541625499 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 01:37:41
- success: True
- trace_id: 16419042948541625499
-
Scan 6665638
- duration: 0:00:11.911494
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665638
- 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_actions/2024-11-04/1730783305", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730783305/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3338072837371492798, "service_name": "drive-thru", "span_id": 4638470988092260957, "trace_id": 7442116591517294162 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 01:16:54
- success: True
- trace_id: 7442116591517294162
-
Scan 6664564
- duration: 0:00:11.778755
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664564
- 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_actions/2024-11-04/1730782906", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730782906/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 726280411798406201, "service_name": "drive-thru", "span_id": 16229221080888426156, "trace_id": 14539416493291530009 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 00:48:22
- success: True
- trace_id: 14539416493291530009
-
Scan 6664056
- duration: 0:00:11.889016
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664056
- 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_actions/2024-11-04/1730782805", "key": "raw/newbookdev_newbookinstance_manager_actions/2024-11-04/1730782805/instance_manager_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15629682479671597370, "service_name": "drive-thru", "span_id": 6506878734105600988, "trace_id": 15670132768858852110 } } - running: False
- schema_name_id: 2747
- start_time: 2024-11-05 00:35:06
- success: True
- trace_id: 15670132768858852110
- attributes:
{ "action": "string", "column_configuration": "string", "description": "string", "dev": "string", "display_in_menu": "string", "icon": "string", "id": "string", "knowledge_base": "string", "label": "string", "mobile": "string", "newbook_region": "string", "page_defaults": "string", "pin": "string", "privilege_check": "string", "route": "string", "saved_views": "string", "section_id": "string", "sort_label": "string", "supports_custom_time": "string", "supports_report_schedule": "string", "supports_report_worker": "string", "tab_configuration": "string", "tenant": "string", "title": "string" } - created: 2024-11-05 23:00:15
- 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_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-05/1730866508'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions" }
- 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:01:48",
"disabled": false,
"format": "raw",
"id": 2747,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookinstance_manager_actions"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"action": "string",
"column_configuration": "string",
"description": "string",
"dev": "string",
"display_in_menu": "string",
"icon": "string",
"id": "string",
"knowledge_base": "string",
"label": "string",
"mobile": "string",
"newbook_region": "string",
"page_defaults": "string",
"pin": "string",
"privilege_check": "string",
"route": "string",
"saved_views": "string",
"section_id": "string",
"sort_label": "string",
"supports_custom_time": "string",
"supports_report_schedule": "string",
"supports_report_worker": "string",
"tab_configuration": "string",
"tenant": "string",
"title": "string"
},
"created": "2024-11-05 23:00:15",
"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_actions`\n(\n `newbook_region` string , `tenant` string , `id` string , `action` string , `route` string , `title` string , `label` string , `sort_label` string , `description` string , `icon` string , `section_id` string , `display_in_menu` string , `privilege_check` string , `pin` string , `saved_views` string , `page_defaults` string , `column_configuration` string , `tab_configuration` string , `mobile` string , `dev` string , `supports_custom_time` string , `supports_report_schedule` string , `supports_report_worker` string , `knowledge_base` 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_actions/2024-11-05/1730866508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_manager_actions"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}