Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749299

created: 2024-11-05 23:35:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-05/1730866560
id: 4749299
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6675331
updated: 2024-11-05 23:36:05

Version 4748987

created: 2024-11-05 23:12:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-05/1730866504
id: 4748987
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6675019
updated: 2024-11-05 23:12:42

Version 4747953

created: 2024-11-05 22:30:21

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-05/1730866369
id: 4747953
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6673985
updated: 2024-11-05 22:30:35

Version 4747189

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730785762
id: 4747189
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6672421
updated: 2024-11-05 05:00:03

Version 4745572

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730785147
id: 4745572
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6670789
updated: 2024-11-05 03:33:08

Version 4745531

created: 2024-11-05 03:31:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730784842
id: 4745531
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6670748
updated: 2024-11-05 03:32:08

Version 4744747

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730784238
id: 4744747
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6669964
updated: 2024-11-05 03:11:31

Version 4744539

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730784076
id: 4744539
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6669756
updated: 2024-11-05 03:06:01

Version 4743757

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783916
id: 4743757
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6668974
updated: 2024-11-05 02:45:15

Version 4742607

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783790
id: 4742607
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6667824
updated: 2024-11-05 02:14:54

Version 4741739

created: 2024-11-05 01:51:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783615
id: 4741739
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6666956
updated: 2024-11-05 01:51:43

Version 4741338

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783546
id: 4741338
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6666555
updated: 2024-11-05 01:41:13

Version 4740131

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783328
id: 4740131
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6665348
updated: 2024-11-05 01:09:22

Version 4739785

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730782928
id: 4739785
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6665002
updated: 2024-11-05 01:00:00

Version 4738946

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730782822
id: 4738946
processed: 1

raw_data:

