Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749391

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-05/1730866580
id: 4749391
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6675429
updated: 2024-11-05 23:45:58

Version 4749099

created: 2024-11-05 23:20:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-05/1730866521
id: 4749099
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6675131
updated: 2024-11-05 23:20:20

Version 4748391

created: 2024-11-05 22:44:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-05/1730866395
id: 4748391
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6674423
updated: 2024-11-05 22:44:54

Version 4747069

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730785776
id: 4747069
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6672301
updated: 2024-11-05 04:47:11

Version 4746424

created: 2024-11-05 04:02:26

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730785155
id: 4746424
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6671645
updated: 2024-11-05 04:02:36

Version 4745645

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730784850
id: 4745645
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6670862
updated: 2024-11-05 03:35:03

Version 4745108

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730784246
id: 4745108
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6670325
updated: 2024-11-05 03:21:02

Version 4744243

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730784084
id: 4744243
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6669460
updated: 2024-11-05 02:57:54

Version 4743531

created: 2024-11-05 02:39:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783922
id: 4743531
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6668748
updated: 2024-11-05 02:39:15

Version 4742699

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783798
id: 4742699
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6667916
updated: 2024-11-05 02:17:21

Version 4741596

created: 2024-11-05 01:47:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783688
id: 4741596
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6666813
updated: 2024-11-05 01:47:53

Version 4741415

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783555
id: 4741415
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6666632
updated: 2024-11-05 01:43:15

Version 4740547

created: 2024-11-05 01:20:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783336
id: 4740547
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6665764
updated: 2024-11-05 01:20:20

Version 4739819

created: 2024-11-05 01:00:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730782935
id: 4739819
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6665036
updated: 2024-11-05 01:00:56

Version 4738676

created: 2024-11-05 00:30:40

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730782758
id: 4738676
processed: 1

raw_data:

{
    "action_id": 3,
    "id": 2,
    "newbook_region": 0,
    "page_tour_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

schema_name_id: 2942
schema_scan_id: 6663889
updated: 2024-11-05 00:30:51

Schema Scans: 15

Last at 2024-11-05 23:45:47

Scan 6675429

duration: 0:00:11.497358

exit_message:

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

id: 6675429

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_newbookpage_tours_actions_link/2024-11-05/1730866580",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-05/1730866580/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10030631198481053704,
        "service_name": "drive-thru",
        "span_id": 10156613711992278441,
        "trace_id": 7920623393120047831
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 23:45:47
success: True
trace_id: 7920623393120047831

Scan 6675131

duration: 0:00:11.814517

exit_message:

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

id: 6675131

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_newbookpage_tours_actions_link/2024-11-05/1730866521",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-05/1730866521/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2645672906107780100,
        "service_name": "drive-thru",
        "span_id": 14239285077434718210,
        "trace_id": 6984873629260465686
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 23:20:08
success: True
trace_id: 6984873629260465686

Scan 6674423

duration: 0:00:14.012187

exit_message:

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

id: 6674423

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_newbookpage_tours_actions_link/2024-11-05/1730866395",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-05/1730866395/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2793962513743583731,
        "service_name": "drive-thru",
        "span_id": 9263555065649719832,
        "trace_id": 10782841719813447972
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 22:44:40
success: True
trace_id: 10782841719813447972

Scan 6672301

duration: 0:00:11.858096

exit_message:

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

id: 6672301

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_newbookpage_tours_actions_link/2024-11-04/1730785776",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730785776/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3159024500236324799,
        "service_name": "drive-thru",
        "span_id": 14480362329662015149,
        "trace_id": 8154758904949361032
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 04:46:59
success: True
trace_id: 8154758904949361032

Scan 6671645

duration: 0:00:11.416490

exit_message:

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

id: 6671645

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_newbookpage_tours_actions_link/2024-11-04/1730785155",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730785155/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1153548365837126664,
        "service_name": "drive-thru",
        "span_id": 10731688538842533149,
        "trace_id": 14225073237046868903
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 04:02:25
success: True
trace_id: 14225073237046868903

Scan 6670862

duration: 0:00:11.387956

exit_message:

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

id: 6670862

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_newbookpage_tours_actions_link/2024-11-04/1730784850",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730784850/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2944097661412651946,
        "service_name": "drive-thru",
        "span_id": 4006294800075069496,
        "trace_id": 17536338189276372541
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 03:34:52
success: True
trace_id: 17536338189276372541

Scan 6670325

duration: 0:00:11.274158

exit_message:

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

id: 6670325

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_newbookpage_tours_actions_link/2024-11-04/1730784246",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730784246/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8855038585100647177,
        "service_name": "drive-thru",
        "span_id": 13658555078949982683,
        "trace_id": 12922775284707332186
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 03:20:51
success: True
trace_id: 12922775284707332186

Scan 6669460

duration: 0:00:11.406374

exit_message:

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

id: 6669460

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_newbookpage_tours_actions_link/2024-11-04/1730784084",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730784084/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9068021191827045482,
        "service_name": "drive-thru",
        "span_id": 9781546107484829599,
        "trace_id": 15612508081626091971
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 02:57:43
success: True
trace_id: 15612508081626091971

Scan 6668748

duration: 0:00:11.340995

exit_message:

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

id: 6668748

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_newbookpage_tours_actions_link/2024-11-04/1730783922",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783922/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13120185037150138603,
        "service_name": "drive-thru",
        "span_id": 14277687865200076143,
        "trace_id": 11156544654354931655
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 02:39:03
success: True
trace_id: 11156544654354931655

Scan 6667916

duration: 0:00:11.324520

exit_message:

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

id: 6667916

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_newbookpage_tours_actions_link/2024-11-04/1730783798",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783798/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12723484118680583201,
        "service_name": "drive-thru",
        "span_id": 5496341447273977525,
        "trace_id": 13374919630760069331
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 02:17:09
success: True
trace_id: 13374919630760069331

Scan 6666813

duration: 0:00:11.360355

exit_message:

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

id: 6666813

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_newbookpage_tours_actions_link/2024-11-04/1730783688",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783688/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7910101315499345201,
        "service_name": "drive-thru",
        "span_id": 16124846035420730182,
        "trace_id": 1659594835497778422
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 01:47:41
success: True
trace_id: 1659594835497778422

Scan 6666632

duration: 0:00:14.085798

exit_message:

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

id: 6666632

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_newbookpage_tours_actions_link/2024-11-04/1730783555",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783555/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8368653257346594795,
        "service_name": "drive-thru",
        "span_id": 412915062375489599,
        "trace_id": 6965460166463851985
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 01:43:01
success: True
trace_id: 6965460166463851985

Scan 6665764

duration: 0:00:11.493798

exit_message:

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

id: 6665764

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_newbookpage_tours_actions_link/2024-11-04/1730783336",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730783336/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12323285953929751922,
        "service_name": "drive-thru",
        "span_id": 4952142541038800380,
        "trace_id": 16053000343377097510
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 01:20:09
success: True
trace_id: 16053000343377097510

Scan 6665036

duration: 0:00:11.333894

exit_message:

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

id: 6665036

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_newbookpage_tours_actions_link/2024-11-04/1730782935",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730782935/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17068896825622450164,
        "service_name": "drive-thru",
        "span_id": 16641395971801362132,
        "trace_id": 16735896481602329923
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 01:00:44
success: True
trace_id: 16735896481602329923

Scan 6663889

duration: 0:00:11.381530

exit_message:

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

id: 6663889

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_newbookpage_tours_actions_link/2024-11-04/1730782758",
        "key": "raw/newbookdev_newbookpage_tours_actions_link/2024-11-04/1730782758/page_tours_actions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_tours_actions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6418575561399864875,
        "service_name": "drive-thru",
        "span_id": 11122827711242564824,
        "trace_id": 3714682311349953101
    }
}

running: False
schema_name_id: 2942
start_time: 2024-11-05 00:30:40
success: True
trace_id: 3714682311349953101

Partitions:

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

Schema:

attributes:

{
    "action_id": "string",
    "id": "string",
    "newbook_region": "string",
    "page_tour_id": "string",
    "tenant": "string"
}

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

ddl:

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