Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link

created: 2024-10-08 18:10:29
disabled: False
format: raw
id: 2825
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749056

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866529
id: 4749056
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6675088
updated: 2024-11-05 23:17:17

Version 4748561

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866463'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866463
id: 4748561
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6674593
updated: 2024-11-05 22:51:26

Version 4747934

created: 2024-11-05 22:29:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866333'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866333
id: 4747934
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6673966
updated: 2024-11-05 22:30:03

Version 4746817

created: 2024-11-05 04:25:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730785738'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730785738
id: 4746817
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6672047
updated: 2024-11-05 04:25:33

Version 4746272

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730785134'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730785134
id: 4746272
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6671493
updated: 2024-11-05 03:56:08

Version 4744801

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784829'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784829
id: 4744801
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6670018
updated: 2024-11-05 03:12:55

Version 4744643

created: 2024-11-05 03:08:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784225'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784225
id: 4744643
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6669862
updated: 2024-11-05 03:08:48

Version 4744056

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784063'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784063
id: 4744056
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6669273
updated: 2024-11-05 02:53:00

Version 4742724

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783906'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783906
id: 4742724
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6667941
updated: 2024-11-05 02:17:58

Version 4742095

created: 2024-11-05 02:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783777'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783777
id: 4742095
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6667312
updated: 2024-11-05 02:01:09

Version 4742059

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783672'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783672
id: 4742059
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6667276
updated: 2024-11-05 02:00:10

Version 4741191

created: 2024-11-05 01:37:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783533'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783533
id: 4741191
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6666408
updated: 2024-11-05 01:37:20

Version 4740047

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783315'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783315
id: 4740047
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6665265
updated: 2024-11-05 01:07:11

Version 4739644

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730782915'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730782915
id: 4739644
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6664861
updated: 2024-11-05 00:56:18

Version 4738389

created: 2024-11-05 00:23:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730782753'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730782753
id: 4738389
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_group_id": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2825
schema_scan_id: 6663600
updated: 2024-11-05 00:23:26

Schema Scans: 15

Last at 2024-11-05 23:17:06

Scan 6675088

duration: 0:00:11.475159

exit_message:

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

id: 6675088

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_newbookknowledge_base_groups_link/2024-11-05/1730866529",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866529/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16307393372537195983,
        "service_name": "drive-thru",
        "span_id": 10346485103526367568,
        "trace_id": 6378069825028146578
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 23:17:06
success: True
trace_id: 6378069825028146578

Scan 6674593

duration: 0:00:11.652762

exit_message:

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

id: 6674593

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_newbookknowledge_base_groups_link/2024-11-05/1730866463",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866463/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8033177752786364807,
        "service_name": "drive-thru",
        "span_id": 17710326478827799609,
        "trace_id": 1499283569004472982
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 22:51:15
success: True
trace_id: 1499283569004472982

Scan 6673966

duration: 0:00:13.903317

exit_message:

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

id: 6673966

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_newbookknowledge_base_groups_link/2024-11-05/1730866333",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866333/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1261340157281909141,
        "service_name": "drive-thru",
        "span_id": 13653014785545941682,
        "trace_id": 16043416696222216773
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 22:29:49
success: True
trace_id: 16043416696222216773

Scan 6672047

duration: 0:00:14.144801

exit_message:

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

id: 6672047

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_newbookknowledge_base_groups_link/2024-11-04/1730785738",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730785738/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6889715671563054140,
        "service_name": "drive-thru",
        "span_id": 6237667414962894040,
        "trace_id": 6509044934557460138
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 04:25:19
success: True
trace_id: 6509044934557460138

Scan 6671493

duration: 0:00:14.101855

exit_message:

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

id: 6671493

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_newbookknowledge_base_groups_link/2024-11-04/1730785134",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730785134/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13665284265360086546,
        "service_name": "drive-thru",
        "span_id": 13390530179172774654,
        "trace_id": 14736704454616797959
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 03:55:54
success: True
trace_id: 14736704454616797959

Scan 6670018

duration: 0:00:11.373957

exit_message:

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

