Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log

created: 2024-10-08 17:45:24
disabled: False
format: raw
id: 2525
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748469

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-05/1730866428
id: 4748469
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6674501
updated: 2024-11-05 22:47:34

Version 4748031

created: 2024-11-05 22:32:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-05/1730866346
id: 4748031
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6674063
updated: 2024-11-05 22:32:59

Version 4747536

created: 2024-11-05 22:19:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-05/1730866258
id: 4747536
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6673568
updated: 2024-11-05 22:19:36

Version 4746689

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730785678
id: 4746689
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6671913
updated: 2024-11-05 04:16:47

Version 4746263

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730785100
id: 4746263
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6671484
updated: 2024-11-05 03:55:43

Version 4745759

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730784794
id: 4745759
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6670977
updated: 2024-11-05 03:38:15

Version 4744016

created: 2024-11-05 02:51:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730784191
id: 4744016
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6669233
updated: 2024-11-05 02:52:00

Version 4743734

created: 2024-11-05 02:44:27

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730784028
id: 4743734
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6668951
updated: 2024-11-05 02:44:38

Version 4742891

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783837
id: 4742891
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6668108
updated: 2024-11-05 02:22:21

Version 4741893

created: 2024-11-05 01:55:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783645
id: 4741893
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6667110
updated: 2024-11-05 01:55:46

Version 4741891

created: 2024-11-05 01:55:29

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783742
id: 4741891
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6667108
updated: 2024-11-05 01:55:40

Version 4740523

created: 2024-11-05 01:19:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783497
id: 4740523
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6665740
updated: 2024-11-05 01:19:44

Version 4740136

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783279
id: 4740136
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6665353
updated: 2024-11-05 01:09:31

Version 4739189

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730782881
id: 4739189
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6664404
updated: 2024-11-05 00:44:17

Version 4738902

created: 2024-11-05 00:36:38

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730782786
id: 4738902
processed: 1

raw_data:

{
    "added_when": 6,
    "contact_details_table": 3,
    "contact_details_table_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 5
}

schema_attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2525
schema_scan_id: 6664115
updated: 2024-11-05 00:36:49

Schema Scans: 15

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

Scan 6674501

duration: 0:00:11.467675

exit_message:

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

id: 6674501

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_newbookcontact_details_viewing_log/2024-11-05/1730866428",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-05/1730866428/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1241029575434724136,
        "service_name": "drive-thru",
        "span_id": 2585661522182226155,
        "trace_id": 18292054816204694697
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 22:47:23
success: True
trace_id: 18292054816204694697

Scan 6674063

duration: 0:00:13.993515

exit_message:

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

id: 6674063

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_newbookcontact_details_viewing_log/2024-11-05/1730866346",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-05/1730866346/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12663868960256892683,
        "service_name": "drive-thru",
        "span_id": 17441213014507400214,
        "trace_id": 3966733431732075434
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 22:32:45
success: True
trace_id: 3966733431732075434

Scan 6673568

duration: 0:00:11.474994

exit_message:

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

id: 6673568

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_newbookcontact_details_viewing_log/2024-11-05/1730866258",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-05/1730866258/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14233996644215275337,
        "service_name": "drive-thru",
        "span_id": 10811651774288937872,
        "trace_id": 8544122306603770960
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 22:19:25
success: True
trace_id: 8544122306603770960

Scan 6671913

duration: 0:00:11.748665

exit_message:

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

id: 6671913

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_newbookcontact_details_viewing_log/2024-11-04/1730785678",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730785678/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16203388224569512218,
        "service_name": "drive-thru",
        "span_id": 3357810646323194645,
        "trace_id": 10522473707886700389
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 04:16:35
success: True
trace_id: 10522473707886700389

Scan 6671484

duration: 0:00:14.086190

exit_message:

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

id: 6671484

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_newbookcontact_details_viewing_log/2024-11-04/1730785100",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730785100/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11893510522020222666,
        "service_name": "drive-thru",
        "span_id": 13557150651360427539,
        "trace_id": 11721354104593262090
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 03:55:29
success: True
trace_id: 11721354104593262090

Scan 6670977

duration: 0:00:11.401752

exit_message:

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

