Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions

created: 2024-10-08 18:38:15
disabled: False
format: raw
id: 3082
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749389

created: 2024-11-05 23:45:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-05/1730866575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-05/1730866575
id: 4749389
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6675427
updated: 2024-11-05 23:45:48

Version 4749315

created: 2024-11-05 23:37:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-05/1730866619'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-05/1730866619
id: 4749315
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6675347
updated: 2024-11-05 23:37:50

Version 4748598

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-05/1730866475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-05/1730866475
id: 4748598
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6674630
updated: 2024-11-05 22:53:02

Version 4747175

created: 2024-11-05 04:58:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730785816'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730785816
id: 4747175
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6672407
updated: 2024-11-05 04:58:30

Version 4746501

created: 2024-11-05 04:06:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730785178'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730785178
id: 4746501
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6671722
updated: 2024-11-05 04:06:29

Version 4745705

created: 2024-11-05 03:36:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730784873'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730784873
id: 4745705
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6670922
updated: 2024-11-05 03:36:39

Version 4745076

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730784269'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730784269
id: 4745076
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6670294
updated: 2024-11-05 03:20:14

Version 4743794

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730784108'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730784108
id: 4743794
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6669011
updated: 2024-11-05 02:46:17

Version 4742992

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730783821'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783821
id: 4742992
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6668209
updated: 2024-11-05 02:25:00

Version 4742475

created: 2024-11-05 02:11:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730783857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783857
id: 4742475
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6667692
updated: 2024-11-05 02:11:23

Version 4742201

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730783705'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783705
id: 4742201
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6667418
updated: 2024-11-05 02:04:01

Version 4740928

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730783578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783578
id: 4740928
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6666145
updated: 2024-11-05 01:30:23

Version 4740706

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730783359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783359
id: 4740706
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6665923
updated: 2024-11-05 01:24:37

Version 4740001

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730782957'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730782957
id: 4740001
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6665218
updated: 2024-11-05 01:05:54

Version 4739366

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-04/1730782845'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730782845
id: 4739366
processed: 1

raw_data:

