Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link

created: 2024-10-08 18:37:58
disabled: False
format: raw
id: 3079
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749493

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-05/1730866630
id: 4749493
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6675562
updated: 2024-11-05 23:57:14

Version 4749409

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-05/1730866593
id: 4749409
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6675447
updated: 2024-11-05 23:47:53

Version 4748906

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-05/1730866499
id: 4748906
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6674938
updated: 2024-11-05 23:08:16

Version 4747198

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730785831
id: 4747198
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6672430
updated: 2024-11-05 05:01:06

Version 4746529

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730785186
id: 4746529
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6671752
updated: 2024-11-05 04:08:00

Version 4745157

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730784882
id: 4745157
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6670374
updated: 2024-11-05 03:22:21

Version 4745123

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730784277
id: 4745123
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6670340
updated: 2024-11-05 03:21:25

Version 4744677

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730784115
id: 4744677
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6669894
updated: 2024-11-05 03:09:41

Version 4743690

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783945
id: 4743690
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6668907
updated: 2024-11-05 02:43:29

Version 4742396

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

ddl:

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

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

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6667613
updated: 2024-11-05 02:09:18

Version 4742252

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783711
id: 4742252
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6667470
updated: 2024-11-05 02:05:28

Version 4740959

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783586
id: 4740959
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6666176
updated: 2024-11-05 01:31:12

Version 4740643

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

ddl:

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

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

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6665860
updated: 2024-11-05 01:22:54

Version 4739902

created: 2024-11-05 01:03:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730782963
id: 4739902
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6665119
updated: 2024-11-05 01:03:16

Version 4739301

created: 2024-11-05 00:47:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730782851
id: 4739301
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "ownership": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3079
schema_scan_id: 6664516
updated: 2024-11-05 00:47:24

Schema Scans: 15

Last at 2024-11-05 23:57:03

Scan 6675562

duration: 0:00:11.624636

exit_message:

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

id: 6675562

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_newbookusers_sharing_link/2024-11-05/1730866630",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-05/1730866630/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1097496808998000369,
        "service_name": "drive-thru",
        "span_id": 14703924965516750240,
        "trace_id": 5377095744902719161
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 23:57:03
success: True
trace_id: 5377095744902719161

Scan 6675447

duration: 0:00:14.408178

exit_message:

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

id: 6675447

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_newbookusers_sharing_link/2024-11-05/1730866593",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-05/1730866593/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12234067235519015894,
        "service_name": "drive-thru",
        "span_id": 14843856293703732953,
        "trace_id": 5834322571539490871
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 23:47:39
success: True
trace_id: 5834322571539490871

Scan 6674938

duration: 0:00:11.510989

exit_message:

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

id: 6674938

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_newbookusers_sharing_link/2024-11-05/1730866499",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-05/1730866499/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11212285007878527906,
        "service_name": "drive-thru",
        "span_id": 10205416741648614742,
        "trace_id": 16970456400457299043
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 23:08:04
success: True
trace_id: 16970456400457299043

Scan 6672430

duration: 0:00:11.519561

exit_message:

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

id: 6672430

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_newbookusers_sharing_link/2024-11-04/1730785831",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730785831/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16078936183955460098,
        "service_name": "drive-thru",
        "span_id": 6192055579535132384,
        "trace_id": 11813514850348124699
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 05:00:54
success: True
trace_id: 11813514850348124699

Scan 6671752

duration: 0:00:11.759879

exit_message:

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

id: 6671752

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_newbookusers_sharing_link/2024-11-04/1730785186",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730785186/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12985988526612381103,
        "service_name": "drive-thru",
        "span_id": 1635008094814997589,
        "trace_id": 7757607780277636375
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 04:07:49
success: True
trace_id: 7757607780277636375

Scan 6670374

duration: 0:00:13.920404

exit_message:

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

