Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsmaintenance_alerts

created: 2023-02-07 01:45:25
disabled: False
format: raw
id: 1437
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717959

created: 2026-04-17 04:56:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-17/1776419649
id: 1717959
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 162169299
updated: 2026-04-17 04:56:48

Version 1716798

created: 2026-04-16 05:20:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-16/1776334549'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-16/1776334549
id: 1716798
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 162114475
updated: 2026-04-16 05:20:30

Version 1715524

created: 2026-04-15 03:42:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-15/1776242363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-15/1776242363
id: 1715524
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 162056411
updated: 2026-04-15 03:42:55

Version 1714316

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-14/1776160758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-14/1776160758
id: 1714316
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 162002964
updated: 2026-04-14 05:01:15

Version 1713080

created: 2026-04-13 05:07:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-13/1776074803'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-13/1776074803
id: 1713080
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161945286
updated: 2026-04-13 05:07:43

Version 1711945

created: 2026-04-12 05:06:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-12/1775988160'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

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

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161896397
updated: 2026-04-12 05:06:32

Version 1710737

created: 2026-04-11 05:18:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-11/1775902577
id: 1710737
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161843956
updated: 2026-04-11 05:19:04

Version 1709579

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

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

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161788623
updated: 2026-04-10 05:03:44

Version 1708404

created: 2026-04-09 05:02:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-09/1775728839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

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

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161732964
updated: 2026-04-09 05:02:45

Version 1707186

created: 2026-04-08 05:11:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-08/1775642997'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-08/1775642997
id: 1707186
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161678345
updated: 2026-04-08 05:12:01

Version 1706079

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-07/1775556858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

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

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161622172
updated: 2026-04-07 05:18:56

Version 1704821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-06/1775470533'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-06/1775470533
id: 1704821
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161564297
updated: 2026-04-06 05:18:53

Version 1703533

created: 2026-04-05 04:55:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-05/1775382946
id: 1703533
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161516492
updated: 2026-04-05 04:56:10

Version 1702444

created: 2026-04-04 04:57:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-04/1775296473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmaintenance_alerts/2026-04-04/1775296473
id: 1702444
processed: 1

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161462146
updated: 2026-04-04 04:57:15

Version 1701281

created: 2026-04-03 05:14:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-03/1775211036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
]

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

raw_data:

{
    "created_at": 6,
    "email": 5,
    "id": 1,
    "min_hours": 4,
    "num_days": 3,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1437
schema_scan_id: 161404880
updated: 2026-04-03 05:14:38

Schema Scans: 15

Last at 2026-04-17 04:56:36

Scan 162169299

duration: 0:00:11.608298

exit_message:

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

id: 162169299

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_imsmaintenance_alerts/2026-04-17/1776419649",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-17/1776419649/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 263628678455709309,
        "service_name": "drive-thru",
        "span_id": 5214368160533341109,
        "trace_id": 14272776356792406394
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-17 04:56:36
success: True
trace_id: 14272776356792406394

Scan 162114475

duration: 0:00:14.372317

exit_message:

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

id: 162114475

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_imsmaintenance_alerts/2026-04-16/1776334549",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-16/1776334549/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14107014527635837147,
        "service_name": "drive-thru",
        "span_id": 9736383127531130840,
        "trace_id": 3073900582800589480
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-16 05:20:16
success: True
trace_id: 3073900582800589480

Scan 162056411

duration: 0:00:14.189772

exit_message:

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

id: 162056411

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_imsmaintenance_alerts/2026-04-15/1776242363",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-15/1776242363/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5071728087215349192,
        "service_name": "drive-thru",
        "span_id": 16953135405204359876,
        "trace_id": 5105548755534410778
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-15 03:42:40
success: True
trace_id: 5105548755534410778

Scan 162002964

duration: 0:00:11.695020

exit_message:

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

id: 162002964

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_imsmaintenance_alerts/2026-04-14/1776160758",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-14/1776160758/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9992243874822063634,
        "service_name": "drive-thru",
        "span_id": 14458079509289443505,
        "trace_id": 4914279064957535927
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-14 05:01:04
success: True
trace_id: 4914279064957535927

Scan 161945286

duration: 0:00:11.685670

exit_message:

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

id: 161945286

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_imsmaintenance_alerts/2026-04-13/1776074803",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-13/1776074803/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4480187770385488779,
        "service_name": "drive-thru",
        "span_id": 11492060488073739793,
        "trace_id": 120277662309195393
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-13 05:07:32
success: True
trace_id: 120277662309195393

Scan 161896397

duration: 0:00:11.707629

exit_message:

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

id: 161896397

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_imsmaintenance_alerts/2026-04-12/1775988160",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-12/1775988160/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15979722011934116980,
        "service_name": "drive-thru",
        "span_id": 11086823435313598651,
        "trace_id": 6304982967081368869
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-12 05:06:20
success: True
trace_id: 6304982967081368869

Scan 161843956

duration: 0:00:14.230777

exit_message:

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

id: 161843956

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_imsmaintenance_alerts/2026-04-11/1775902577",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-11/1775902577/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4872966147285110371,
        "service_name": "drive-thru",
        "span_id": 13018428728802466132,
        "trace_id": 16224010944245384777
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-11 05:18:49
success: True
trace_id: 16224010944245384777

Scan 161788623

duration: 0:00:14.089785

exit_message:

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

id: 161788623

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_imsmaintenance_alerts/2026-04-10/1775815219",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-10/1775815219/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6201599863986956111,
        "service_name": "drive-thru",
        "span_id": 13157508384417923108,
        "trace_id": 13120882688077100800
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-10 05:03:30
success: True
trace_id: 13120882688077100800

Scan 161732964

duration: 0:00:11.696682

exit_message:

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

id: 161732964

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_imsmaintenance_alerts/2026-04-09/1775728839",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-09/1775728839/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2398441446929960629,
        "service_name": "drive-thru",
        "span_id": 271037259822080117,
        "trace_id": 14912949786102483660
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-09 05:02:33
success: True
trace_id: 14912949786102483660

Scan 161678345

duration: 0:00:14.325456

exit_message:

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

id: 161678345

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_imsmaintenance_alerts/2026-04-08/1775642997",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-08/1775642997/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16542388497925516479,
        "service_name": "drive-thru",
        "span_id": 15307167621283055129,
        "trace_id": 7564030155412535633
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-08 05:11:47
success: True
trace_id: 7564030155412535633

Scan 161622172

duration: 0:00:14.170947

exit_message:

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

id: 161622172

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_imsmaintenance_alerts/2026-04-07/1775556858",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-07/1775556858/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4318683346945805955,
        "service_name": "drive-thru",
        "span_id": 13908344719302921991,
        "trace_id": 2741630576481213455
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-07 05:18:42
success: True
trace_id: 2741630576481213455

Scan 161564297

duration: 0:00:14.149744

exit_message:

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

id: 161564297

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_imsmaintenance_alerts/2026-04-06/1775470533",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-06/1775470533/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2853501656614045329,
        "service_name": "drive-thru",
        "span_id": 16231014309742070534,
        "trace_id": 13758406524915811239
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-06 05:18:39
success: True
trace_id: 13758406524915811239

Scan 161516492

duration: 0:00:14.296103

exit_message:

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

id: 161516492

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_imsmaintenance_alerts/2026-04-05/1775382946",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-05/1775382946/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3292509234414422787,
        "service_name": "drive-thru",
        "span_id": 12090866331785382127,
        "trace_id": 16741419292580136614
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-05 04:55:56
success: True
trace_id: 16741419292580136614

Scan 161462146

duration: 0:00:11.637281

exit_message:

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

id: 161462146

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_imsmaintenance_alerts/2026-04-04/1775296473",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-04/1775296473/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12997745162686827728,
        "service_name": "drive-thru",
        "span_id": 16204576413946060932,
        "trace_id": 2508150487231441574
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-04 04:57:03
success: True
trace_id: 2508150487231441574

Scan 161404880

duration: 0:00:14.239345

exit_message:

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

id: 161404880

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_imsmaintenance_alerts/2026-04-03/1775211036",
        "key": "raw/stellar_imsmaintenance_alerts/2026-04-03/1775211036/maintenance_alerts.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmaintenance_alerts",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13669723761997692369,
        "service_name": "drive-thru",
        "span_id": 7324245364718380471,
        "trace_id": 2582320339917821909
    }
}

running: False
schema_name_id: 1437
start_time: 2026-04-03 05:14:24
success: True
trace_id: 2582320339917821909

Partitions:

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

Schema:

attributes:

{
    "created_at": "string",
    "email": "string",
    "id": "string",
    "min_hours": "string",
    "num_days": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:56:37

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
}

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:45:25",
        "disabled": false,
        "format": "raw",
        "id": 1437,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsmaintenance_alerts"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created_at": "string",
            "email": "string",
            "id": "string",
            "min_hours": "string",
            "num_days": "string",
            "style_id": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:56:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmaintenance_alerts`\n(\n `tenant`  string , `id`  string , `style_id`  string , `num_days`  string , `min_hours`  string , `email`  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_imsmaintenance_alerts/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmaintenance_alerts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmaintenance_alerts"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}