Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749417

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-05/1730866585
id: 4749417
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6675461
updated: 2024-11-05 23:48:50

Version 4748873

created: 2024-11-05 23:06:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-05/1730866526
id: 4748873
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6674906
updated: 2024-11-05 23:06:32

Version 4748240

created: 2024-11-05 22:39:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-05/1730866403
id: 4748240
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6674272
updated: 2024-11-05 22:39:29

Version 4747057

created: 2024-11-05 04:45:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730785780
id: 4747057
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6672289
updated: 2024-11-05 04:45:55

Version 4746430

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730785158
id: 4746430
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6671651
updated: 2024-11-05 04:02:57

Version 4745595

created: 2024-11-05 03:33:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730784852
id: 4745595
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6670812
updated: 2024-11-05 03:33:46

Version 4744270

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730784249
id: 4744270
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6669487
updated: 2024-11-05 02:58:37

Version 4744099

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730784087
id: 4744099
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6669316
updated: 2024-11-05 02:54:12

Version 4743703

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783924
id: 4743703
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6668920
updated: 2024-11-05 02:43:51

Version 4742708

created: 2024-11-05 02:17:22

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783800
id: 4742708
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6667925
updated: 2024-11-05 02:17:32

Version 4742123

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783690
id: 4742123
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6667340
updated: 2024-11-05 02:01:57

Version 4741416

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783557
id: 4741416
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6666633
updated: 2024-11-05 01:43:16

Version 4740610

created: 2024-11-05 01:21:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783338
id: 4740610
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6665827
updated: 2024-11-05 01:22:03

Version 4739917

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730782967
id: 4739917
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6665134
updated: 2024-11-05 01:03:39

Version 4738985

created: 2024-11-05 00:38:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730782829
id: 4738985
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2957
schema_scan_id: 6664199
updated: 2024-11-05 00:39:02

Schema Scans: 15

Last at 2024-11-05 23:48:36

Scan 6675461

duration: 0:00:13.985212

exit_message:

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

id: 6675461

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_newbookprevious_suppliers/2024-11-05/1730866585",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-05/1730866585/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5072917204092458189,
        "service_name": "drive-thru",
        "span_id": 17764158717274865786,
        "trace_id": 11795562669955639473
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 23:48:36
success: True
trace_id: 11795562669955639473

Scan 6674906

duration: 0:00:14.060489

exit_message:

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

id: 6674906

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_newbookprevious_suppliers/2024-11-05/1730866526",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-05/1730866526/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8354691189090966994,
        "service_name": "drive-thru",
        "span_id": 11320830071694652451,
        "trace_id": 7281981654234504687
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 23:06:18
success: True
trace_id: 7281981654234504687

Scan 6674272

duration: 0:00:11.440786

exit_message:

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

id: 6674272

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_newbookprevious_suppliers/2024-11-05/1730866403",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-05/1730866403/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10376904401843892000,
        "service_name": "drive-thru",
        "span_id": 18042715929517521991,
        "trace_id": 12660575467236375732
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 22:39:18
success: True
trace_id: 12660575467236375732

Scan 6672289

duration: 0:00:11.528569

exit_message:

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

id: 6672289

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_newbookprevious_suppliers/2024-11-04/1730785780",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730785780/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12227872148051869930,
        "service_name": "drive-thru",
        "span_id": 2664083884350027092,
        "trace_id": 965468708941742476
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 04:45:44
success: True
trace_id: 965468708941742476

Scan 6671651

duration: 0:00:13.988747

exit_message:

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

id: 6671651

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_newbookprevious_suppliers/2024-11-04/1730785158",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730785158/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7427388127159043884,
        "service_name": "drive-thru",
        "span_id": 13605665911243858115,
        "trace_id": 3820168731774550972
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 04:02:43
success: True
trace_id: 3820168731774550972

Scan 6670812

duration: 0:00:11.364626

exit_message:

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

id: 6670812

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_newbookprevious_suppliers/2024-11-04/1730784852",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730784852/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13932570840020116237,
        "service_name": "drive-thru",
        "span_id": 9507956006105900539,
        "trace_id": 10312151620942533532
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 03:33:34
success: True
trace_id: 10312151620942533532

