Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories

created: 2024-10-08 18:35:18
disabled: False
format: raw
id: 3055
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749358

created: 2024-11-05 23:42:06

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6675391
updated: 2024-11-05 23:42:17

Version 4749279

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

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6675311
updated: 2024-11-05 23:33:55

Version 4748649

created: 2024-11-05 22:54:59

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6674681
updated: 2024-11-05 22:55:12

Version 4747267

created: 2024-11-05 05:09:11

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6672539
updated: 2024-11-05 05:09:22

Version 4746775

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

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6672003
updated: 2024-11-05 04:22:28

Version 4745821

created: 2024-11-05 03:39:59

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6671039
updated: 2024-11-05 03:40:13

Version 4745088

created: 2024-11-05 03:20:20

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730784271
id: 4745088
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6670305
updated: 2024-11-05 03:20:31

Version 4743841

created: 2024-11-05 02:47:17

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783941
id: 4743841
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6669058
updated: 2024-11-05 02:47:28

Version 4743813

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730784110
id: 4743813
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6669030
updated: 2024-11-05 02:46:43

Version 4742816

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783823
id: 4742816
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6668033
updated: 2024-11-05 02:20:26

Version 4742073

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783707
id: 4742073
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6667290
updated: 2024-11-05 02:00:31

Version 4741535

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

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6666752
updated: 2024-11-05 01:46:21

Version 4740745

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

ddl:

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

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

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6665962
updated: 2024-11-05 01:25:32

Version 4739686

created: 2024-11-05 00:57:10

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730782960
id: 4739686
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6664903
updated: 2024-11-05 00:57:24

Version 4738610

created: 2024-11-05 00:28:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730782727
id: 4738610
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 4,
    "default_labour_type_id": 5,
    "id": 2,
    "newbook_region": 0,
    "queue_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

schema_name_id: 3055
schema_scan_id: 6663823
updated: 2024-11-05 00:29:07

Schema Scans: 15

Last at 2024-11-05 23:42:06

Scan 6675391

duration: 0:00:11.595002

exit_message:

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

id: 6675391

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_categories/2024-11-05/1730866579",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-05/1730866579/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16004312963128585517,
        "service_name": "drive-thru",
        "span_id": 8020725022276464259,
        "trace_id": 6479659430078835900
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 23:42:06
success: True
trace_id: 6479659430078835900

Scan 6675311

duration: 0:00:11.487711

exit_message:

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

id: 6675311

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_categories/2024-11-05/1730866621",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-05/1730866621/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9832860400489457842,
        "service_name": "drive-thru",
        "span_id": 2335810929728576426,
        "trace_id": 8024107029185041731
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 23:33:44
success: True
trace_id: 8024107029185041731

Scan 6674681

duration: 0:00:14.089329

exit_message:

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

id: 6674681

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_categories/2024-11-05/1730866480",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-05/1730866480/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9216074922735024432,
        "service_name": "drive-thru",
        "span_id": 14521155623062482885,
        "trace_id": 1595876032270456151
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 22:54:58
success: True
trace_id: 1595876032270456151

Scan 6672539

duration: 0:00:11.517389

exit_message:

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

id: 6672539

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_categories/2024-11-04/1730785820",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730785820/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10775007758159476013,
        "service_name": "drive-thru",
        "span_id": 12194315309205063551,
        "trace_id": 15754317140420949295
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 05:09:11
success: True
trace_id: 15754317140420949295

Scan 6672003

duration: 0:00:11.591858

exit_message:

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

id: 6672003

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_categories/2024-11-04/1730785180",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730785180/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6392246988784385009,
        "service_name": "drive-thru",
        "span_id": 5261744447869597218,
        "trace_id": 3881537884387246961
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 04:22:17
success: True
trace_id: 3881537884387246961

Scan 6671039

duration: 0:00:13.993635

exit_message:

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

id: 6671039

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_categories/2024-11-04/1730784874",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730784874/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13054050141825844688,
        "service_name": "drive-thru",
        "span_id": 4411173847327437026,
        "trace_id": 4911262482412076158
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 03:39:59
success: True
trace_id: 4911262482412076158

