Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads

created: 2024-10-08 18:38:12
disabled: False
format: raw
id: 3081
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749272

created: 2024-11-05 23:33:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-05/1730866620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-05/1730866620
id: 4749272
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6675304
updated: 2024-11-05 23:33:15

Version 4749150

created: 2024-11-05 23:23:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-05/1730866577
id: 4749150
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6675182
updated: 2024-11-05 23:23:58

Version 4748617

created: 2024-11-05 22:53:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-05/1730866477'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-05/1730866477
id: 4748617
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6674649
updated: 2024-11-05 22:53:51

Version 4747170

created: 2024-11-05 04:57:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730785818'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730785818
id: 4747170
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6672402
updated: 2024-11-05 04:58:01

Version 4745846

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730785179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730785179
id: 4745846
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6671063
updated: 2024-11-05 03:40:57

Version 4745837

created: 2024-11-05 03:40:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730784874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730784874
id: 4745837
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6671054
updated: 2024-11-05 03:40:40

Version 4744984

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730784270'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730784270
id: 4744984
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6670202
updated: 2024-11-05 03:17:51

Version 4744779

created: 2024-11-05 03:12:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730784108'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730784108
id: 4744779
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6669996
updated: 2024-11-05 03:12:20

Version 4743642

created: 2024-11-05 02:42:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730783940'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783940
id: 4743642
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6668859
updated: 2024-11-05 02:42:13

Version 4742995

created: 2024-11-05 02:24:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730783822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783822
id: 4742995
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6668212
updated: 2024-11-05 02:25:05

Version 4742049

created: 2024-11-05 01:59:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730783706'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783706
id: 4742049
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6667266
updated: 2024-11-05 01:59:48

Version 4741524

created: 2024-11-05 01:45:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730783579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783579
id: 4741524
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6666741
updated: 2024-11-05 01:46:00

Version 4740304

created: 2024-11-05 01:13:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730783360'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783360
id: 4740304
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6665521
updated: 2024-11-05 01:14:01

Version 4739885

created: 2024-11-05 01:02:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730782958'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730782958
id: 4739885
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6665102
updated: 2024-11-05 01:02:47

Version 4739188

created: 2024-11-05 00:44:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-04/1730782845'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730782845
id: 4739188
processed: 1

raw_data:

