Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookslab_sizes

created: 2024-10-08 18:17:18
disabled: False
format: raw
id: 2888
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749495

created: 2024-11-05 23:57:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-05/1730866602'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-05/1730866602
id: 4749495
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6675572
updated: 2024-11-05 23:57:40

Version 4749248

created: 2024-11-05 23:30:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-05/1730866547'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-05/1730866547
id: 4749248
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6675280
updated: 2024-11-05 23:30:58

Version 4748524

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-05/1730866436'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-05/1730866436
id: 4748524
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6674557
updated: 2024-11-05 22:49:55

Version 4746652

created: 2024-11-05 04:14:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730785166'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730785166
id: 4746652
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6671875
updated: 2024-11-05 04:14:53

Version 4746323

created: 2024-11-05 03:58:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730785796'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730785796
id: 4746323
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6671544
updated: 2024-11-05 03:58:16

Version 4745731

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730784861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730784861
id: 4745731
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6670948
updated: 2024-11-05 03:37:22

Version 4744918

created: 2024-11-05 03:15:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730784257'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730784257
id: 4744918
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6670135
updated: 2024-11-05 03:16:04

Version 4744125

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730784096'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730784096
id: 4744125
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6669342
updated: 2024-11-05 02:54:53

Version 4743805

created: 2024-11-05 02:46:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730783930'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730783930
id: 4743805
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6669022
updated: 2024-11-05 02:46:31

Version 4742808

created: 2024-11-05 02:19:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730783809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730783809
id: 4742808
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6668025
updated: 2024-11-05 02:20:12

Version 4742167

created: 2024-11-05 02:02:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730783696'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730783696
id: 4742167
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6667384
updated: 2024-11-05 02:03:06

Version 4740897

created: 2024-11-05 01:29:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730783566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730783566
id: 4740897
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6666114
updated: 2024-11-05 01:29:33

Version 4740597

created: 2024-11-05 01:21:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730783348'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730783348
id: 4740597
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6665815
updated: 2024-11-05 01:21:42

Version 4739816

created: 2024-11-05 01:00:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730782946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730782946
id: 4739816
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6665033
updated: 2024-11-05 01:00:55

Version 4739182

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-04/1730782836'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookslab_sizes/2024-11-04/1730782836
id: 4739182
processed: 1

raw_data:

{
    "active": 8,
    "height": 6,
    "id": 2,
    "length": 5,
    "name": 3,
    "newbook_region": 0,
    "online": 7,
    "tenant": 1,
    "width": 4
}

schema_attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2888
schema_scan_id: 6664397
updated: 2024-11-05 00:44:11

Schema Scans: 15

Last at 2024-11-05 23:57:28

Scan 6675572

duration: 0:00:11.606592

exit_message:

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

id: 6675572

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_newbookslab_sizes/2024-11-05/1730866602",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-05/1730866602/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8649433824682467273,
        "service_name": "drive-thru",
        "span_id": 6344213254796808256,
        "trace_id": 17967248982998337217
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 23:57:28
success: True
trace_id: 17967248982998337217

Scan 6675280

duration: 0:00:14.170969

exit_message:

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

id: 6675280

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_newbookslab_sizes/2024-11-05/1730866547",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-05/1730866547/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17401598483337770028,
        "service_name": "drive-thru",
        "span_id": 5850116502007797399,
        "trace_id": 2938456407976604116
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 23:30:44
success: True
trace_id: 2938456407976604116

Scan 6674557

duration: 0:00:14.147427

exit_message:

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

id: 6674557

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_newbookslab_sizes/2024-11-05/1730866436",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-05/1730866436/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3636649160258048093,
        "service_name": "drive-thru",
        "span_id": 9462665651986104520,
        "trace_id": 7851251994733589797
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 22:49:41
success: True
trace_id: 7851251994733589797

Scan 6671875

duration: 0:00:14.124822

exit_message:

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

id: 6671875

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_newbookslab_sizes/2024-11-04/1730785166",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730785166/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8060647406041974011,
        "service_name": "drive-thru",
        "span_id": 279712330141380054,
        "trace_id": 7350956714262869559
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 04:14:39
success: True
trace_id: 7350956714262869559

Scan 6671544

duration: 0:00:11.721956

exit_message:

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

id: 6671544

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_newbookslab_sizes/2024-11-04/1730785796",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730785796/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13368599179711724671,
        "service_name": "drive-thru",
        "span_id": 6864311387285583350,
        "trace_id": 3263321714208149669
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 03:58:05
success: True
trace_id: 3263321714208149669

Scan 6670948

duration: 0:00:11.395772

exit_message:

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

