Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees

created: 2024-10-08 17:48:56
disabled: False
format: raw
id: 2575
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748683

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-05/1730866487'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-05/1730866487
id: 4748683
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6674715
updated: 2024-11-05 22:56:35

Version 4748220

created: 2024-11-05 22:38:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-05/1730866402'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-05/1730866402
id: 4748220
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6674252
updated: 2024-11-05 22:38:46

Version 4747660

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-05/1730866290'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-05/1730866290
id: 4747660
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6673692
updated: 2024-11-05 22:22:53

Version 4747099

created: 2024-11-05 04:50:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730785707'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730785707
id: 4747099
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6672331
updated: 2024-11-05 04:50:24

Version 4746085

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730785117'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730785117
id: 4746085
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6671306
updated: 2024-11-05 03:48:57

Version 4745364

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730784812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730784812
id: 4745364
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6670581
updated: 2024-11-05 03:27:43

Version 4744697

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730784209'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730784209
id: 4744697
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6669914
updated: 2024-11-05 03:10:15

Version 4743469

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730783893'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783893
id: 4743469
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6668685
updated: 2024-11-05 02:37:38

Version 4743321

created: 2024-11-05 02:33:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730784046'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730784046
id: 4743321
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6668537
updated: 2024-11-05 02:33:40

Version 4742430

created: 2024-11-05 02:10:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730783759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783759
id: 4742430
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6667647
updated: 2024-11-05 02:10:13

Version 4741671

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730783608'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783608
id: 4741671
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6666888
updated: 2024-11-05 01:49:55

Version 4740958

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730783515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783515
id: 4740958
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6666175
updated: 2024-11-05 01:31:12

Version 4740269

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730783297'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783297
id: 4740269
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6665485
updated: 2024-11-05 01:13:06

Version 4739428

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730782899'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730782899
id: 4739428
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6664644
updated: 2024-11-05 00:50:37

Version 4738797

created: 2024-11-05 00:33:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-04/1730782799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730782799
id: 4738797
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "description": 8,
    "event_package_id": 4,
    "gl_account_id": 7,
    "gl_category_id": 6,
    "id": 2,
    "inventory_item_id": 5,
    "newbook_region": 0,
    "per_adult": 13,
    "per_animal": 16,
    "per_child": 14,
    "per_infant": 15,
    "tax_free": 17,
    "tenant": 1,
    "type": 3,
    "within_days": 10,
    "within_type": 9
}

schema_attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

schema_name_id: 2575
schema_scan_id: 6664010
updated: 2024-11-05 00:34:04

Schema Scans: 15

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

Scan 6674715

duration: 0:00:11.817370

exit_message:

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

id: 6674715

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_newbookevents_packages_adjustment_fees/2024-11-05/1730866487",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-05/1730866487/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11913982735819397489,
        "service_name": "drive-thru",
        "span_id": 4122011123270194913,
        "trace_id": 17367229864084188841
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 22:56:23
success: True
trace_id: 17367229864084188841

Scan 6674252

duration: 0:00:11.939161

exit_message:

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

id: 6674252

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_newbookevents_packages_adjustment_fees/2024-11-05/1730866402",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-05/1730866402/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10614018943727792811,
        "service_name": "drive-thru",
        "span_id": 871287280098964379,
        "trace_id": 17536062280083683854
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 22:38:34
success: True
trace_id: 17536062280083683854

Scan 6673692

duration: 0:00:11.715069

exit_message:

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

id: 6673692

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_newbookevents_packages_adjustment_fees/2024-11-05/1730866290",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-05/1730866290/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3259568939869666640,
        "service_name": "drive-thru",
        "span_id": 1183782572802983328,
        "trace_id": 6940716892602865788
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 22:22:41
success: True
trace_id: 6940716892602865788

Scan 6672331

duration: 0:00:11.899269

exit_message:

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

id: 6672331

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_newbookevents_packages_adjustment_fees/2024-11-04/1730785707",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730785707/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3461225645749865168,
        "service_name": "drive-thru",
        "span_id": 15917708220456076350,
        "trace_id": 11580712293251085216
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 04:50:12
success: True
trace_id: 11580712293251085216

Scan 6671306

duration: 0:00:11.919872

exit_message:

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

id: 6671306

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_newbookevents_packages_adjustment_fees/2024-11-04/1730785117",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730785117/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 506426359888611888,
        "service_name": "drive-thru",
        "span_id": 13972951718549072206,
        "trace_id": 11097925147737446658
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 03:48:45
success: True
trace_id: 11097925147737446658

Scan 6670581

duration: 0:00:14.190817

exit_message:

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

id: 6670581

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_newbookevents_packages_adjustment_fees/2024-11-04/1730784812",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730784812/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4113202551695822094,
        "service_name": "drive-thru",
        "span_id": 17081913216686767490,
        "trace_id": 15195297632798690780
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 03:27:29
success: True
trace_id: 15195297632798690780