{
    "active": 11,
    "display_on": 10,
    "id": 2,
    "image_uri": 5,
    "margin_bottom": 7,
    "margin_left": 8,
    "margin_right": 9,
    "margin_top": 6,
    "name": 3,
    "newbook_region": 0,
    "pdf_size": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

schema_name_id: 3081
schema_scan_id: 6664403
updated: 2024-11-05 00:44:17

Schema Scans: 15

Last at 2024-11-05 23:33:03

Scan 6675304

duration: 0:00:11.683168

exit_message:

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

id: 6675304

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_newbooktemplate_letterheads/2024-11-05/1730866620",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-05/1730866620/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18056469686491465556,
        "service_name": "drive-thru",
        "span_id": 17595363122838549609,
        "trace_id": 9270981185499678091
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 23:33:03
success: True
trace_id: 9270981185499678091

Scan 6675182

duration: 0:00:11.693812

exit_message:

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

id: 6675182

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_newbooktemplate_letterheads/2024-11-05/1730866577",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-05/1730866577/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13026973999202695881,
        "service_name": "drive-thru",
        "span_id": 17663157229465558382,
        "trace_id": 7832831381503617399
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 23:23:46
success: True
trace_id: 7832831381503617399

Scan 6674649

duration: 0:00:14.440520

exit_message:

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

id: 6674649

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_newbooktemplate_letterheads/2024-11-05/1730866477",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-05/1730866477/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16345797996470093026,
        "service_name": "drive-thru",
        "span_id": 11461081200442630924,
        "trace_id": 10115139185231287816
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 22:53:37
success: True
trace_id: 10115139185231287816

Scan 6672402

duration: 0:00:14.234071

exit_message:

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

id: 6672402

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_newbooktemplate_letterheads/2024-11-04/1730785818",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730785818/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15594607710114874143,
        "service_name": "drive-thru",
        "span_id": 9559430817426498496,
        "trace_id": 2144772656018857654
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 04:57:47
success: True
trace_id: 2144772656018857654

Scan 6671063

duration: 0:00:11.842560

exit_message:

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

id: 6671063

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_newbooktemplate_letterheads/2024-11-04/1730785179",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730785179/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6774722376157024187,
        "service_name": "drive-thru",
        "span_id": 8237271664357761381,
        "trace_id": 5947028289491125875
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 03:40:45
success: True
trace_id: 5947028289491125875

Scan 6671054

duration: 0:00:14.240266

exit_message:

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

id: 6671054

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_newbooktemplate_letterheads/2024-11-04/1730784874",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730784874/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15883620001544622748,
        "service_name": "drive-thru",
        "span_id": 14188522204020389599,
        "trace_id": 13243691599077443271
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 03:40:26
success: True
trace_id: 13243691599077443271

Scan 6670202

duration: 0:00:14.022746

exit_message:

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

id: 6670202

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_newbooktemplate_letterheads/2024-11-04/1730784270",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730784270/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5951371068573853286,
        "service_name": "drive-thru",
        "span_id": 14709265666980119627,
        "trace_id": 7235447008067925299
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 03:17:37
success: True
trace_id: 7235447008067925299

Scan 6669996

duration: 0:00:11.574368

exit_message:

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

id: 6669996

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_newbooktemplate_letterheads/2024-11-04/1730784108",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730784108/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8736451909943619670,
        "service_name": "drive-thru",
        "span_id": 14384953282631822368,
        "trace_id": 13629585303862673560
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 03:12:09
success: True
trace_id: 13629585303862673560

Scan 6668859

duration: 0:00:11.613029

exit_message:

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

id: 6668859

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_newbooktemplate_letterheads/2024-11-04/1730783940",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783940/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2097959700364640985,
        "service_name": "drive-thru",
        "span_id": 3037665250934548146,
        "trace_id": 9641318815755229411
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 02:42:01
success: True
trace_id: 9641318815755229411

Scan 6668212

duration: 0:00:11.613551

exit_message:

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

id: 6668212

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_newbooktemplate_letterheads/2024-11-04/1730783822",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783822/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11550880691366389340,
        "service_name": "drive-thru",
        "span_id": 12584336077458491570,
        "trace_id": 17698177285592215909
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 02:24:53
success: True
trace_id: 17698177285592215909

Scan 6667266

duration: 0:00:11.478353

exit_message:

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

id: 6667266

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_newbooktemplate_letterheads/2024-11-04/1730783706",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783706/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13924716417473055898,
        "service_name": "drive-thru",
        "span_id": 11836399657504834553,
        "trace_id": 7030503024899162545
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 01:59:37
success: True
trace_id: 7030503024899162545

Scan 6666741

duration: 0:00:11.490488

exit_message:

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

id: 6666741

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_newbooktemplate_letterheads/2024-11-04/1730783579",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783579/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14831268385533921108,
        "service_name": "drive-thru",
        "span_id": 8303199737637294154,
        "trace_id": 8138171285622365535
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 01:45:48
success: True
trace_id: 8138171285622365535

Scan 6665521

duration: 0:00:14.113537

exit_message:

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

id: 6665521

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_newbooktemplate_letterheads/2024-11-04/1730783360",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730783360/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1380345280089508288,
        "service_name": "drive-thru",
        "span_id": 5314464507568123221,
        "trace_id": 474517552906358982
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 01:13:47
success: True
trace_id: 474517552906358982

Scan 6665102

duration: 0:00:13.968615

exit_message:

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

id: 6665102

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_newbooktemplate_letterheads/2024-11-04/1730782958",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730782958/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7372603190706508176,
        "service_name": "drive-thru",
        "span_id": 15415709766213207491,
        "trace_id": 12100214132536176394
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 01:02:33
success: True
trace_id: 12100214132536176394

Scan 6664403

duration: 0:00:13.991797

exit_message:

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

id: 6664403

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_newbooktemplate_letterheads/2024-11-04/1730782845",
        "key": "raw/newbookdev_newbooktemplate_letterheads/2024-11-04/1730782845/template_letterheads.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3706239806633836893,
        "service_name": "drive-thru",
        "span_id": 15956873880166136196,
        "trace_id": 10443650209373825388
    }
}

running: False
schema_name_id: 3081
start_time: 2024-11-05 00:44:03
success: True
trace_id: 10443650209373825388

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "display_on": "string",
    "id": "string",
    "image_uri": "string",
    "margin_bottom": "string",
    "margin_left": "string",
    "margin_right": "string",
    "margin_top": "string",
    "name": "string",
    "newbook_region": "string",
    "pdf_size": "string",
    "tenant": "string"
}

created: 2024-11-05 23:33: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_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-05/1730866620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
}

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 18:38:12",
        "disabled": false,
        "format": "raw",
        "id": 3081,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktemplate_letterheads"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "display_on": "string",
            "id": "string",
            "image_uri": "string",
            "margin_bottom": "string",
            "margin_left": "string",
            "margin_right": "string",
            "margin_top": "string",
            "name": "string",
            "newbook_region": "string",
            "pdf_size": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:33: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_newbooktemplate_letterheads`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `pdf_size`  string , `image_uri`  string , `margin_top`  string , `margin_bottom`  string , `margin_left`  string , `margin_right`  string , `display_on`  string , `active`  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_newbooktemplate_letterheads/2024-11-05/1730866620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktemplate_letterheads"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}