Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imslocation_toggles

created: 2023-02-07 01:48:26
disabled: False
format: raw
id: 1497
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717955

created: 2026-04-17 04:56:22

ddl:

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

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 162169292
updated: 2026-04-17 04:56:36

Version 1716796

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-16/1776334548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imslocation_toggles/2026-04-16/1776334548
id: 1716796
processed: 1

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 162114471
updated: 2026-04-16 05:20:15

Version 1715478

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-15/1776242362'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imslocation_toggles/2026-04-15/1776242362
id: 1715478
processed: 1

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 162056361
updated: 2026-04-15 03:41:01

Version 1714400

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 162003134
updated: 2026-04-14 05:05:00

Version 1713086

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-13/1776074803'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161945292
updated: 2026-04-13 05:07:59

Version 1711886

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-12/1775988160'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161896319
updated: 2026-04-12 05:03:37

Version 1710767

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161843988
updated: 2026-04-11 05:20:12

Version 1709612

created: 2026-04-10 05:04:58

ddl:

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

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161788676
updated: 2026-04-10 05:05:12

Version 1708407

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imslocation_toggles/2026-04-09/1775728837
id: 1708407
processed: 1

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161732965
updated: 2026-04-09 05:02:46

Version 1707166

created: 2026-04-08 05:10:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-08/1775642987'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imslocation_toggles/2026-04-08/1775642987
id: 1707166
processed: 1

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161678325
updated: 2026-04-08 05:10:24

Version 1705983

created: 2026-04-07 05:14:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161622061
updated: 2026-04-07 05:15:04

Version 1704815

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-06/1775470532'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imslocation_toggles/2026-04-06/1775470532
id: 1704815
processed: 1

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161564290
updated: 2026-04-06 05:18:32

Version 1703559

created: 2026-04-05 04:57:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161516538
updated: 2026-04-05 04:57:16

Version 1702469

created: 2026-04-04 04:58:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-04/1775296473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161462185
updated: 2026-04-04 04:58:16

Version 1701291

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
]

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

raw_data:

{
    "location_id": 1,
    "status": 3,
    "tenant": 0,
    "toggle_id": 2
}

schema_attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

schema_name_id: 1497
schema_scan_id: 161404892
updated: 2026-04-03 05:15:03

Schema Scans: 15

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

Scan 162169292

duration: 0:00:14.858490

exit_message:

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

id: 162169292

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_imslocation_toggles/2026-04-17/1776419648",
        "key": "raw/stellar_imslocation_toggles/2026-04-17/1776419648/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13727302036294813752,
        "service_name": "drive-thru",
        "span_id": 8327635025309018996,
        "trace_id": 21703916405360468
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-17 04:56:21
success: True
trace_id: 21703916405360468

Scan 162114471

duration: 0:00:12.516539

exit_message:

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

id: 162114471

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_imslocation_toggles/2026-04-16/1776334548",
        "key": "raw/stellar_imslocation_toggles/2026-04-16/1776334548/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4562969499184172493,
        "service_name": "drive-thru",
        "span_id": 5421611077616871205,
        "trace_id": 6069433194236010870
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-16 05:20:03
success: True
trace_id: 6069433194236010870

Scan 162056361

duration: 0:00:14.919565

exit_message:

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

id: 162056361

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_imslocation_toggles/2026-04-15/1776242362",
        "key": "raw/stellar_imslocation_toggles/2026-04-15/1776242362/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15547746511363899196,
        "service_name": "drive-thru",
        "span_id": 2407416275955080425,
        "trace_id": 3035583300189934315
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-15 03:40:46
success: True
trace_id: 3035583300189934315

Scan 162003134

duration: 0:00:12.349416

exit_message:

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

id: 162003134

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_imslocation_toggles/2026-04-14/1776160757",
        "key": "raw/stellar_imslocation_toggles/2026-04-14/1776160757/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18436997857967515712,
        "service_name": "drive-thru",
        "span_id": 15880974447870049906,
        "trace_id": 9376773003431931267
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-14 05:04:48
success: True
trace_id: 9376773003431931267