Scan 6669487

duration: 0:00:11.536604

exit_message:

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

id: 6669487

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_newbookprevious_suppliers/2024-11-04/1730784249",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730784249/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6842904693918124020,
        "service_name": "drive-thru",
        "span_id": 2312088545642745209,
        "trace_id": 16935298816330317297
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 02:58:26
success: True
trace_id: 16935298816330317297

Scan 6669316

duration: 0:00:11.359123

exit_message:

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

id: 6669316

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_newbookprevious_suppliers/2024-11-04/1730784087",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730784087/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8247701858066518744,
        "service_name": "drive-thru",
        "span_id": 13948699254458872947,
        "trace_id": 7096753746325889575
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 02:54:01
success: True
trace_id: 7096753746325889575

Scan 6668920

duration: 0:00:13.885687

exit_message:

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

id: 6668920

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_newbookprevious_suppliers/2024-11-04/1730783924",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783924/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9752147603813106754,
        "service_name": "drive-thru",
        "span_id": 1997830859584957075,
        "trace_id": 1567551604623455894
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 02:43:37
success: True
trace_id: 1567551604623455894

Scan 6667925

duration: 0:00:11.305285

exit_message:

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

id: 6667925

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_newbookprevious_suppliers/2024-11-04/1730783800",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783800/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17499340057349865252,
        "service_name": "drive-thru",
        "span_id": 1545455381690743035,
        "trace_id": 15899703982519821293
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 02:17:21
success: True
trace_id: 15899703982519821293

Scan 6667340

duration: 0:00:13.892330

exit_message:

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

id: 6667340

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_newbookprevious_suppliers/2024-11-04/1730783690",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783690/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11042038006296996830,
        "service_name": "drive-thru",
        "span_id": 11338270950510986896,
        "trace_id": 2998682181940160872
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 02:01:43
success: True
trace_id: 2998682181940160872

Scan 6666633

duration: 0:00:13.920212

exit_message:

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

id: 6666633

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_newbookprevious_suppliers/2024-11-04/1730783557",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783557/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 965417745799722737,
        "service_name": "drive-thru",
        "span_id": 8994387151038874006,
        "trace_id": 5952947956343117792
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 01:43:02
success: True
trace_id: 5952947956343117792

Scan 6665827

duration: 0:00:11.352010

exit_message:

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

id: 6665827

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_newbookprevious_suppliers/2024-11-04/1730783338",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730783338/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8753945787644647288,
        "service_name": "drive-thru",
        "span_id": 15182024767734557550,
        "trace_id": 10145335234062653160
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 01:21:51
success: True
trace_id: 10145335234062653160

Scan 6665134

duration: 0:00:13.870401

exit_message:

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

id: 6665134

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_newbookprevious_suppliers/2024-11-04/1730782967",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730782967/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17395483157782348333,
        "service_name": "drive-thru",
        "span_id": 11710710597696520908,
        "trace_id": 3022407955524306877
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 01:03:25
success: True
trace_id: 3022407955524306877

Scan 6664199

duration: 0:00:13.957243

exit_message:

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

id: 6664199

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_newbookprevious_suppliers/2024-11-04/1730782829",
        "key": "raw/newbookdev_newbookprevious_suppliers/2024-11-04/1730782829/previous_suppliers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9265978639424869835,
        "service_name": "drive-thru",
        "span_id": 6344121960777887110,
        "trace_id": 3666858198856415537
    }
}

running: False
schema_name_id: 2957
start_time: 2024-11-05 00:38:49
success: True
trace_id: 3666858198856415537

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

created: 2024-11-05 23:48: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_newbookprevious_suppliers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  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_newbookprevious_suppliers/2024-11-05/1730866585'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers"
}

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:24:38",
        "disabled": false,
        "format": "raw",
        "id": 2957,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookprevious_suppliers"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:48: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_newbookprevious_suppliers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  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_newbookprevious_suppliers/2024-11-05/1730866585'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprevious_suppliers"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}