Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log

created: 2024-10-08 18:02:52
disabled: False
format: raw
id: 2757
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749008

created: 2024-11-05 23:13:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866507
id: 4749008
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6675040
updated: 2024-11-05 23:13:54

Version 4748480

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866428'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

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

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6674512
updated: 2024-11-05 22:47:58

Version 4747662

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866308
id: 4747662
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6673694
updated: 2024-11-05 22:22:57

Version 4747128

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730785720'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730785720
id: 4747128
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6672360
updated: 2024-11-05 04:53:36

Version 4746200

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730785124'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730785124
id: 4746200
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6671421
updated: 2024-11-05 03:53:01

Version 4745433

created: 2024-11-05 03:29:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784819'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784819
id: 4745433
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6670651
updated: 2024-11-05 03:29:30

Version 4744712

created: 2024-11-05 03:10:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784215'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784215
id: 4744712
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6669929
updated: 2024-11-05 03:10:40

Version 4744349

created: 2024-11-05 03:00:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784053'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784053
id: 4744349
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6669566
updated: 2024-11-05 03:00:45

Version 4743537

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783899'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783899
id: 4743537
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6668754
updated: 2024-11-05 02:39:24

Version 4742029

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783766
id: 4742029
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6667246
updated: 2024-11-05 01:59:20

Version 4742017

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783664'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783664
id: 4742017
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6667234
updated: 2024-11-05 01:58:58

Version 4741120

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783523'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783523
id: 4741120
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6666337
updated: 2024-11-05 01:35:31

Version 4740424

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783305'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783305
id: 4740424
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6665641
updated: 2024-11-05 01:17:10

Version 4739601

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730782906'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730782906
id: 4739601
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6664817
updated: 2024-11-05 00:55:06

Version 4738685

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730782750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730782750
id: 4738685
processed: 1

raw_data:

{
    "deleted_when": 6,
    "deletion_type": 5,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2757
schema_scan_id: 6663898
updated: 2024-11-05 00:31:06

Schema Scans: 15

Last at 2024-11-05 23:13:43

Scan 6675040

duration: 0:00:11.537597

exit_message:

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

id: 6675040

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_newbookinstance_deletion_log/2024-11-05/1730866507",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866507/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6793981147986593701,
        "service_name": "drive-thru",
        "span_id": 17381280444029434834,
        "trace_id": 13636188197895702840
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 23:13:43
success: True
trace_id: 13636188197895702840

Scan 6674512

duration: 0:00:11.576507

exit_message:

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

id: 6674512

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_newbookinstance_deletion_log/2024-11-05/1730866428",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866428/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17908855073925781348,
        "service_name": "drive-thru",
        "span_id": 7957811836589181814,
        "trace_id": 3100749157174391972
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 22:47:46
success: True
trace_id: 3100749157174391972

Scan 6673694

duration: 0:00:13.908689

exit_message:

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

id: 6673694

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_newbookinstance_deletion_log/2024-11-05/1730866308",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866308/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10429427889919412644,
        "service_name": "drive-thru",
        "span_id": 608982180848725669,
        "trace_id": 14776223003971734876
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 22:22:43
success: True
trace_id: 14776223003971734876

Scan 6672360

duration: 0:00:14.094477

exit_message:

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

id: 6672360

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_newbookinstance_deletion_log/2024-11-04/1730785720",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730785720/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1492550093072105239,
        "service_name": "drive-thru",
        "span_id": 17035522243429956290,
        "trace_id": 4735424475173457495
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 04:53:22
success: True
trace_id: 4735424475173457495

Scan 6671421

duration: 0:00:11.698964

exit_message:

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

id: 6671421

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_newbookinstance_deletion_log/2024-11-04/1730785124",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730785124/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7475242510187216535,
        "service_name": "drive-thru",
        "span_id": 6194174879886268012,
        "trace_id": 15745297845918930760
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 03:52:50
success: True
trace_id: 15745297845918930760

Scan 6670651

duration: 0:00:13.948982

exit_message:

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

id: 6670651

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_newbookinstance_deletion_log/2024-11-04/1730784819",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784819/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12866220588251045665,
        "service_name": "drive-thru",
        "span_id": 16203790716528306993,
        "trace_id": 4860991578803130639
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 03:29:16
success: True
trace_id: 4860991578803130639

Scan 6669929

duration: 0:00:13.836460

exit_message:

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

id: 6669929

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_newbookinstance_deletion_log/2024-11-04/1730784215",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784215/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6030004769921725216,
        "service_name": "drive-thru",
        "span_id": 14730642679227019775,
        "trace_id": 912581229733470142
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 03:10:26
success: True
trace_id: 912581229733470142

Scan 6669566

duration: 0:00:11.518841

exit_message:

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

id: 6669566

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_newbookinstance_deletion_log/2024-11-04/1730784053",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730784053/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8121191184894461373,
        "service_name": "drive-thru",
        "span_id": 5194673575589429091,
        "trace_id": 11754321842704685593
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 03:00:34
success: True
trace_id: 11754321842704685593

Scan 6668754

duration: 0:00:11.483514

exit_message:

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

id: 6668754

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_newbookinstance_deletion_log/2024-11-04/1730783899",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783899/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 94409761050745306,
        "service_name": "drive-thru",
        "span_id": 11456069763599149524,
        "trace_id": 9072828228652752919
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 02:39:12
success: True
trace_id: 9072828228652752919

Scan 6667246

duration: 0:00:11.519488

exit_message:

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

id: 6667246

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_newbookinstance_deletion_log/2024-11-04/1730783766",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783766/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15093744011583558416,
        "service_name": "drive-thru",
        "span_id": 13077693555599976047,
        "trace_id": 2538849301603158417
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 01:59:09
success: True
trace_id: 2538849301603158417

Scan 6667234

duration: 0:00:11.387600

exit_message:

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

id: 6667234

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_newbookinstance_deletion_log/2024-11-04/1730783664",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783664/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16037657216067582262,
        "service_name": "drive-thru",
        "span_id": 11843289356174209325,
        "trace_id": 4872977212024218777
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 01:58:46
success: True
trace_id: 4872977212024218777

Scan 6666337

duration: 0:00:11.462441

exit_message:

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

id: 6666337

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_newbookinstance_deletion_log/2024-11-04/1730783523",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783523/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3464128873808755906,
        "service_name": "drive-thru",
        "span_id": 3903082568662983953,
        "trace_id": 1880163054881630815
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 01:35:19
success: True
trace_id: 1880163054881630815

Scan 6665641

duration: 0:00:13.833659

exit_message:

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

id: 6665641

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_newbookinstance_deletion_log/2024-11-04/1730783305",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730783305/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5416909233472213256,
        "service_name": "drive-thru",
        "span_id": 513379587412746676,
        "trace_id": 9827971004036927135
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 01:16:56
success: True
trace_id: 9827971004036927135

Scan 6664817

duration: 0:00:11.442301

exit_message:

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

id: 6664817

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_newbookinstance_deletion_log/2024-11-04/1730782906",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730782906/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6075138572602407901,
        "service_name": "drive-thru",
        "span_id": 15212092004548341627,
        "trace_id": 1583736715031504745
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 00:54:54
success: True
trace_id: 1583736715031504745

Scan 6663898

duration: 0:00:14.070858

exit_message:

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

id: 6663898

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_newbookinstance_deletion_log/2024-11-04/1730782750",
        "key": "raw/newbookdev_newbookinstance_deletion_log/2024-11-04/1730782750/instance_deletion_log.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8902958506933808280,
        "service_name": "drive-thru",
        "span_id": 8733806369600788319,
        "trace_id": 5812576571507884643
    }
}

running: False
schema_name_id: 2757
start_time: 2024-11-05 00:30:52
success: True
trace_id: 5812576571507884643

Partitions:

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

Schema:

attributes:

{
    "deleted_when": "string",
    "deletion_type": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "user_id": "string"
}

created: 2024-11-05 23:13:43

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 18:02:52",
        "disabled": false,
        "format": "raw",
        "id": 2757,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookinstance_deletion_log"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "deleted_when": "string",
            "deletion_type": "string",
            "id": "string",
            "instance_id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "user_id": "string"
        },
        "created": "2024-11-05 23:13:43",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `instance_id`  string , `deletion_type`  string , `deleted_when`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstance_deletion_log/2024-11-05/1730866507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstance_deletion_log"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}