Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types

created: 2024-10-08 17:57:30
disabled: False
format: raw
id: 2693
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748872

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-05/1730866491
id: 4748872
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6674904
updated: 2024-11-05 23:06:24

Version 4748359

created: 2024-11-05 22:43:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-05/1730866406
id: 4748359
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6674392
updated: 2024-11-05 22:43:45

Version 4747628

created: 2024-11-05 22:21:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-05/1730866293
id: 4747628
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6673660
updated: 2024-11-05 22:22:02

Version 4747100

created: 2024-11-05 04:50:21

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730785709
id: 4747100
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6672332
updated: 2024-11-05 04:50:32

Version 4746168

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730785118
id: 4746168
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6671390
updated: 2024-11-05 03:51:53

Version 4745372

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730784813
id: 4745372
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6670589
updated: 2024-11-05 03:27:54

Version 4744700

created: 2024-11-05 03:10:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730784209
id: 4744700
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6669917
updated: 2024-11-05 03:10:18

Version 4744244

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730784047
id: 4744244
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6669461
updated: 2024-11-05 02:57:57

Version 4743601

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783894
id: 4743601
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6668818
updated: 2024-11-05 02:41:06

Version 4742592

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783761
id: 4742592
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6667809
updated: 2024-11-05 02:14:30

Version 4741765

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783660
id: 4741765
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6666982
updated: 2024-11-05 01:52:21

Version 4740627

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783516
id: 4740627
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6665844
updated: 2024-11-05 01:22:29

Version 4740392

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783298
id: 4740392
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6665610
updated: 2024-11-05 01:16:19

Version 4739596

created: 2024-11-05 00:54:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730782900
id: 4739596
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6664813
updated: 2024-11-05 00:55:03

Version 4738631

created: 2024-11-05 00:29:27

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730782800
id: 4738631
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "run_sheet_id": 3,
    "task_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2693
schema_scan_id: 6663844
updated: 2024-11-05 00:29:37

Schema Scans: 15

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

Scan 6674904

duration: 0:00:11.416608

exit_message:

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

id: 6674904

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_newbookevents_run_sheets_task_types/2024-11-05/1730866491",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-05/1730866491/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12906467356300100199,
        "service_name": "drive-thru",
        "span_id": 13186156987996366775,
        "trace_id": 10136714175530450832
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 23:06:13
success: True
trace_id: 10136714175530450832

Scan 6674392

duration: 0:00:14.011319

exit_message:

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

id: 6674392

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_newbookevents_run_sheets_task_types/2024-11-05/1730866406",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-05/1730866406/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11191655130493369119,
        "service_name": "drive-thru",
        "span_id": 11459131307650501277,
        "trace_id": 13651454174563709514
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 22:43:31
success: True
trace_id: 13651454174563709514

Scan 6673660

duration: 0:00:11.307041

exit_message:

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

id: 6673660

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_newbookevents_run_sheets_task_types/2024-11-05/1730866293",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-05/1730866293/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12323428791434590917,
        "service_name": "drive-thru",
        "span_id": 4785566705342046089,
        "trace_id": 5581329953705472469
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 22:21:51
success: True
trace_id: 5581329953705472469

Scan 6672332

duration: 0:00:11.498123

exit_message:

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

id: 6672332

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_newbookevents_run_sheets_task_types/2024-11-04/1730785709",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730785709/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17854907961284135642,
        "service_name": "drive-thru",
        "span_id": 9278378794882785583,
        "trace_id": 125887621781601643
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 04:50:20
success: True
trace_id: 125887621781601643

Scan 6671390

duration: 0:00:11.515230

exit_message:

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

id: 6671390

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_newbookevents_run_sheets_task_types/2024-11-04/1730785118",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730785118/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16083600086313426559,
        "service_name": "drive-thru",
        "span_id": 406675439885105243,
        "trace_id": 13190748933957462387
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 03:51:42
success: True
trace_id: 13190748933957462387

Scan 6670589

duration: 0:00:11.361697

exit_message:

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

