Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749435

created: 2024-11-05 23:50:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-05/1730866595
id: 4749435
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6675486
updated: 2024-11-05 23:50:50

Version 4749342

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-05/1730866632
id: 4749342
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6675374
updated: 2024-11-05 23:40:39

Version 4748746

created: 2024-11-05 22:59:10

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-05/1730866502
id: 4748746
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6674778
updated: 2024-11-05 22:59:23

Version 4747210

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730785833
id: 4747210
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6672444
updated: 2024-11-05 05:02:28

Version 4746577

created: 2024-11-05 04:10:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730785187
id: 4746577
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6671800
updated: 2024-11-05 04:10:45

Version 4745133

created: 2024-11-05 03:21:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730784880
id: 4745133
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6670350
updated: 2024-11-05 03:21:41

Version 4745130

created: 2024-11-05 03:21:23

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730784278
id: 4745130
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6670347
updated: 2024-11-05 03:21:34

Version 4743844

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730784116
id: 4743844
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6669061
updated: 2024-11-05 02:47:32

Version 4742477

created: 2024-11-05 02:11:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783859
id: 4742477
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6667694
updated: 2024-11-05 02:11:24

Version 4742405

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783829
id: 4742405
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6667623
updated: 2024-11-05 02:09:36

Version 4742116

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783712
id: 4742116
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6667333
updated: 2024-11-05 02:01:43

Version 4741612

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783587
id: 4741612
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6666829
updated: 2024-11-05 01:48:18

Version 4740696

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783368
id: 4740696
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6665913
updated: 2024-11-05 01:24:16

Version 4740042

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730782964
id: 4740042
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6665259
updated: 2024-11-05 01:06:57

Version 4739212

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730782852
id: 4739212
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3080
schema_scan_id: 6664427
updated: 2024-11-05 00:44:53

Schema Scans: 15

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

Scan 6675486

duration: 0:00:11.533291

exit_message:

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

id: 6675486

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_newbookvideo_tutorials_favourites/2024-11-05/1730866595",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-05/1730866595/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12561450550029136850,
        "service_name": "drive-thru",
        "span_id": 3400490005061938971,
        "trace_id": 10375075286464856675
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 23:50:38
success: True
trace_id: 10375075286464856675

Scan 6675374

duration: 0:00:13.992229

exit_message:

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

id: 6675374

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_newbookvideo_tutorials_favourites/2024-11-05/1730866632",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-05/1730866632/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10473873197076368223,
        "service_name": "drive-thru",
        "span_id": 15539648501630795819,
        "trace_id": 9957400117009571582
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 23:40:25
success: True
trace_id: 9957400117009571582

Scan 6674778

duration: 0:00:14.145683

exit_message:

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

id: 6674778

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_newbookvideo_tutorials_favourites/2024-11-05/1730866502",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-05/1730866502/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12261697629268506428,
        "service_name": "drive-thru",
        "span_id": 18343396207849669795,
        "trace_id": 3792005200459094655
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 22:59:09
success: True
trace_id: 3792005200459094655

Scan 6672444

duration: 0:00:11.408596

exit_message:

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

id: 6672444

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_newbookvideo_tutorials_favourites/2024-11-04/1730785833",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730785833/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10229873184678690192,
        "service_name": "drive-thru",
        "span_id": 3303107664715210201,
        "trace_id": 6680909534655164661
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 05:02:16
success: True
trace_id: 6680909534655164661

Scan 6671800

duration: 0:00:14.080189

exit_message:

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

id: 6671800

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_newbookvideo_tutorials_favourites/2024-11-04/1730785187",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730785187/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12823029448129417842,
        "service_name": "drive-thru",
        "span_id": 157966807334845372,
        "trace_id": 2840966028681898341
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 04:10:31
success: True
trace_id: 2840966028681898341

Scan 6670350

duration: 0:00:13.885913

exit_message:

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

id: 6670350

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_newbookvideo_tutorials_favourites/2024-11-04/1730784880",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730784880/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8030017940822376601,
        "service_name": "drive-thru",
        "span_id": 5233045242860627668,
        "trace_id": 2607948471724785959
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 03:21:28
success: True
trace_id: 2607948471724785959