id: 6670977

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_newbookcontact_details_viewing_log/2024-11-04/1730784794",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730784794/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8449942500354881855,
        "service_name": "drive-thru",
        "span_id": 12803624786541606800,
        "trace_id": 7303013238456222343
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 03:38:04
success: True
trace_id: 7303013238456222343

Scan 6669233

duration: 0:00:11.337367

exit_message:

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

id: 6669233

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_newbookcontact_details_viewing_log/2024-11-04/1730784191",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730784191/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7798117671110596076,
        "service_name": "drive-thru",
        "span_id": 13379196234619189107,
        "trace_id": 15058538068533463652
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 02:51:49
success: True
trace_id: 15058538068533463652

Scan 6668951

duration: 0:00:11.398469

exit_message:

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

id: 6668951

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_newbookcontact_details_viewing_log/2024-11-04/1730784028",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730784028/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12692141980678194888,
        "service_name": "drive-thru",
        "span_id": 7118993314716229328,
        "trace_id": 7111748022876113720
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 02:44:26
success: True
trace_id: 7111748022876113720

Scan 6668108

duration: 0:00:13.863445

exit_message:

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

id: 6668108

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_newbookcontact_details_viewing_log/2024-11-04/1730783837",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783837/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17597156036084961319,
        "service_name": "drive-thru",
        "span_id": 17570001921118353,
        "trace_id": 480738482746831298
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 02:22:07
success: True
trace_id: 480738482746831298

Scan 6667110

duration: 0:00:11.315766

exit_message:

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

id: 6667110

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_newbookcontact_details_viewing_log/2024-11-04/1730783645",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783645/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3565827893469065858,
        "service_name": "drive-thru",
        "span_id": 6544765087823740179,
        "trace_id": 16120292179061217512
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 01:55:35
success: True
trace_id: 16120292179061217512

Scan 6667108

duration: 0:00:11.276180

exit_message:

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

id: 6667108

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_newbookcontact_details_viewing_log/2024-11-04/1730783742",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783742/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10069204334770670059,
        "service_name": "drive-thru",
        "span_id": 14133319732890457015,
        "trace_id": 14133185347747052587
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 01:55:28
success: True
trace_id: 14133185347747052587

Scan 6665740

duration: 0:00:11.565957

exit_message:

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

id: 6665740

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_newbookcontact_details_viewing_log/2024-11-04/1730783497",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783497/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16466976640196833747,
        "service_name": "drive-thru",
        "span_id": 4516008123868496986,
        "trace_id": 14300333506954530094
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 01:19:32
success: True
trace_id: 14300333506954530094

Scan 6665353

duration: 0:00:11.394020

exit_message:

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

id: 6665353

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_newbookcontact_details_viewing_log/2024-11-04/1730783279",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730783279/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8845539204268332860,
        "service_name": "drive-thru",
        "span_id": 10870936098405976144,
        "trace_id": 9566760733354338003
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 01:09:20
success: True
trace_id: 9566760733354338003

Scan 6664404

duration: 0:00:13.876153

exit_message:

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

id: 6664404

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_newbookcontact_details_viewing_log/2024-11-04/1730782881",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730782881/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5465829101025981324,
        "service_name": "drive-thru",
        "span_id": 7271129683353062600,
        "trace_id": 16888073041080278749
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 00:44:04
success: True
trace_id: 16888073041080278749

Scan 6664115

duration: 0:00:11.405292

exit_message:

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

id: 6664115

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_newbookcontact_details_viewing_log/2024-11-04/1730782786",
        "key": "raw/newbookdev_newbookcontact_details_viewing_log/2024-11-04/1730782786/contact_details_viewing_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4609160854602146049,
        "service_name": "drive-thru",
        "span_id": 11845493522310301186,
        "trace_id": 16015036065849243470
    }
}

running: False
schema_name_id: 2525
start_time: 2024-11-05 00:36:37
success: True
trace_id: 16015036065849243470

Partitions:

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

Schema:

attributes:

{
    "added_when": "string",
    "contact_details_table": "string",
    "contact_details_table_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `contact_details_table`  string , `contact_details_table_id`  string , `user_id`  string , `added_when`  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_newbookcontact_details_viewing_log/2024-11-05/1730866428'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_viewing_log"
}

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