Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookroutes_periods

created: 2024-10-08 18:25:30
disabled: False
format: raw
id: 2965
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749485

created: 2024-11-05 23:56:08

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-05/1730866597
id: 4749485
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6675553
updated: 2024-11-05 23:56:22

Version 4748966

created: 2024-11-05 23:11:23

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-05/1730866538
id: 4748966
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6674998
updated: 2024-11-05 23:11:37

Version 4748334

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-05/1730866423
id: 4748334
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6674366
updated: 2024-11-05 22:42:48

Version 4747016

created: 2024-11-05 04:41:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730785790
id: 4747016
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6672247
updated: 2024-11-05 04:41:36

Version 4746425

created: 2024-11-05 04:02:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730785163
id: 4746425
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6671646
updated: 2024-11-05 04:02:43

Version 4745695

created: 2024-11-05 03:36:12

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730784858
id: 4745695
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6670912
updated: 2024-11-05 03:36:25

Version 4744901

created: 2024-11-05 03:15:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730784254
id: 4744901
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6670118
updated: 2024-11-05 03:15:38

Version 4743668

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730784092
id: 4743668
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6668885
updated: 2024-11-05 02:42:55

Version 4743172

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730783853
id: 4743172
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6668389
updated: 2024-11-05 02:29:44

Version 4742268

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730783806
id: 4742268
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6667485
updated: 2024-11-05 02:05:54

Version 4742169

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730783694
id: 4742169
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6667386
updated: 2024-11-05 02:03:06

Version 4741437

created: 2024-11-05 01:43:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730783562
id: 4741437
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6666654
updated: 2024-11-05 01:43:45

Version 4740679

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730783344
id: 4740679
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6665896
updated: 2024-11-05 01:23:49

Version 4739870

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730782942
id: 4739870
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6665087
updated: 2024-11-05 01:02:24

Version 4739191

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookroutes_periods/2024-11-04/1730782833
id: 4739191
processed: 1

raw_data:

{
    "description": 4,
    "id": 2,
    "newbook_region": 0,
    "period_from": 5,
    "period_to": 6,
    "route_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

schema_name_id: 2965
schema_scan_id: 6664406
updated: 2024-11-05 00:44:27

Schema Scans: 15

Last at 2024-11-05 23:56:08

Scan 6675553

duration: 0:00:14.073272

exit_message:

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

id: 6675553

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_newbookroutes_periods/2024-11-05/1730866597",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-05/1730866597/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2859153791527915979,
        "service_name": "drive-thru",
        "span_id": 746437533137254810,
        "trace_id": 1937315032868566518
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 23:56:08
success: True
trace_id: 1937315032868566518

Scan 6674998

duration: 0:00:14.163569

exit_message:

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

id: 6674998

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_newbookroutes_periods/2024-11-05/1730866538",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-05/1730866538/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16477242218980174611,
        "service_name": "drive-thru",
        "span_id": 1792956603008697351,
        "trace_id": 3704837837068997745
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 23:11:22
success: True
trace_id: 3704837837068997745

Scan 6674366

duration: 0:00:11.522427

exit_message:

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

id: 6674366

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_newbookroutes_periods/2024-11-05/1730866423",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-05/1730866423/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7052716481055359119,
        "service_name": "drive-thru",
        "span_id": 11433177686877701502,
        "trace_id": 9584523181637173885
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 22:42:36
success: True
trace_id: 9584523181637173885

Scan 6672247

duration: 0:00:11.512065

exit_message:

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

id: 6672247

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_newbookroutes_periods/2024-11-04/1730785790",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730785790/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1507946447701307697,
        "service_name": "drive-thru",
        "span_id": 1955236610463000043,
        "trace_id": 3545645829915549256
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 04:41:24
success: True
trace_id: 3545645829915549256

Scan 6671646

duration: 0:00:11.470089

exit_message:

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

id: 6671646

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_newbookroutes_periods/2024-11-04/1730785163",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730785163/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13465937140170316601,
        "service_name": "drive-thru",
        "span_id": 789335132725778067,
        "trace_id": 5478798066832425853
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 04:02:32
success: True
trace_id: 5478798066832425853

Scan 6670912

duration: 0:00:13.902020

exit_message:

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

id: 6670912

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_newbookroutes_periods/2024-11-04/1730784858",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730784858/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4619389487521952101,
        "service_name": "drive-thru",
        "span_id": 7446003490559396510,
        "trace_id": 210153621863202213
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 03:36:11
success: True
trace_id: 210153621863202213

Scan 6670118

duration: 0:00:13.902169

exit_message:

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

id: 6670118

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_newbookroutes_periods/2024-11-04/1730784254",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730784254/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7480516854581958217,
        "service_name": "drive-thru",
        "span_id": 1177354987712269010,
        "trace_id": 6346166124241202055
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 03:15:24
success: True
trace_id: 6346166124241202055

Scan 6668885

duration: 0:00:13.993795

exit_message:

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

id: 6668885

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_newbookroutes_periods/2024-11-04/1730784092",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730784092/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10942746235645487647,
        "service_name": "drive-thru",
        "span_id": 6767300812673127113,
        "trace_id": 17311059092610731354
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 02:42:42
success: True
trace_id: 17311059092610731354

Scan 6668389

duration: 0:00:13.934102

exit_message:

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

id: 6668389

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_newbookroutes_periods/2024-11-04/1730783853",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730783853/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6509795084582963200,
        "service_name": "drive-thru",
        "span_id": 18366706819610990622,
        "trace_id": 5507371530156714065
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 02:29:30
success: True
trace_id: 5507371530156714065

Scan 6667485

duration: 0:00:11.445470

exit_message:

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

id: 6667485

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_newbookroutes_periods/2024-11-04/1730783806",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730783806/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6658574746090204647,
        "service_name": "drive-thru",
        "span_id": 17524653084493907595,
        "trace_id": 752816150400896689
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 02:05:43
success: True
trace_id: 752816150400896689

Scan 6667386

duration: 0:00:13.962042

exit_message:

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

id: 6667386

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_newbookroutes_periods/2024-11-04/1730783694",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730783694/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15793693401015229316,
        "service_name": "drive-thru",
        "span_id": 1300646731825005578,
        "trace_id": 12619341176315761316
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 02:02:52
success: True
trace_id: 12619341176315761316

Scan 6666654

duration: 0:00:11.350922

exit_message:

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

id: 6666654

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_newbookroutes_periods/2024-11-04/1730783562",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730783562/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9173751458135013421,
        "service_name": "drive-thru",
        "span_id": 11117739162265618355,
        "trace_id": 18338614375064576710
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 01:43:34
success: True
trace_id: 18338614375064576710

Scan 6665896

duration: 0:00:11.365779

exit_message:

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

id: 6665896

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_newbookroutes_periods/2024-11-04/1730783344",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730783344/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1555218885019385041,
        "service_name": "drive-thru",
        "span_id": 5636574984874061010,
        "trace_id": 12242706931403176042
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 01:23:38
success: True
trace_id: 12242706931403176042

Scan 6665087

duration: 0:00:13.950684

exit_message:

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

id: 6665087

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_newbookroutes_periods/2024-11-04/1730782942",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730782942/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8250781446258232371,
        "service_name": "drive-thru",
        "span_id": 6590252848953251242,
        "trace_id": 11160357981235328342
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 01:02:10
success: True
trace_id: 11160357981235328342

Scan 6664406

duration: 0:00:14.095544

exit_message:

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

id: 6664406

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_newbookroutes_periods/2024-11-04/1730782833",
        "key": "raw/newbookdev_newbookroutes_periods/2024-11-04/1730782833/routes_periods.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookroutes_periods",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2246135385584335232,
        "service_name": "drive-thru",
        "span_id": 18435447285859426388,
        "trace_id": 14489609105117098966
    }
}

running: False
schema_name_id: 2965
start_time: 2024-11-05 00:44:13
success: True
trace_id: 14489609105117098966

Partitions:

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

Schema:

attributes:

{
    "description": "string",
    "id": "string",
    "newbook_region": "string",
    "period_from": "string",
    "period_to": "string",
    "route_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:56:08

ddl:

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

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