Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imscustom_header_links

created: 2025-12-17 03:46:22
disabled: False
format: raw
id: 4300
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718017

created: 2026-04-17 04:58:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-17/1776419646
id: 1718017
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 162169361
updated: 2026-04-17 04:59:07

Version 1716692

created: 2026-04-16 05:16:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-16/1776334546
id: 1716692
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 162114361
updated: 2026-04-16 05:16:15

Version 1715516

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-15/1776242359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-15/1776242359
id: 1715516
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 162056402
updated: 2026-04-15 03:42:30

Version 1714337

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

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

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 162003008
updated: 2026-04-14 05:02:13

Version 1713140

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-13/1776074800'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-13/1776074800
id: 1713140
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161945347
updated: 2026-04-13 05:10:02

Version 1711880

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

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

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161896313
updated: 2026-04-12 05:03:15

Version 1710775

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

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

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161843997
updated: 2026-04-11 05:20:30

Version 1709545

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

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

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161788585
updated: 2026-04-10 05:02:20

Version 1708383

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-09/1775728839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

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

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161732939
updated: 2026-04-09 05:01:52

Version 1707268

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-08/1775643002'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-08/1775643002
id: 1707268
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161678428
updated: 2026-04-08 05:15:41

Version 1706077

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-07/1775556857
id: 1706077
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161622170
updated: 2026-04-07 05:18:54

Version 1704792

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-06/1775470528
id: 1704792
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161564264
updated: 2026-04-06 05:17:44

Version 1703560

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-05/1775382944'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-05/1775382944
id: 1703560
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161516541
updated: 2026-04-05 04:57:17

Version 1702423

created: 2026-04-04 04:56:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-04/1775296470'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscustom_header_links/2026-04-04/1775296470
id: 1702423
processed: 1

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161462124
updated: 2026-04-04 04:56:33

Version 1701224

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
]

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

raw_data:

{
    "created_at": 9,
    "frontend_position": 6,
    "id": 1,
    "is_visible": 7,
    "location_id": 8,
    "menu_name": 2,
    "parent_id": 4,
    "tenant": 0,
    "type": 3,
    "updated_at": 10,
    "url": 5
}

schema_attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

schema_name_id: 4300
schema_scan_id: 161404822
updated: 2026-04-03 05:12:28

Schema Scans: 15

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

Scan 162169361

duration: 0:00:31.690556

exit_message:

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

id: 162169361

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_imscustom_header_links/2026-04-17/1776419646",
        "key": "raw/stellar_imscustom_header_links/2026-04-17/1776419646/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8607411159515004475,
        "service_name": "drive-thru",
        "span_id": 7047885541641484752,
        "trace_id": 18040504498534691583
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-17 04:58:36
success: True
trace_id: 18040504498534691583

Scan 162114361

duration: 0:00:14.361451

exit_message:

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

id: 162114361

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_imscustom_header_links/2026-04-16/1776334546",
        "key": "raw/stellar_imscustom_header_links/2026-04-16/1776334546/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12496862204361962820,
        "service_name": "drive-thru",
        "span_id": 889065642597659364,
        "trace_id": 6373181098292109717
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-16 05:16:01
success: True
trace_id: 6373181098292109717

Scan 162056402

duration: 0:00:14.288164

exit_message:

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

id: 162056402

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_imscustom_header_links/2026-04-15/1776242359",
        "key": "raw/stellar_imscustom_header_links/2026-04-15/1776242359/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14798374573945508916,
        "service_name": "drive-thru",
        "span_id": 6860603814925667357,
        "trace_id": 8083973807216424921
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-15 03:42:16
success: True
trace_id: 8083973807216424921

Scan 162003008

duration: 0:00:14.333535

exit_message:

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

id: 162003008

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_imscustom_header_links/2026-04-14/1776160756",
        "key": "raw/stellar_imscustom_header_links/2026-04-14/1776160756/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13373106804867142240,
        "service_name": "drive-thru",
        "span_id": 12409720995432132917,
        "trace_id": 849182479372831179
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-14 05:01:59
success: True
trace_id: 849182479372831179

Scan 161945347

duration: 0:00:14.263817

exit_message:

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

id: 161945347

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_imscustom_header_links/2026-04-13/1776074800",
        "key": "raw/stellar_imscustom_header_links/2026-04-13/1776074800/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5655208065645807685,
        "service_name": "drive-thru",
        "span_id": 10600223123301008774,
        "trace_id": 1753292650370002633
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-13 05:09:48
success: True
trace_id: 1753292650370002633

Scan 161896313

duration: 0:00:14.317374

exit_message:

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

id: 161896313

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_imscustom_header_links/2026-04-12/1775988157",
        "key": "raw/stellar_imscustom_header_links/2026-04-12/1775988157/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8531458741255925989,
        "service_name": "drive-thru",
        "span_id": 10916626073695913100,
        "trace_id": 14090903524439650096
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-12 05:03:01
success: True
trace_id: 14090903524439650096

Scan 161843997

duration: 0:00:11.655102

exit_message:

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

