Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances_actions
- created: 2024-10-08 18:06:48
- disabled: False
- format: raw
- id: 2792
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookinstances_actions" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748779
- created: 2024-11-05 23:01:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-05/1730866511'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-05/1730866511
- id: 4748779
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6674811
- updated: 2024-11-05 23:01:17
-
Version 4748452
- created: 2024-11-05 22:46:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-05/1730866434'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-05/1730866434
- id: 4748452
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6674484
- updated: 2024-11-05 22:47:00
-
Version 4747778
- created: 2024-11-05 22:25:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-05/1730866313'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-05/1730866313
- id: 4747778
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6673809
- updated: 2024-11-05 22:25:51
-
Version 4746763
- created: 2024-11-05 04:21:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730785723'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730785723
- id: 4746763
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6671989
- updated: 2024-11-05 04:21:36
-
Version 4746499
- created: 2024-11-05 04:06:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730785126'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730785126
- id: 4746499
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6671720
- updated: 2024-11-05 04:06:27
-
Version 4745445
- created: 2024-11-05 03:29:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730784821'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730784821
- id: 4745445
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6670662
- updated: 2024-11-05 03:29:45
-
Version 4744110
- created: 2024-11-05 02:54:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730784217'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730784217
- id: 4744110
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6669326
- updated: 2024-11-05 02:54:27
-
Version 4743936
- created: 2024-11-05 02:49:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730784055'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730784055
- id: 4743936
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6669153
- updated: 2024-11-05 02:49:57
-
Version 4742662
- created: 2024-11-05 02:16:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730783900'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730783900
- id: 4742662
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6667878
- updated: 2024-11-05 02:16:20
-
Version 4742474
- created: 2024-11-05 02:11:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730783769'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730783769
- id: 4742474
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6667691
- updated: 2024-11-05 02:11:25
-
Version 4741466
- created: 2024-11-05 01:44:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730783610'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730783610
- id: 4741466
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6666683
- updated: 2024-11-05 01:44:31
-
Version 4741016
- created: 2024-11-05 01:32:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730783524'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730783524
- id: 4741016
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6666233
- updated: 2024-11-05 01:32:49
-
Version 4740416
- created: 2024-11-05 01:16:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730783307'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730783307
- id: 4740416
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6665632
- updated: 2024-11-05 01:16:56
-
Version 4739477
- created: 2024-11-05 00:51:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730782907'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730782907
- id: 4739477
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6664692
- updated: 2024-11-05 00:51:55
-
Version 4739023
- created: 2024-11-05 00:39:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-04/1730782806'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_actions/2024-11-04/1730782806
- id: 4739023
- processed: 1
- raw_data:
{ "action": 3, "column_configuration": 16, "description": 8, "dev": 19, "display_in_menu": 11, "icon": 9, "id": 2, "knowledge_base": 24, "label": 6, "mobile": 18, "newbook_region": 0, "page_defaults": 15, "pin": 13, "privilege_check": 12, "route": 4, "saved_views": 14, "section_id": 10, "software_type": 20, "sort_label": 7, "supports_custom_time": 21, "supports_report_schedule": 22, "supports_report_worker": 23, "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", "software_type": "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: 2792
- schema_scan_id: 6664237
- updated: 2024-11-05 00:39:59
Schema Scans: 15
Last at 2024-11-05 23:01:03
-
Scan 6674811
- duration: 0:00:14.670399
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674811
- 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_newbookinstances_actions/2024-11-05/1730866511", "key": "raw/newbookdev_newbookinstances_actions/2024-11-05/1730866511/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11893143170923571985, "service_name": "drive-thru", "span_id": 4550755064674757976, "trace_id": 18092173425183829299 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 23:01:03
- success: True
- trace_id: 18092173425183829299
-
Scan 6674484
- duration: 0:00:14.723686
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674484
- 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_newbookinstances_actions/2024-11-05/1730866434", "key": "raw/newbookdev_newbookinstances_actions/2024-11-05/1730866434/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5200454893886025096, "service_name": "drive-thru", "span_id": 4518723497357008247, "trace_id": 6191775586470281203 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 22:46:45
- success: True
- trace_id: 6191775586470281203
-
Scan 6673809
- duration: 0:00:12.201234
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673809
- 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_newbookinstances_actions/2024-11-05/1730866313", "key": "raw/newbookdev_newbookinstances_actions/2024-11-05/1730866313/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6460881732953308971, "service_name": "drive-thru", "span_id": 1686790775921040246, "trace_id": 1503605855318553701 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 22:25:38
- success: True
- trace_id: 1503605855318553701
-
Scan 6671989
- duration: 0:00:12.134163
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671989
- 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_newbookinstances_actions/2024-11-04/1730785723", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730785723/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5479687510344848876, "service_name": "drive-thru", "span_id": 3207217608637739002, "trace_id": 14031345102685061102 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 04:21:24
- success: True
- trace_id: 14031345102685061102
-
Scan 6671720
- duration: 0:00:12.325287
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671720
- 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_newbookinstances_actions/2024-11-04/1730785126", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730785126/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13463957992673515630, "service_name": "drive-thru", "span_id": 16011796483962197363, "trace_id": 737450943266064891 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 04:06:14
- success: True
- trace_id: 737450943266064891
-
Scan 6670662
- duration: 0:00:12.116129
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670662
- 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_newbookinstances_actions/2024-11-04/1730784821", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730784821/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3328825479162924643, "service_name": "drive-thru", "span_id": 2924520508423185969, "trace_id": 1372351716040857682 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 03:29:33
- success: True
- trace_id: 1372351716040857682
-
Scan 6669326
- duration: 0:00:12.274376
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669326
- 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_newbookinstances_actions/2024-11-04/1730784217", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730784217/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12223819349826775970, "service_name": "drive-thru", "span_id": 10470134730431614929, "trace_id": 13397944323023481109 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 02:54:15
- success: True
- trace_id: 13397944323023481109
-
Scan 6669153
- duration: 0:00:14.553393
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669153
- 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_newbookinstances_actions/2024-11-04/1730784055", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730784055/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4272690181882412880, "service_name": "drive-thru", "span_id": 903840385929474104, "trace_id": 9344783837122183720 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 02:49:42
- success: True
- trace_id: 9344783837122183720
-
Scan 6667878
- duration: 0:00:14.528363
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667878
- 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_newbookinstances_actions/2024-11-04/1730783900", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730783900/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15920050038067329759, "service_name": "drive-thru", "span_id": 16648799225029113777, "trace_id": 15293746818450759420 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 02:16:06
- success: True
- trace_id: 15293746818450759420
-
Scan 6667691
- duration: 0:00:14.385523
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667691
- 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_newbookinstances_actions/2024-11-04/1730783769", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730783769/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2284854060323378264, "service_name": "drive-thru", "span_id": 15067671003722044069, "trace_id": 8694431992948709881 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 02:11:11
- success: True
- trace_id: 8694431992948709881
-
Scan 6666683
- duration: 0:00:12.161312
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666683
- 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_newbookinstances_actions/2024-11-04/1730783610", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730783610/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4473020234456806202, "service_name": "drive-thru", "span_id": 231392938563621894, "trace_id": 15411101005138065336 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 01:44:19
- success: True
- trace_id: 15411101005138065336
-
Scan 6666233
- duration: 0:00:14.376366
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666233
- 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_newbookinstances_actions/2024-11-04/1730783524", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730783524/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5490725098314786445, "service_name": "drive-thru", "span_id": 12182066706300889278, "trace_id": 5961463175722275002 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 01:32:35
- success: True
- trace_id: 5961463175722275002
-
Scan 6665632
- duration: 0:00:14.525688
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665632
- 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_newbookinstances_actions/2024-11-04/1730783307", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730783307/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18429194384582848094, "service_name": "drive-thru", "span_id": 10992418117831322669, "trace_id": 12516865518046113378 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 01:16:42
- success: True
- trace_id: 12516865518046113378
-
Scan 6664692
- duration: 0:00:14.557245
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664692
- 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_newbookinstances_actions/2024-11-04/1730782907", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730782907/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9319607243816273626, "service_name": "drive-thru", "span_id": 17091100249587454314, "trace_id": 17181701821231498928 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 00:51:41
- success: True
- trace_id: 17181701821231498928
-
Scan 6664237
- duration: 0:00:11.885833
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664237
- 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_newbookinstances_actions/2024-11-04/1730782806", "key": "raw/newbookdev_newbookinstances_actions/2024-11-04/1730782806/instances_actions.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_actions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 675355288350231219, "service_name": "drive-thru", "span_id": 15017287113229257931, "trace_id": 5604083299894069159 } } - running: False
- schema_name_id: 2792
- start_time: 2024-11-05 00:39:47
- success: True
- trace_id: 5604083299894069159
- 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", "software_type": "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:01:04
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-05/1730866511'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_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:06:48",
"disabled": false,
"format": "raw",
"id": 2792,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookinstances_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",
"software_type": "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:01:04",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_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 , `software_type` 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_newbookinstances_actions/2024-11-05/1730866511'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_actions`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_actions"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}