Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites

created: 2024-10-08 18:06:26
disabled: False
format: raw
id: 2789
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748902

created: 2024-11-05 23:07:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_favourites/2024-11-05/1730866528
id: 4748902
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6674934
updated: 2024-11-05 23:08:04

Version 4748673

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_favourites/2024-11-05/1730866462
id: 4748673
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6674706
updated: 2024-11-05 22:56:11

Version 4747923

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_favourites/2024-11-05/1730866332
id: 4747923
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6673955
updated: 2024-11-05 22:29:43

Version 4747075

created: 2024-11-05 04:47:38

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6672307
updated: 2024-11-05 04:47:49

Version 4746514

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6671735
updated: 2024-11-05 04:07:13

Version 4745479

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6670697
updated: 2024-11-05 03:30:45

Version 4744621

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6669839
updated: 2024-11-05 03:08:13

Version 4744313

created: 2024-11-05 02:59:34

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6669530
updated: 2024-11-05 02:59:45

Version 4742723

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6667940
updated: 2024-11-05 02:17:57

Version 4742657

created: 2024-11-05 02:15:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783776
id: 4742657
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6667874
updated: 2024-11-05 02:16:13

Version 4741812

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783671
id: 4741812
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6667029
updated: 2024-11-05 01:53:37

Version 4740687

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6665904
updated: 2024-11-05 01:24:03

Version 4740419

created: 2024-11-05 01:16:48

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6665636
updated: 2024-11-05 01:17:02

Version 4739543

created: 2024-11-05 00:53:24

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6664758
updated: 2024-11-05 00:53:35

Version 4738744

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2789
schema_scan_id: 6663958
updated: 2024-11-05 00:32:39

Schema Scans: 15

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

Scan 6674934

duration: 0:00:13.923889

exit_message:

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

id: 6674934

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_favourites/2024-11-05/1730866528",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-05/1730866528/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11388985637128715178,
        "service_name": "drive-thru",
        "span_id": 10490711223260079838,
        "trace_id": 4465070334536236025
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 23:07:50
success: True
trace_id: 4465070334536236025

Scan 6674706

duration: 0:00:11.545496

exit_message:

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

id: 6674706

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_favourites/2024-11-05/1730866462",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-05/1730866462/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6300868307621428070,
        "service_name": "drive-thru",
        "span_id": 17475149131675130383,
        "trace_id": 8092326611332475320
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 22:56:00
success: True
trace_id: 8092326611332475320

Scan 6673955

duration: 0:00:13.777984

exit_message:

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

id: 6673955

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_favourites/2024-11-05/1730866332",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-05/1730866332/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17657420456243684067,
        "service_name": "drive-thru",
        "span_id": 10518048269730822473,
        "trace_id": 10104156221886337836
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 22:29:30
success: True
trace_id: 10104156221886337836

Scan 6672307

duration: 0:00:11.459545

exit_message:

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

id: 6672307

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_favourites/2024-11-04/1730785738",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730785738/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10097216617378149654,
        "service_name": "drive-thru",
        "span_id": 7368441926983954507,
        "trace_id": 2469177664851578759
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 04:47:37
success: True
trace_id: 2469177664851578759

Scan 6671735

duration: 0:00:14.068261

exit_message:

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

id: 6671735

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_favourites/2024-11-04/1730785134",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730785134/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6737897286559167445,
        "service_name": "drive-thru",
        "span_id": 8775688250607530056,
        "trace_id": 9762381809294667901
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 04:06:59
success: True
trace_id: 9762381809294667901

Scan 6670697

duration: 0:00:13.809755

exit_message:

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

id: 6670697

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_favourites/2024-11-04/1730784829",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730784829/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10798036386981060713,
        "service_name": "drive-thru",
        "span_id": 15818200829566361378,
        "trace_id": 18308812048099113635
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 03:30:32
success: True
trace_id: 18308812048099113635

Scan 6669839

duration: 0:00:13.908827

exit_message:

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

id: 6669839

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_favourites/2024-11-04/1730784225",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730784225/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8743013460221347068,
        "service_name": "drive-thru",
        "span_id": 3165917610951902415,
        "trace_id": 499539998502050778
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 03:08:00
success: True
trace_id: 499539998502050778

Scan 6669530

duration: 0:00:11.323893

exit_message:

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

id: 6669530

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_favourites/2024-11-04/1730784063",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730784063/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7443712037877726189,
        "service_name": "drive-thru",
        "span_id": 5344803477489059276,
        "trace_id": 7683971556508307248
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 02:59:34
success: True
trace_id: 7683971556508307248

Scan 6667940

duration: 0:00:11.318300

exit_message:

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

id: 6667940

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_favourites/2024-11-04/1730783906",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783906/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5033398988422305147,
        "service_name": "drive-thru",
        "span_id": 16040053443139801607,
        "trace_id": 12457849265439717143
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 02:17:46
success: True
trace_id: 12457849265439717143

Scan 6667874

duration: 0:00:13.691821

exit_message:

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

id: 6667874

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_favourites/2024-11-04/1730783776",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783776/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15295123431999491500,
        "service_name": "drive-thru",
        "span_id": 8805653789788822194,
        "trace_id": 10937902206663557588
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 02:15:59
success: True
trace_id: 10937902206663557588

Scan 6667029

duration: 0:00:13.891325

exit_message:

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

id: 6667029

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_favourites/2024-11-04/1730783671",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783671/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15993588384939563059,
        "service_name": "drive-thru",
        "span_id": 12736094696245239301,
        "trace_id": 16270999089914929291
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 01:53:23
success: True
trace_id: 16270999089914929291

Scan 6665904

duration: 0:00:11.284250

exit_message:

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

id: 6665904

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_favourites/2024-11-04/1730783533",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783533/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15587022430794687947,
        "service_name": "drive-thru",
        "span_id": 16048798935808546588,
        "trace_id": 2211446866412658154
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 01:23:52
success: True
trace_id: 2211446866412658154

Scan 6665636

duration: 0:00:13.922924

exit_message:

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

id: 6665636

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_favourites/2024-11-04/1730783315",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730783315/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 347603458537478355,
        "service_name": "drive-thru",
        "span_id": 5712436629104462116,
        "trace_id": 10091614306502108404
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 01:16:48
success: True
trace_id: 10091614306502108404

Scan 6664758

duration: 0:00:11.418840

exit_message:

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

id: 6664758

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_favourites/2024-11-04/1730782915",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730782915/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6994525691750665727,
        "service_name": "drive-thru",
        "span_id": 9317895996373674593,
        "trace_id": 10520693258226629151
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 00:53:23
success: True
trace_id: 10520693258226629151

Scan 6663958

duration: 0:00:13.802742

exit_message:

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

id: 6663958

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_favourites/2024-11-04/1730782812",
        "key": "raw/newbookdev_newbookknowledge_base_favourites/2024-11-04/1730782812/knowledge_base_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17560812074478143187,
        "service_name": "drive-thru",
        "span_id": 10025444160948738981,
        "trace_id": 9521987797522452247
    }
}

running: False
schema_name_id: 2789
start_time: 2024-11-05 00:32:26
success: True
trace_id: 9521987797522452247

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 23:07:51

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_favourites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `knowledge_base_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_favourites/2024-11-05/1730866528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookknowledge_base_favourites"
}

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