Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsaudit_logs

created: 2025-10-15 03:45:54
disabled: False
format: raw
id: 4284
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717936

created: 2026-04-17 04:55:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-17/1776419643
id: 1717936
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 162169272
updated: 2026-04-17 04:55:52

Version 1716742

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-16/1776334545
id: 1716742
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 162114412
updated: 2026-04-16 05:18:05

Version 1715457

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-15/1776242356
id: 1715457
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 162056340
updated: 2026-04-15 03:40:18

Version 1714302

created: 2026-04-14 05:00:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-14/1776160751'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-14/1776160751
id: 1714302
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 162002917
updated: 2026-04-14 05:00:32

Version 1713066

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-13/1776074796'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-13/1776074796
id: 1713066
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161945272
updated: 2026-04-13 05:07:15

Version 1711916

created: 2026-04-12 05:05:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-12/1775988157
id: 1711916
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161896365
updated: 2026-04-12 05:05:12

Version 1710684

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-11/1775902573'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-11/1775902573
id: 1710684
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161843903
updated: 2026-04-11 05:17:01

Version 1709500

created: 2026-04-10 05:00:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-10/1775815208'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-10/1775815208
id: 1709500
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161788533
updated: 2026-04-10 05:00:29

Version 1708364

created: 2026-04-09 05:00:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-09/1775728830'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-09/1775728830
id: 1708364
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161732918
updated: 2026-04-09 05:01:12

Version 1707225

created: 2026-04-08 05:13:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-08/1775642998
id: 1707225
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161678384
updated: 2026-04-08 05:13:56

Version 1705996

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-07/1775556856
id: 1705996
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161622074
updated: 2026-04-07 05:15:33

Version 1704754

created: 2026-04-06 05:16:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-06/1775470525'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-06/1775470525
id: 1704754
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161564225
updated: 2026-04-06 05:16:18

Version 1703537

created: 2026-04-05 04:56:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

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

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161516501
updated: 2026-04-05 04:56:21

Version 1702422

created: 2026-04-04 04:56:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-04/1775296466
id: 1702422
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161462123
updated: 2026-04-04 04:56:29

Version 1701243

created: 2026-04-03 05:12:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaudit_logs/2026-04-03/1775211034
id: 1701243
processed: 1

raw_data:

{
    "column_name": 4,
    "created_at": 13,
    "event_type": 11,
    "id": 1,
    "ip_address": 9,
    "new_value": 6,
    "notes": 12,
    "object_id": 3,
    "object_type": 2,
    "old_value": 5,
    "tenant": 0,
    "updated_at": 14,
    "user_agent": 10,
    "user_id": 7,
    "user_type": 8
}

schema_attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

schema_name_id: 4284
schema_scan_id: 161404841
updated: 2026-04-03 05:13:07

Schema Scans: 15

Last at 2026-04-17 04:55:40

Scan 162169272

duration: 0:00:11.965476

exit_message:

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

id: 162169272

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_imsaudit_logs/2026-04-17/1776419643",
        "key": "raw/stellar_imsaudit_logs/2026-04-17/1776419643/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17855214518903601316,
        "service_name": "drive-thru",
        "span_id": 9075483892310365717,
        "trace_id": 11159278578287215453
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-17 04:55:40
success: True
trace_id: 11159278578287215453

Scan 162114412

duration: 0:00:14.510428

exit_message:

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

id: 162114412

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_imsaudit_logs/2026-04-16/1776334545",
        "key": "raw/stellar_imsaudit_logs/2026-04-16/1776334545/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13165081403118589896,
        "service_name": "drive-thru",
        "span_id": 16451764505444051845,
        "trace_id": 5868788425277428830
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-16 05:17:50
success: True
trace_id: 5868788425277428830

Scan 162056340

duration: 0:00:14.600952

exit_message:

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

id: 162056340

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_imsaudit_logs/2026-04-15/1776242356",
        "key": "raw/stellar_imsaudit_logs/2026-04-15/1776242356/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17593146671655021437,
        "service_name": "drive-thru",
        "span_id": 17981882956641395908,
        "trace_id": 15501868488486703736
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-15 03:40:04
success: True
trace_id: 15501868488486703736

Scan 162002917

duration: 0:00:11.908266

exit_message:

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

id: 162002917

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_imsaudit_logs/2026-04-14/1776160751",
        "key": "raw/stellar_imsaudit_logs/2026-04-14/1776160751/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14250962050952886038,
        "service_name": "drive-thru",
        "span_id": 2456220717533325776,
        "trace_id": 10190186433226207626
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-14 05:00:20
success: True
trace_id: 10190186433226207626

Scan 161945272

duration: 0:00:14.665014

exit_message:

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

id: 161945272

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_imsaudit_logs/2026-04-13/1776074796",
        "key": "raw/stellar_imsaudit_logs/2026-04-13/1776074796/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4285153250383003651,
        "service_name": "drive-thru",
        "span_id": 4853940134341303299,
        "trace_id": 5668030211114426062
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-13 05:07:00
success: True
trace_id: 5668030211114426062

Scan 161896365

duration: 0:00:11.940815

exit_message:

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

id: 161896365

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_imsaudit_logs/2026-04-12/1775988157",
        "key": "raw/stellar_imsaudit_logs/2026-04-12/1775988157/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6308219935937159384,
        "service_name": "drive-thru",
        "span_id": 16197533068018036949,
        "trace_id": 9418994684292900256
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-12 05:05:00
success: True
trace_id: 9418994684292900256