{
    "firstname": 4,
    "id": 2,
    "lastname": 5,
    "messenger_identifier": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2854
schema_scan_id: 6664160
updated: 2024-11-05 00:37:57

Schema Scans: 15

Last at 2024-11-05 23:35:54

Scan 6675331

duration: 0:00:11.434925

exit_message:

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

id: 6675331

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_newbooknewbook_messenger_guests/2024-11-05/1730866560",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-05/1730866560/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15340017440265659485,
        "service_name": "drive-thru",
        "span_id": 771283716737511964,
        "trace_id": 14308109074527768337
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 23:35:54
success: True
trace_id: 14308109074527768337

Scan 6675019

duration: 0:00:11.491233

exit_message:

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

id: 6675019

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_newbooknewbook_messenger_guests/2024-11-05/1730866504",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-05/1730866504/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16225604671963120169,
        "service_name": "drive-thru",
        "span_id": 14016780471910080718,
        "trace_id": 3644632574952439532
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 23:12:30
success: True
trace_id: 3644632574952439532

Scan 6673985

duration: 0:00:14.029324

exit_message:

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

id: 6673985

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_newbooknewbook_messenger_guests/2024-11-05/1730866369",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-05/1730866369/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3351152901956746208,
        "service_name": "drive-thru",
        "span_id": 10254290379872923088,
        "trace_id": 9146787919463096575
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 22:30:21
success: True
trace_id: 9146787919463096575

Scan 6672421

duration: 0:00:11.536273

exit_message:

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

id: 6672421

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_newbooknewbook_messenger_guests/2024-11-04/1730785762",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730785762/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11593420655231169840,
        "service_name": "drive-thru",
        "span_id": 11468289068093718432,
        "trace_id": 873874225552674008
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 04:59:51
success: True
trace_id: 873874225552674008

Scan 6670789

duration: 0:00:11.409623

exit_message:

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

id: 6670789

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_newbooknewbook_messenger_guests/2024-11-04/1730785147",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730785147/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4240192240212009080,
        "service_name": "drive-thru",
        "span_id": 10601951666108602422,
        "trace_id": 9839695386785425002
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 03:32:56
success: True
trace_id: 9839695386785425002

Scan 6670748

duration: 0:00:13.924527

exit_message:

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

id: 6670748

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_newbooknewbook_messenger_guests/2024-11-04/1730784842",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730784842/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10540422678898517485,
        "service_name": "drive-thru",
        "span_id": 14983551509154132769,
        "trace_id": 18137178043658377549
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 03:31:54
success: True
trace_id: 18137178043658377549

Scan 6669964

duration: 0:00:11.229776

exit_message:

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

id: 6669964

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_newbooknewbook_messenger_guests/2024-11-04/1730784238",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730784238/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17056031070716330251,
        "service_name": "drive-thru",
        "span_id": 9347541942470848585,
        "trace_id": 15799271165535084085
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 03:11:20
success: True
trace_id: 15799271165535084085

Scan 6669756

duration: 0:00:13.861254

exit_message:

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

id: 6669756

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_newbooknewbook_messenger_guests/2024-11-04/1730784076",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730784076/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10386386600126177186,
        "service_name": "drive-thru",
        "span_id": 16908141840325735000,
        "trace_id": 11236358041367665836
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 03:05:47
success: True
trace_id: 11236358041367665836

Scan 6668974

duration: 0:00:13.989242

exit_message:

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

id: 6668974

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_newbooknewbook_messenger_guests/2024-11-04/1730783916",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783916/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18331963836694650513,
        "service_name": "drive-thru",
        "span_id": 8356477299211546156,
        "trace_id": 10801282276120822586
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 02:45:01
success: True
trace_id: 10801282276120822586

Scan 6667824

duration: 0:00:11.453603

exit_message:

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

id: 6667824

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_newbooknewbook_messenger_guests/2024-11-04/1730783790",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783790/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9027089617276399724,
        "service_name": "drive-thru",
        "span_id": 4327216674692703711,
        "trace_id": 12166645560113533447
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 02:14:42
success: True
trace_id: 12166645560113533447

Scan 6666956

duration: 0:00:11.360563

exit_message:

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

id: 6666956

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_newbooknewbook_messenger_guests/2024-11-04/1730783615",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783615/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6030837582073259147,
        "service_name": "drive-thru",
        "span_id": 11400902650654299153,
        "trace_id": 7205732337859074789
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 01:51:32
success: True
trace_id: 7205732337859074789

Scan 6666555

duration: 0:00:11.482076

exit_message:

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

id: 6666555

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_newbooknewbook_messenger_guests/2024-11-04/1730783546",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783546/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 36152587164235994,
        "service_name": "drive-thru",
        "span_id": 4734216799683619245,
        "trace_id": 5578063777429062274
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 01:41:01
success: True
trace_id: 5578063777429062274

Scan 6665348

duration: 0:00:11.740784

exit_message:

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

id: 6665348

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_newbooknewbook_messenger_guests/2024-11-04/1730783328",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730783328/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5712100714307153133,
        "service_name": "drive-thru",
        "span_id": 2482771796242290604,
        "trace_id": 7531494929795294518
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 01:09:11
success: True
trace_id: 7531494929795294518

Scan 6665002

duration: 0:00:11.442929

exit_message:

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

id: 6665002

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_newbooknewbook_messenger_guests/2024-11-04/1730782928",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730782928/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2780226047513191037,
        "service_name": "drive-thru",
        "span_id": 18365178834614722494,
        "trace_id": 13948643663154838016
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 00:59:49
success: True
trace_id: 13948643663154838016

Scan 6664160

duration: 0:00:11.350658

exit_message:

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

id: 6664160

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_newbooknewbook_messenger_guests/2024-11-04/1730782822",
        "key": "raw/newbookdev_newbooknewbook_messenger_guests/2024-11-04/1730782822/newbook_messenger_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10274727749218404175,
        "service_name": "drive-thru",
        "span_id": 17391455345208131668,
        "trace_id": 4220378121868511573
    }
}

running: False
schema_name_id: 2854
start_time: 2024-11-05 00:37:46
success: True
trace_id: 4220378121868511573

Partitions:

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

Schema:

attributes:

{
    "firstname": "string",
    "id": "string",
    "lastname": "string",
    "messenger_identifier": "string",
    "newbook_region": "string",
    "tenant": "string"
}

created: 2024-11-05 23:35:54

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `messenger_identifier`  string , `firstname`  string , `lastname`  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_newbooknewbook_messenger_guests/2024-11-05/1730866560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooknewbook_messenger_guests"
}

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