Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link

created: 2024-10-08 18:11:01
disabled: False
format: raw
id: 2830
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748908

created: 2024-11-05 23:08:08

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-05/1730866530
id: 4748908
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6674940
updated: 2024-11-05 23:08:21

Version 4748568

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-05/1730866464
id: 4748568
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6674600
updated: 2024-11-05 22:51:46

Version 4747946

created: 2024-11-05 22:30:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-05/1730866334
id: 4747946
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6673978
updated: 2024-11-05 22:30:20

Version 4747098

created: 2024-11-05 04:50:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730785739
id: 4747098
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6672330
updated: 2024-11-05 04:50:20

Version 4746212

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730785135
id: 4746212
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6671433
updated: 2024-11-05 03:53:31

Version 4744783

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730784830
id: 4744783
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6670000
updated: 2024-11-05 03:12:26

Version 4744654

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730784226
id: 4744654
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6669871
updated: 2024-11-05 03:09:03

Version 4744419

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730784064
id: 4744419
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6669636
updated: 2024-11-05 03:02:45

Version 4743299

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

ddl:

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

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

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6668516
updated: 2024-11-05 02:33:09

Version 4742610

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

ddl:

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

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

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6667828
updated: 2024-11-05 02:14:58

Version 4741686

created: 2024-11-05 01:50:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783612
id: 4741686
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6666903
updated: 2024-11-05 01:50:19

Version 4741194

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

ddl:

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

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

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6666411
updated: 2024-11-05 01:37:25

Version 4740493

created: 2024-11-05 01:18:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783316
id: 4740493
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6665710
updated: 2024-11-05 01:18:59

Version 4739682

created: 2024-11-05 00:57:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730782916
id: 4739682
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6664899
updated: 2024-11-05 00:57:18

Version 4739133

created: 2024-11-05 00:42:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730782812
id: 4739133
processed: 1

raw_data:

{
    "id": 2,
    "knowledge_base_id": 3,
    "newbook_region": 0,
    "software_type_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

schema_name_id: 2830
schema_scan_id: 6664349
updated: 2024-11-05 00:42:55

Schema Scans: 15

Last at 2024-11-05 23:08:07

Scan 6674940

duration: 0:00:13.997993

exit_message:

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

id: 6674940

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_software_type_link/2024-11-05/1730866530",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-05/1730866530/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13377204927200403207,
        "service_name": "drive-thru",
        "span_id": 9288685748240398262,
        "trace_id": 11516635418761213271
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 23:08:07
success: True
trace_id: 11516635418761213271

Scan 6674600

duration: 0:00:13.969878

exit_message:

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

id: 6674600

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_software_type_link/2024-11-05/1730866464",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-05/1730866464/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8092553262325359903,
        "service_name": "drive-thru",
        "span_id": 15879878321337629458,
        "trace_id": 715000703904402858
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 22:51:33
success: True
trace_id: 715000703904402858

Scan 6673978

duration: 0:00:14.183151

exit_message:

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

id: 6673978

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_software_type_link/2024-11-05/1730866334",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-05/1730866334/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5466327346002246304,
        "service_name": "drive-thru",
        "span_id": 17626766125177256641,
        "trace_id": 8010556422088580603
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 22:30:06
success: True
trace_id: 8010556422088580603

Scan 6672330

duration: 0:00:13.969311

exit_message:

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

id: 6672330

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_software_type_link/2024-11-04/1730785739",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730785739/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10387689053554134815,
        "service_name": "drive-thru",
        "span_id": 11665669002873876895,
        "trace_id": 7402314953609699557
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 04:50:06
success: True
trace_id: 7402314953609699557

Scan 6671433

duration: 0:00:13.981623

exit_message:

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

id: 6671433

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_software_type_link/2024-11-04/1730785135",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730785135/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11660071982715750468,
        "service_name": "drive-thru",
        "span_id": 17217816394948335580,
        "trace_id": 17593061666305008192
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 03:53:17
success: True
trace_id: 17593061666305008192

Scan 6670000

duration: 0:00:13.851382

exit_message:

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

id: 6670000

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_software_type_link/2024-11-04/1730784830",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730784830/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 166254748490601549,
        "service_name": "drive-thru",
        "span_id": 14080911027710008247,
        "trace_id": 17561379926519219050
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 03:12:13
success: True
trace_id: 17561379926519219050

Scan 6669871

duration: 0:00:11.370116

exit_message:

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

id: 6669871

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_software_type_link/2024-11-04/1730784226",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730784226/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10409056240436541642,
        "service_name": "drive-thru",
        "span_id": 12351277589954689887,
        "trace_id": 5025249283407521489
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 03:08:52
success: True
trace_id: 5025249283407521489

Scan 6669636

duration: 0:00:13.739777

exit_message:

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

id: 6669636

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_software_type_link/2024-11-04/1730784064",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730784064/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13531244772175756778,
        "service_name": "drive-thru",
        "span_id": 10641379169914033608,
        "trace_id": 4763961478274669097
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 03:02:31
success: True
trace_id: 4763961478274669097

Scan 6668516

duration: 0:00:13.926353

exit_message:

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

id: 6668516

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_software_type_link/2024-11-04/1730783906",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783906/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7542822592261070366,
        "service_name": "drive-thru",
        "span_id": 811466699866643845,
        "trace_id": 16264384022000368797
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 02:32:55
success: True
trace_id: 16264384022000368797

Scan 6667828

duration: 0:00:11.356236

exit_message:

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

id: 6667828

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_software_type_link/2024-11-04/1730783777",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783777/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14290820150277020465,
        "service_name": "drive-thru",
        "span_id": 9953817595631360392,
        "trace_id": 6553227519822565378
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 02:14:47
success: True
trace_id: 6553227519822565378

Scan 6666903

duration: 0:00:13.854817

exit_message:

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

id: 6666903

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_software_type_link/2024-11-04/1730783612",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783612/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14686655847673143133,
        "service_name": "drive-thru",
        "span_id": 16989774576511913284,
        "trace_id": 4762831307850117278
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 01:50:05
success: True
trace_id: 4762831307850117278

Scan 6666411

duration: 0:00:11.426684

exit_message:

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

id: 6666411

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_software_type_link/2024-11-04/1730783533",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783533/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15426221045290543637,
        "service_name": "drive-thru",
        "span_id": 10463377620261063269,
        "trace_id": 1186164105597328083
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 01:37:14
success: True
trace_id: 1186164105597328083

Scan 6665710

duration: 0:00:13.762391

exit_message:

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

id: 6665710

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_software_type_link/2024-11-04/1730783316",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730783316/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10187665860481688530,
        "service_name": "drive-thru",
        "span_id": 5151557279839987461,
        "trace_id": 16946715589226450334
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 01:18:46
success: True
trace_id: 16946715589226450334

Scan 6664899

duration: 0:00:11.421540

exit_message:

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

id: 6664899

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_software_type_link/2024-11-04/1730782916",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730782916/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9519751669962899236,
        "service_name": "drive-thru",
        "span_id": 17073167489448916902,
        "trace_id": 7283668926133509879
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 00:57:06
success: True
trace_id: 7283668926133509879

Scan 6664349

duration: 0:00:13.912914

exit_message:

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

id: 6664349

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_software_type_link/2024-11-04/1730782812",
        "key": "raw/newbookdev_newbookknowledge_base_software_type_link/2024-11-04/1730782812/knowledge_base_software_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_software_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5332386352806356791,
        "service_name": "drive-thru",
        "span_id": 3071361734452793619,
        "trace_id": 9876626936595722080
    }
}

running: False
schema_name_id: 2830
start_time: 2024-11-05 00:42:41
success: True
trace_id: 9876626936595722080

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "knowledge_base_id": "string",
    "newbook_region": "string",
    "software_type_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:08:08

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