Scan 161843903

duration: 0:00:14.722460

exit_message:

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

id: 161843903

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_imsaudit_logs/2026-04-11/1775902573",
        "key": "raw/stellar_imsaudit_logs/2026-04-11/1775902573/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4954926792527885102,
        "service_name": "drive-thru",
        "span_id": 11960795817036576509,
        "trace_id": 8682614510361343722
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-11 05:16:46
success: True
trace_id: 8682614510361343722

Scan 161788533

duration: 0:00:14.518002

exit_message:

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

id: 161788533

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_imsaudit_logs/2026-04-10/1775815208",
        "key": "raw/stellar_imsaudit_logs/2026-04-10/1775815208/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9919045335293212751,
        "service_name": "drive-thru",
        "span_id": 13258114054808678228,
        "trace_id": 1496367255305163590
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-10 05:00:15
success: True
trace_id: 1496367255305163590

Scan 161732918

duration: 0:00:14.537697

exit_message:

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

id: 161732918

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_imsaudit_logs/2026-04-09/1775728830",
        "key": "raw/stellar_imsaudit_logs/2026-04-09/1775728830/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4906342849041269029,
        "service_name": "drive-thru",
        "span_id": 2284268537927245462,
        "trace_id": 13184966257372529315
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-09 05:00:58
success: True
trace_id: 13184966257372529315

Scan 161678384

duration: 0:00:14.490786

exit_message:

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

id: 161678384

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_imsaudit_logs/2026-04-08/1775642998",
        "key": "raw/stellar_imsaudit_logs/2026-04-08/1775642998/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6013085982528562541,
        "service_name": "drive-thru",
        "span_id": 1167782423283914873,
        "trace_id": 2560895101350446488
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-08 05:13:42
success: True
trace_id: 2560895101350446488

Scan 161622074

duration: 0:00:14.603458

exit_message:

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

id: 161622074

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_imsaudit_logs/2026-04-07/1775556856",
        "key": "raw/stellar_imsaudit_logs/2026-04-07/1775556856/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12484978578638756613,
        "service_name": "drive-thru",
        "span_id": 1769315536700227143,
        "trace_id": 1598971337579707330
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-07 05:15:18
success: True
trace_id: 1598971337579707330

Scan 161564225

duration: 0:00:14.477305

exit_message:

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

id: 161564225

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_imsaudit_logs/2026-04-06/1775470525",
        "key": "raw/stellar_imsaudit_logs/2026-04-06/1775470525/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7469533132190077375,
        "service_name": "drive-thru",
        "span_id": 14980036116912158501,
        "trace_id": 8065887461600072848
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-06 05:16:03
success: True
trace_id: 8065887461600072848

Scan 161516501

duration: 0:00:14.538342

exit_message:

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

id: 161516501

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_imsaudit_logs/2026-04-05/1775382945",
        "key": "raw/stellar_imsaudit_logs/2026-04-05/1775382945/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7072726416071560760,
        "service_name": "drive-thru",
        "span_id": 8421626070498522910,
        "trace_id": 9977845684184710301
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-05 04:56:07
success: True
trace_id: 9977845684184710301

Scan 161462123

duration: 0:00:14.492340

exit_message:

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

id: 161462123

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_imsaudit_logs/2026-04-04/1775296466",
        "key": "raw/stellar_imsaudit_logs/2026-04-04/1775296466/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9248718572714088650,
        "service_name": "drive-thru",
        "span_id": 3882231711567321107,
        "trace_id": 17640178911657717893
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-04 04:56:14
success: True
trace_id: 17640178911657717893

Scan 161404841

duration: 0:00:11.946803

exit_message:

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

id: 161404841

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_imsaudit_logs/2026-04-03/1775211034",
        "key": "raw/stellar_imsaudit_logs/2026-04-03/1775211034/audit_logs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaudit_logs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16503684006229701295,
        "service_name": "drive-thru",
        "span_id": 15710411032572856159,
        "trace_id": 6280653301188231550
    }
}

running: False
schema_name_id: 4284
start_time: 2026-04-03 05:12:55
success: True
trace_id: 6280653301188231550

Partitions:

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

Schema:

attributes:

{
    "column_name": "string",
    "created_at": "string",
    "event_type": "string",
    "id": "string",
    "ip_address": "string",
    "new_value": "string",
    "notes": "string",
    "object_id": "string",
    "object_type": "string",
    "old_value": "string",
    "tenant": "string",
    "updated_at": "string",
    "user_agent": "string",
    "user_id": "string",
    "user_type": "string"
}

created: 2026-04-17 04:55:41

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-10-15 03:45:54",
        "disabled": false,
        "format": "raw",
        "id": 4284,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsaudit_logs"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "column_name": "string",
            "created_at": "string",
            "event_type": "string",
            "id": "string",
            "ip_address": "string",
            "new_value": "string",
            "notes": "string",
            "object_id": "string",
            "object_type": "string",
            "old_value": "string",
            "tenant": "string",
            "updated_at": "string",
            "user_agent": "string",
            "user_id": "string",
            "user_type": "string"
        },
        "created": "2026-04-17 04:55:41",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaudit_logs`\n(\n `tenant`  string , `id`  string , `object_type`  string , `object_id`  string , `column_name`  string , `old_value`  string , `new_value`  string , `user_id`  string , `user_type`  string , `ip_address`  string , `user_agent`  string , `event_type`  string , `notes`  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_imsaudit_logs/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaudit_logs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaudit_logs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}