Scan 6670305

duration: 0:00:11.527597

exit_message:

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

id: 6670305

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_categories/2024-11-04/1730784271",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730784271/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1387084676896269217,
        "service_name": "drive-thru",
        "span_id": 1623198804510200084,
        "trace_id": 18322056665644897084
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 03:20:20
success: True
trace_id: 18322056665644897084

Scan 6669058

duration: 0:00:11.417387

exit_message:

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

id: 6669058

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_categories/2024-11-04/1730783941",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783941/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12563025180217121321,
        "service_name": "drive-thru",
        "span_id": 15433219162885602445,
        "trace_id": 17908992851447453640
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 02:47:17
success: True
trace_id: 17908992851447453640

Scan 6669030

duration: 0:00:11.326305

exit_message:

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

id: 6669030

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_categories/2024-11-04/1730784110",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730784110/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1770847865152179643,
        "service_name": "drive-thru",
        "span_id": 7434667996507958483,
        "trace_id": 1882196522135274164
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 02:46:32
success: True
trace_id: 1882196522135274164

Scan 6668033

duration: 0:00:14.021059

exit_message:

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

id: 6668033

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_categories/2024-11-04/1730783823",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783823/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17470314906039546208,
        "service_name": "drive-thru",
        "span_id": 8873517565801437559,
        "trace_id": 15581297038877548499
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 02:20:12
success: True
trace_id: 15581297038877548499

Scan 6667290

duration: 0:00:13.864539

exit_message:

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

id: 6667290

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_categories/2024-11-04/1730783707",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783707/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1793391440012407251,
        "service_name": "drive-thru",
        "span_id": 3063525934564908561,
        "trace_id": 11438827123451720791
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 02:00:17
success: True
trace_id: 11438827123451720791

Scan 6666752

duration: 0:00:11.355085

exit_message:

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

id: 6666752

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_categories/2024-11-04/1730783580",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783580/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2546092462450489945,
        "service_name": "drive-thru",
        "span_id": 2072350995849004758,
        "trace_id": 9850205899572613787
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 01:46:10
success: True
trace_id: 9850205899572613787

Scan 6665962

duration: 0:00:11.361543

exit_message:

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

id: 6665962

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_categories/2024-11-04/1730783361",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730783361/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12511508720316816075,
        "service_name": "drive-thru",
        "span_id": 3571324215769420175,
        "trace_id": 7568756609223912093
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 01:25:21
success: True
trace_id: 7568756609223912093

Scan 6664903

duration: 0:00:13.917619

exit_message:

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

id: 6664903

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_categories/2024-11-04/1730782960",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730782960/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13296606147994789980,
        "service_name": "drive-thru",
        "span_id": 10004438133398107239,
        "trace_id": 12009552442767280473
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 00:57:10
success: True
trace_id: 12009552442767280473

Scan 6663823

duration: 0:00:11.270118

exit_message:

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

id: 6663823

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_categories/2024-11-04/1730782727",
        "key": "raw/newbookdev_newbooktickets_queues_categories/2024-11-04/1730782727/tickets_queues_categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9265568020160811457,
        "service_name": "drive-thru",
        "span_id": 13238851716923780621,
        "trace_id": 518339696158560193
    }
}

running: False
schema_name_id: 3055
start_time: 2024-11-05 00:28:56
success: True
trace_id: 518339696158560193

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "category_id": "string",
    "default_labour_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "queue_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:42: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_newbooktickets_queues_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `queue_id`  string , `category_id`  string , `default_labour_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_newbooktickets_queues_categories/2024-11-05/1730866579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories"
}

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:35:18",
        "disabled": false,
        "format": "raw",
        "id": 3055,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktickets_queues_categories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "category_id": "string",
            "default_labour_type_id": "string",
            "id": "string",
            "newbook_region": "string",
            "queue_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:42: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_newbooktickets_queues_categories`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `queue_id`  string , `category_id`  string , `default_labour_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_newbooktickets_queues_categories/2024-11-05/1730866579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_queues_categories"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}