Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup

created: 2024-10-08 18:28:03
disabled: False
format: raw
id: 2990
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749207

created: 2024-11-05 23:27:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866595
id: 4749207
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6675239
updated: 2024-11-05 23:28:04

Version 4748914

created: 2024-11-05 23:08:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866536
id: 4748914
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6674946
updated: 2024-11-05 23:08:43

Version 4748353

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866420
id: 4748353
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6674385
updated: 2024-11-05 22:43:31

Version 4747080

created: 2024-11-05 04:48:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730785788
id: 4747080
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6672312
updated: 2024-11-05 04:48:20

Version 4745719

created: 2024-11-05 03:36:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730784857
id: 4745719
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6670937
updated: 2024-11-05 03:37:00

Version 4745702

created: 2024-11-05 03:36:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730785162
id: 4745702
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6670919
updated: 2024-11-05 03:36:35

Version 4744433

created: 2024-11-05 03:02:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730784091
id: 4744433
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6669650
updated: 2024-11-05 03:03:07

Version 4744289

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730784253
id: 4744289
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6669506
updated: 2024-11-05 02:59:08

Version 4742884

created: 2024-11-05 02:21:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783927
id: 4742884
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6668101
updated: 2024-11-05 02:22:07

Version 4742782

created: 2024-11-05 02:19:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783805
id: 4742782
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6667999
updated: 2024-11-05 02:19:27

Version 4741506

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783619
id: 4741506
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6666723
updated: 2024-11-05 01:45:35

Version 4741365

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783562
id: 4741365
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6666582
updated: 2024-11-05 01:41:55

Version 4740467

created: 2024-11-05 01:18:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783343
id: 4740467
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6665684
updated: 2024-11-05 01:18:19

Version 4739847

created: 2024-11-05 01:01:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730782942
id: 4739847
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6665064
updated: 2024-11-05 01:01:42

Version 4738941

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730782833
id: 4738941
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "reports_schedule_id": 3,
    "table_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

schema_name_id: 2990
schema_scan_id: 6664155
updated: 2024-11-05 00:37:52

Schema Scans: 15

Last at 2024-11-05 23:27:52

Scan 6675239

duration: 0:00:11.612920

exit_message:

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

id: 6675239

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_newbookreports_schedule_recipients_backup/2024-11-05/1730866595",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866595/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15535423927987583205,
        "service_name": "drive-thru",
        "span_id": 14459487269500745660,
        "trace_id": 11644270821075904261
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 23:27:52
success: True
trace_id: 11644270821075904261

Scan 6674946

duration: 0:00:14.041370

exit_message:

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

id: 6674946

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_newbookreports_schedule_recipients_backup/2024-11-05/1730866536",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866536/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9163443243227194458,
        "service_name": "drive-thru",
        "span_id": 5246560823413361227,
        "trace_id": 13619574210291430280
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 23:08:29
success: True
trace_id: 13619574210291430280

Scan 6674385

duration: 0:00:14.274612

exit_message:

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

id: 6674385

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_newbookreports_schedule_recipients_backup/2024-11-05/1730866420",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866420/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15841663546902064184,
        "service_name": "drive-thru",
        "span_id": 13511278228715532490,
        "trace_id": 18422938077667274912
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 22:43:17
success: True
trace_id: 18422938077667274912

Scan 6672312

duration: 0:00:14.130038

exit_message:

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

id: 6672312

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_newbookreports_schedule_recipients_backup/2024-11-04/1730785788",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730785788/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7557376385330148404,
        "service_name": "drive-thru",
        "span_id": 2249422936981524550,
        "trace_id": 4186038639084757886
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 04:48:06
success: True
trace_id: 4186038639084757886

Scan 6670937

duration: 0:00:11.432997

exit_message:

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

id: 6670937

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_newbookreports_schedule_recipients_backup/2024-11-04/1730784857",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730784857/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8630854235329113575,
        "service_name": "drive-thru",
        "span_id": 11651470466145260414,
        "trace_id": 16683911318776011584
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 03:36:48
success: True
trace_id: 16683911318776011584

Scan 6670919

duration: 0:00:11.381362

exit_message:

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

id: 6670919

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_newbookreports_schedule_recipients_backup/2024-11-04/1730785162",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730785162/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12070694957187448041,
        "service_name": "drive-thru",
        "span_id": 17176953645204037882,
        "trace_id": 9471263680162812602
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 03:36:24
success: True
trace_id: 9471263680162812602