Scan 6669914

duration: 0:00:14.192933

exit_message:

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

id: 6669914

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_newbookevents_packages_adjustment_fees/2024-11-04/1730784209",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730784209/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7623378622657740307,
        "service_name": "drive-thru",
        "span_id": 8622670340325012480,
        "trace_id": 6637244705232548774
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 03:10:01
success: True
trace_id: 6637244705232548774

Scan 6668685

duration: 0:00:11.580519

exit_message:

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

id: 6668685

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_newbookevents_packages_adjustment_fees/2024-11-04/1730783893",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783893/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17699032131935927147,
        "service_name": "drive-thru",
        "span_id": 14406345664727959073,
        "trace_id": 11462490030621397654
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 02:37:27
success: True
trace_id: 11462490030621397654

Scan 6668537

duration: 0:00:11.663400

exit_message:

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

id: 6668537

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_newbookevents_packages_adjustment_fees/2024-11-04/1730784046",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730784046/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6029157463588308887,
        "service_name": "drive-thru",
        "span_id": 15914058714551195675,
        "trace_id": 2436657814260464731
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 02:33:29
success: True
trace_id: 2436657814260464731

Scan 6667647

duration: 0:00:11.788760

exit_message:

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

id: 6667647

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_newbookevents_packages_adjustment_fees/2024-11-04/1730783759",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783759/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4006053476261698977,
        "service_name": "drive-thru",
        "span_id": 18052697980764028281,
        "trace_id": 15463758460657378096
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 02:10:01
success: True
trace_id: 15463758460657378096

Scan 6666888

duration: 0:00:11.591252

exit_message:

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

id: 6666888

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_newbookevents_packages_adjustment_fees/2024-11-04/1730783608",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783608/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2659795376186548225,
        "service_name": "drive-thru",
        "span_id": 5155061590239979298,
        "trace_id": 9631825523103635414
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 01:49:43
success: True
trace_id: 9631825523103635414

Scan 6666175

duration: 0:00:14.257231

exit_message:

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

id: 6666175

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_newbookevents_packages_adjustment_fees/2024-11-04/1730783515",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783515/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4131839461659063197,
        "service_name": "drive-thru",
        "span_id": 17604487002511122903,
        "trace_id": 16564073596417416766
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 01:30:58
success: True
trace_id: 16564073596417416766

Scan 6665485

duration: 0:00:11.707167

exit_message:

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

id: 6665485

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_newbookevents_packages_adjustment_fees/2024-11-04/1730783297",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730783297/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14413529004203024595,
        "service_name": "drive-thru",
        "span_id": 4497810220221476089,
        "trace_id": 15716729472682015721
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 01:12:54
success: True
trace_id: 15716729472682015721

Scan 6664644

duration: 0:00:14.237365

exit_message:

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

id: 6664644

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_newbookevents_packages_adjustment_fees/2024-11-04/1730782899",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730782899/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10488286663282531695,
        "service_name": "drive-thru",
        "span_id": 11002566122078352606,
        "trace_id": 9966112928195110421
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 00:50:23
success: True
trace_id: 9966112928195110421

Scan 6664010

duration: 0:00:11.665228

exit_message:

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

id: 6664010

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_newbookevents_packages_adjustment_fees/2024-11-04/1730782799",
        "key": "raw/newbookdev_newbookevents_packages_adjustment_fees/2024-11-04/1730782799/events_packages_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4553350552142995805,
        "service_name": "drive-thru",
        "span_id": 7294827209316956395,
        "trace_id": 5537545671048841082
    }
}

running: False
schema_name_id: 2575
start_time: 2024-11-05 00:33:52
success: True
trace_id: 5537545671048841082

Partitions:

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

Schema:

attributes:

{
    "amount": "string",
    "amount_type": "string",
    "description": "string",
    "event_package_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "id": "string",
    "inventory_item_id": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "tax_free": "string",
    "tenant": "string",
    "type": "string",
    "within_days": "string",
    "within_type": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-05/1730866487'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
}

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:48:56",
        "disabled": false,
        "format": "raw",
        "id": 2575,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookevents_packages_adjustment_fees"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "amount_type": "string",
            "description": "string",
            "event_package_id": "string",
            "gl_account_id": "string",
            "gl_category_id": "string",
            "id": "string",
            "inventory_item_id": "string",
            "newbook_region": "string",
            "per_adult": "string",
            "per_animal": "string",
            "per_child": "string",
            "per_infant": "string",
            "tax_free": "string",
            "tenant": "string",
            "type": "string",
            "within_days": "string",
            "within_type": "string"
        },
        "created": "2024-11-05 22:56:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `event_package_id`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `within_type`  string , `within_days`  string , `amount_type`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `tax_free`  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_newbookevents_packages_adjustment_fees/2024-11-05/1730866487'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_packages_adjustment_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}