Scan 6670347

duration: 0:00:11.370985

exit_message:

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

id: 6670347

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_newbookvideo_tutorials_favourites/2024-11-04/1730784278",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730784278/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15689725935125690072,
        "service_name": "drive-thru",
        "span_id": 15723522244984155489,
        "trace_id": 13254889042421440984
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 03:21:23
success: True
trace_id: 13254889042421440984

Scan 6669061

duration: 0:00:11.346299

exit_message:

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

id: 6669061

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_newbookvideo_tutorials_favourites/2024-11-04/1730784116",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730784116/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 675994380457911391,
        "service_name": "drive-thru",
        "span_id": 6813800335376714532,
        "trace_id": 5609393428659403027
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 02:47:20
success: True
trace_id: 5609393428659403027

Scan 6667694

duration: 0:00:11.327579

exit_message:

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

id: 6667694

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_newbookvideo_tutorials_favourites/2024-11-04/1730783859",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783859/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6318074312427515594,
        "service_name": "drive-thru",
        "span_id": 1989479693451057098,
        "trace_id": 1035385340529096994
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 02:11:13
success: True
trace_id: 1035385340529096994

Scan 6667623

duration: 0:00:13.772043

exit_message:

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

id: 6667623

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_newbookvideo_tutorials_favourites/2024-11-04/1730783829",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783829/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14422870761035357475,
        "service_name": "drive-thru",
        "span_id": 8104365796874564800,
        "trace_id": 1012064298801006806
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 02:09:22
success: True
trace_id: 1012064298801006806

Scan 6667333

duration: 0:00:13.841834

exit_message:

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

id: 6667333

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_newbookvideo_tutorials_favourites/2024-11-04/1730783712",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783712/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17225338291134542551,
        "service_name": "drive-thru",
        "span_id": 14270478945194341328,
        "trace_id": 15468216899570168134
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 02:01:30
success: True
trace_id: 15468216899570168134

Scan 6666829

duration: 0:00:11.205763

exit_message:

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

id: 6666829

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_newbookvideo_tutorials_favourites/2024-11-04/1730783587",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783587/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8878930541252061704,
        "service_name": "drive-thru",
        "span_id": 8774801863162464780,
        "trace_id": 11773210795630623095
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 01:48:07
success: True
trace_id: 11773210795630623095

Scan 6665913

duration: 0:00:11.387788

exit_message:

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

id: 6665913

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_newbookvideo_tutorials_favourites/2024-11-04/1730783368",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730783368/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 645845806631251965,
        "service_name": "drive-thru",
        "span_id": 6699217126425283346,
        "trace_id": 13423046635452968223
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 01:24:04
success: True
trace_id: 13423046635452968223

Scan 6665259

duration: 0:00:11.250088

exit_message:

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

id: 6665259

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_newbookvideo_tutorials_favourites/2024-11-04/1730782964",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730782964/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17792998280747195587,
        "service_name": "drive-thru",
        "span_id": 13962747457557348670,
        "trace_id": 11471093142457866508
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 01:06:46
success: True
trace_id: 11471093142457866508

Scan 6664427

duration: 0:00:11.292255

exit_message:

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

id: 6664427

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_newbookvideo_tutorials_favourites/2024-11-04/1730782852",
        "key": "raw/newbookdev_newbookvideo_tutorials_favourites/2024-11-04/1730782852/video_tutorials_favourites.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 42668589142967,
        "service_name": "drive-thru",
        "span_id": 10272304865083039533,
        "trace_id": 4203789511131242525
    }
}

running: False
schema_name_id: 3080
start_time: 2024-11-05 00:44:42
success: True
trace_id: 4203789511131242525

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 23:50:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `video_tutorials_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_newbookvideo_tutorials_favourites/2024-11-05/1730866595'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_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:38:01",
        "disabled": false,
        "format": "raw",
        "id": 3080,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookvideo_tutorials_favourites"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "user_id": "string",
            "video_tutorials_id": "string"
        },
        "created": "2024-11-05 23:50:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `video_tutorials_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_newbookvideo_tutorials_favourites/2024-11-05/1730866595'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookvideo_tutorials_favourites"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}