Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_deposits

created: 2024-10-08 17:39:23
disabled: False
format: raw
id: 2442
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748013

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866377'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866377
id: 4748013
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6674045
updated: 2024-11-05 22:32:28

Version 4747785

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866311
id: 4747785
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6673817
updated: 2024-11-05 22:26:03

Version 4747402

created: 2024-11-05 22:15:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866237'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866237
id: 4747402
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6673434
updated: 2024-11-05 22:15:44

Version 4746700

created: 2024-11-05 04:17:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730785655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730785655
id: 4746700
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6671924
updated: 2024-11-05 04:17:25

Version 4746165

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730785085'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730785085
id: 4746165
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6671386
updated: 2024-11-05 03:51:48

Version 4745049

created: 2024-11-05 03:19:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784780'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784780
id: 4745049
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6670266
updated: 2024-11-05 03:19:32

Version 4744535

created: 2024-11-05 03:05:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784177'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784177
id: 4744535
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6669752
updated: 2024-11-05 03:05:50

Version 4743079

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784014'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784014
id: 4743079
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6668296
updated: 2024-11-05 02:27:18

Version 4743047

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783834'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783834
id: 4743047
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6668264
updated: 2024-11-05 02:26:28

Version 4742344

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783727
id: 4742344
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6667561
updated: 2024-11-05 02:07:56

Version 4741602

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783634
id: 4741602
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6666820
updated: 2024-11-05 01:48:05

Version 4740821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783482'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783482
id: 4740821
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6666038
updated: 2024-11-05 01:27:35

Version 4740044

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783264'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783264
id: 4740044
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6665261
updated: 2024-11-05 01:07:04

Version 4739246

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730782867'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730782867
id: 4739246
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6664461
updated: 2024-11-05 00:45:50

Version 4738728

created: 2024-11-05 00:32:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730782775'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-04/1730782775
id: 4738728
processed: 1

raw_data:

{
    "amount": 4,
    "booking_id": 3,
    "due_date": 6,
    "from_type": 7,
    "from_type_id": 8,
    "id": 2,
    "newbook_region": 0,
    "original_amount": 5,
    "tenant": 1
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

schema_name_id: 2442
schema_scan_id: 6663941
updated: 2024-11-05 00:32:11

Schema Scans: 15

Last at 2024-11-05 22:32:14

Scan 6674045

duration: 0:00:13.975605

exit_message:

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

id: 6674045

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_newbookbookings_deposits/2024-11-05/1730866377",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866377/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11740406854115576905,
        "service_name": "drive-thru",
        "span_id": 9635125881597638678,
        "trace_id": 10087789006542680260
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 22:32:14
success: True
trace_id: 10087789006542680260

Scan 6673817

duration: 0:00:11.447790

exit_message:

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

id: 6673817

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_newbookbookings_deposits/2024-11-05/1730866311",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866311/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12341399506225380323,
        "service_name": "drive-thru",
        "span_id": 18222896608837472734,
        "trace_id": 14535705028805834881
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 22:25:51
success: True
trace_id: 14535705028805834881

Scan 6673434

duration: 0:00:11.576489

exit_message:

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

id: 6673434

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_newbookbookings_deposits/2024-11-05/1730866237",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866237/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 990928843465589614,
        "service_name": "drive-thru",
        "span_id": 381248903620745878,
        "trace_id": 10603753929327932280
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 22:15:32
success: True
trace_id: 10603753929327932280

Scan 6671924

duration: 0:00:14.204413

exit_message:

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

id: 6671924

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_newbookbookings_deposits/2024-11-04/1730785655",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730785655/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5467005857138078996,
        "service_name": "drive-thru",
        "span_id": 4765496714549892983,
        "trace_id": 4520693582218097503
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 04:17:11
success: True
trace_id: 4520693582218097503

Scan 6671386

duration: 0:00:14.198302

exit_message:

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

id: 6671386

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_newbookbookings_deposits/2024-11-04/1730785085",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730785085/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9948952629282420775,
        "service_name": "drive-thru",
        "span_id": 2467544247739941260,
        "trace_id": 12209504639112328949
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 03:51:34
success: True
trace_id: 12209504639112328949

Scan 6670266

duration: 0:00:13.787743

exit_message:

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

id: 6670266

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_newbookbookings_deposits/2024-11-04/1730784780",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784780/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3310123801044283625,
        "service_name": "drive-thru",
        "span_id": 16278834076638048124,
        "trace_id": 14655591720759962555
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 03:19:19
success: True
trace_id: 14655591720759962555

Scan 6669752

duration: 0:00:11.444056

exit_message:

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

id: 6669752

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_newbookbookings_deposits/2024-11-04/1730784177",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784177/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1559523549413574767,
        "service_name": "drive-thru",
        "span_id": 3278946964913235273,
        "trace_id": 9937273811147515334
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 03:05:38
success: True
trace_id: 9937273811147515334

Scan 6668296

duration: 0:00:13.994553

exit_message:

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

id: 6668296

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_newbookbookings_deposits/2024-11-04/1730784014",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730784014/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4737832176751720695,
        "service_name": "drive-thru",
        "span_id": 3918426648424833787,
        "trace_id": 480326953735629723
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 02:27:04
success: True
trace_id: 480326953735629723

Scan 6668264

duration: 0:00:14.002727

exit_message:

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

id: 6668264

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_newbookbookings_deposits/2024-11-04/1730783834",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783834/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1816632773724268356,
        "service_name": "drive-thru",
        "span_id": 8537040581955015599,
        "trace_id": 17725698834060530115
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 02:26:14
success: True
trace_id: 17725698834060530115

Scan 6667561

duration: 0:00:13.935834

exit_message:

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

id: 6667561

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_newbookbookings_deposits/2024-11-04/1730783727",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783727/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15010803216383693113,
        "service_name": "drive-thru",
        "span_id": 3696007409302653775,
        "trace_id": 6861540111396859758
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 02:07:42
success: True
trace_id: 6861540111396859758

Scan 6666820

duration: 0:00:11.470214

exit_message:

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

id: 6666820

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_newbookbookings_deposits/2024-11-04/1730783634",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783634/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10760481904601249902,
        "service_name": "drive-thru",
        "span_id": 4089513766391970647,
        "trace_id": 4181040948361337897
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 01:47:53
success: True
trace_id: 4181040948361337897

Scan 6666038

duration: 0:00:14.019116

exit_message:

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

id: 6666038

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_newbookbookings_deposits/2024-11-04/1730783482",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783482/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7191918245334422697,
        "service_name": "drive-thru",
        "span_id": 162934715056082276,
        "trace_id": 13891650496378512284
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 01:27:21
success: True
trace_id: 13891650496378512284

Scan 6665261

duration: 0:00:11.459271

exit_message:

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

id: 6665261

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_newbookbookings_deposits/2024-11-04/1730783264",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730783264/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1060127853213476866,
        "service_name": "drive-thru",
        "span_id": 1685840846196247297,
        "trace_id": 7440979484132334386
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 01:06:52
success: True
trace_id: 7440979484132334386

Scan 6664461

duration: 0:00:11.432434

exit_message:

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

id: 6664461

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_newbookbookings_deposits/2024-11-04/1730782867",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730782867/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10857999554849893289,
        "service_name": "drive-thru",
        "span_id": 4500434367164358514,
        "trace_id": 1373148112512905463
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 00:45:39
success: True
trace_id: 1373148112512905463

Scan 6663941

duration: 0:00:11.373775

exit_message:

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

id: 6663941

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_newbookbookings_deposits/2024-11-04/1730782775",
        "key": "raw/newbookdev_newbookbookings_deposits/2024-11-04/1730782775/bookings_deposits.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_deposits",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14607196773553197496,
        "service_name": "drive-thru",
        "span_id": 18423857203048051753,
        "trace_id": 2470033269024121002
    }
}

running: False
schema_name_id: 2442
start_time: 2024-11-05 00:32:00
success: True
trace_id: 2470033269024121002

Partitions:

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

Schema:

attributes:

{
    "amount": "string",
    "booking_id": "string",
    "due_date": "string",
    "from_type": "string",
    "from_type_id": "string",
    "id": "string",
    "newbook_region": "string",
    "original_amount": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866377'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
}

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:39:23",
        "disabled": false,
        "format": "raw",
        "id": 2442,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookbookings_deposits"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "booking_id": "string",
            "due_date": "string",
            "from_type": "string",
            "from_type_id": "string",
            "id": "string",
            "newbook_region": "string",
            "original_amount": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:32:14",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `amount`  string , `original_amount`  string , `due_date`  string , `from_type`  string , `from_type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_deposits/2024-11-05/1730866377'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_deposits`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_deposits"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}