Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs

created: 2024-10-08 18:09:46
disabled: False
format: raw
id: 2819
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749011

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6675043
updated: 2024-11-05 23:14:09

Version 4748621

created: 2024-11-05 22:53:47

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6674653
updated: 2024-11-05 22:54:01

Version 4747895

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6673927
updated: 2024-11-05 22:29:00

Version 4746940

created: 2024-11-05 04:34:11

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6672171
updated: 2024-11-05 04:34:22

Version 4746258

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6671479
updated: 2024-11-05 03:55:29

Version 4745471

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6670688
updated: 2024-11-05 03:30:31

Version 4745219

created: 2024-11-05 03:23:46

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6670437
updated: 2024-11-05 03:23:57

Version 4743669

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6668886
updated: 2024-11-05 02:42:56

Version 4743429

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6668646
updated: 2024-11-05 02:36:40

Version 4742593

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6667810
updated: 2024-11-05 02:14:31

Version 4742074

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783670
id: 4742074
processed: 1

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6667291
updated: 2024-11-05 02:00:35

Version 4740684

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783530
id: 4740684
processed: 1

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6665901
updated: 2024-11-05 01:24:00

Version 4740474

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6665691
updated: 2024-11-05 01:18:27

Version 4739657

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

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6664874
updated: 2024-11-05 00:56:38

Version 4739004

created: 2024-11-05 00:39:20

ddl:

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

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

raw_data:

{
    "category_id": 3,
    "date": 4,
    "id": 2,
    "newbook_region": 0,
    "price": 5,
    "tenant": 1,
    "updated_when": 6
}

schema_attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

schema_name_id: 2819
schema_scan_id: 6664219
updated: 2024-11-05 00:39:34

Schema Scans: 15

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

Scan 6675043

duration: 0:00:14.351005

exit_message:

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

id: 6675043

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_unit_costs/2024-11-05/1730866524",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-05/1730866524/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13953208254385086531,
        "service_name": "drive-thru",
        "span_id": 15574516691284594644,
        "trace_id": 11762940799858279933
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 23:13:54
success: True
trace_id: 11762940799858279933

Scan 6674653

duration: 0:00:14.013365

exit_message:

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

id: 6674653

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_unit_costs/2024-11-05/1730866456",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-05/1730866456/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14767954830056677323,
        "service_name": "drive-thru",
        "span_id": 12530708096183345650,
        "trace_id": 3713080573214431564
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 22:53:47
success: True
trace_id: 3713080573214431564

Scan 6673927

duration: 0:00:11.414660

exit_message:

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

id: 6673927

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_unit_costs/2024-11-05/1730866328",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-05/1730866328/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2964116520592847166,
        "service_name": "drive-thru",
        "span_id": 8274878822792225849,
        "trace_id": 8588274408960153236
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 22:28:48
success: True
trace_id: 8588274408960153236

Scan 6672171

duration: 0:00:12.162781

exit_message:

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

id: 6672171

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_unit_costs/2024-11-04/1730785734",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730785734/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15725216975837517175,
        "service_name": "drive-thru",
        "span_id": 7259079734059003480,
        "trace_id": 4388352676251505426
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 04:34:11
success: True
trace_id: 4388352676251505426

Scan 6671479

duration: 0:00:11.581255

exit_message:

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

id: 6671479

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_unit_costs/2024-11-04/1730785132",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730785132/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2475409003747479511,
        "service_name": "drive-thru",
        "span_id": 1219670954654764730,
        "trace_id": 296298228994584224
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 03:55:17
success: True
trace_id: 296298228994584224

Scan 6670688

duration: 0:00:11.360409

exit_message:

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

id: 6670688

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_unit_costs/2024-11-04/1730784827",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730784827/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11809276691604032512,
        "service_name": "drive-thru",
        "span_id": 16422313245951884211,
        "trace_id": 991755964356596173
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 03:30:20
success: True
trace_id: 991755964356596173

Scan 6670437

duration: 0:00:11.279967

exit_message:

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

