Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsjob_reports

created: 2023-02-07 01:47:34
disabled: False
format: raw
id: 1480
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "stellar_imsjob_reports"
}

type: drivethrucsv

Schema Versions: 15

Version 1718023

created: 2026-04-17 04:59:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-17/1776419647
id: 1718023
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 162169388
updated: 2026-04-17 04:59:19

Version 1716721

created: 2026-04-16 05:17:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-16/1776334547'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-16/1776334547
id: 1716721
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 162114390
updated: 2026-04-16 05:17:18

Version 1715473

created: 2026-04-15 03:40:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-15/1776242361'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-15/1776242361
id: 1715473
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 162056356
updated: 2026-04-15 03:40:51

Version 1714343

created: 2026-04-14 05:02:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-14/1776160757
id: 1714343
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 162003022
updated: 2026-04-14 05:02:28

Version 1713121

created: 2026-04-13 05:09:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-13/1776074802'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-13/1776074802
id: 1713121
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161945327
updated: 2026-04-13 05:09:19

Version 1711974

created: 2026-04-12 05:08:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-12/1775988160'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-12/1775988160
id: 1711974
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161896435
updated: 2026-04-12 05:08:12

Version 1710757

created: 2026-04-11 05:19:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-11/1775902576
id: 1710757
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161843978
updated: 2026-04-11 05:19:52

Version 1709601

created: 2026-04-10 05:04:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-10/1775815219
id: 1709601
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161788655
updated: 2026-04-10 05:04:35

Version 1708382

created: 2026-04-09 05:01:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-09/1775728839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-09/1775728839
id: 1708382
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161732938
updated: 2026-04-09 05:01:54

Version 1707278

created: 2026-04-08 05:15:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-08/1775643004'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-08/1775643004
id: 1707278
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161678438
updated: 2026-04-08 05:16:01

Version 1706076

created: 2026-04-07 05:18:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-07/1775556858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-07/1775556858
id: 1706076
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161622169
updated: 2026-04-07 05:18:54

Version 1704807

created: 2026-04-06 05:18:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-06/1775470531'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-06/1775470531
id: 1704807
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161564282
updated: 2026-04-06 05:18:17

Version 1703625

created: 2026-04-05 04:59:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-05/1775382947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-05/1775382947
id: 1703625
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161516645
updated: 2026-04-05 04:59:37

Version 1702441

created: 2026-04-04 04:56:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-04/1775296472'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-04/1775296472
id: 1702441
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161462142
updated: 2026-04-04 04:57:11

Version 1701216

created: 2026-04-03 05:11:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-03/1775211035
id: 1701216
processed: 1

raw_data:

{
    "created_at": 6,
    "details": 3,
    "finished_at": 5,
    "id": 1,
    "job": 2,
    "started_at": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1480
schema_scan_id: 161404814
updated: 2026-04-03 05:12:09

Schema Scans: 15

Last at 2026-04-17 04:59:07

Scan 162169388

duration: 0:00:11.888995

exit_message:

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

id: 162169388

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-17/1776419647",
        "key": "raw/stellar_imsjob_reports/2026-04-17/1776419647/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12828487314272883680,
        "service_name": "drive-thru",
        "span_id": 17561634568819387023,
        "trace_id": 1731780608556777109
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-17 04:59:07
success: True
trace_id: 1731780608556777109

Scan 162114390

duration: 0:00:11.871282

exit_message:

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

id: 162114390

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-16/1776334547",
        "key": "raw/stellar_imsjob_reports/2026-04-16/1776334547/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13682443364240275805,
        "service_name": "drive-thru",
        "span_id": 16476800482412721985,
        "trace_id": 15265130232788250625
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-16 05:17:06
success: True
trace_id: 15265130232788250625

Scan 162056356

duration: 0:00:14.429065

exit_message:

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

id: 162056356

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-15/1776242361",
        "key": "raw/stellar_imsjob_reports/2026-04-15/1776242361/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14671035841568479961,
        "service_name": "drive-thru",
        "span_id": 10131958393430260278,
        "trace_id": 9841630808148517191
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-15 03:40:37
success: True
trace_id: 9841630808148517191

Scan 162003022

duration: 0:00:14.340979

exit_message:

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

id: 162003022

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-14/1776160757",
        "key": "raw/stellar_imsjob_reports/2026-04-14/1776160757/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17452238878087879252,
        "service_name": "drive-thru",
        "span_id": 2049992084859266788,
        "trace_id": 1701405581702099994
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-14 05:02:14
success: True
trace_id: 1701405581702099994

Scan 161945327

duration: 0:00:14.309541

exit_message:

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

id: 161945327

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-13/1776074802",
        "key": "raw/stellar_imsjob_reports/2026-04-13/1776074802/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4814632030608417709,
        "service_name": "drive-thru",
        "span_id": 6891862459388515655,
        "trace_id": 6891776114459647844
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-13 05:09:05
success: True
trace_id: 6891776114459647844

Scan 161896435

duration: 0:00:11.806709

exit_message:

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

id: 161896435

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-12/1775988160",
        "key": "raw/stellar_imsjob_reports/2026-04-12/1775988160/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12256396969019216232,
        "service_name": "drive-thru",
        "span_id": 8628511958138858412,
        "trace_id": 11752180179903549367
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-12 05:08:00
success: True
trace_id: 11752180179903549367

Scan 161843978

duration: 0:00:11.769989

exit_message:

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

id: 161843978

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-11/1775902576",
        "key": "raw/stellar_imsjob_reports/2026-04-11/1775902576/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14304861124338011836,
        "service_name": "drive-thru",
        "span_id": 5785377399732973163,
        "trace_id": 16201665163080819496
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-11 05:19:41
success: True
trace_id: 16201665163080819496

Scan 161788655

duration: 0:00:11.940336

exit_message:

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

id: 161788655

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-10/1775815219",
        "key": "raw/stellar_imsjob_reports/2026-04-10/1775815219/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6989027904221141864,
        "service_name": "drive-thru",
        "span_id": 2363698156718056457,
        "trace_id": 18113861928615642781
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-10 05:04:23
success: True
trace_id: 18113861928615642781

Scan 161732938

duration: 0:00:14.473301

exit_message:

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

id: 161732938

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-09/1775728839",
        "key": "raw/stellar_imsjob_reports/2026-04-09/1775728839/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3462943821542531483,
        "service_name": "drive-thru",
        "span_id": 9129740569360113461,
        "trace_id": 3083598575609374683
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-09 05:01:40
success: True
trace_id: 3083598575609374683

Scan 161678438

duration: 0:00:11.793834

exit_message:

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

id: 161678438

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-08/1775643004",
        "key": "raw/stellar_imsjob_reports/2026-04-08/1775643004/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6563459313896311982,
        "service_name": "drive-thru",
        "span_id": 12560415782269436732,
        "trace_id": 12514502502657190136
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-08 05:15:50
success: True
trace_id: 12514502502657190136

Scan 161622169

duration: 0:00:14.343396

exit_message:

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

id: 161622169

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-07/1775556858",
        "key": "raw/stellar_imsjob_reports/2026-04-07/1775556858/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6547757943900595281,
        "service_name": "drive-thru",
        "span_id": 6583302806731098268,
        "trace_id": 10085756813941941749
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-07 05:18:39
success: True
trace_id: 10085756813941941749

Scan 161564282

duration: 0:00:11.706188

exit_message:

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

id: 161564282

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-06/1775470531",
        "key": "raw/stellar_imsjob_reports/2026-04-06/1775470531/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5664077634291881384,
        "service_name": "drive-thru",
        "span_id": 10157056030040009796,
        "trace_id": 16867430857945416454
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-06 05:18:05
success: True
trace_id: 16867430857945416454

Scan 161516645

duration: 0:00:14.248904

exit_message:

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

id: 161516645

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-05/1775382947",
        "key": "raw/stellar_imsjob_reports/2026-04-05/1775382947/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12684667496317124186,
        "service_name": "drive-thru",
        "span_id": 742014961981817559,
        "trace_id": 8030652078846958571
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-05 04:59:23
success: True
trace_id: 8030652078846958571

Scan 161462142

duration: 0:00:14.265047

exit_message:

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

id: 161462142

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-04/1775296472",
        "key": "raw/stellar_imsjob_reports/2026-04-04/1775296472/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9701504241983093519,
        "service_name": "drive-thru",
        "span_id": 15624990492069739171,
        "trace_id": 6988725366258499431
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-04 04:56:56
success: True
trace_id: 6988725366258499431

Scan 161404814

duration: 0:00:11.891701

exit_message:

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

id: 161404814

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsjob_reports/2026-04-03/1775211035",
        "key": "raw/stellar_imsjob_reports/2026-04-03/1775211035/job_reports.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsjob_reports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3115858796140981623,
        "service_name": "drive-thru",
        "span_id": 8139729146383071044,
        "trace_id": 11207670744105850090
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-03 05:11:58
success: True
trace_id: 11207670744105850090

Partitions:

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

Schema:

attributes:

{
    "created_at": "string",
    "details": "string",
    "finished_at": "string",
    "id": "string",
    "job": "string",
    "started_at": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:59:08

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-02-07 01:47:34",
        "disabled": false,
        "format": "raw",
        "id": 1480,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsjob_reports"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created_at": "string",
            "details": "string",
            "finished_at": "string",
            "id": "string",
            "job": "string",
            "started_at": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:59:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsjob_reports`\n(\n `tenant`  string , `id`  string , `job`  string , `details`  string , `started_at`  string , `finished_at`  string , `created_at`  string , `updated_at`  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-prod/raw/stellar_imsjob_reports/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsjob_reports`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsjob_reports"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}