Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcontact_templates

created: 2024-10-08 17:49:37
disabled: False
format: raw
id: 2585
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbookcontact_templates"
}

type: drivethrucsv

Schema Versions: 15

Version 4748393

created: 2024-11-05 22:44:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-05/1730866432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-05/1730866432
id: 4748393
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6674424
updated: 2024-11-05 22:44:55

Version 4747864

created: 2024-11-05 22:27:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-05/1730866349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-05/1730866349
id: 4747864
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6673896
updated: 2024-11-05 22:28:09

Version 4747528

created: 2024-11-05 22:19:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-05/1730866260'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-05/1730866260
id: 4747528
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6673558
updated: 2024-11-05 22:19:23

Version 4746955

created: 2024-11-05 04:35:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730785680'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730785680
id: 4746955
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6672186
updated: 2024-11-05 04:35:28

Version 4746026

created: 2024-11-05 03:46:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730785101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730785101
id: 4746026
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6671246
updated: 2024-11-05 03:46:48

Version 4745513

created: 2024-11-05 03:31:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730784797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730784797
id: 4745513
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6670730
updated: 2024-11-05 03:31:40

Version 4744459

created: 2024-11-05 03:03:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730784192'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730784192
id: 4744459
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6669676
updated: 2024-11-05 03:03:49

Version 4743194

created: 2024-11-05 02:30:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730784029'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730784029
id: 4743194
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6668411
updated: 2024-11-05 02:30:15

Version 4743086

created: 2024-11-05 02:27:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730783838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730783838
id: 4743086
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6668303
updated: 2024-11-05 02:27:32

Version 4741883

created: 2024-11-05 01:55:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730783743'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730783743
id: 4741883
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6667100
updated: 2024-11-05 01:55:28

Version 4741730

created: 2024-11-05 01:51:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730783646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730783646
id: 4741730
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6666947
updated: 2024-11-05 01:51:31

Version 4740860

created: 2024-11-05 01:28:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730783498'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730783498
id: 4740860
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6666077
updated: 2024-11-05 01:28:36

Version 4740256

created: 2024-11-05 01:12:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730783280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730783280
id: 4740256
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6665472
updated: 2024-11-05 01:12:43

Version 4739420

created: 2024-11-05 00:50:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730782882'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730782882
id: 4739420
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6664635
updated: 2024-11-05 00:50:23

Version 4738905

created: 2024-11-05 00:36:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-04/1730782787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_templates/2024-11-04/1730782787
id: 4738905
processed: 1

raw_data:

{
    "active": 24,
    "bind": 13,
    "content": 5,
    "content_order": 28,
    "counter_signable": 25,
    "email_content": 6,
    "email_footer": 17,
    "email_header": 15,
    "email_subject": 4,
    "favourites": 21,
    "footer": 16,
    "header": 14,
    "id": 2,
    "internal_email": 22,
    "last_updated": 20,
    "letterhead": 18,
    "name": 3,
    "newbook_region": 0,
    "ota_content": 10,
    "pdf_size": 12,
    "send_via": 19,
    "sending_type": 23,
    "signatures_required": 26,
    "signatures_required_before_checkin": 27,
    "slack_content": 9,
    "sms_content": 8,
    "tenant": 1,
    "text_content": 7,
    "type": 11
}

schema_attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

schema_name_id: 2585
schema_scan_id: 6664118
updated: 2024-11-05 00:36:53

Schema Scans: 15

Last at 2024-11-05 22:44:40

Scan 6674424

duration: 0:00:15.005819

exit_message:

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

id: 6674424

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_newbookcontact_templates/2024-11-05/1730866432",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-05/1730866432/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10395451581450889501,
        "service_name": "drive-thru",
        "span_id": 13467860878387974595,
        "trace_id": 948428732501909175
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 22:44:40
success: True
trace_id: 948428732501909175

Scan 6673896

duration: 0:00:12.064078

exit_message:

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

id: 6673896

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_newbookcontact_templates/2024-11-05/1730866349",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-05/1730866349/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 767897652037431597,
        "service_name": "drive-thru",
        "span_id": 15522829178098918710,
        "trace_id": 14641924861319228326
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 22:27:57
success: True
trace_id: 14641924861319228326

Scan 6673558

duration: 0:00:12.011836

exit_message:

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

id: 6673558

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_newbookcontact_templates/2024-11-05/1730866260",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-05/1730866260/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17801413274711486344,
        "service_name": "drive-thru",
        "span_id": 1409052413373790454,
        "trace_id": 15445618342908896391
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 22:19:11
success: True
trace_id: 15445618342908896391

Scan 6672186

duration: 0:00:12.279333

exit_message:

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

id: 6672186

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_newbookcontact_templates/2024-11-04/1730785680",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730785680/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5310260352730089184,
        "service_name": "drive-thru",
        "span_id": 1712092301367121524,
        "trace_id": 1290898602048656006
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 04:35:16
success: True
trace_id: 1290898602048656006

Scan 6671246

duration: 0:00:12.376216

exit_message:

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

id: 6671246

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_newbookcontact_templates/2024-11-04/1730785101",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730785101/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12484966224833795613,
        "service_name": "drive-thru",
        "span_id": 3735181739865862650,
        "trace_id": 15700195988896435653
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 03:46:35
success: True
trace_id: 15700195988896435653

Scan 6670730

duration: 0:00:12.407000

exit_message:

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

id: 6670730

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_newbookcontact_templates/2024-11-04/1730784797",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730784797/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13500387004907611772,
        "service_name": "drive-thru",
        "span_id": 17519165753411895431,
        "trace_id": 5149703753583507038
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 03:31:27
success: True
trace_id: 5149703753583507038

Scan 6669676