id: 6670374

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_newbookusers_sharing_link/2024-11-04/1730784882",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730784882/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4433397923889646814,
        "service_name": "drive-thru",
        "span_id": 17757932083465814400,
        "trace_id": 16503878736601516609
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 03:22:07
success: True
trace_id: 16503878736601516609

Scan 6670340

duration: 0:00:11.358570

exit_message:

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

id: 6670340

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_newbookusers_sharing_link/2024-11-04/1730784277",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730784277/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8960134063456126772,
        "service_name": "drive-thru",
        "span_id": 7023701908482259787,
        "trace_id": 3165575859787160460
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 03:21:13
success: True
trace_id: 3165575859787160460

Scan 6669894

duration: 0:00:13.915405

exit_message:

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

id: 6669894

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_newbookusers_sharing_link/2024-11-04/1730784115",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730784115/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11946198352131681219,
        "service_name": "drive-thru",
        "span_id": 15585954948861499709,
        "trace_id": 6811246419457308583
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 03:09:27
success: True
trace_id: 6811246419457308583

Scan 6668907

duration: 0:00:13.883569

exit_message:

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

id: 6668907

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_newbookusers_sharing_link/2024-11-04/1730783945",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783945/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 886747527655386043,
        "service_name": "drive-thru",
        "span_id": 12111195605396377481,
        "trace_id": 4658353361235248206
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 02:43:15
success: True
trace_id: 4658353361235248206

Scan 6667613

duration: 0:00:13.792763

exit_message:

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

id: 6667613

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_newbookusers_sharing_link/2024-11-04/1730783829",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783829/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4217111457726249979,
        "service_name": "drive-thru",
        "span_id": 7262687894716402315,
        "trace_id": 14122532159865049308
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 02:09:05
success: True
trace_id: 14122532159865049308

Scan 6667470

duration: 0:00:13.969743

exit_message:

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

id: 6667470

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_newbookusers_sharing_link/2024-11-04/1730783711",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783711/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3218356967887934041,
        "service_name": "drive-thru",
        "span_id": 15706361746256201213,
        "trace_id": 13060812341023315392
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 02:05:14
success: True
trace_id: 13060812341023315392

Scan 6666176

duration: 0:00:11.419049

exit_message:

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

id: 6666176

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_newbookusers_sharing_link/2024-11-04/1730783586",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783586/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2777305200701941794,
        "service_name": "drive-thru",
        "span_id": 2177557379266576954,
        "trace_id": 12859796631217273910
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 01:31:00
success: True
trace_id: 12859796631217273910

Scan 6665860

duration: 0:00:11.374332

exit_message:

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

id: 6665860

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_newbookusers_sharing_link/2024-11-04/1730783368",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730783368/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12096600905435781148,
        "service_name": "drive-thru",
        "span_id": 6648811748037724676,
        "trace_id": 5453991224299993309
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 01:22:42
success: True
trace_id: 5453991224299993309

Scan 6665119

duration: 0:00:14.068541

exit_message:

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

id: 6665119

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_newbookusers_sharing_link/2024-11-04/1730782963",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730782963/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14783217996449408205,
        "service_name": "drive-thru",
        "span_id": 4419790046518240707,
        "trace_id": 8775121207345145723
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 01:03:02
success: True
trace_id: 8775121207345145723

Scan 6664516

duration: 0:00:18.890468

exit_message:

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

id: 6664516

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_newbookusers_sharing_link/2024-11-04/1730782851",
        "key": "raw/newbookdev_newbookusers_sharing_link/2024-11-04/1730782851/users_sharing_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_sharing_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16105406772989325492,
        "service_name": "drive-thru",
        "span_id": 12901703755456169715,
        "trace_id": 17365599979221932492
    }
}

running: False
schema_name_id: 3079
start_time: 2024-11-05 00:47:05
success: True
trace_id: 17365599979221932492

Partitions:

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

Schema:

attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "ownership": "string",
    "tenant": "string",
    "user_id": "string"
}

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

ddl:

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