Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsemail_templates

created: 2023-02-07 01:46:02
disabled: False
format: raw
id: 1451
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717985

created: 2026-04-17 04:57:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-17/1776419648
id: 1717985
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 162169325
updated: 2026-04-17 04:57:47

Version 1716767

created: 2026-04-16 05:18:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-16/1776334547'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 162114437
updated: 2026-04-16 05:19:04

Version 1715459

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-15/1776242361'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 162056342
updated: 2026-04-15 03:40:21

Version 1714334

created: 2026-04-14 05:01:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-14/1776160756
id: 1714334
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 162003000
updated: 2026-04-14 05:02:00

Version 1713158

created: 2026-04-13 05:10:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-13/1776074802'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161945368
updated: 2026-04-13 05:10:44

Version 1711923

created: 2026-04-12 05:05:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-12/1775988159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-12/1775988159
id: 1711923
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161896372
updated: 2026-04-12 05:05:38

Version 1710756

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161843975
updated: 2026-04-11 05:19:49

Version 1709604

created: 2026-04-10 05:04:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-10/1775815220
id: 1709604
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161788660
updated: 2026-04-10 05:04:45

Version 1708445

created: 2026-04-09 05:04:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-09/1775728838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-09/1775728838
id: 1708445
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161733008
updated: 2026-04-09 05:04:17

Version 1707275

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-08/1775643003'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-08/1775643003
id: 1707275
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161678435
updated: 2026-04-08 05:15:59

Version 1705995

created: 2026-04-07 05:15:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-07/1775556858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161622072
updated: 2026-04-07 05:15:30

Version 1704796

created: 2026-04-06 05:17:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-06/1775470531'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161564267
updated: 2026-04-06 05:17:51

Version 1703618

created: 2026-04-05 04:59:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-05/1775382945
id: 1703618
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161516627
updated: 2026-04-05 04:59:30

Version 1702438

created: 2026-04-04 04:56:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-04/1775296472'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

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

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161462139
updated: 2026-04-04 04:57:03

Version 1701209

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-03/1775211036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_templates/2026-04-03/1775211036
id: 1701209
processed: 1

raw_data:

{
    "body": 6,
    "created_at": 7,
    "id": 1,
    "location_id": 2,
    "subject": 5,
    "template_name": 3,
    "template_type": 4,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1451
schema_scan_id: 161404807
updated: 2026-04-03 05:11:53

Schema Scans: 15

Last at 2026-04-17 04:57:32

Scan 162169325

duration: 0:00:14.716708

exit_message:

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

id: 162169325

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_imsemail_templates/2026-04-17/1776419648",
        "key": "raw/stellar_imsemail_templates/2026-04-17/1776419648/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1246063179230682961,
        "service_name": "drive-thru",
        "span_id": 1169320416433745714,
        "trace_id": 17640427069069085846
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-17 04:57:32
success: True
trace_id: 17640427069069085846

Scan 162114437

duration: 0:00:14.428937

exit_message:

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

id: 162114437

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_imsemail_templates/2026-04-16/1776334547",
        "key": "raw/stellar_imsemail_templates/2026-04-16/1776334547/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12216502746212478015,
        "service_name": "drive-thru",
        "span_id": 14837263741270679630,
        "trace_id": 1844941143441569005
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-16 05:18:50
success: True
trace_id: 1844941143441569005

Scan 162056342

duration: 0:00:14.320019

exit_message:

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

id: 162056342

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_imsemail_templates/2026-04-15/1776242361",
        "key": "raw/stellar_imsemail_templates/2026-04-15/1776242361/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2254621976910326234,
        "service_name": "drive-thru",
        "span_id": 85566033526270426,
        "trace_id": 16420372533787240828
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-15 03:40:06
success: True
trace_id: 16420372533787240828

Scan 162003000

duration: 0:00:11.871636

exit_message:

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

id: 162003000

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_imsemail_templates/2026-04-14/1776160756",
        "key": "raw/stellar_imsemail_templates/2026-04-14/1776160756/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13519206631340408399,
        "service_name": "drive-thru",
        "span_id": 9023250287079818198,
        "trace_id": 14112893993601881032
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-14 05:01:49
success: True
trace_id: 14112893993601881032

Scan 161945368

duration: 0:00:14.373227

exit_message:

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

id: 161945368

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_imsemail_templates/2026-04-13/1776074802",
        "key": "raw/stellar_imsemail_templates/2026-04-13/1776074802/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8577059614452850934,
        "service_name": "drive-thru",
        "span_id": 10667634083175151991,
        "trace_id": 14091113954967856995
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-13 05:10:29
success: True
trace_id: 14091113954967856995

Scan 161896372

duration: 0:00:14.372065

exit_message:

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

id: 161896372

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_imsemail_templates/2026-04-12/1775988159",
        "key": "raw/stellar_imsemail_templates/2026-04-12/1775988159/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8391905368131013827,
        "service_name": "drive-thru",
        "span_id": 6193562456169092926,
        "trace_id": 1274493290168675196
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-12 05:05:24
success: True
trace_id: 1274493290168675196

Scan 161843975

duration: 0:00:14.486396

exit_message:

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

id: 161843975

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_imsemail_templates/2026-04-11/1775902576",
        "key": "raw/stellar_imsemail_templates/2026-04-11/1775902576/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 509448818138284420,
        "service_name": "drive-thru",
        "span_id": 3229337385956680442,
        "trace_id": 5972748035499429423
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-11 05:19:35
success: True
trace_id: 5972748035499429423

Scan 161788660

duration: 0:00:14.397994

exit_message:

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

id: 161788660

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_imsemail_templates/2026-04-10/1775815220",
        "key": "raw/stellar_imsemail_templates/2026-04-10/1775815220/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4978141003325693981,
        "service_name": "drive-thru",
        "span_id": 5785052868124534666,
        "trace_id": 5076816577070068046
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-10 05:04:31
success: True
trace_id: 5076816577070068046

Scan 161733008

duration: 0:00:11.985395

exit_message:

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

id: 161733008

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_imsemail_templates/2026-04-09/1775728838",
        "key": "raw/stellar_imsemail_templates/2026-04-09/1775728838/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6545362827634388999,
        "service_name": "drive-thru",
        "span_id": 10103928319447517936,
        "trace_id": 14432410359759986213
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-09 05:04:05
success: True
trace_id: 14432410359759986213

Scan 161678435

duration: 0:00:14.409380

exit_message:

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

id: 161678435

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_imsemail_templates/2026-04-08/1775643003",
        "key": "raw/stellar_imsemail_templates/2026-04-08/1775643003/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16198719507394150083,
        "service_name": "drive-thru",
        "span_id": 11362726161436188369,
        "trace_id": 12871387955333482398
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-08 05:15:44
success: True
trace_id: 12871387955333482398

Scan 161622072

duration: 0:00:11.940492

exit_message:

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

id: 161622072

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_imsemail_templates/2026-04-07/1775556858",
        "key": "raw/stellar_imsemail_templates/2026-04-07/1775556858/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16268093467756236408,
        "service_name": "drive-thru",
        "span_id": 3770831346185622246,
        "trace_id": 6500969531676987675
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-07 05:15:18
success: True
trace_id: 6500969531676987675

Scan 161564267

duration: 0:00:11.949634

exit_message:

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

id: 161564267

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_imsemail_templates/2026-04-06/1775470531",
        "key": "raw/stellar_imsemail_templates/2026-04-06/1775470531/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4665938006258825366,
        "service_name": "drive-thru",
        "span_id": 14014190510944196474,
        "trace_id": 16614363578967590319
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-06 05:17:39
success: True
trace_id: 16614363578967590319

Scan 161516627

duration: 0:00:24.189833

exit_message:

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

id: 161516627

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_imsemail_templates/2026-04-05/1775382945",
        "key": "raw/stellar_imsemail_templates/2026-04-05/1775382945/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10347843113808277038,
        "service_name": "drive-thru",
        "span_id": 18275442048391064995,
        "trace_id": 5917287660068310706
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-05 04:59:06
success: True
trace_id: 5917287660068310706

Scan 161462139

duration: 0:00:14.366496

exit_message:

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

id: 161462139

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_imsemail_templates/2026-04-04/1775296472",
        "key": "raw/stellar_imsemail_templates/2026-04-04/1775296472/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1101867786737620988,
        "service_name": "drive-thru",
        "span_id": 13805336099830626347,
        "trace_id": 6729909122534261993
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-04 04:56:49
success: True
trace_id: 6729909122534261993

Scan 161404807

duration: 0:00:11.981763

exit_message:

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

id: 161404807

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_imsemail_templates/2026-04-03/1775211036",
        "key": "raw/stellar_imsemail_templates/2026-04-03/1775211036/email_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4890912313734401282,
        "service_name": "drive-thru",
        "span_id": 934526736365115217,
        "trace_id": 14637208944040753622
    }
}

running: False
schema_name_id: 1451
start_time: 2026-04-03 05:11:41
success: True
trace_id: 14637208944040753622

Partitions:

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

Schema:

attributes:

{
    "body": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "subject": "string",
    "template_name": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:57:33

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
}

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:46:02",
        "disabled": false,
        "format": "raw",
        "id": 1451,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsemail_templates"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "body": "string",
            "created_at": "string",
            "id": "string",
            "location_id": "string",
            "subject": "string",
            "template_name": "string",
            "template_type": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:57:33",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_templates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `template_name`  string , `template_type`  string , `subject`  string , `body`  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_imsemail_templates/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_templates`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_templates"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}