id: 6670589

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_newbookevents_run_sheets_task_types/2024-11-04/1730784813",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730784813/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4215521202098302547,
        "service_name": "drive-thru",
        "span_id": 16967434295094856087,
        "trace_id": 16330554698295351909
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 03:27:43
success: True
trace_id: 16330554698295351909

Scan 6669917

duration: 0:00:13.974955

exit_message:

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

id: 6669917

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_newbookevents_run_sheets_task_types/2024-11-04/1730784209",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730784209/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11120318754385601827,
        "service_name": "drive-thru",
        "span_id": 11786015932750973551,
        "trace_id": 1178877663327205821
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 03:10:05
success: True
trace_id: 1178877663327205821

Scan 6669461

duration: 0:00:13.748326

exit_message:

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

id: 6669461

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_newbookevents_run_sheets_task_types/2024-11-04/1730784047",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730784047/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11941805311131006208,
        "service_name": "drive-thru",
        "span_id": 12253175848219087856,
        "trace_id": 14593762315322257922
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 02:57:43
success: True
trace_id: 14593762315322257922

Scan 6668818

duration: 0:00:11.315344

exit_message:

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

id: 6668818

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_newbookevents_run_sheets_task_types/2024-11-04/1730783894",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783894/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3073015055468922692,
        "service_name": "drive-thru",
        "span_id": 13909524477711714444,
        "trace_id": 10406649620795421309
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 02:40:55
success: True
trace_id: 10406649620795421309

Scan 6667809

duration: 0:00:13.771907

exit_message:

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

id: 6667809

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_newbookevents_run_sheets_task_types/2024-11-04/1730783761",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783761/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11014976443879640755,
        "service_name": "drive-thru",
        "span_id": 15653615994614409357,
        "trace_id": 11633380184501221471
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 02:14:16
success: True
trace_id: 11633380184501221471

Scan 6666982

duration: 0:00:11.347970

exit_message:

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

id: 6666982

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_newbookevents_run_sheets_task_types/2024-11-04/1730783660",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783660/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14541993634458958463,
        "service_name": "drive-thru",
        "span_id": 14093243514089115807,
        "trace_id": 13890009331388869625
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 01:52:10
success: True
trace_id: 13890009331388869625

Scan 6665844

duration: 0:00:11.162108

exit_message:

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

id: 6665844

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_newbookevents_run_sheets_task_types/2024-11-04/1730783516",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783516/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 609388697100263569,
        "service_name": "drive-thru",
        "span_id": 1338674287018181592,
        "trace_id": 17343111650365844552
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 01:22:18
success: True
trace_id: 17343111650365844552

Scan 6665610

duration: 0:00:13.954332

exit_message:

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

id: 6665610

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_newbookevents_run_sheets_task_types/2024-11-04/1730783298",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730783298/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16854832383689766801,
        "service_name": "drive-thru",
        "span_id": 6741248089472320823,
        "trace_id": 835773480428401659
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 01:16:06
success: True
trace_id: 835773480428401659

Scan 6664813

duration: 0:00:11.342373

exit_message:

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

id: 6664813

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_newbookevents_run_sheets_task_types/2024-11-04/1730782900",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730782900/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2655001890231597812,
        "service_name": "drive-thru",
        "span_id": 7205926609727973535,
        "trace_id": 7125455906094182856
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 00:54:51
success: True
trace_id: 7125455906094182856

Scan 6663844

duration: 0:00:11.185246

exit_message:

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

id: 6663844

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_newbookevents_run_sheets_task_types/2024-11-04/1730782800",
        "key": "raw/newbookdev_newbookevents_run_sheets_task_types/2024-11-04/1730782800/events_run_sheets_task_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_run_sheets_task_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1198545121387101450,
        "service_name": "drive-thru",
        "span_id": 10009500332349938506,
        "trace_id": 8647421968374123198
    }
}

running: False
schema_name_id: 2693
start_time: 2024-11-05 00:29:26
success: True
trace_id: 8647421968374123198

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "run_sheet_id": "string",
    "task_type_id": "string",
    "tenant": "string"
}

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

ddl:

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

Server:

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

Raw:

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