Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktickets_queues

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749504

created: 2024-11-05 23:58:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-05/1730866621
id: 4749504
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6675593
updated: 2024-11-05 23:58:47

Version 4749224

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-05/1730866579
id: 4749224
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6675256
updated: 2024-11-05 23:29:16

Version 4748724

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-05/1730866480
id: 4748724
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6674756
updated: 2024-11-05 22:58:20

Version 4747197

created: 2024-11-05 05:00:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730785820
id: 4747197
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6672429
updated: 2024-11-05 05:00:56

Version 4746517

created: 2024-11-05 04:07:11

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730785180
id: 4746517
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6671738
updated: 2024-11-05 04:07:22

Version 4745992

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6671213
updated: 2024-11-05 03:45:34

Version 4744987

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6670204
updated: 2024-11-05 03:17:51

Version 4744190

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730784109
id: 4744190
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6669407
updated: 2024-11-05 02:56:33

Version 4743663

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6668880
updated: 2024-11-05 02:42:45

Version 4742889

created: 2024-11-05 02:22:05

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6668106
updated: 2024-11-05 02:22:16

Version 4741512

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730783623
id: 4741512
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6666729
updated: 2024-11-05 01:45:46

Version 4741296

created: 2024-11-05 01:39:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730783580
id: 4741296
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6666513
updated: 2024-11-05 01:40:07

Version 4740654

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730783361
id: 4740654
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6665871
updated: 2024-11-05 01:23:14

Version 4739890

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6665107
updated: 2024-11-05 01:02:54

Version 4739192

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues/2024-11-04/1730782846
id: 4739192
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2992
schema_scan_id: 6664407
updated: 2024-11-05 00:44:27

Schema Scans: 15

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

Scan 6675593

duration: 0:00:14.074776

exit_message:

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

id: 6675593

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_newbooktickets_queues/2024-11-05/1730866621",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-05/1730866621/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8761741067892800728,
        "service_name": "drive-thru",
        "span_id": 4983947472431060606,
        "trace_id": 1995307010163539088
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 23:58:33
success: True
trace_id: 1995307010163539088

Scan 6675256

duration: 0:00:11.486362

exit_message:

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

id: 6675256

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_newbooktickets_queues/2024-11-05/1730866579",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-05/1730866579/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3650354600980020051,
        "service_name": "drive-thru",
        "span_id": 3076858112579463362,
        "trace_id": 6952568022606562563
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 23:29:04
success: True
trace_id: 6952568022606562563

Scan 6674756

duration: 0:00:14.003569

exit_message:

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

id: 6674756

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_newbooktickets_queues/2024-11-05/1730866480",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-05/1730866480/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 535233754323119286,
        "service_name": "drive-thru",
        "span_id": 11695596987327867959,
        "trace_id": 14919620338952645729
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 22:58:06
success: True
trace_id: 14919620338952645729

Scan 6672429

duration: 0:00:11.601945

exit_message:

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

id: 6672429

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_newbooktickets_queues/2024-11-04/1730785820",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730785820/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6627788150134734201,
        "service_name": "drive-thru",
        "span_id": 6025749892244786283,
        "trace_id": 8654903780321528675
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 05:00:44
success: True
trace_id: 8654903780321528675

Scan 6671738

duration: 0:00:11.457071

exit_message:

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

id: 6671738

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_newbooktickets_queues/2024-11-04/1730785180",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730785180/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3080889376325146749,
        "service_name": "drive-thru",
        "span_id": 1164977780012533485,
        "trace_id": 733275861456709701
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 04:07:11
success: True
trace_id: 733275861456709701

Scan 6671213

duration: 0:00:11.442827

exit_message:

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

id: 6671213

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_newbooktickets_queues/2024-11-04/1730784874",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730784874/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2082723742353274785,
        "service_name": "drive-thru",
        "span_id": 8807917973453220129,
        "trace_id": 6495693800480548961
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 03:45:23
success: True
trace_id: 6495693800480548961

Scan 6670204

duration: 0:00:11.303201

exit_message:

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

id: 6670204

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_newbooktickets_queues/2024-11-04/1730784270",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730784270/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9031882344980677259,
        "service_name": "drive-thru",
        "span_id": 646202378785811951,
        "trace_id": 3361193934378634272
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 03:17:40
success: True
trace_id: 3361193934378634272

Scan 6669407

duration: 0:00:11.411221

exit_message:

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

id: 6669407

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_newbooktickets_queues/2024-11-04/1730784109",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730784109/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15704536112186723132,
        "service_name": "drive-thru",
        "span_id": 1902393266739973868,
        "trace_id": 3209331059466304238
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 02:56:21
success: True
trace_id: 3209331059466304238

Scan 6668880

duration: 0:00:11.365681

exit_message:

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

id: 6668880

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_newbooktickets_queues/2024-11-04/1730783940",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730783940/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9019870577231259445,
        "service_name": "drive-thru",
        "span_id": 7385625831122927441,
        "trace_id": 16449973839810240495
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 02:42:34
success: True
trace_id: 16449973839810240495

Scan 6668106

duration: 0:00:11.391248

exit_message:

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

id: 6668106

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_newbooktickets_queues/2024-11-04/1730783822",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730783822/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13014177789945788354,
        "service_name": "drive-thru",
        "span_id": 7593860017881731450,
        "trace_id": 17797600653804112369
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 02:22:05
success: True
trace_id: 17797600653804112369

Scan 6666729

duration: 0:00:13.897943

exit_message:

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

id: 6666729

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_newbooktickets_queues/2024-11-04/1730783623",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730783623/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11162128067057570756,
        "service_name": "drive-thru",
        "span_id": 5776564592012608034,
        "trace_id": 12542791988645915526
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 01:45:32
success: True
trace_id: 12542791988645915526

Scan 6666513

duration: 0:00:11.468678

exit_message:

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

id: 6666513

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_newbooktickets_queues/2024-11-04/1730783580",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730783580/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 216105234287332899,
        "service_name": "drive-thru",
        "span_id": 8208390000013171832,
        "trace_id": 910354270883512924
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 01:39:55
success: True
trace_id: 910354270883512924

Scan 6665871

duration: 0:00:14.184341

exit_message:

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

id: 6665871

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_newbooktickets_queues/2024-11-04/1730783361",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730783361/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10726294777428490296,
        "service_name": "drive-thru",
        "span_id": 15046532489404442132,
        "trace_id": 13677173077599575663
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 01:23:00
success: True
trace_id: 13677173077599575663

Scan 6665107

duration: 0:00:13.793642

exit_message:

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

id: 6665107

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_newbooktickets_queues/2024-11-04/1730782958",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730782958/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11107579114075648562,
        "service_name": "drive-thru",
        "span_id": 14250271658654991933,
        "trace_id": 12265685773199777659
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 01:02:40
success: True
trace_id: 12265685773199777659

Scan 6664407

duration: 0:00:14.049330

exit_message:

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

id: 6664407

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_newbooktickets_queues/2024-11-04/1730782846",
        "key": "raw/newbookdev_newbooktickets_queues/2024-11-04/1730782846/tickets_queues.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4327173947907797066,
        "service_name": "drive-thru",
        "span_id": 6665161196620147724,
        "trace_id": 3240624648875527592
    }
}

running: False
schema_name_id: 2992
start_time: 2024-11-05 00:44:13
success: True
trace_id: 3240624648875527592

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 23:58:34

ddl:

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

Server:

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

Raw:

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