Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcontact_details_types

created: 2024-10-08 17:55:04
disabled: False
format: raw
id: 2660
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748478

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-05/1730866427'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-05/1730866427
id: 4748478
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6674510
updated: 2024-11-05 22:47:52

Version 4748034

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-05/1730866345'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-05/1730866345
id: 4748034
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6674066
updated: 2024-11-05 22:33:04

Version 4747507

created: 2024-11-05 22:18:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-05/1730866258'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

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

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6673539
updated: 2024-11-05 22:18:52

Version 4746669

created: 2024-11-05 04:15:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730785678'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

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

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6671892
updated: 2024-11-05 04:15:45

Version 4746024

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730785099'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730785099
id: 4746024
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6671245
updated: 2024-11-05 03:46:45

Version 4745303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730784794'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

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

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6670520
updated: 2024-11-05 03:26:07

Version 4744793

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730784190'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730784190
id: 4744793
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6670010
updated: 2024-11-05 03:12:45

Version 4744174

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730784029'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730784029
id: 4744174
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6669391
updated: 2024-11-05 02:56:08

Version 4743309

created: 2024-11-05 02:33:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730783880'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783880
id: 4743309
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6668526
updated: 2024-11-05 02:33:25

Version 4741856

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730783741'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783741
id: 4741856
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6667073
updated: 2024-11-05 01:54:44

Version 4741424

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730783603'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783603
id: 4741424
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6666641
updated: 2024-11-05 01:43:30

Version 4740529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730783497'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

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

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6665745
updated: 2024-11-05 01:19:52

Version 4740141

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730783278'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783278
id: 4740141
processed: 1

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6665358
updated: 2024-11-05 01:09:43

Version 4739406

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730782881'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

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

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6664621
updated: 2024-11-05 00:49:59

Version 4738528

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-04/1730782786'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
]

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

raw_data:

{
    "default_display_kiosk": 8,
    "default_display_online": 5,
    "default_display_option": 4,
    "default_files_kiosk": 9,
    "default_files_online": 7,
    "default_files_option": 6,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2660
schema_scan_id: 6663741
updated: 2024-11-05 00:26:58

Schema Scans: 15

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

Scan 6674510

duration: 0:00:11.723277

exit_message:

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

id: 6674510

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_types/2024-11-05/1730866427",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-05/1730866427/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8559546065824659214,
        "service_name": "drive-thru",
        "span_id": 8286782792711994832,
        "trace_id": 17208012955627203623
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 22:47:40
success: True
trace_id: 17208012955627203623

Scan 6674066

duration: 0:00:11.759112

exit_message:

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

id: 6674066

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_types/2024-11-05/1730866345",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-05/1730866345/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9368870178228501390,
        "service_name": "drive-thru",
        "span_id": 18442747829941906935,
        "trace_id": 9669943262780981206
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 22:32:52
success: True
trace_id: 9669943262780981206

Scan 6673539

duration: 0:00:13.970563

exit_message:

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

id: 6673539

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_types/2024-11-05/1730866258",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-05/1730866258/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13348367544739065828,
        "service_name": "drive-thru",
        "span_id": 7274964964727403220,
        "trace_id": 1717784378695952316
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 22:18:38
success: True
trace_id: 1717784378695952316

Scan 6671892

duration: 0:00:14.197950

exit_message:

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

id: 6671892

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_types/2024-11-04/1730785678",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730785678/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16070432098706108133,
        "service_name": "drive-thru",
        "span_id": 13057354748938797681,
        "trace_id": 3929371927815923431
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 04:15:31
success: True
trace_id: 3929371927815923431

Scan 6671245

duration: 0:00:11.635352

exit_message:

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

id: 6671245

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_types/2024-11-04/1730785099",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730785099/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13315224831426687540,
        "service_name": "drive-thru",
        "span_id": 13659498981332019027,
        "trace_id": 1492784595580034823
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 03:46:34
success: True
trace_id: 1492784595580034823

Scan 6670520

duration: 0:00:11.452665

exit_message:

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

id: 6670520

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_types/2024-11-04/1730784794",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730784794/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 554643388255635777,
        "service_name": "drive-thru",
        "span_id": 5712717249905827451,
        "trace_id": 16670941880528376859
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 03:25:55
success: True
trace_id: 16670941880528376859

Scan 6670010

duration: 0:00:13.816506

exit_message:

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

id: 6670010

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_types/2024-11-04/1730784190",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730784190/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18167773703926293436,
        "service_name": "drive-thru",
        "span_id": 9310969875503636338,
        "trace_id": 12248299630117904721
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 03:12:31
success: True
trace_id: 12248299630117904721

Scan 6669391

duration: 0:00:11.570267

exit_message:

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

id: 6669391

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_types/2024-11-04/1730784029",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730784029/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2920852708945755503,
        "service_name": "drive-thru",
        "span_id": 4458345905041303444,
        "trace_id": 14157782095588136209
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 02:55:56
success: True
trace_id: 14157782095588136209

Scan 6668526

duration: 0:00:14.046989

exit_message:

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

id: 6668526

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_types/2024-11-04/1730783880",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783880/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 953242854072215654,
        "service_name": "drive-thru",
        "span_id": 1613910039725814258,
        "trace_id": 8426756819286624374
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 02:33:11
success: True
trace_id: 8426756819286624374

Scan 6667073

duration: 0:00:11.737842

exit_message:

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

id: 6667073

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_types/2024-11-04/1730783741",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783741/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15288236761381275674,
        "service_name": "drive-thru",
        "span_id": 8944206331035222983,
        "trace_id": 10966680760812061782
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 01:54:32
success: True
trace_id: 10966680760812061782

Scan 6666641

duration: 0:00:14.089734

exit_message:

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

id: 6666641

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_types/2024-11-04/1730783603",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783603/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2662144995962313004,
        "service_name": "drive-thru",
        "span_id": 2443520374031561023,
        "trace_id": 5584026291499695454
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 01:43:16
success: True
trace_id: 5584026291499695454

Scan 6665745

duration: 0:00:11.475886

exit_message:

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

id: 6665745

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_types/2024-11-04/1730783497",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783497/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7228962831206313866,
        "service_name": "drive-thru",
        "span_id": 14751055049923123659,
        "trace_id": 7032148419955458807
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 01:19:40
success: True
trace_id: 7032148419955458807

Scan 6665358

duration: 0:00:13.968830

exit_message:

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

id: 6665358

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_types/2024-11-04/1730783278",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730783278/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8701214734531819448,
        "service_name": "drive-thru",
        "span_id": 3066840486413823857,
        "trace_id": 3461936498253479064
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 01:09:29
success: True
trace_id: 3461936498253479064

Scan 6664621

duration: 0:00:11.403939

exit_message:

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

id: 6664621

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_types/2024-11-04/1730782881",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730782881/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14236346764406833856,
        "service_name": "drive-thru",
        "span_id": 4711283584946588462,
        "trace_id": 11479405029355823172
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 00:49:47
success: True
trace_id: 11479405029355823172

Scan 6663741

duration: 0:00:11.432054

exit_message:

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

id: 6663741

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_types/2024-11-04/1730782786",
        "key": "raw/newbookdev_newbookcontact_details_types/2024-11-04/1730782786/contact_details_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcontact_details_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13800823315626106769,
        "service_name": "drive-thru",
        "span_id": 6508682321339198693,
        "trace_id": 2282118716010278303
    }
}

running: False
schema_name_id: 2660
start_time: 2024-11-05 00:26:47
success: True
trace_id: 2282118716010278303

Partitions:

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

Schema:

attributes:

{
    "default_display_kiosk": "string",
    "default_display_online": "string",
    "default_display_option": "string",
    "default_files_kiosk": "string",
    "default_files_online": "string",
    "default_files_option": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

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

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_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-05/1730866427'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
}

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:55:04",
        "disabled": false,
        "format": "raw",
        "id": 2660,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcontact_details_types"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "default_display_kiosk": "string",
            "default_display_online": "string",
            "default_display_option": "string",
            "default_files_kiosk": "string",
            "default_files_online": "string",
            "default_files_option": "string",
            "id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "type": "string"
        },
        "created": "2024-11-05 22:47:41",
        "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_types`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `default_display_option`  string , `default_display_online`  string , `default_files_option`  string , `default_files_online`  string , `default_display_kiosk`  string , `default_files_kiosk`  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_types/2024-11-05/1730866427'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcontact_details_types`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcontact_details_types"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}