duration: 0:00:12.299859

exit_message:

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

id: 6669676

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_newbookcontact_templates/2024-11-04/1730784192",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730784192/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16571219538385675662,
        "service_name": "drive-thru",
        "span_id": 16162724417821066197,
        "trace_id": 2105670957400172848
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 03:03:37
success: True
trace_id: 2105670957400172848

Scan 6668411

duration: 0:00:12.127143

exit_message:

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

id: 6668411

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_newbookcontact_templates/2024-11-04/1730784029",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730784029/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5532679938910237710,
        "service_name": "drive-thru",
        "span_id": 7257474093242659399,
        "trace_id": 3045842116297820471
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 02:30:02
success: True
trace_id: 3045842116297820471

Scan 6668303

duration: 0:00:14.771854

exit_message:

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

id: 6668303

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_newbookcontact_templates/2024-11-04/1730783838",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730783838/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10451740505959287388,
        "service_name": "drive-thru",
        "span_id": 245096180252096556,
        "trace_id": 14903698252854887996
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 02:27:17
success: True
trace_id: 14903698252854887996

Scan 6667100

duration: 0:00:14.584507

exit_message:

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

id: 6667100

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_newbookcontact_templates/2024-11-04/1730783743",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730783743/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5336348795515737749,
        "service_name": "drive-thru",
        "span_id": 1716055951537333488,
        "trace_id": 3227155520542071131
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 01:55:14
success: True
trace_id: 3227155520542071131

Scan 6666947

duration: 0:00:14.696490

exit_message:

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

id: 6666947

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_newbookcontact_templates/2024-11-04/1730783646",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730783646/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4857630423476517828,
        "service_name": "drive-thru",
        "span_id": 8522904176549865580,
        "trace_id": 11161881384576903852
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 01:51:17
success: True
trace_id: 11161881384576903852

Scan 6666077

duration: 0:00:12.018261

exit_message:

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

id: 6666077

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_newbookcontact_templates/2024-11-04/1730783498",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730783498/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13777101614823102955,
        "service_name": "drive-thru",
        "span_id": 6229565799661317812,
        "trace_id": 1486734775359782832
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 01:28:24
success: True
trace_id: 1486734775359782832

Scan 6665472

duration: 0:00:12.118676

exit_message:

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

id: 6665472

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_newbookcontact_templates/2024-11-04/1730783280",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730783280/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17828979996517522717,
        "service_name": "drive-thru",
        "span_id": 9911846088824608871,
        "trace_id": 8067732423814334365
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 01:12:31
success: True
trace_id: 8067732423814334365

Scan 6664635

duration: 0:00:12.146750

exit_message:

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

id: 6664635

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_newbookcontact_templates/2024-11-04/1730782882",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730782882/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6459907082167917194,
        "service_name": "drive-thru",
        "span_id": 8601162043685478375,
        "trace_id": 98141744562583968
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 00:50:10
success: True
trace_id: 98141744562583968

Scan 6664118

duration: 0:00:12.205688

exit_message:

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

id: 6664118

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_newbookcontact_templates/2024-11-04/1730782787",
        "key": "raw/newbookdev_newbookcontact_templates/2024-11-04/1730782787/contact_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13556328356100160562,
        "service_name": "drive-thru",
        "span_id": 8836965398037622853,
        "trace_id": 53953677349040407
    }
}

running: False
schema_name_id: 2585
start_time: 2024-11-05 00:36:41
success: True
trace_id: 53953677349040407

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "bind": "string",
    "content": "string",
    "content_order": "string",
    "counter_signable": "string",
    "email_content": "string",
    "email_footer": "string",
    "email_header": "string",
    "email_subject": "string",
    "favourites": "string",
    "footer": "string",
    "header": "string",
    "id": "string",
    "internal_email": "string",
    "last_updated": "string",
    "letterhead": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_content": "string",
    "pdf_size": "string",
    "send_via": "string",
    "sending_type": "string",
    "signatures_required": "string",
    "signatures_required_before_checkin": "string",
    "slack_content": "string",
    "sms_content": "string",
    "tenant": "string",
    "text_content": "string",
    "type": "string"
}

created: 2024-11-05 22:44:42

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-05/1730866432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 17:49:37",
        "disabled": false,
        "format": "raw",
        "id": 2585,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcontact_templates"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "bind": "string",
            "content": "string",
            "content_order": "string",
            "counter_signable": "string",
            "email_content": "string",
            "email_footer": "string",
            "email_header": "string",
            "email_subject": "string",
            "favourites": "string",
            "footer": "string",
            "header": "string",
            "id": "string",
            "internal_email": "string",
            "last_updated": "string",
            "letterhead": "string",
            "name": "string",
            "newbook_region": "string",
            "ota_content": "string",
            "pdf_size": "string",
            "send_via": "string",
            "sending_type": "string",
            "signatures_required": "string",
            "signatures_required_before_checkin": "string",
            "slack_content": "string",
            "sms_content": "string",
            "tenant": "string",
            "text_content": "string",
            "type": "string"
        },
        "created": "2024-11-05 22:44:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `email_subject`  string , `content`  string , `email_content`  string , `text_content`  string , `sms_content`  string , `slack_content`  string , `ota_content`  string , `type`  string , `pdf_size`  string , `bind`  string , `header`  string , `email_header`  string , `footer`  string , `email_footer`  string , `letterhead`  string , `send_via`  string , `last_updated`  string , `favourites`  string , `internal_email`  string , `sending_type`  string , `active`  string , `counter_signable`  string , `signatures_required`  string , `signatures_required_before_checkin`  string , `content_order`  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_newbookcontact_templates/2024-11-05/1730866432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_templates`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_templates"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}