Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookequipment_types

created: 2024-10-08 17:53:31
disabled: False
format: raw
id: 2639
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748736

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-05/1730866484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-05/1730866484
id: 4748736
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6674768
updated: 2024-11-05 22:58:52

Version 4748399

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-05/1730866398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-05/1730866398
id: 4748399
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6674431
updated: 2024-11-05 22:45:09

Version 4747659

created: 2024-11-05 22:22:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-05/1730866287'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-05/1730866287
id: 4747659
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6673691
updated: 2024-11-05 22:22:52

Version 4746843

created: 2024-11-05 04:27:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730785706'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730785706
id: 4746843
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6672073
updated: 2024-11-05 04:27:29

Version 4746151

created: 2024-11-05 03:51:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730785116'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730785116
id: 4746151
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6671372
updated: 2024-11-05 03:51:18

Version 4745390

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730784811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730784811
id: 4745390
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6670607
updated: 2024-11-05 03:28:23

Version 4744892

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730784207'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730784207
id: 4744892
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6670109
updated: 2024-11-05 03:15:22

Version 4744233

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730784045'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730784045
id: 4744233
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6669450
updated: 2024-11-05 02:57:38

Version 4743217

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730783892'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730783892
id: 4743217
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6668435
updated: 2024-11-05 02:30:50

Version 4742582

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730783758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730783758
id: 4742582
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6667799
updated: 2024-11-05 02:14:15

Version 4742006

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730783658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730783658
id: 4742006
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6667223
updated: 2024-11-05 01:58:43

Version 4741068

created: 2024-11-05 01:33:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730783514'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730783514
id: 4741068
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6666285
updated: 2024-11-05 01:34:09

Version 4740371

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730783296'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730783296
id: 4740371
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6665588
updated: 2024-11-05 01:15:43

Version 4739418

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730782898'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730782898
id: 4739418
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6664633
updated: 2024-11-05 00:50:16

Version 4738529

created: 2024-11-05 00:26:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-04/1730782748'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_types/2024-11-04/1730782748
id: 4738529
processed: 1

raw_data:

{
    "active": 6,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "slideouts_enabled": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

schema_name_id: 2639
schema_scan_id: 6663742
updated: 2024-11-05 00:26:59

Schema Scans: 15

Last at 2024-11-05 22:58:38

Scan 6674768

duration: 0:00:13.999676

exit_message:

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

id: 6674768

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_newbookequipment_types/2024-11-05/1730866484",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-05/1730866484/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 308299311623320362,
        "service_name": "drive-thru",
        "span_id": 3899390477310274213,
        "trace_id": 3235646314957965713
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 22:58:38
success: True
trace_id: 3235646314957965713

Scan 6674431

duration: 0:00:13.987991

exit_message:

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

id: 6674431

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_newbookequipment_types/2024-11-05/1730866398",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-05/1730866398/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17831273566691724133,
        "service_name": "drive-thru",
        "span_id": 15447443902841796150,
        "trace_id": 14010144419913376216
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 22:44:55
success: True
trace_id: 14010144419913376216

Scan 6673691

duration: 0:00:11.343059

exit_message:

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

id: 6673691

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_newbookequipment_types/2024-11-05/1730866287",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-05/1730866287/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8618020744618762924,
        "service_name": "drive-thru",
        "span_id": 8085739049128318558,
        "trace_id": 13869283713073830103
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 22:22:41
success: True
trace_id: 13869283713073830103

Scan 6672073

duration: 0:00:14.081409

exit_message:

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

id: 6672073

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_newbookequipment_types/2024-11-04/1730785706",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730785706/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3314832430031123204,
        "service_name": "drive-thru",
        "span_id": 9025776061081583866,
        "trace_id": 4478829159142895466
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 04:27:15
success: True
trace_id: 4478829159142895466

Scan 6671372

duration: 0:00:14.078159

exit_message:

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

id: 6671372

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_newbookequipment_types/2024-11-04/1730785116",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730785116/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5730846092668134849,
        "service_name": "drive-thru",
        "span_id": 4597235907095325296,
        "trace_id": 3883250791204469134
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 03:51:04
success: True
trace_id: 3883250791204469134

Scan 6670607

duration: 0:00:11.404575

exit_message:

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

id: 6670607

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_newbookequipment_types/2024-11-04/1730784811",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730784811/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4198542286637539580,
        "service_name": "drive-thru",
        "span_id": 15181826402444303418,
        "trace_id": 12278431424727057415
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 03:28:11
success: True
trace_id: 12278431424727057415

Scan 6670109

duration: 0:00:11.419943

exit_message:

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

id: 6670109

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_newbookequipment_types/2024-11-04/1730784207",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730784207/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2512795326021270216,
        "service_name": "drive-thru",
        "span_id": 6884446731772470719,
        "trace_id": 13406065783878271904
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 03:15:11
success: True
trace_id: 13406065783878271904

Scan 6669450

duration: 0:00:11.356622

exit_message:

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

id: 6669450

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_newbookequipment_types/2024-11-04/1730784045",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730784045/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4994098184452672220,
        "service_name": "drive-thru",
        "span_id": 1554438873709185082,
        "trace_id": 17209619738991310635
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 02:57:26
success: True
trace_id: 17209619738991310635

Scan 6668435

duration: 0:00:11.423467

exit_message:

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

id: 6668435

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_newbookequipment_types/2024-11-04/1730783892",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730783892/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7321406219387259060,
        "service_name": "drive-thru",
        "span_id": 12783047030977512928,
        "trace_id": 3581120428518124199
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 02:30:38
success: True
trace_id: 3581120428518124199

Scan 6667799

duration: 0:00:11.297433

exit_message:

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

id: 6667799

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_newbookequipment_types/2024-11-04/1730783758",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730783758/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7780135182823698125,
        "service_name": "drive-thru",
        "span_id": 9706607080337758772,
        "trace_id": 10433594080150091749
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 02:14:03
success: True
trace_id: 10433594080150091749

Scan 6667223

duration: 0:00:11.373096

exit_message:

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

id: 6667223

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_newbookequipment_types/2024-11-04/1730783658",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730783658/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9423912873994535691,
        "service_name": "drive-thru",
        "span_id": 13214203233270420262,
        "trace_id": 4537889199898951213
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 01:58:31
success: True
trace_id: 4537889199898951213

Scan 6666285

duration: 0:00:11.434753

exit_message:

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

id: 6666285

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_newbookequipment_types/2024-11-04/1730783514",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730783514/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6452497358576460526,
        "service_name": "drive-thru",
        "span_id": 748564288386404421,
        "trace_id": 10614231928521577941
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 01:33:58
success: True
trace_id: 10614231928521577941

Scan 6665588

duration: 0:00:11.512591

exit_message:

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

id: 6665588

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_newbookequipment_types/2024-11-04/1730783296",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730783296/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4981634909965467312,
        "service_name": "drive-thru",
        "span_id": 2096662520555337030,
        "trace_id": 9775451858219450725
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 01:15:32
success: True
trace_id: 9775451858219450725

Scan 6664633

duration: 0:00:11.194770

exit_message:

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

id: 6664633

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_newbookequipment_types/2024-11-04/1730782898",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730782898/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12763390399205570711,
        "service_name": "drive-thru",
        "span_id": 4411900842741442218,
        "trace_id": 7254881910954551724
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 00:50:05
success: True
trace_id: 7254881910954551724

Scan 6663742

duration: 0:00:11.404848

exit_message:

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

id: 6663742

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_newbookequipment_types/2024-11-04/1730782748",
        "key": "raw/newbookdev_newbookequipment_types/2024-11-04/1730782748/equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3781303212366813253,
        "service_name": "drive-thru",
        "span_id": 17043008759000859868,
        "trace_id": 5477500819769831193
    }
}

running: False
schema_name_id: 2639
start_time: 2024-11-05 00:26:47
success: True
trace_id: 5477500819769831193

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "slideouts_enabled": "string",
    "tenant": "string"
}

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

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 17:53:31",
        "disabled": false,
        "format": "raw",
        "id": 2639,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookequipment_types"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "display_order": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "slideouts_enabled": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:58:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookequipment_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `slideouts_enabled`  string , `display_order`  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_newbookequipment_types/2024-11-05/1730866484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_types`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_types"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}