Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees

created: 2024-10-08 17:37:14
disabled: False
format: raw
id: 2412
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747994

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866343
id: 4747994
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6674026
updated: 2024-11-05 22:31:48

Version 4747624

created: 2024-11-05 22:21:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866280
id: 4747624
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6673656
updated: 2024-11-05 22:21:52

Version 4747407

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866224
id: 4747407
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6673439
updated: 2024-11-05 22:15:55

Version 4745899

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730785635
id: 4745899
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6671117
updated: 2024-11-05 03:42:31

Version 4745159

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730785074
id: 4745159
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6670376
updated: 2024-11-05 03:22:21

Version 4745040

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784768
id: 4745040
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6670257
updated: 2024-11-05 03:19:16

Version 4744470

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784165
id: 4744470
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6669687
updated: 2024-11-05 03:04:06

Version 4743662

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784003
id: 4743662
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6668879
updated: 2024-11-05 02:42:45

Version 4743214

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783860
id: 4743214
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6668431
updated: 2024-11-05 02:30:48

Version 4742274

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783716
id: 4742274
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6667491
updated: 2024-11-05 02:06:00

Version 4741105

created: 2024-11-05 01:34:57

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783626
id: 4741105
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6666322
updated: 2024-11-05 01:35:08

Version 4740756

created: 2024-11-05 01:25:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783471
id: 4740756
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6665973
updated: 2024-11-05 01:25:52

Version 4739977

created: 2024-11-05 01:05:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783252
id: 4739977
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6665194
updated: 2024-11-05 01:05:16

Version 4739313

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730782855
id: 4739313
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6664527
updated: 2024-11-05 00:47:36

Version 4738650

created: 2024-11-05 00:29:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730782737
id: 4738650
processed: 1

raw_data:

{
    "amount": 12,
    "amount_type": 11,
    "category_id": 4,
    "description": 8,
    "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",
    "category_id": "string",
    "description": "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: 2412
schema_scan_id: 6663863
updated: 2024-11-05 00:30:11

Schema Scans: 15

Last at 2024-11-05 22:31:36

Scan 6674026

duration: 0:00:11.903872

exit_message:

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

id: 6674026

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_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866343",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866343/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3688804607299017189,
        "service_name": "drive-thru",
        "span_id": 16740653929324251730,
        "trace_id": 14627830074488819742
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 22:31:36
success: True
trace_id: 14627830074488819742

Scan 6673656

duration: 0:00:11.646028

exit_message:

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

id: 6673656

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_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866280",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866280/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2747951440720824262,
        "service_name": "drive-thru",
        "span_id": 14885358875710499888,
        "trace_id": 4271733943063404881
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 22:21:40
success: True
trace_id: 4271733943063404881

Scan 6673439

duration: 0:00:11.806130

exit_message:

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

id: 6673439

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_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866224",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866224/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4824141287911710607,
        "service_name": "drive-thru",
        "span_id": 16352765457702309493,
        "trace_id": 15086037995127465214
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 22:15:44
success: True
trace_id: 15086037995127465214

Scan 6671117

duration: 0:00:11.841615

exit_message:

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

id: 6671117

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730785635",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730785635/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6470369491334852378,
        "service_name": "drive-thru",
        "span_id": 8965484185277179913,
        "trace_id": 3006941195635182599
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 03:42:20
success: True
trace_id: 3006941195635182599

Scan 6670376

duration: 0:00:11.646978

exit_message:

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

id: 6670376

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730785074",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730785074/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4167191066524068701,
        "service_name": "drive-thru",
        "span_id": 16130789751537550647,
        "trace_id": 13419739316570217228
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 03:22:10
success: True
trace_id: 13419739316570217228

Scan 6670257

duration: 0:00:11.898424

exit_message:

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

id: 6670257

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784768",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784768/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6871879992183436472,
        "service_name": "drive-thru",
        "span_id": 3105562351217226131,
        "trace_id": 7729666148960913601
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 03:19:04
success: True
trace_id: 7729666148960913601

Scan 6669687

duration: 0:00:14.209924

exit_message:

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

id: 6669687

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784165",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784165/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5740378182157124037,
        "service_name": "drive-thru",
        "span_id": 11606715948253841152,
        "trace_id": 4291169225292883097
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 03:03:52
success: True
trace_id: 4291169225292883097

Scan 6668879

duration: 0:00:11.671603

exit_message:

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

id: 6668879

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784003",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730784003/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9959247122813657395,
        "service_name": "drive-thru",
        "span_id": 6245627340179991568,
        "trace_id": 4456635560519642223
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 02:42:33
success: True
trace_id: 4456635560519642223

Scan 6668431

duration: 0:00:11.702031

exit_message:

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

id: 6668431

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783860",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783860/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3811511621568592876,
        "service_name": "drive-thru",
        "span_id": 15167047380146672892,
        "trace_id": 2976749001410816612
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 02:30:37
success: True
trace_id: 2976749001410816612

Scan 6667491

duration: 0:00:11.721051

exit_message:

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

id: 6667491

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783716",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783716/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15239291494975294893,
        "service_name": "drive-thru",
        "span_id": 12220805988175722800,
        "trace_id": 12160023509099276170
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 02:05:49
success: True
trace_id: 12160023509099276170

Scan 6666322

duration: 0:00:11.675452

exit_message:

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

id: 6666322

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783626",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783626/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12641871180701873761,
        "service_name": "drive-thru",
        "span_id": 8474716998882119352,
        "trace_id": 8364333643654734807
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 01:34:56
success: True
trace_id: 8364333643654734807

Scan 6665973

duration: 0:00:11.547554

exit_message:

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

id: 6665973

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783471",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783471/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18227882056348927380,
        "service_name": "drive-thru",
        "span_id": 10138581677172552659,
        "trace_id": 16743664219007944630
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 01:25:41
success: True
trace_id: 16743664219007944630

Scan 6665194

duration: 0:00:11.715211

exit_message:

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

id: 6665194

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783252",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730783252/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5982865855577561629,
        "service_name": "drive-thru",
        "span_id": 3663693528145208202,
        "trace_id": 15998613442841157888
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 01:05:04
success: True
trace_id: 15998613442841157888

Scan 6664527

duration: 0:00:11.603846

exit_message:

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

id: 6664527

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730782855",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730782855/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4144041151846162770,
        "service_name": "drive-thru",
        "span_id": 18387599563246345596,
        "trace_id": 2163285907495505462
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 00:47:24
success: True
trace_id: 2163285907495505462

Scan 6663863

duration: 0:00:14.231229

exit_message:

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

id: 6663863

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_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730782737",
        "key": "raw/newbookdev_newbookaccommodation_categories_adjustment_fees/2024-11-04/1730782737/accommodation_categories_adjustment_fees.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6788111524203819134,
        "service_name": "drive-thru",
        "span_id": 9965286448339290692,
        "trace_id": 615189648776387620
    }
}

running: False
schema_name_id: 2412
start_time: 2024-11-05 00:29:57
success: True
trace_id: 615189648776387620

Partitions:

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

Schema:

attributes:

{
    "amount": "string",
    "amount_type": "string",
    "category_id": "string",
    "description": "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:31:37

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `category_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_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_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:37:14",
        "disabled": false,
        "format": "raw",
        "id": 2412,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccommodation_categories_adjustment_fees"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "amount_type": "string",
            "category_id": "string",
            "description": "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:31:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `category_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_newbookaccommodation_categories_adjustment_fees/2024-11-05/1730866343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_categories_adjustment_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}