Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749475

created: 2024-11-05 23:55:05

ddl:

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

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

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6675540
updated: 2024-11-05 23:55:16

Version 4749180

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-05/1730866592
id: 4749180
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6675212
updated: 2024-11-05 23:26:12

Version 4748901

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-05/1730866497
id: 4748901
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6674933
updated: 2024-11-05 23:08:03

Version 4747188

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730785830
id: 4747188
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6672420
updated: 2024-11-05 05:00:00

Version 4746560

created: 2024-11-05 04:09:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730785185
id: 4746560
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6671784
updated: 2024-11-05 04:09:50

Version 4745740

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730784878
id: 4745740
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6670957
updated: 2024-11-05 03:37:38

Version 4745602

created: 2024-11-05 03:33:47

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730784276
id: 4745602
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6670819
updated: 2024-11-05 03:33:58

Version 4744447

created: 2024-11-05 03:03:15

ddl:

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

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

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6669664
updated: 2024-11-05 03:03:29

Version 4742980

created: 2024-11-05 02:24:29

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783944
id: 4742980
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6668197
updated: 2024-11-05 02:24:40

Version 4742842

created: 2024-11-05 02:20:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783828
id: 4742842
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6668059
updated: 2024-11-05 02:21:06

Version 4741710

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783710
id: 4741710
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6666927
updated: 2024-11-05 01:50:55

Version 4740957

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

ddl:

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

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

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6666174
updated: 2024-11-05 01:31:09

Version 4740361

created: 2024-11-05 01:15:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783367
id: 4740361
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6665578
updated: 2024-11-05 01:15:29

Version 4739695

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

ddl:

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

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

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6664912
updated: 2024-11-05 00:57:35

Version 4739294

created: 2024-11-05 00:46:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730782850
id: 4739294
processed: 1

raw_data:

{
    "action_id": 4,
    "container": 5,
    "id": 2,
    "newbook_region": 0,
    "tab_href": 6,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 3070
schema_scan_id: 6664509
updated: 2024-11-05 00:47:07

Schema Scans: 15

Last at 2024-11-05 23:55:05

Scan 6675540

duration: 0:00:11.606542

exit_message:

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

id: 6675540

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_pinned_tabs/2024-11-05/1730866630",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-05/1730866630/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7134075221784210615,
        "service_name": "drive-thru",
        "span_id": 15638002123009292245,
        "trace_id": 11500596179953327761
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 23:55:05
success: True
trace_id: 11500596179953327761

Scan 6675212

duration: 0:00:13.991138

exit_message:

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

id: 6675212

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_pinned_tabs/2024-11-05/1730866592",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-05/1730866592/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6660656669050526046,
        "service_name": "drive-thru",
        "span_id": 17757504388711342454,
        "trace_id": 6012147766665704709
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 23:25:58
success: True
trace_id: 6012147766665704709

Scan 6674933

duration: 0:00:14.168843

exit_message:

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

id: 6674933

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_pinned_tabs/2024-11-05/1730866497",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-05/1730866497/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3298893487616560657,
        "service_name": "drive-thru",
        "span_id": 253999662905578361,
        "trace_id": 3096964592406458605
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 23:07:49
success: True
trace_id: 3096964592406458605

Scan 6672420

duration: 0:00:11.455984

exit_message:

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

id: 6672420

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_pinned_tabs/2024-11-04/1730785830",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730785830/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1974806687283760413,
        "service_name": "drive-thru",
        "span_id": 6092376917693914633,
        "trace_id": 12406566491156405353
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 04:59:49
success: True
trace_id: 12406566491156405353

Scan 6671784

duration: 0:00:14.126494

exit_message:

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

id: 6671784

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_pinned_tabs/2024-11-04/1730785185",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730785185/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5708190145654731918,
        "service_name": "drive-thru",
        "span_id": 8277890163463162470,
        "trace_id": 6426340308955989102
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 04:09:36
success: True
trace_id: 6426340308955989102

Scan 6670957

duration: 0:00:14.021747

exit_message:

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

id: 6670957

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_pinned_tabs/2024-11-04/1730784878",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730784878/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16206271084015362530,
        "service_name": "drive-thru",
        "span_id": 16315317599814041397,
        "trace_id": 14087016959333806444
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 03:37:24
success: True
trace_id: 14087016959333806444

Scan 6670819

duration: 0:00:11.433229

exit_message:

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

id: 6670819

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_pinned_tabs/2024-11-04/1730784276",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730784276/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 897317804047872757,
        "service_name": "drive-thru",
        "span_id": 14450571072864310335,
        "trace_id": 14093124745781191407
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 03:33:47
success: True
trace_id: 14093124745781191407

Scan 6669664

duration: 0:00:13.821381

exit_message:

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

id: 6669664

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_pinned_tabs/2024-11-04/1730784115",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730784115/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7988068137975650952,
        "service_name": "drive-thru",
        "span_id": 9043590942094880815,
        "trace_id": 3618929033286694883
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 03:03:15
success: True
trace_id: 3618929033286694883

Scan 6668197

duration: 0:00:11.350321

exit_message:

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

id: 6668197

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_pinned_tabs/2024-11-04/1730783944",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783944/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1843150227131140809,
        "service_name": "drive-thru",
        "span_id": 5061196538877031327,
        "trace_id": 6121351291804817713
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 02:24:29
success: True
trace_id: 6121351291804817713

Scan 6668059

duration: 0:00:14.031008

exit_message:

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

id: 6668059

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_pinned_tabs/2024-11-04/1730783828",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783828/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9284995593329888997,
        "service_name": "drive-thru",
        "span_id": 16235915390812568487,
        "trace_id": 5557827948754494461
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 02:20:52
success: True
trace_id: 5557827948754494461

Scan 6666927

duration: 0:00:11.348551

exit_message:

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

id: 6666927

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_pinned_tabs/2024-11-04/1730783710",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783710/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 449085130853898441,
        "service_name": "drive-thru",
        "span_id": 5826914103328657,
        "trace_id": 15834115610969955982
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 01:50:44
success: True
trace_id: 15834115610969955982

Scan 6666174

duration: 0:00:11.494613

exit_message:

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

id: 6666174

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_pinned_tabs/2024-11-04/1730783586",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783586/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18014717476679857932,
        "service_name": "drive-thru",
        "span_id": 10416482985959451972,
        "trace_id": 7853183493112468687
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 01:30:57
success: True
trace_id: 7853183493112468687

Scan 6665578

duration: 0:00:13.943959

exit_message:

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

id: 6665578

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_pinned_tabs/2024-11-04/1730783367",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730783367/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16904911415203074761,
        "service_name": "drive-thru",
        "span_id": 8179300716603790487,
        "trace_id": 17523987437333239614
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 01:15:15
success: True
trace_id: 17523987437333239614

Scan 6664912

duration: 0:00:11.336587

exit_message:

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

id: 6664912

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_pinned_tabs/2024-11-04/1730782963",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730782963/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6858590086051344699,
        "service_name": "drive-thru",
        "span_id": 228943422562906880,
        "trace_id": 8766134618248319279
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 00:57:23
success: True
trace_id: 8766134618248319279

Scan 6664509

duration: 0:00:13.958715

exit_message:

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

id: 6664509

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_pinned_tabs/2024-11-04/1730782850",
        "key": "raw/newbookdev_newbookusers_pinned_tabs/2024-11-04/1730782850/users_pinned_tabs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_pinned_tabs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7428912694045445149,
        "service_name": "drive-thru",
        "span_id": 1374797799618450362,
        "trace_id": 8425438325088503418
    }
}

running: False
schema_name_id: 3070
start_time: 2024-11-05 00:46:53
success: True
trace_id: 8425438325088503418

Partitions:

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

Schema:

attributes:

{
    "action_id": "string",
    "container": "string",
    "id": "string",
    "newbook_region": "string",
    "tab_href": "string",
    "tenant": "string",
    "user_id": "string"
}

created: 2024-11-05 23:55:05

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

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