Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions

created: 2024-10-08 17:54:38
disabled: False
format: raw
id: 2655
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749115

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-05/1730866520
id: 4749115
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6675147
updated: 2024-11-05 23:21:35

Version 4748516

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-05/1730866450
id: 4748516
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6674548
updated: 2024-11-05 22:49:29

Version 4747827

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-05/1730866324
id: 4747827
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6673859
updated: 2024-11-05 22:27:13

Version 4747149

created: 2024-11-05 04:55:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730785731
id: 4747149
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6672381
updated: 2024-11-05 04:55:46

Version 4746252

created: 2024-11-05 03:55:01

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730785130
id: 4746252
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6671473
updated: 2024-11-05 03:55:13

Version 4745669

created: 2024-11-05 03:35:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730784825
id: 4745669
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6670886
updated: 2024-11-05 03:35:45

Version 4744758

created: 2024-11-05 03:11:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730784221
id: 4744758
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6669975
updated: 2024-11-05 03:11:48

Version 4743970

created: 2024-11-05 02:50:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730784059
id: 4743970
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6669187
updated: 2024-11-05 02:50:52

Version 4743268

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783903
id: 4743268
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6668485
updated: 2024-11-05 02:32:17

Version 4742646

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783773
id: 4742646
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6667863
updated: 2024-11-05 02:15:53

Version 4741930

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783669
id: 4741930
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6667147
updated: 2024-11-05 01:56:43

Version 4741153

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783529
id: 4741153
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6666371
updated: 2024-11-05 01:36:21

Version 4740386

created: 2024-11-05 01:15:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783311
id: 4740386
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6665603
updated: 2024-11-05 01:16:05

Version 4739377

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730782912
id: 4739377
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6664592
updated: 2024-11-05 00:49:13

Version 4738553

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730782752
id: 4738553
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "inventory_item_discount_id": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2655
schema_scan_id: 6663766
updated: 2024-11-05 00:27:36

Schema Scans: 15

Last at 2024-11-05 23:21:21

Scan 6675147

duration: 0:00:14.003876

exit_message:

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

id: 6675147

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_items_discounts_restrictions/2024-11-05/1730866520",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-05/1730866520/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14849175259351803472,
        "service_name": "drive-thru",
        "span_id": 7624210148831275359,
        "trace_id": 6685698668388334802
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 23:21:21
success: True
trace_id: 6685698668388334802

Scan 6674548

duration: 0:00:11.457884

exit_message:

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

id: 6674548

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_items_discounts_restrictions/2024-11-05/1730866450",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-05/1730866450/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3216666452463861050,
        "service_name": "drive-thru",
        "span_id": 18273838157831395719,
        "trace_id": 308396093471234214
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 22:49:18
success: True
trace_id: 308396093471234214

Scan 6673859

duration: 0:00:11.366923

exit_message:

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

id: 6673859

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_items_discounts_restrictions/2024-11-05/1730866324",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-05/1730866324/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18278166607859098801,
        "service_name": "drive-thru",
        "span_id": 10795259135022386985,
        "trace_id": 2254046341976092081
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 22:27:02
success: True
trace_id: 2254046341976092081

Scan 6672381

duration: 0:00:14.011610

exit_message:

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

id: 6672381

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_items_discounts_restrictions/2024-11-04/1730785731",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730785731/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2597072883675501237,
        "service_name": "drive-thru",
        "span_id": 16069599759964293568,
        "trace_id": 11822739659973790433
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 04:55:33
success: True
trace_id: 11822739659973790433

Scan 6671473

duration: 0:00:11.677592

exit_message:

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

id: 6671473

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_items_discounts_restrictions/2024-11-04/1730785130",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730785130/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17000377791784286950,
        "service_name": "drive-thru",
        "span_id": 9190637787073372533,
        "trace_id": 7757219726124598173
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 03:55:01
success: True
trace_id: 7757219726124598173

Scan 6670886

duration: 0:00:13.877717

exit_message:

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

id: 6670886

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_items_discounts_restrictions/2024-11-04/1730784825",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730784825/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12622484870747022891,
        "service_name": "drive-thru",
        "span_id": 1793804242589677172,
        "trace_id": 13501979720826646160
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 03:35:31
success: True
trace_id: 13501979720826646160