id: 6670437

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_unit_costs/2024-11-04/1730784223",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730784223/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3447560615753987105,
        "service_name": "drive-thru",
        "span_id": 2417702755263349017,
        "trace_id": 4864658773935783340
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 03:23:46
success: True
trace_id: 4864658773935783340

Scan 6668886

duration: 0:00:11.607344

exit_message:

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

id: 6668886

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_unit_costs/2024-11-04/1730783904",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783904/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8531703711022175996,
        "service_name": "drive-thru",
        "span_id": 1423969366569763739,
        "trace_id": 6319287883376422028
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 02:42:45
success: True
trace_id: 6319287883376422028

Scan 6668646

duration: 0:00:13.952120

exit_message:

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

id: 6668646

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_unit_costs/2024-11-04/1730784061",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730784061/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7323349501972569916,
        "service_name": "drive-thru",
        "span_id": 3769168109414588743,
        "trace_id": 6442866566947876289
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 02:36:26
success: True
trace_id: 6442866566947876289

Scan 6667810

duration: 0:00:11.342983

exit_message:

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

id: 6667810

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_unit_costs/2024-11-04/1730783774",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783774/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17127622020732059504,
        "service_name": "drive-thru",
        "span_id": 10355464777220440693,
        "trace_id": 12827677784989171172
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 02:14:19
success: True
trace_id: 12827677784989171172

Scan 6667291

duration: 0:00:13.805719

exit_message:

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

id: 6667291

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_unit_costs/2024-11-04/1730783670",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783670/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12242577375114190473,
        "service_name": "drive-thru",
        "span_id": 8930444517765545214,
        "trace_id": 12054085308877205528
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 02:00:21
success: True
trace_id: 12054085308877205528

Scan 6665901

duration: 0:00:14.294545

exit_message:

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

id: 6665901

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_unit_costs/2024-11-04/1730783530",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783530/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16399796969765528494,
        "service_name": "drive-thru",
        "span_id": 16443579036733749091,
        "trace_id": 2796718738479288907
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 01:23:45
success: True
trace_id: 2796718738479288907

Scan 6665691

duration: 0:00:11.546117

exit_message:

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

id: 6665691

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_unit_costs/2024-11-04/1730783313",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730783313/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17803998435808694959,
        "service_name": "drive-thru",
        "span_id": 3574758319896566173,
        "trace_id": 10964650704096058386
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 01:18:16
success: True
trace_id: 10964650704096058386

Scan 6664874

duration: 0:00:13.788253

exit_message:

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

id: 6664874

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_unit_costs/2024-11-04/1730782913",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730782913/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12865989102784922226,
        "service_name": "drive-thru",
        "span_id": 413869794867169671,
        "trace_id": 7100261167798908460
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 00:56:24
success: True
trace_id: 7100261167798908460

Scan 6664219

duration: 0:00:14.049233

exit_message:

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

id: 6664219

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_unit_costs/2024-11-04/1730782810",
        "key": "raw/newbookdev_newbookinventory_items_unit_costs/2024-11-04/1730782810/inventory_items_unit_costs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12949321042412516535,
        "service_name": "drive-thru",
        "span_id": 5908540774063739369,
        "trace_id": 7215189204137406897
    }
}

running: False
schema_name_id: 2819
start_time: 2024-11-05 00:39:20
success: True
trace_id: 7215189204137406897

Partitions:

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

Schema:

attributes:

{
    "category_id": "string",
    "date": "string",
    "id": "string",
    "newbook_region": "string",
    "price": "string",
    "tenant": "string",
    "updated_when": "string"
}

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

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_unit_costs`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `date`  string , `price`  string , `updated_when`  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_unit_costs/2024-11-05/1730866524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs"
}

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:09:46",
        "disabled": false,
        "format": "raw",
        "id": 2819,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookinventory_items_unit_costs"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "category_id": "string",
            "date": "string",
            "id": "string",
            "newbook_region": "string",
            "price": "string",
            "tenant": "string",
            "updated_when": "string"
        },
        "created": "2024-11-05 23:13:55",
        "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_unit_costs`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `category_id`  string , `date`  string , `price`  string , `updated_when`  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_unit_costs/2024-11-05/1730866524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinventory_items_unit_costs"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}