Scan 161945292

duration: 0:00:14.882370

exit_message:

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

id: 161945292

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_imslocation_toggles/2026-04-13/1776074803",
        "key": "raw/stellar_imslocation_toggles/2026-04-13/1776074803/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4914185611687467624,
        "service_name": "drive-thru",
        "span_id": 16743935899443353690,
        "trace_id": 18081915879269789952
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-13 05:07:44
success: True
trace_id: 18081915879269789952

Scan 161896319

duration: 0:00:14.988738

exit_message:

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

id: 161896319

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_imslocation_toggles/2026-04-12/1775988160",
        "key": "raw/stellar_imslocation_toggles/2026-04-12/1775988160/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15579484256860938211,
        "service_name": "drive-thru",
        "span_id": 8764248425038563823,
        "trace_id": 17084199493156709170
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-12 05:03:22
success: True
trace_id: 17084199493156709170

Scan 161843988

duration: 0:00:14.958327

exit_message:

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

id: 161843988

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_imslocation_toggles/2026-04-11/1775902577",
        "key": "raw/stellar_imslocation_toggles/2026-04-11/1775902577/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16099332830094515718,
        "service_name": "drive-thru",
        "span_id": 10896306192353264599,
        "trace_id": 16620065139468460086
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-11 05:19:58
success: True
trace_id: 16620065139468460086

Scan 161788676

duration: 0:00:14.887224

exit_message:

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

id: 161788676

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_imslocation_toggles/2026-04-10/1775815220",
        "key": "raw/stellar_imslocation_toggles/2026-04-10/1775815220/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 565207067884290499,
        "service_name": "drive-thru",
        "span_id": 5751178061234540181,
        "trace_id": 1191261736362832209
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-10 05:04:57
success: True
trace_id: 1191261736362832209

Scan 161732965

duration: 0:00:12.257187

exit_message:

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

id: 161732965

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_imslocation_toggles/2026-04-09/1775728837",
        "key": "raw/stellar_imslocation_toggles/2026-04-09/1775728837/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11396468037138089553,
        "service_name": "drive-thru",
        "span_id": 7637291868242423679,
        "trace_id": 3522648207219088833
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-09 05:02:33
success: True
trace_id: 3522648207219088833

Scan 161678325

duration: 0:00:14.935566

exit_message:

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

id: 161678325

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_imslocation_toggles/2026-04-08/1775642987",
        "key": "raw/stellar_imslocation_toggles/2026-04-08/1775642987/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9642945863685366211,
        "service_name": "drive-thru",
        "span_id": 17428521143915605129,
        "trace_id": 16059904329318873593
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-08 05:10:09
success: True
trace_id: 16059904329318873593

Scan 161622061

duration: 0:00:12.628302

exit_message:

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

id: 161622061

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_imslocation_toggles/2026-04-07/1775556857",
        "key": "raw/stellar_imslocation_toggles/2026-04-07/1775556857/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7980237777932210683,
        "service_name": "drive-thru",
        "span_id": 590781148549903644,
        "trace_id": 17123353604564460145
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-07 05:14:52
success: True
trace_id: 17123353604564460145

Scan 161564290

duration: 0:00:12.407081

exit_message:

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

id: 161564290

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_imslocation_toggles/2026-04-06/1775470532",
        "key": "raw/stellar_imslocation_toggles/2026-04-06/1775470532/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2314586692557119098,
        "service_name": "drive-thru",
        "span_id": 10550168543191436920,
        "trace_id": 10586325901885933592
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-06 05:18:20
success: True
trace_id: 10586325901885933592

Scan 161516538

duration: 0:00:15.015296

exit_message:

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

