Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbedding_types

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748175

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-05/1730866372
id: 4748175
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6674209
updated: 2024-11-05 22:37:17

Version 4747764

created: 2024-11-05 22:25:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-05/1730866307
id: 4747764
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6673796
updated: 2024-11-05 22:25:38

Version 4747424

created: 2024-11-05 22:16:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-05/1730866234
id: 4747424
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6673456
updated: 2024-11-05 22:16:29

Version 4746837

created: 2024-11-05 04:26:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730785653
id: 4746837
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6672068
updated: 2024-11-05 04:27:03

Version 4746145

created: 2024-11-05 03:50:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730785084
id: 4746145
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6671366
updated: 2024-11-05 03:51:03

Version 4745042

created: 2024-11-05 03:19:08

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730784778
id: 4745042
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6670259
updated: 2024-11-05 03:19:18

Version 4744507

created: 2024-11-05 03:04:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730784175
id: 4744507
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6669724
updated: 2024-11-05 03:05:09

Version 4744023

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730784013
id: 4744023
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6669240
updated: 2024-11-05 02:52:12

Version 4743257

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730783868
id: 4743257
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6668474
updated: 2024-11-05 02:31:59

Version 4742173

created: 2024-11-05 02:03:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730783725
id: 4742173
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6667390
updated: 2024-11-05 02:03:17

Version 4741179

created: 2024-11-05 01:36:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730783633
id: 4741179
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6666396
updated: 2024-11-05 01:37:06

Version 4740808

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730783481
id: 4740808
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6666026
updated: 2024-11-05 01:27:14

Version 4740172

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730783262
id: 4740172
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6665389
updated: 2024-11-05 01:10:29

Version 4739369

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730782865
id: 4739369
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6664584
updated: 2024-11-05 00:49:01

Version 4738257

created: 2024-11-05 00:19:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbedding_types/2024-11-04/1730782740
id: 4738257
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2420
schema_scan_id: 6663467
updated: 2024-11-05 00:19:54

Schema Scans: 15

Last at 2024-11-05 22:37:05

Scan 6674209

duration: 0:00:11.530106

exit_message:

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

id: 6674209

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_newbookbedding_types/2024-11-05/1730866372",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-05/1730866372/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7108320565923747013,
        "service_name": "drive-thru",
        "span_id": 994071155420553432,
        "trace_id": 5362672408142311463
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 22:37:05
success: True
trace_id: 5362672408142311463

Scan 6673796

duration: 0:00:14.007836

exit_message:

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

id: 6673796

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_newbookbedding_types/2024-11-05/1730866307",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-05/1730866307/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3892640712248583784,
        "service_name": "drive-thru",
        "span_id": 14028848245695219539,
        "trace_id": 13476331566078631311
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 22:25:24
success: True
trace_id: 13476331566078631311

Scan 6673456

duration: 0:00:11.379025

exit_message:

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

id: 6673456

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_newbookbedding_types/2024-11-05/1730866234",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-05/1730866234/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4612992328983912232,
        "service_name": "drive-thru",
        "span_id": 15246867020398875015,
        "trace_id": 15532868954575590806
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 22:16:18
success: True
trace_id: 15532868954575590806

Scan 6672068

duration: 0:00:14.081374

exit_message:

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

id: 6672068

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_newbookbedding_types/2024-11-04/1730785653",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730785653/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14188674098041927894,
        "service_name": "drive-thru",
        "span_id": 3991713676060122399,
        "trace_id": 1143102901105496323
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 04:26:49
success: True
trace_id: 1143102901105496323

Scan 6671366

duration: 0:00:11.498785

exit_message:

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

id: 6671366

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_newbookbedding_types/2024-11-04/1730785084",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730785084/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4131455649790357006,
        "service_name": "drive-thru",
        "span_id": 5744620167009928716,
        "trace_id": 2906921608013130072
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 03:50:51
success: True
trace_id: 2906921608013130072

