Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link

created: 2024-10-08 18:03:11
disabled: False
format: raw
id: 2760
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749111

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-05/1730866524
id: 4749111
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6675143
updated: 2024-11-05 23:21:09

Version 4748532

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-05/1730866456
id: 4748532
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6674564
updated: 2024-11-05 22:50:09

Version 4747739

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-05/1730866328
id: 4747739
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6673771
updated: 2024-11-05 22:24:57

Version 4747162

created: 2024-11-05 04:56:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730785734
id: 4747162
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6672394
updated: 2024-11-05 04:57:09

Version 4746249

created: 2024-11-05 03:54:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730785132
id: 4746249
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6671470
updated: 2024-11-05 03:55:07

Version 4745431

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730784827
id: 4745431
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6670648
updated: 2024-11-05 03:29:29

Version 4744760

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730784223
id: 4744760
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6669977
updated: 2024-11-05 03:11:53

Version 4743472

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783904
id: 4743472
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6668689
updated: 2024-11-05 02:37:42

Version 4743426

created: 2024-11-05 02:36:21

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730784061
id: 4743426
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6668643
updated: 2024-11-05 02:36:34

Version 4742514

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783774
id: 4742514
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6667731
updated: 2024-11-05 02:12:23

Version 4741683

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783612
id: 4741683
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6666900
updated: 2024-11-05 01:50:13

Version 4741042

created: 2024-11-05 01:33:17

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783531
id: 4741042
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6666259
updated: 2024-11-05 01:33:28

Version 4740028

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783313
id: 4740028
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6665245
updated: 2024-11-05 01:06:38

Version 4739632

created: 2024-11-05 00:55:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730782913
id: 4739632
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6664849
updated: 2024-11-05 00:55:57

Version 4739031

created: 2024-11-05 00:40:00

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730782810
id: 4739031
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "removed_by": 7,
    "removed_when": 6,
    "task_type_id": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2760
schema_scan_id: 6664246
updated: 2024-11-05 00:40:14

Schema Scans: 15

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

Scan 6675143

duration: 0:00:11.592604

exit_message:

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

id: 6675143

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_newbookinventory_task_type_display_link/2024-11-05/1730866524",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-05/1730866524/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12731092268967179095,
        "service_name": "drive-thru",
        "span_id": 7954655730577923434,
        "trace_id": 3612631812759138357
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 23:20:58
success: True
trace_id: 3612631812759138357

Scan 6674564

duration: 0:00:11.512207

exit_message:

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

id: 6674564

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_newbookinventory_task_type_display_link/2024-11-05/1730866456",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-05/1730866456/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17584228646313756573,
        "service_name": "drive-thru",
        "span_id": 11952693060798233650,
        "trace_id": 5502344502144183125
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 22:49:58
success: True
trace_id: 5502344502144183125

Scan 6673771

duration: 0:00:13.919761

exit_message:

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

id: 6673771

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_newbookinventory_task_type_display_link/2024-11-05/1730866328",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-05/1730866328/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13241673647446872402,
        "service_name": "drive-thru",
        "span_id": 4518094210928102590,
        "trace_id": 3516644180727574963
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 22:24:43
success: True
trace_id: 3516644180727574963

Scan 6672394

duration: 0:00:14.147207

exit_message:

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

id: 6672394

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_newbookinventory_task_type_display_link/2024-11-04/1730785734",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730785734/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15576898010880996290,
        "service_name": "drive-thru",
        "span_id": 1371644785905705102,
        "trace_id": 18084689023012408614
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 04:56:55
success: True
trace_id: 18084689023012408614

Scan 6671470

duration: 0:00:14.186314

exit_message:

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

id: 6671470

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_newbookinventory_task_type_display_link/2024-11-04/1730785132",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730785132/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13701682358154780687,
        "service_name": "drive-thru",
        "span_id": 2655943817105769523,
        "trace_id": 14836712879474873997
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 03:54:52
success: True
trace_id: 14836712879474873997

Scan 6670648

duration: 0:00:13.997882

exit_message:

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