id: 161516538

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_imslocation_toggles/2026-04-05/1775382946",
        "key": "raw/stellar_imslocation_toggles/2026-04-05/1775382946/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1327108280298337913,
        "service_name": "drive-thru",
        "span_id": 11041270720928229130,
        "trace_id": 9031986354731861518
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-05 04:57:01
success: True
trace_id: 9031986354731861518

Scan 161462185

duration: 0:00:15.119660

exit_message:

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

id: 161462185

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_imslocation_toggles/2026-04-04/1775296473",
        "key": "raw/stellar_imslocation_toggles/2026-04-04/1775296473/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2114052873080886845,
        "service_name": "drive-thru",
        "span_id": 3029923358978916778,
        "trace_id": 18038466966418991104
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-04 04:58:01
success: True
trace_id: 18038466966418991104

Scan 161404892

duration: 0:00:12.681635

exit_message:

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

id: 161404892

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_imslocation_toggles/2026-04-03/1775211035",
        "key": "raw/stellar_imslocation_toggles/2026-04-03/1775211035/location_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imslocation_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17365619513812448028,
        "service_name": "drive-thru",
        "span_id": 13057365153226715448,
        "trace_id": 2774628599806397075
    }
}

running: False
schema_name_id: 1497
start_time: 2026-04-03 05:14:50
success: True
trace_id: 2774628599806397075

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "100": "string",
    "101": "string",
    "104": "string",
    "105": "string",
    "106": "string",
    "107": "string",
    "118": "string",
    "120": "string",
    "121": "string",
    "122": "string",
    "132": "string",
    "133": "string",
    "137": "string",
    "160": "string",
    "162": "string",
    "163": "string",
    "171": "string",
    "18": "string",
    "182": "string",
    "1_1": "string",
    "21": "string",
    "219": "string",
    "220": "string",
    "222": "string",
    "241": "string",
    "244": "string",
    "270": "string",
    "279": "string",
    "280": "string",
    "283": "string",
    "284": "string",
    "285": "string",
    "30": "string",
    "309": "string",
    "31": "string",
    "33": "string",
    "34": "string",
    "49": "string",
    "50": "string",
    "60": "string",
    "67": "string",
    "68": "string",
    "69": "string",
    "7": "string",
    "70": "string",
    "71": "string",
    "72": "string",
    "77": "string",
    "8": "string",
    "84": "string",
    "9": "string",
    "99": "string",
    "location_id": "string",
    "status": "string",
    "status_1": "string",
    "tenant": "string",
    "toggle_id": "string"
}

created: 2026-04-17 04:56:22

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:48:26",
        "disabled": false,
        "format": "raw",
        "id": 1497,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imslocation_toggles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "100": "string",
            "101": "string",
            "104": "string",
            "105": "string",
            "106": "string",
            "107": "string",
            "118": "string",
            "120": "string",
            "121": "string",
            "122": "string",
            "132": "string",
            "133": "string",
            "137": "string",
            "160": "string",
            "162": "string",
            "163": "string",
            "171": "string",
            "18": "string",
            "182": "string",
            "1_1": "string",
            "21": "string",
            "219": "string",
            "220": "string",
            "222": "string",
            "241": "string",
            "244": "string",
            "270": "string",
            "279": "string",
            "280": "string",
            "283": "string",
            "284": "string",
            "285": "string",
            "30": "string",
            "309": "string",
            "31": "string",
            "33": "string",
            "34": "string",
            "49": "string",
            "50": "string",
            "60": "string",
            "67": "string",
            "68": "string",
            "69": "string",
            "7": "string",
            "70": "string",
            "71": "string",
            "72": "string",
            "77": "string",
            "8": "string",
            "84": "string",
            "9": "string",
            "99": "string",
            "location_id": "string",
            "status": "string",
            "status_1": "string",
            "tenant": "string",
            "toggle_id": "string"
        },
        "created": "2026-04-17 04:56:22",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imslocation_toggles`\n(\n `tenant`  string , `location_id`  string , `toggle_id`  string , `status`  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_imslocation_toggles/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imslocation_toggles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imslocation_toggles"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}