Scan 6669975

duration: 0:00:13.884694

exit_message:

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

id: 6669975

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_items_discounts_restrictions/2024-11-04/1730784221",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730784221/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7754950496426221195,
        "service_name": "drive-thru",
        "span_id": 18370039057960063891,
        "trace_id": 16717267226759468349
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 03:11:35
success: True
trace_id: 16717267226759468349

Scan 6669187

duration: 0:00:13.831502

exit_message:

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

id: 6669187

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_items_discounts_restrictions/2024-11-04/1730784059",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730784059/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1719777673638225904,
        "service_name": "drive-thru",
        "span_id": 16918230220185123813,
        "trace_id": 5896498414856875309
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 02:50:38
success: True
trace_id: 5896498414856875309

Scan 6668485

duration: 0:00:13.924526

exit_message:

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

id: 6668485

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_items_discounts_restrictions/2024-11-04/1730783903",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783903/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2292065667109526883,
        "service_name": "drive-thru",
        "span_id": 15740366582205469934,
        "trace_id": 8319130413729214884
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 02:32:03
success: True
trace_id: 8319130413729214884

Scan 6667863

duration: 0:00:11.438170

exit_message:

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

id: 6667863

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_items_discounts_restrictions/2024-11-04/1730783773",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783773/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8191998794263498256,
        "service_name": "drive-thru",
        "span_id": 8650605169859067386,
        "trace_id": 11572840732330615575
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 02:15:42
success: True
trace_id: 11572840732330615575

Scan 6667147

duration: 0:00:13.841631

exit_message:

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

id: 6667147

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_items_discounts_restrictions/2024-11-04/1730783669",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783669/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2216327412416168308,
        "service_name": "drive-thru",
        "span_id": 13464872020702203221,
        "trace_id": 14302868637578368969
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 01:56:30
success: True
trace_id: 14302868637578368969

Scan 6666371

duration: 0:00:11.315543

exit_message:

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

id: 6666371

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_items_discounts_restrictions/2024-11-04/1730783529",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783529/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4264771798852458081,
        "service_name": "drive-thru",
        "span_id": 10261290307367653427,
        "trace_id": 2251443311687475652
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 01:36:09
success: True
trace_id: 2251443311687475652

Scan 6665603

duration: 0:00:11.352885

exit_message:

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

id: 6665603

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_items_discounts_restrictions/2024-11-04/1730783311",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730783311/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17884905866037235626,
        "service_name": "drive-thru",
        "span_id": 17016283714941337322,
        "trace_id": 2035830536272062438
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 01:15:54
success: True
trace_id: 2035830536272062438

Scan 6664592

duration: 0:00:11.354709

exit_message:

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

id: 6664592

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_items_discounts_restrictions/2024-11-04/1730782912",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730782912/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16899962564113287191,
        "service_name": "drive-thru",
        "span_id": 18260506167182898536,
        "trace_id": 4029829282139676841
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 00:49:01
success: True
trace_id: 4029829282139676841

Scan 6663766

duration: 0:00:11.353507

exit_message:

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

id: 6663766

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_items_discounts_restrictions/2024-11-04/1730782752",
        "key": "raw/newbookdev_newbookinventory_items_discounts_restrictions/2024-11-04/1730782752/inventory_items_discounts_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3289093145573751757,
        "service_name": "drive-thru",
        "span_id": 10069840678613565025,
        "trace_id": 15703750756143112638
    }
}

running: False
schema_name_id: 2655
start_time: 2024-11-05 00:27:25
success: True
trace_id: 15703750756143112638

Partitions:

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

Schema:

attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "inventory_item_discount_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

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

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_items_discounts_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `inventory_item_discount_id`  string , `for`  string , `for_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_newbookinventory_items_discounts_restrictions/2024-11-05/1730866520'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions"
}

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:54:38",
        "disabled": false,
        "format": "raw",
        "id": 2655,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookinventory_items_discounts_restrictions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "for": "string",
            "for_id": "string",
            "id": "string",
            "inventory_item_discount_id": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:21:21",
        "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_items_discounts_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `inventory_item_discount_id`  string , `for`  string , `for_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_newbookinventory_items_discounts_restrictions/2024-11-05/1730866520'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinventory_items_discounts_restrictions"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}