id: 6670018

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_newbookknowledge_base_groups_link/2024-11-04/1730784829",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784829/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10103455192785104711,
        "service_name": "drive-thru",
        "span_id": 7953387538727997165,
        "trace_id": 11350876120054780719
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 03:12:44
success: True
trace_id: 11350876120054780719

Scan 6669862

duration: 0:00:11.403905

exit_message:

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

id: 6669862

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_newbookknowledge_base_groups_link/2024-11-04/1730784225",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784225/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 370695458781310267,
        "service_name": "drive-thru",
        "span_id": 15383458252928683370,
        "trace_id": 2971387956585220301
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 03:08:37
success: True
trace_id: 2971387956585220301

Scan 6669273

duration: 0:00:11.333407

exit_message:

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

id: 6669273

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_newbookknowledge_base_groups_link/2024-11-04/1730784063",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730784063/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8163472804156459455,
        "service_name": "drive-thru",
        "span_id": 11401071169887784088,
        "trace_id": 14393837045240318110
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 02:52:49
success: True
trace_id: 14393837045240318110

Scan 6667941

duration: 0:00:11.380884

exit_message:

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

id: 6667941

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_newbookknowledge_base_groups_link/2024-11-04/1730783906",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783906/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8805291878769327886,
        "service_name": "drive-thru",
        "span_id": 11406280956385073515,
        "trace_id": 486456001918092787
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 02:17:46
success: True
trace_id: 486456001918092787

Scan 6667312

duration: 0:00:13.998284

exit_message:

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

id: 6667312

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_newbookknowledge_base_groups_link/2024-11-04/1730783777",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783777/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1390489743316897488,
        "service_name": "drive-thru",
        "span_id": 443738826960044351,
        "trace_id": 5659450006752503218
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 02:00:55
success: True
trace_id: 5659450006752503218

Scan 6667276

duration: 0:00:13.821365

exit_message:

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

id: 6667276

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_newbookknowledge_base_groups_link/2024-11-04/1730783672",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783672/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3627709341577225203,
        "service_name": "drive-thru",
        "span_id": 17330831008748999162,
        "trace_id": 18417583671167004410
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 01:59:57
success: True
trace_id: 18417583671167004410

Scan 6666408

duration: 0:00:11.464788

exit_message:

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

id: 6666408

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_newbookknowledge_base_groups_link/2024-11-04/1730783533",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783533/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5936690648415569395,
        "service_name": "drive-thru",
        "span_id": 14889252450605046879,
        "trace_id": 5982304606629540496
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 01:37:08
success: True
trace_id: 5982304606629540496

Scan 6665265

duration: 0:00:13.801848

exit_message:

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

id: 6665265

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_newbookknowledge_base_groups_link/2024-11-04/1730783315",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730783315/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14586948004920884850,
        "service_name": "drive-thru",
        "span_id": 8736710601248961558,
        "trace_id": 7683268457814046309
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 01:06:57
success: True
trace_id: 7683268457814046309

Scan 6664861

duration: 0:00:13.987373

exit_message:

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

id: 6664861

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_newbookknowledge_base_groups_link/2024-11-04/1730782915",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730782915/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10478135125425246726,
        "service_name": "drive-thru",
        "span_id": 2410300320369581572,
        "trace_id": 16507073339273793430
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 00:56:04
success: True
trace_id: 16507073339273793430

Scan 6663600

duration: 0:00:11.493233

exit_message:

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

id: 6663600

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_newbookknowledge_base_groups_link/2024-11-04/1730782753",
        "key": "raw/newbookdev_newbookknowledge_base_groups_link/2024-11-04/1730782753/knowledge_base_groups_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3651488300890300716,
        "service_name": "drive-thru",
        "span_id": 16773476983570182692,
        "trace_id": 15864764961231474860
    }
}

running: False
schema_name_id: 2825
start_time: 2024-11-05 00:23:14
success: True
trace_id: 15864764961231474860

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "knowledge_base_group_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
}

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:10:29",
        "disabled": false,
        "format": "raw",
        "id": 2825,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookknowledge_base_groups_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "knowledge_base_group_id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2024-11-05 23:17:06",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `knowledge_base_group_id`  string , `type`  string , `type_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_groups_link/2024-11-05/1730866529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_groups_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}