Scan 6669650

duration: 0:00:13.894941

exit_message:

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

id: 6669650

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_newbookreports_schedule_recipients_backup/2024-11-04/1730784091",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730784091/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1953233622697437217,
        "service_name": "drive-thru",
        "span_id": 6085717056352110153,
        "trace_id": 17223844295262712579
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 03:02:53
success: True
trace_id: 17223844295262712579

Scan 6669506

duration: 0:00:13.879895

exit_message:

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

id: 6669506

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_newbookreports_schedule_recipients_backup/2024-11-04/1730784253",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730784253/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10750957908063601269,
        "service_name": "drive-thru",
        "span_id": 6000778588517850391,
        "trace_id": 13416508621105246929
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 02:58:55
success: True
trace_id: 13416508621105246929

Scan 6668101

duration: 0:00:11.537329

exit_message:

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

id: 6668101

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_newbookreports_schedule_recipients_backup/2024-11-04/1730783927",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783927/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6124209963205374612,
        "service_name": "drive-thru",
        "span_id": 10691646796827100639,
        "trace_id": 16056904150602483251
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 02:21:56
success: True
trace_id: 16056904150602483251

Scan 6667999

duration: 0:00:11.502551

exit_message:

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

id: 6667999

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_newbookreports_schedule_recipients_backup/2024-11-04/1730783805",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783805/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7118208682447090275,
        "service_name": "drive-thru",
        "span_id": 3811082005787799242,
        "trace_id": 8780713527327310346
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 02:19:15
success: True
trace_id: 8780713527327310346

Scan 6666723

duration: 0:00:14.027876

exit_message:

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

id: 6666723

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_newbookreports_schedule_recipients_backup/2024-11-04/1730783619",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783619/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17137304573389146687,
        "service_name": "drive-thru",
        "span_id": 17610257244483250710,
        "trace_id": 2929896861228501080
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 01:45:21
success: True
trace_id: 2929896861228501080

Scan 6666582

duration: 0:00:14.226578

exit_message:

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

id: 6666582

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_newbookreports_schedule_recipients_backup/2024-11-04/1730783562",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783562/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6634804277923683968,
        "service_name": "drive-thru",
        "span_id": 11984784835851039968,
        "trace_id": 1076277262680521039
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 01:41:40
success: True
trace_id: 1076277262680521039

Scan 6665684

duration: 0:00:13.967339

exit_message:

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

id: 6665684

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_newbookreports_schedule_recipients_backup/2024-11-04/1730783343",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730783343/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15265118526234186766,
        "service_name": "drive-thru",
        "span_id": 13095724141236218491,
        "trace_id": 13548077582124219726
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 01:18:05
success: True
trace_id: 13548077582124219726

Scan 6665064

duration: 0:00:11.503450

exit_message:

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

id: 6665064

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_newbookreports_schedule_recipients_backup/2024-11-04/1730782942",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730782942/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10891880110413166281,
        "service_name": "drive-thru",
        "span_id": 2323793581329551327,
        "trace_id": 11280286237790314319
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 01:01:31
success: True
trace_id: 11280286237790314319

Scan 6664155

duration: 0:00:13.855051

exit_message:

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

id: 6664155

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_newbookreports_schedule_recipients_backup/2024-11-04/1730782833",
        "key": "raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-04/1730782833/reports_schedule_recipients_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12679882048815998393,
        "service_name": "drive-thru",
        "span_id": 13862323618884488188,
        "trace_id": 3143680957140774114
    }
}

running: False
schema_name_id: 2990
start_time: 2024-11-05 00:37:39
success: True
trace_id: 3143680957140774114

Partitions:

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

Schema:

attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "reports_schedule_id": "string",
    "table_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:27:53

ddl:

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

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:28:03",
        "disabled": false,
        "format": "raw",
        "id": 2990,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookreports_schedule_recipients_backup"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "for": "string",
            "for_id": "string",
            "id": "string",
            "newbook_region": "string",
            "reports_schedule_id": "string",
            "table_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:27:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `reports_schedule_id`  string , `for`  string , `for_id`  string , `table_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_schedule_recipients_backup/2024-11-05/1730866595'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_schedule_recipients_backup"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}