id: 6670948

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_newbookslab_sizes/2024-11-04/1730784861",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730784861/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3777731788379469068,
        "service_name": "drive-thru",
        "span_id": 12436221171093303660,
        "trace_id": 2884714654195600511
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 03:37:10
success: True
trace_id: 2884714654195600511

Scan 6670135

duration: 0:00:11.423389

exit_message:

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

id: 6670135

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_newbookslab_sizes/2024-11-04/1730784257",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730784257/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 951764463087445304,
        "service_name": "drive-thru",
        "span_id": 3984661958812552402,
        "trace_id": 15545700214867482710
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 03:15:53
success: True
trace_id: 15545700214867482710

Scan 6669342

duration: 0:00:14.033114

exit_message:

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

id: 6669342

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_newbookslab_sizes/2024-11-04/1730784096",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730784096/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16638398437401519193,
        "service_name": "drive-thru",
        "span_id": 5713372963849698683,
        "trace_id": 3032874743335024838
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 02:54:39
success: True
trace_id: 3032874743335024838

Scan 6669022

duration: 0:00:11.478838

exit_message:

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

id: 6669022

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_newbookslab_sizes/2024-11-04/1730783930",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730783930/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1070893999550142230,
        "service_name": "drive-thru",
        "span_id": 2213254690357135849,
        "trace_id": 10036879171417312359
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 02:46:19
success: True
trace_id: 10036879171417312359

Scan 6668025

duration: 0:00:13.992158

exit_message:

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

id: 6668025

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_newbookslab_sizes/2024-11-04/1730783809",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730783809/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1715959329946190581,
        "service_name": "drive-thru",
        "span_id": 14562587371446808648,
        "trace_id": 6662846783352867391
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 02:19:58
success: True
trace_id: 6662846783352867391

Scan 6667384

duration: 0:00:13.929601

exit_message:

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

id: 6667384

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_newbookslab_sizes/2024-11-04/1730783696",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730783696/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15517331278287491854,
        "service_name": "drive-thru",
        "span_id": 3374039049798724284,
        "trace_id": 13963907082132756166
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 02:02:52
success: True
trace_id: 13963907082132756166

Scan 6666114

duration: 0:00:11.481535

exit_message:

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

id: 6666114

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_newbookslab_sizes/2024-11-04/1730783566",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730783566/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4608894071879510874,
        "service_name": "drive-thru",
        "span_id": 6908431144792094918,
        "trace_id": 10983748690135887982
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 01:29:22
success: True
trace_id: 10983748690135887982

Scan 6665815

duration: 0:00:11.622464

exit_message:

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

id: 6665815

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_newbookslab_sizes/2024-11-04/1730783348",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730783348/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13266331449476009806,
        "service_name": "drive-thru",
        "span_id": 2656252517532241859,
        "trace_id": 10121164929464601626
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 01:21:30
success: True
trace_id: 10121164929464601626

Scan 6665033

duration: 0:00:13.831766

exit_message:

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

id: 6665033

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_newbookslab_sizes/2024-11-04/1730782946",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730782946/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5921233294754163526,
        "service_name": "drive-thru",
        "span_id": 16999518649740776398,
        "trace_id": 3290778522650985638
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 01:00:41
success: True
trace_id: 3290778522650985638

Scan 6664397

duration: 0:00:11.323895

exit_message:

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

id: 6664397

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_newbookslab_sizes/2024-11-04/1730782836",
        "key": "raw/newbookdev_newbookslab_sizes/2024-11-04/1730782836/slab_sizes.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookslab_sizes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1909418261898331937,
        "service_name": "drive-thru",
        "span_id": 3115195494575462994,
        "trace_id": 11338766150303495467
    }
}

running: False
schema_name_id: 2888
start_time: 2024-11-05 00:44:00
success: True
trace_id: 11338766150303495467

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "height": "string",
    "id": "string",
    "length": "string",
    "name": "string",
    "newbook_region": "string",
    "online": "string",
    "tenant": "string",
    "width": "string"
}

created: 2024-11-05 23:57:29

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-05/1730866602'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
}

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:17:18",
        "disabled": false,
        "format": "raw",
        "id": 2888,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookslab_sizes"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "height": "string",
            "id": "string",
            "length": "string",
            "name": "string",
            "newbook_region": "string",
            "online": "string",
            "tenant": "string",
            "width": "string"
        },
        "created": "2024-11-05 23:57:29",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookslab_sizes`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `width`  string , `length`  string , `height`  string , `online`  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_newbookslab_sizes/2024-11-05/1730866602'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookslab_sizes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookslab_sizes"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}