Schema Info
Schema Name: sfdl_prod_drivethru.newbook_newbookus_tax_rates
- created: 2025-05-13 02:14:48
- disabled: False
- format: raw
- id: 3844
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "newbook_newbookus_tax_rates" } - type: drivethrucsv
Schema Versions: 4
-
Version 1318806
- created: 2025-05-23 13:39:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.newbook_newbookus_tax_rates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.newbook_newbookus_tax_rates`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `display_name` string , `tax_type` string , `tax_amount` string , `tax_reduction_after_days` string , `tax_reduction_amount` string , `tax_reduction_retroactive` string , `tax_reduction_benefits_guest` string , `tax_contribution` string , `tax_gl_account_id` string , `tax_invoice_charge` string , `tax_applies_to` string , `tax_start_date` string , `tax_stop_date` string , `report_tax_collected_gl_account_id` string , `report_tax_uncollected_gl_account_id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-23/1748024641'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.newbook_newbookus_tax_rates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-23/1748024641
- id: 1318806
- processed: 1
- raw_data:
{ "display_name": 4, "id": 2, "name": 3, "newbook_region": 0, "report_tax_collected_gl_account_id": 17, "report_tax_uncollected_gl_account_id": 18, "tax_amount": 6, "tax_applies_to": 14, "tax_contribution": 11, "tax_gl_account_id": 12, "tax_invoice_charge": 13, "tax_reduction_after_days": 7, "tax_reduction_amount": 8, "tax_reduction_benefits_guest": 10, "tax_reduction_retroactive": 9, "tax_start_date": 15, "tax_stop_date": 16, "tax_type": 5, "tenant": 1 } - schema_attributes:
{ "display_name": "string", "id": "string", "name": "string", "newbook_region": "string", "report_tax_collected_gl_account_id": "string", "report_tax_uncollected_gl_account_id": "string", "tax_amount": "string", "tax_applies_to": "string", "tax_contribution": "string", "tax_gl_account_id": "string", "tax_invoice_charge": "string", "tax_reduction_after_days": "string", "tax_reduction_amount": "string", "tax_reduction_benefits_guest": "string", "tax_reduction_retroactive": "string", "tax_start_date": "string", "tax_stop_date": "string", "tax_type": "string", "tenant": "string" } - schema_name_id: 3844
- schema_scan_id: 142615987
- updated: 2025-05-23 13:39:24
-
Version 1313428
- created: 2025-05-20 02:57:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.newbook_newbookus_tax_rates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.newbook_newbookus_tax_rates`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `display_name` string , `tax_type` string , `tax_amount` string , `tax_reduction_after_days` string , `tax_reduction_amount` string , `tax_reduction_retroactive` string , `tax_reduction_benefits_guest` string , `tax_contribution` string , `tax_gl_account_id` string , `tax_invoice_charge` string , `tax_applies_to` string , `tax_start_date` string , `tax_stop_date` string , `report_tax_collected_gl_account_id` string , `report_tax_uncollected_gl_account_id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-20/1747727443'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.newbook_newbookus_tax_rates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-20/1747727443
- id: 1313428
- processed: 1
- raw_data:
{ "display_name": 4, "id": 2, "name": 3, "newbook_region": 0, "report_tax_collected_gl_account_id": 17, "report_tax_uncollected_gl_account_id": 18, "tax_amount": 6, "tax_applies_to": 14, "tax_contribution": 11, "tax_gl_account_id": 12, "tax_invoice_charge": 13, "tax_reduction_after_days": 7, "tax_reduction_amount": 8, "tax_reduction_benefits_guest": 10, "tax_reduction_retroactive": 9, "tax_start_date": 15, "tax_stop_date": 16, "tax_type": 5, "tenant": 1 } - schema_attributes:
{ "display_name": "string", "id": "string", "name": "string", "newbook_region": "string", "report_tax_collected_gl_account_id": "string", "report_tax_uncollected_gl_account_id": "string", "tax_amount": "string", "tax_applies_to": "string", "tax_contribution": "string", "tax_gl_account_id": "string", "tax_invoice_charge": "string", "tax_reduction_after_days": "string", "tax_reduction_amount": "string", "tax_reduction_benefits_guest": "string", "tax_reduction_retroactive": "string", "tax_start_date": "string", "tax_stop_date": "string", "tax_type": "string", "tenant": "string" } - schema_name_id: 3844
- schema_scan_id: 142431884
- updated: 2025-05-20 02:57:58
-
Version 1303064
- created: 2025-05-13 03:38:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.newbook_newbookus_tax_rates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.newbook_newbookus_tax_rates`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `display_name` string , `tax_type` string , `tax_amount` string , `tax_reduction_after_days` string , `tax_reduction_amount` string , `tax_reduction_retroactive` string , `tax_reduction_benefits_guest` string , `tax_contribution` string , `tax_gl_account_id` string , `tax_invoice_charge` string , `tax_applies_to` string , `tax_start_date` string , `tax_stop_date` string , `report_tax_collected_gl_account_id` string , `report_tax_uncollected_gl_account_id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-13/1747124686'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.newbook_newbookus_tax_rates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-13/1747124686
- id: 1303064
- processed: 1
- raw_data:
{ "display_name": 4, "id": 2, "name": 3, "newbook_region": 0, "report_tax_collected_gl_account_id": 17, "report_tax_uncollected_gl_account_id": 18, "tax_amount": 6, "tax_applies_to": 14, "tax_contribution": 11, "tax_gl_account_id": 12, "tax_invoice_charge": 13, "tax_reduction_after_days": 7, "tax_reduction_amount": 8, "tax_reduction_benefits_guest": 10, "tax_reduction_retroactive": 9, "tax_start_date": 15, "tax_stop_date": 16, "tax_type": 5, "tenant": 1 } - schema_attributes:
{ "display_name": "string", "id": "string", "name": "string", "newbook_region": "string", "report_tax_collected_gl_account_id": "string", "report_tax_uncollected_gl_account_id": "string", "tax_amount": "string", "tax_applies_to": "string", "tax_contribution": "string", "tax_gl_account_id": "string", "tax_invoice_charge": "string", "tax_reduction_after_days": "string", "tax_reduction_amount": "string", "tax_reduction_benefits_guest": "string", "tax_reduction_retroactive": "string", "tax_start_date": "string", "tax_stop_date": "string", "tax_type": "string", "tenant": "string" } - schema_name_id: 3844
- schema_scan_id: 142073291
- updated: 2025-05-13 03:38:26
-
Version 1302197
- created: 2025-05-13 02:14:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.newbook_newbookus_tax_rates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.newbook_newbookus_tax_rates`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `display_name` string , `tax_type` string , `tax_amount` string , `tax_reduction_after_days` string , `tax_reduction_amount` string , `tax_reduction_retroactive` string , `tax_reduction_benefits_guest` string , `tax_contribution` string , `tax_gl_account_id` string , `tax_invoice_charge` string , `tax_applies_to` string , `tax_start_date` string , `tax_stop_date` string , `report_tax_collected_gl_account_id` string , `report_tax_uncollected_gl_account_id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-13/1747119822'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.newbook_newbookus_tax_rates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-13/1747119822
- id: 1302197
- processed: 1
- raw_data:
{ "display_name": 4, "id": 2, "name": 3, "newbook_region": 0, "report_tax_collected_gl_account_id": 17, "report_tax_uncollected_gl_account_id": 18, "tax_amount": 6, "tax_applies_to": 14, "tax_contribution": 11, "tax_gl_account_id": 12, "tax_invoice_charge": 13, "tax_reduction_after_days": 7, "tax_reduction_amount": 8, "tax_reduction_benefits_guest": 10, "tax_reduction_retroactive": 9, "tax_start_date": 15, "tax_stop_date": 16, "tax_type": 5, "tenant": 1 } - schema_attributes:
{ "display_name": "string", "id": "string", "name": "string", "newbook_region": "string", "report_tax_collected_gl_account_id": "string", "report_tax_uncollected_gl_account_id": "string", "tax_amount": "string", "tax_applies_to": "string", "tax_contribution": "string", "tax_gl_account_id": "string", "tax_invoice_charge": "string", "tax_reduction_after_days": "string", "tax_reduction_amount": "string", "tax_reduction_benefits_guest": "string", "tax_reduction_retroactive": "string", "tax_start_date": "string", "tax_stop_date": "string", "tax_type": "string", "tenant": "string" } - schema_name_id: 3844
- schema_scan_id: 142071240
- updated: 2025-05-13 02:15:03
Schema Scans: 4
Last at 2025-05-23 13:39:12
-
Scan 142615987
- duration: 0:00:11.957172
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 142615987
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-23/1748024641", "key": "raw/newbook_newbookus_tax_rates/2025-05-23/1748024641/us_tax_rates.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.newbook_newbookus_tax_rates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6792116681276113560, "service_name": "drive-thru", "span_id": 18443762529299549084, "trace_id": 6669880847681052256 } } - running: False
- schema_name_id: 3844
- start_time: 2025-05-23 13:39:12
- success: True
- trace_id: 6669880847681052256
-
Scan 142431884
- duration: 0:00:11.695028
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 142431884
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-20/1747727443", "key": "raw/newbook_newbookus_tax_rates/2025-05-20/1747727443/us_tax_rates.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.newbook_newbookus_tax_rates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12179628169528082038, "service_name": "drive-thru", "span_id": 10954645009194403208, "trace_id": 3746453846558080013 } } - running: False
- schema_name_id: 3844
- start_time: 2025-05-20 02:57:46
- success: True
- trace_id: 3746453846558080013
-
Scan 142073291
- duration: 0:00:11.791944
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 142073291
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-13/1747124686", "key": "raw/newbook_newbookus_tax_rates/2025-05-13/1747124686/us_tax_rates.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.newbook_newbookus_tax_rates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11592725419652453679, "service_name": "drive-thru", "span_id": 7396176457569058133, "trace_id": 845186523274384636 } } - running: False
- schema_name_id: 3844
- start_time: 2025-05-13 03:38:14
- success: True
- trace_id: 845186523274384636
-
Scan 142071240
- duration: 0:00:14.261629
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 142071240
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-13/1747119822", "key": "raw/newbook_newbookus_tax_rates/2025-05-13/1747119822/us_tax_rates.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.newbook_newbookus_tax_rates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2031848071892214514, "service_name": "drive-thru", "span_id": 9030983869535720511, "trace_id": 7247256659278428115 } } - running: False
- schema_name_id: 3844
- start_time: 2025-05-13 02:14:48
- success: True
- trace_id: 7247256659278428115
- attributes:
{ "display_name": "string", "id": "string", "name": "string", "newbook_region": "string", "report_tax_collected_gl_account_id": "string", "report_tax_uncollected_gl_account_id": "string", "tax_amount": "string", "tax_applies_to": "string", "tax_contribution": "string", "tax_gl_account_id": "string", "tax_invoice_charge": "string", "tax_reduction_after_days": "string", "tax_reduction_amount": "string", "tax_reduction_benefits_guest": "string", "tax_reduction_retroactive": "string", "tax_start_date": "string", "tax_stop_date": "string", "tax_type": "string", "tenant": "string" } - created: 2025-05-23 13:39:13
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.newbook_newbookus_tax_rates`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `display_name` string , `tax_type` string , `tax_amount` string , `tax_reduction_after_days` string , `tax_reduction_amount` string , `tax_reduction_retroactive` string , `tax_reduction_benefits_guest` string , `tax_contribution` string , `tax_gl_account_id` string , `tax_invoice_charge` string , `tax_applies_to` string , `tax_start_date` string , `tax_stop_date` string , `report_tax_collected_gl_account_id` string , `report_tax_uncollected_gl_account_id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-23/1748024641'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.newbook_newbookus_tax_rates`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.newbook_newbookus_tax_rates" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2025-05-13 02:14:48",
"disabled": false,
"format": "raw",
"id": 3844,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "newbook_newbookus_tax_rates"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"display_name": "string",
"id": "string",
"name": "string",
"newbook_region": "string",
"report_tax_collected_gl_account_id": "string",
"report_tax_uncollected_gl_account_id": "string",
"tax_amount": "string",
"tax_applies_to": "string",
"tax_contribution": "string",
"tax_gl_account_id": "string",
"tax_invoice_charge": "string",
"tax_reduction_after_days": "string",
"tax_reduction_amount": "string",
"tax_reduction_benefits_guest": "string",
"tax_reduction_retroactive": "string",
"tax_start_date": "string",
"tax_stop_date": "string",
"tax_type": "string",
"tenant": "string"
},
"created": "2025-05-23 13:39:13",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.newbook_newbookus_tax_rates`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `display_name` string , `tax_type` string , `tax_amount` string , `tax_reduction_after_days` string , `tax_reduction_amount` string , `tax_reduction_retroactive` string , `tax_reduction_benefits_guest` string , `tax_contribution` string , `tax_gl_account_id` string , `tax_invoice_charge` string , `tax_applies_to` string , `tax_start_date` string , `tax_stop_date` string , `report_tax_collected_gl_account_id` string , `report_tax_uncollected_gl_account_id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/newbook_newbookus_tax_rates/2025-05-23/1748024641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.newbook_newbookus_tax_rates`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.newbook_newbookus_tax_rates"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}