Scan 6670259

duration: 0:00:11.345385

exit_message:

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

id: 6670259

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_newbookbedding_types/2024-11-04/1730784778",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730784778/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14387665829437886169,
        "service_name": "drive-thru",
        "span_id": 181969836355100326,
        "trace_id": 3703680902682218790
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 03:19:07
success: True
trace_id: 3703680902682218790

Scan 6669724

duration: 0:00:13.843163

exit_message:

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

id: 6669724

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_newbookbedding_types/2024-11-04/1730784175",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730784175/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13801177770062725840,
        "service_name": "drive-thru",
        "span_id": 6258192771568118805,
        "trace_id": 1661333876274234663
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 03:04:56
success: True
trace_id: 1661333876274234663

Scan 6669240

duration: 0:00:11.421321

exit_message:

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

id: 6669240

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_newbookbedding_types/2024-11-04/1730784013",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730784013/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12886239273533256611,
        "service_name": "drive-thru",
        "span_id": 8892191442975157561,
        "trace_id": 6747896917146949606
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 02:52:00
success: True
trace_id: 6747896917146949606

Scan 6668474

duration: 0:00:13.770069

exit_message:

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

id: 6668474

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_newbookbedding_types/2024-11-04/1730783868",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730783868/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7650830325075980960,
        "service_name": "drive-thru",
        "span_id": 16934234700195806165,
        "trace_id": 4240537807524026502
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 02:31:46
success: True
trace_id: 4240537807524026502

Scan 6667390

duration: 0:00:13.881825

exit_message:

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

id: 6667390

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_newbookbedding_types/2024-11-04/1730783725",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730783725/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8357121451851484658,
        "service_name": "drive-thru",
        "span_id": 7617886520111076191,
        "trace_id": 3689266823315165995
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 02:03:03
success: True
trace_id: 3689266823315165995

Scan 6666396

duration: 0:00:14.007293

exit_message:

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

id: 6666396

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_newbookbedding_types/2024-11-04/1730783633",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730783633/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11586536090106190844,
        "service_name": "drive-thru",
        "span_id": 14565384880576119065,
        "trace_id": 14516248197511796112
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 01:36:52
success: True
trace_id: 14516248197511796112

Scan 6666026

duration: 0:00:11.479804

exit_message:

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

id: 6666026

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_newbookbedding_types/2024-11-04/1730783481",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730783481/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16931772393823941705,
        "service_name": "drive-thru",
        "span_id": 1986087429501142051,
        "trace_id": 18359929368233282708
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 01:27:02
success: True
trace_id: 18359929368233282708

Scan 6665389

duration: 0:00:11.530706

exit_message:

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

id: 6665389

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_newbookbedding_types/2024-11-04/1730783262",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730783262/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4355246340409577159,
        "service_name": "drive-thru",
        "span_id": 10680398009369651459,
        "trace_id": 2061680006295611376
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 01:10:18
success: True
trace_id: 2061680006295611376

Scan 6664584

duration: 0:00:11.180746

exit_message:

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

id: 6664584

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_newbookbedding_types/2024-11-04/1730782865",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730782865/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3049243426145620872,
        "service_name": "drive-thru",
        "span_id": 525742534573351442,
        "trace_id": 7685660230347419244
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 00:48:50
success: True
trace_id: 7685660230347419244

Scan 6663467

duration: 0:00:11.272433

exit_message:

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

id: 6663467

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_newbookbedding_types/2024-11-04/1730782740",
        "key": "raw/newbookdev_newbookbedding_types/2024-11-04/1730782740/bedding_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbedding_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3171651073418146966,
        "service_name": "drive-thru",
        "span_id": 4362268101643182018,
        "trace_id": 15951168925452854099
    }
}

running: False
schema_name_id: 2420
start_time: 2024-11-05 00:19:43
success: True
trace_id: 15951168925452854099

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "ota_type_id": "string",
    "tenant": "string"
}

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

ddl:

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