{
    "active": 6,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tax_rate_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

schema_name_id: 3082
schema_scan_id: 6664581
updated: 2024-11-05 00:48:58

Schema Scans: 15

Last at 2024-11-05 23:45:34

Scan 6675427

duration: 0:00:14.119624

exit_message:

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

id: 6675427

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_newbooktax_rates_restrictions/2024-11-05/1730866575",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-05/1730866575/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5620074012469444160,
        "service_name": "drive-thru",
        "span_id": 12309143974906420373,
        "trace_id": 8370497826846362741
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 23:45:34
success: True
trace_id: 8370497826846362741

Scan 6675347

duration: 0:00:14.022192

exit_message:

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

id: 6675347

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_newbooktax_rates_restrictions/2024-11-05/1730866619",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-05/1730866619/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13101351288976063910,
        "service_name": "drive-thru",
        "span_id": 9962699376959391896,
        "trace_id": 13311378700905312179
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 23:37:36
success: True
trace_id: 13311378700905312179

Scan 6674630

duration: 0:00:11.531114

exit_message:

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

id: 6674630

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_newbooktax_rates_restrictions/2024-11-05/1730866475",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-05/1730866475/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 998270754215975288,
        "service_name": "drive-thru",
        "span_id": 17708546823351861417,
        "trace_id": 569733548006136852
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 22:52:50
success: True
trace_id: 569733548006136852

Scan 6672407

duration: 0:00:11.573546

exit_message:

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

id: 6672407

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_newbooktax_rates_restrictions/2024-11-04/1730785816",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730785816/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7607446672451947613,
        "service_name": "drive-thru",
        "span_id": 16938363558004692737,
        "trace_id": 9258725532923138897
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 04:58:19
success: True
trace_id: 9258725532923138897

Scan 6671722

duration: 0:00:11.492320

exit_message:

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

id: 6671722

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_newbooktax_rates_restrictions/2024-11-04/1730785178",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730785178/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11213085844145830673,
        "service_name": "drive-thru",
        "span_id": 13865762589273537380,
        "trace_id": 7555189693440594620
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 04:06:18
success: True
trace_id: 7555189693440594620

Scan 6670922

duration: 0:00:11.425248

exit_message:

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

id: 6670922

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_newbooktax_rates_restrictions/2024-11-04/1730784873",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730784873/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7654844533148919882,
        "service_name": "drive-thru",
        "span_id": 1117342938144998681,
        "trace_id": 10283912657875677017
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 03:36:27
success: True
trace_id: 10283912657875677017

Scan 6670294

duration: 0:00:11.426870

exit_message:

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

id: 6670294

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_newbooktax_rates_restrictions/2024-11-04/1730784269",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730784269/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11292132153430738926,
        "service_name": "drive-thru",
        "span_id": 9097116507704445668,
        "trace_id": 9221704304530914182
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 03:20:02
success: True
trace_id: 9221704304530914182

Scan 6669011

duration: 0:00:13.954305

exit_message:

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

id: 6669011

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_newbooktax_rates_restrictions/2024-11-04/1730784108",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730784108/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2508980588343642677,
        "service_name": "drive-thru",
        "span_id": 5474396048620985688,
        "trace_id": 4673549369600208060
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 02:46:03
success: True
trace_id: 4673549369600208060

Scan 6668209

duration: 0:00:11.489648

exit_message:

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

id: 6668209

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_newbooktax_rates_restrictions/2024-11-04/1730783821",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783821/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7668856806177835693,
        "service_name": "drive-thru",
        "span_id": 12703598353778883395,
        "trace_id": 14502566384242660712
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 02:24:49
success: True
trace_id: 14502566384242660712

Scan 6667692

duration: 0:00:11.247870

exit_message:

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

id: 6667692

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_newbooktax_rates_restrictions/2024-11-04/1730783857",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783857/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7196148976788571051,
        "service_name": "drive-thru",
        "span_id": 14795383952018845874,
        "trace_id": 2675751184964967840
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 02:11:12
success: True
trace_id: 2675751184964967840

Scan 6667418

duration: 0:00:13.952251

exit_message:

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

id: 6667418

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_newbooktax_rates_restrictions/2024-11-04/1730783705",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783705/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8904211475143387102,
        "service_name": "drive-thru",
        "span_id": 7120130254559472293,
        "trace_id": 12545538840298018288
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 02:03:47
success: True
trace_id: 12545538840298018288

Scan 6666145

duration: 0:00:11.487149

exit_message:

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

id: 6666145

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_newbooktax_rates_restrictions/2024-11-04/1730783578",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783578/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 603126758078729015,
        "service_name": "drive-thru",
        "span_id": 7759797310154374529,
        "trace_id": 16662964919919890481
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 01:30:12
success: True
trace_id: 16662964919919890481

Scan 6665923

duration: 0:00:13.863151

exit_message:

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

id: 6665923

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_newbooktax_rates_restrictions/2024-11-04/1730783359",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730783359/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15691822886201542927,
        "service_name": "drive-thru",
        "span_id": 6670753117030009833,
        "trace_id": 14069537338187338967
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 01:24:24
success: True
trace_id: 14069537338187338967

Scan 6665218

duration: 0:00:11.373092

exit_message:

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

id: 6665218

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_newbooktax_rates_restrictions/2024-11-04/1730782957",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730782957/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10534059813284538508,
        "service_name": "drive-thru",
        "span_id": 15121309449706503317,
        "trace_id": 7147067802314542870
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 01:05:42
success: True
trace_id: 7147067802314542870

Scan 6664581

duration: 0:00:11.392845

exit_message:

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

id: 6664581

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_newbooktax_rates_restrictions/2024-11-04/1730782845",
        "key": "raw/newbookdev_newbooktax_rates_restrictions/2024-11-04/1730782845/tax_rates_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7199150130356564687,
        "service_name": "drive-thru",
        "span_id": 571640317241360046,
        "trace_id": 8538759137489652031
    }
}

running: False
schema_name_id: 3082
start_time: 2024-11-05 00:48:47
success: True
trace_id: 8538759137489652031

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tax_rate_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:45:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-05/1730866575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 18:38:15",
        "disabled": false,
        "format": "raw",
        "id": 3082,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktax_rates_restrictions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "for": "string",
            "for_id": "string",
            "id": "string",
            "newbook_region": "string",
            "tax_rate_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:45:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `tax_rate_id`  string , `for`  string , `for_id`  string , `active`  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_newbooktax_rates_restrictions/2024-11-05/1730866575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktax_rates_restrictions"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}