Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookdocumentation

created: 2024-10-08 17:57:12
disabled: False
format: raw
id: 2689
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748795

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

ddl:

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

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

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6674827
updated: 2024-11-05 23:02:08

Version 4748369

created: 2024-11-05 22:43:48

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-05/1730866389
id: 4748369
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6674401
updated: 2024-11-05 22:44:02

Version 4747612

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

ddl:

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

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

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6673644
updated: 2024-11-05 22:21:37

Version 4746361

created: 2024-11-05 03:59:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730785114
id: 4746361
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6671582
updated: 2024-11-05 03:59:58

Version 4746089

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730785701
id: 4746089
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6671310
updated: 2024-11-05 03:49:07

Version 4744670

created: 2024-11-05 03:09:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730784808
id: 4744670
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6669887
updated: 2024-11-05 03:09:29

Version 4744546

created: 2024-11-05 03:05:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730784205
id: 4744546
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6669763
updated: 2024-11-05 03:06:13

Version 4743940

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730784042
id: 4743940
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6669157
updated: 2024-11-05 02:50:06

Version 4743581

created: 2024-11-05 02:40:23

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730783890
id: 4743581
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6668798
updated: 2024-11-05 02:40:34

Version 4741963

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730783756
id: 4741963
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6667180
updated: 2024-11-05 01:57:40

Version 4741029

created: 2024-11-05 01:32:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730783607
id: 4741029
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6666246
updated: 2024-11-05 01:33:07

Version 4740939

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730783511
id: 4740939
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6666156
updated: 2024-11-05 01:30:41

Version 4740376

created: 2024-11-05 01:15:40

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730783294
id: 4740376
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6665593
updated: 2024-11-05 01:15:51

Version 4739570

created: 2024-11-05 00:54:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730782895
id: 4739570
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6664786
updated: 2024-11-05 00:54:18

Version 4738973

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdocumentation/2024-11-04/1730782796
id: 4738973
processed: 1

raw_data:

{
    "active": 9,
    "content": 6,
    "description": 4,
    "group": 5,
    "id": 2,
    "last_updated": 8,
    "name": 3,
    "newbook_region": 0,
    "software_type": 7,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 2689
schema_scan_id: 6664187
updated: 2024-11-05 00:38:46

Schema Scans: 15

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

Scan 6674827

duration: 0:00:11.807817

exit_message:

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

id: 6674827

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_newbookdocumentation/2024-11-05/1730866475",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-05/1730866475/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16678710088587611453,
        "service_name": "drive-thru",
        "span_id": 4035727474075630405,
        "trace_id": 5817358079219453366
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 23:01:56
success: True
trace_id: 5817358079219453366

Scan 6674401

duration: 0:00:14.340658

exit_message:

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

id: 6674401

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_newbookdocumentation/2024-11-05/1730866389",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-05/1730866389/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1888349388510279090,
        "service_name": "drive-thru",
        "span_id": 2571755057888846241,
        "trace_id": 1702293249662402913
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 22:43:48
success: True
trace_id: 1702293249662402913

Scan 6673644

duration: 0:00:14.155450

exit_message:

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

id: 6673644

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_newbookdocumentation/2024-11-05/1730866280",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-05/1730866280/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13138349888823938427,
        "service_name": "drive-thru",
        "span_id": 263941248813938941,
        "trace_id": 15741348039970151885
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 22:21:23
success: True
trace_id: 15741348039970151885

Scan 6671582

duration: 0:00:14.328644

exit_message:

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

id: 6671582

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_newbookdocumentation/2024-11-04/1730785114",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730785114/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7221306841501901818,
        "service_name": "drive-thru",
        "span_id": 890581712042457076,
        "trace_id": 12073459838041516416
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 03:59:43
success: True
trace_id: 12073459838041516416

Scan 6671310

duration: 0:00:14.299313

exit_message:

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

id: 6671310

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_newbookdocumentation/2024-11-04/1730785701",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730785701/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16372510169229473567,
        "service_name": "drive-thru",
        "span_id": 14563931300322715245,
        "trace_id": 3218067344088369666
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 03:48:53
success: True
trace_id: 3218067344088369666

Scan 6669887

duration: 0:00:11.523154

exit_message:

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

id: 6669887

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_newbookdocumentation/2024-11-04/1730784808",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730784808/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 668936431716935699,
        "service_name": "drive-thru",
        "span_id": 7573572988120660760,
        "trace_id": 9144676926803040261
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 03:09:17
success: True
trace_id: 9144676926803040261

Scan 6669763

duration: 0:00:14.126711

exit_message:

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

id: 6669763

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_newbookdocumentation/2024-11-04/1730784205",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730784205/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4258465561644700527,
        "service_name": "drive-thru",
        "span_id": 5960260231255865114,
        "trace_id": 13798216207895026032
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 03:05:59
success: True
trace_id: 13798216207895026032

Scan 6669157

duration: 0:00:14.116097

exit_message:

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

id: 6669157

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_newbookdocumentation/2024-11-04/1730784042",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730784042/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10360671800438477015,
        "service_name": "drive-thru",
        "span_id": 16756320232184395352,
        "trace_id": 9665769272432501723
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 02:49:52
success: True
trace_id: 9665769272432501723

Scan 6668798

duration: 0:00:11.536089

exit_message:

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

id: 6668798

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_newbookdocumentation/2024-11-04/1730783890",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730783890/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9734249377908783719,
        "service_name": "drive-thru",
        "span_id": 11494018178519232364,
        "trace_id": 12251724364541096171
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 02:40:23
success: True
trace_id: 12251724364541096171

Scan 6667180

duration: 0:00:14.127440

exit_message:

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

id: 6667180

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_newbookdocumentation/2024-11-04/1730783756",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730783756/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5002597353575319184,
        "service_name": "drive-thru",
        "span_id": 253460510889653103,
        "trace_id": 12648634932269514134
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 01:57:26
success: True
trace_id: 12648634932269514134

Scan 6666246

duration: 0:00:11.533542

exit_message:

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

id: 6666246

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_newbookdocumentation/2024-11-04/1730783607",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730783607/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14206730484707672018,
        "service_name": "drive-thru",
        "span_id": 15305882691395716939,
        "trace_id": 16043962991452656481
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 01:32:55
success: True
trace_id: 16043962991452656481

Scan 6666156

duration: 0:00:11.582211

exit_message:

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

id: 6666156

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_newbookdocumentation/2024-11-04/1730783511",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730783511/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 313276430849144942,
        "service_name": "drive-thru",
        "span_id": 17612057097771716018,
        "trace_id": 1343333763562784647
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 01:30:30
success: True
trace_id: 1343333763562784647

Scan 6665593

duration: 0:00:11.570357

exit_message:

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

id: 6665593

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_newbookdocumentation/2024-11-04/1730783294",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730783294/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1670876346262041087,
        "service_name": "drive-thru",
        "span_id": 14928910331184557140,
        "trace_id": 15944711452091790977
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 01:15:40
success: True
trace_id: 15944711452091790977

Scan 6664786

duration: 0:00:14.035585

exit_message:

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

id: 6664786

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_newbookdocumentation/2024-11-04/1730782895",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730782895/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17096758361137274653,
        "service_name": "drive-thru",
        "span_id": 14443400382832641497,
        "trace_id": 9721681127100374704
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 00:54:04
success: True
trace_id: 9721681127100374704

Scan 6664187

duration: 0:00:14.078852

exit_message:

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

id: 6664187

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_newbookdocumentation/2024-11-04/1730782796",
        "key": "raw/newbookdev_newbookdocumentation/2024-11-04/1730782796/documentation.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdocumentation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1145173551076621615,
        "service_name": "drive-thru",
        "span_id": 460090079566107174,
        "trace_id": 16187606731318681959
    }
}

running: False
schema_name_id: 2689
start_time: 2024-11-05 00:38:32
success: True
trace_id: 16187606731318681959

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "content": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "last_updated": "string",
    "name": "string",
    "newbook_region": "string",
    "software_type": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdocumentation`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `group`  string , `content`  string , `software_type`  string , `last_updated`  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_newbookdocumentation/2024-11-05/1730866475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdocumentation`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdocumentation"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 17:57:12",
        "disabled": false,
        "format": "raw",
        "id": 2689,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookdocumentation"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "content": "string",
            "description": "string",
            "group": "string",
            "id": "string",
            "last_updated": "string",
            "name": "string",
            "newbook_region": "string",
            "software_type": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:01:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookdocumentation`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `group`  string , `content`  string , `software_type`  string , `last_updated`  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_newbookdocumentation/2024-11-05/1730866475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookdocumentation`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookdocumentation"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}