Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments

created: 2024-10-08 17:43:58
disabled: False
format: raw
id: 2506
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748266

created: 2024-11-05 22:40:14

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-05/1730866381
id: 4748266
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6674298
updated: 2024-11-05 22:40:27

Version 4747773

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-05/1730866314
id: 4747773
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6673805
updated: 2024-11-05 22:25:51

Version 4747415

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-05/1730866239
id: 4747415
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6673447
updated: 2024-11-05 22:16:17

Version 4746710

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730785658
id: 4746710
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6671934
updated: 2024-11-05 04:17:52

Version 4745957

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730785087
id: 4745957
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6671177
updated: 2024-11-05 03:44:17

Version 4745214

created: 2024-11-05 03:23:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730784781
id: 4745214
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6670432
updated: 2024-11-05 03:23:48

Version 4744547

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730784178
id: 4744547
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6669765
updated: 2024-11-05 03:06:15

Version 4744062

created: 2024-11-05 02:53:00

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730784015
id: 4744062
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6669279
updated: 2024-11-05 02:53:11

Version 4743320

created: 2024-11-05 02:33:29

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783870
id: 4743320
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6668538
updated: 2024-11-05 02:33:40

Version 4742334

created: 2024-11-05 02:07:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783728
id: 4742334
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6667551
updated: 2024-11-05 02:07:39

Version 4741828

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783635
id: 4741828
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6667045
updated: 2024-11-05 01:54:00

Version 4740925

created: 2024-11-05 01:30:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783484
id: 4740925
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6666142
updated: 2024-11-05 01:30:20

Version 4740041

created: 2024-11-05 01:06:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783266
id: 4740041
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6665258
updated: 2024-11-05 01:06:57

Version 4739353

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730782869
id: 4739353
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6664568
updated: 2024-11-05 00:48:36

Version 4738855

created: 2024-11-05 00:35:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730782776
id: 4738855
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2506
schema_scan_id: 6664069
updated: 2024-11-05 00:35:35

Schema Scans: 15

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

Scan 6674298

duration: 0:00:13.989865

exit_message:

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

id: 6674298

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_newbookbookings_market_segments/2024-11-05/1730866381",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-05/1730866381/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10129317687122168968,
        "service_name": "drive-thru",
        "span_id": 16662078945166112378,
        "trace_id": 1524561409898780830
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 22:40:13
success: True
trace_id: 1524561409898780830

Scan 6673805

duration: 0:00:13.879821

exit_message:

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

id: 6673805

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_newbookbookings_market_segments/2024-11-05/1730866314",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-05/1730866314/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15748756857783022305,
        "service_name": "drive-thru",
        "span_id": 13712031166389647299,
        "trace_id": 6319704393405300028
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 22:25:38
success: True
trace_id: 6319704393405300028

Scan 6673447

duration: 0:00:13.948955

exit_message:

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

id: 6673447

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_newbookbookings_market_segments/2024-11-05/1730866239",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-05/1730866239/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10441525039744242150,
        "service_name": "drive-thru",
        "span_id": 964257695412889438,
        "trace_id": 10907559943471360068
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 22:16:03
success: True
trace_id: 10907559943471360068

Scan 6671934

duration: 0:00:13.977997

exit_message:

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

id: 6671934

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_newbookbookings_market_segments/2024-11-04/1730785658",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730785658/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10934880823960914993,
        "service_name": "drive-thru",
        "span_id": 17141478556290691670,
        "trace_id": 13495520588449259477
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 04:17:38
success: True
trace_id: 13495520588449259477

Scan 6671177

duration: 0:00:11.452373

exit_message:

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

id: 6671177

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_newbookbookings_market_segments/2024-11-04/1730785087",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730785087/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4560340440435141230,
        "service_name": "drive-thru",
        "span_id": 18270957705192917149,
        "trace_id": 14210717766974856040
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 03:44:05
success: True
trace_id: 14210717766974856040

Scan 6670432