id: 6670648

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_newbookinventory_task_type_display_link/2024-11-04/1730784827",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730784827/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 885842469592484691,
        "service_name": "drive-thru",
        "span_id": 1624442987813668491,
        "trace_id": 2212375658045172259
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 03:29:15
success: True
trace_id: 2212375658045172259

Scan 6669977

duration: 0:00:11.397099

exit_message:

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

id: 6669977

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_newbookinventory_task_type_display_link/2024-11-04/1730784223",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730784223/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18297996980805802348,
        "service_name": "drive-thru",
        "span_id": 3726301045304140709,
        "trace_id": 16283199704305811240
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 03:11:41
success: True
trace_id: 16283199704305811240

Scan 6668689

duration: 0:00:11.362809

exit_message:

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

id: 6668689

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_newbookinventory_task_type_display_link/2024-11-04/1730783904",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783904/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4010614124312630853,
        "service_name": "drive-thru",
        "span_id": 16216566988886491524,
        "trace_id": 14064646358387355640
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 02:37:30
success: True
trace_id: 14064646358387355640

Scan 6668643

duration: 0:00:13.986050

exit_message:

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

id: 6668643

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_newbookinventory_task_type_display_link/2024-11-04/1730784061",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730784061/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5875336922945290847,
        "service_name": "drive-thru",
        "span_id": 16911463663413100236,
        "trace_id": 4870841926324479513
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 02:36:20
success: True
trace_id: 4870841926324479513

Scan 6667731

duration: 0:00:11.426216

exit_message:

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

id: 6667731

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_newbookinventory_task_type_display_link/2024-11-04/1730783774",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783774/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8340025536891600391,
        "service_name": "drive-thru",
        "span_id": 17325277667562310281,
        "trace_id": 16709018013525640158
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 02:12:12
success: True
trace_id: 16709018013525640158

Scan 6666900

duration: 0:00:13.909882

exit_message:

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

id: 6666900

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_newbookinventory_task_type_display_link/2024-11-04/1730783612",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783612/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1394510684872474851,
        "service_name": "drive-thru",
        "span_id": 857758373126975079,
        "trace_id": 10863908247481024828
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 01:49:59
success: True
trace_id: 10863908247481024828

Scan 6666259

duration: 0:00:11.334265

exit_message:

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

id: 6666259

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_newbookinventory_task_type_display_link/2024-11-04/1730783531",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783531/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3277720407454813399,
        "service_name": "drive-thru",
        "span_id": 12200986440644669094,
        "trace_id": 16203587472143282643
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 01:33:16
success: True
trace_id: 16203587472143282643

Scan 6665245

duration: 0:00:11.421494

exit_message:

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

id: 6665245

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_newbookinventory_task_type_display_link/2024-11-04/1730783313",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730783313/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17260848244953705926,
        "service_name": "drive-thru",
        "span_id": 17349760284789100040,
        "trace_id": 6727230944584930924
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 01:06:26
success: True
trace_id: 6727230944584930924

Scan 6664849

duration: 0:00:11.428945

exit_message:

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

id: 6664849

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_newbookinventory_task_type_display_link/2024-11-04/1730782913",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730782913/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13778621644744032587,
        "service_name": "drive-thru",
        "span_id": 11384691755859412225,
        "trace_id": 13351911001822337917
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 00:55:46
success: True
trace_id: 13351911001822337917

Scan 6664246

duration: 0:00:14.042840

exit_message:

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

id: 6664246

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_newbookinventory_task_type_display_link/2024-11-04/1730782810",
        "key": "raw/newbookdev_newbookinventory_task_type_display_link/2024-11-04/1730782810/inventory_task_type_display_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_task_type_display_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14654544200942640678,
        "service_name": "drive-thru",
        "span_id": 13692910770220987669,
        "trace_id": 12038854893603086662
    }
}

running: False
schema_name_id: 2760
start_time: 2024-11-05 00:40:00
success: True
trace_id: 12038854893603086662

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "removed_by": "string",
    "removed_when": "string",
    "task_type_id": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

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

ddl:

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

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