id: 161843997

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_imscustom_header_links/2026-04-11/1775902577",
        "key": "raw/stellar_imscustom_header_links/2026-04-11/1775902577/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13705465011359719384,
        "service_name": "drive-thru",
        "span_id": 5004366220307285224,
        "trace_id": 11660263614276088690
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-11 05:20:18
success: True
trace_id: 11660263614276088690

Scan 161788585

duration: 0:00:11.911123

exit_message:

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

id: 161788585

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_imscustom_header_links/2026-04-10/1775815219",
        "key": "raw/stellar_imscustom_header_links/2026-04-10/1775815219/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13327104372326226638,
        "service_name": "drive-thru",
        "span_id": 8099920874438329103,
        "trace_id": 5985607322097500048
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-10 05:02:08
success: True
trace_id: 5985607322097500048

Scan 161732939

duration: 0:00:11.744748

exit_message:

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

id: 161732939

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_imscustom_header_links/2026-04-09/1775728839",
        "key": "raw/stellar_imscustom_header_links/2026-04-09/1775728839/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14364694889759938008,
        "service_name": "drive-thru",
        "span_id": 4477912024553961079,
        "trace_id": 12462481808995833054
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-09 05:01:41
success: True
trace_id: 12462481808995833054

Scan 161678428

duration: 0:00:11.802737

exit_message:

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

id: 161678428

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_imscustom_header_links/2026-04-08/1775643002",
        "key": "raw/stellar_imscustom_header_links/2026-04-08/1775643002/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4153371234984435536,
        "service_name": "drive-thru",
        "span_id": 11090436719031835149,
        "trace_id": 6757960176420673300
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-08 05:15:29
success: True
trace_id: 6757960176420673300

Scan 161622170

duration: 0:00:14.285593

exit_message:

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

id: 161622170

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_imscustom_header_links/2026-04-07/1775556857",
        "key": "raw/stellar_imscustom_header_links/2026-04-07/1775556857/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12815080526468566540,
        "service_name": "drive-thru",
        "span_id": 10405232769185572516,
        "trace_id": 5107164447405544998
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-07 05:18:40
success: True
trace_id: 5107164447405544998

Scan 161564264

duration: 0:00:11.747180

exit_message:

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

id: 161564264

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_imscustom_header_links/2026-04-06/1775470528",
        "key": "raw/stellar_imscustom_header_links/2026-04-06/1775470528/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16421838003503948091,
        "service_name": "drive-thru",
        "span_id": 12212054388117902728,
        "trace_id": 3355013459218007257
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-06 05:17:32
success: True
trace_id: 3355013459218007257

Scan 161516541

duration: 0:00:14.323806

exit_message:

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

id: 161516541

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_imscustom_header_links/2026-04-05/1775382944",
        "key": "raw/stellar_imscustom_header_links/2026-04-05/1775382944/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15886851645982288633,
        "service_name": "drive-thru",
        "span_id": 13326763168847173036,
        "trace_id": 13420212283900091736
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-05 04:57:02
success: True
trace_id: 13420212283900091736

Scan 161462124

duration: 0:00:14.254489

exit_message:

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

id: 161462124

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_imscustom_header_links/2026-04-04/1775296470",
        "key": "raw/stellar_imscustom_header_links/2026-04-04/1775296470/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11037168951098132906,
        "service_name": "drive-thru",
        "span_id": 17336847784420908653,
        "trace_id": 15370293039779236327
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-04 04:56:18
success: True
trace_id: 15370293039779236327

Scan 161404822

duration: 0:00:11.685608

exit_message:

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

id: 161404822

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_imscustom_header_links/2026-04-03/1775211034",
        "key": "raw/stellar_imscustom_header_links/2026-04-03/1775211034/custom_header_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscustom_header_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6164252307888136854,
        "service_name": "drive-thru",
        "span_id": 17665196741765090640,
        "trace_id": 16991058778359897939
    }
}

running: False
schema_name_id: 4300
start_time: 2026-04-03 05:12:16
success: True
trace_id: 16991058778359897939

Partitions:

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

Schema:

attributes:

{
    "created_at": "string",
    "frontend_position": "string",
    "id": "string",
    "is_visible": "string",
    "location_id": "string",
    "menu_name": "string",
    "parent_id": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "url": "string"
}

created: 2026-04-17 04:58:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
}

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-12-17 03:46:22",
        "disabled": false,
        "format": "raw",
        "id": 4300,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imscustom_header_links"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created_at": "string",
            "frontend_position": "string",
            "id": "string",
            "is_visible": "string",
            "location_id": "string",
            "menu_name": "string",
            "parent_id": "string",
            "tenant": "string",
            "type": "string",
            "updated_at": "string",
            "url": "string"
        },
        "created": "2026-04-17 04:58:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscustom_header_links`\n(\n `tenant`  string , `id`  string , `menu_name`  string , `type`  string , `parent_id`  string , `url`  string , `frontend_position`  string , `is_visible`  string , `location_id`  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_imscustom_header_links/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscustom_header_links`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscustom_header_links"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}