duration: 0:00:13.821977

exit_message:

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

id: 6670432

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_newbookbookings_market_segments/2024-11-04/1730784781",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730784781/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1111927971951948804,
        "service_name": "drive-thru",
        "span_id": 598383934096692086,
        "trace_id": 6267129638992476673
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 03:23:35
success: True
trace_id: 6267129638992476673

Scan 6669765

duration: 0:00:13.867026

exit_message:

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

id: 6669765

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_newbookbookings_market_segments/2024-11-04/1730784178",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730784178/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 608732370464232001,
        "service_name": "drive-thru",
        "span_id": 11982766862501473576,
        "trace_id": 8986001473120281409
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 03:06:01
success: True
trace_id: 8986001473120281409

Scan 6669279

duration: 0:00:11.472006

exit_message:

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

id: 6669279

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_newbookbookings_market_segments/2024-11-04/1730784015",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730784015/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15548297450168379693,
        "service_name": "drive-thru",
        "span_id": 12497393881516191667,
        "trace_id": 18323396601298378165
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 02:52:59
success: True
trace_id: 18323396601298378165

Scan 6668538

duration: 0:00:11.304178

exit_message:

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

id: 6668538

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_newbookbookings_market_segments/2024-11-04/1730783870",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783870/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6468658803048058270,
        "service_name": "drive-thru",
        "span_id": 15381964589648912792,
        "trace_id": 1326476472353002431
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 02:33:29
success: True
trace_id: 1326476472353002431

Scan 6667551

duration: 0:00:11.336790

exit_message:

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

id: 6667551

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_newbookbookings_market_segments/2024-11-04/1730783728",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783728/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13575618663059434741,
        "service_name": "drive-thru",
        "span_id": 6830531739206312820,
        "trace_id": 177397720582794872
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 02:07:28
success: True
trace_id: 177397720582794872

Scan 6667045

duration: 0:00:11.404674

exit_message:

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

id: 6667045

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_newbookbookings_market_segments/2024-11-04/1730783635",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783635/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15262358478701883222,
        "service_name": "drive-thru",
        "span_id": 1295711202933881594,
        "trace_id": 12522985449887161073
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 01:53:49
success: True
trace_id: 12522985449887161073

Scan 6666142

duration: 0:00:13.832730

exit_message:

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

id: 6666142

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_newbookbookings_market_segments/2024-11-04/1730783484",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783484/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4462097749276580785,
        "service_name": "drive-thru",
        "span_id": 2290974624650427287,
        "trace_id": 8788288336404778374
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 01:30:06
success: True
trace_id: 8788288336404778374

Scan 6665258

duration: 0:00:11.252087

exit_message:

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

id: 6665258

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_newbookbookings_market_segments/2024-11-04/1730783266",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730783266/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3213174909904024535,
        "service_name": "drive-thru",
        "span_id": 2760735201010465079,
        "trace_id": 16456801334869193926
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 01:06:45
success: True
trace_id: 16456801334869193926

Scan 6664568

duration: 0:00:11.301416

exit_message:

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

id: 6664568

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_newbookbookings_market_segments/2024-11-04/1730782869",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730782869/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2918170091128842806,
        "service_name": "drive-thru",
        "span_id": 9724075941958832283,
        "trace_id": 1717173445329753024
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 00:48:25
success: True
trace_id: 1717173445329753024

Scan 6664069

duration: 0:00:11.276654

exit_message:

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

id: 6664069

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_newbookbookings_market_segments/2024-11-04/1730782776",
        "key": "raw/newbookdev_newbookbookings_market_segments/2024-11-04/1730782776/bookings_market_segments.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_market_segments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17601165948016502173,
        "service_name": "drive-thru",
        "span_id": 16286679119799639076,
        "trace_id": 12406488983758646611
    }
}

running: False
schema_name_id: 2506
start_time: 2024-11-05 00:35:24
success: True
trace_id: 12406488983758646611

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 22:40:14

ddl:

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

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