Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imstoggle_details

created: 2023-02-07 01:49:00
disabled: False
format: raw
id: 1506
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717987

created: 2026-04-17 04:57:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-17/1776419655
id: 1717987
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 162169326
updated: 2026-04-17 04:57:48

Version 1716770

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-16/1776334555'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-16/1776334555
id: 1716770
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 162114440
updated: 2026-04-16 05:19:11

Version 1715534

created: 2026-04-15 03:43:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-15/1776242369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-15/1776242369
id: 1715534
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 162056421
updated: 2026-04-15 03:43:15

Version 1714414

created: 2026-04-14 05:05:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-14/1776160764'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-14/1776160764
id: 1714414
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 162003163
updated: 2026-04-14 05:05:37

Version 1713169

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-13/1776074809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-13/1776074809
id: 1713169
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161945379
updated: 2026-04-13 05:11:15

Version 1711967

created: 2026-04-12 05:07:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-12/1775988167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-12/1775988167
id: 1711967
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161896425
updated: 2026-04-12 05:07:44

Version 1710789

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-11/1775902582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-11/1775902582
id: 1710789
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161844019
updated: 2026-04-11 05:21:02

Version 1709613

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-10/1775815222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-10/1775815222
id: 1709613
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161788685
updated: 2026-04-10 05:05:18

Version 1708449

created: 2026-04-09 05:04:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-09/1775728844'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-09/1775728844
id: 1708449
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161733012
updated: 2026-04-09 05:04:29

Version 1707206

created: 2026-04-08 05:12:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-08/1775642994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-08/1775642994
id: 1707206
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161678365
updated: 2026-04-08 05:13:06

Version 1706083

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-07/1775556863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-07/1775556863
id: 1706083
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161622176
updated: 2026-04-07 05:19:08

Version 1704847

created: 2026-04-06 05:19:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-06/1775470540'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-06/1775470540
id: 1704847
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161564324
updated: 2026-04-06 05:19:48

Version 1703640

created: 2026-04-05 04:59:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-05/1775382952'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-05/1775382952
id: 1703640
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161516697
updated: 2026-04-05 05:00:05

Version 1702461

created: 2026-04-04 04:57:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-04/1775296475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-04/1775296475
id: 1702461
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161462170
updated: 2026-04-04 04:57:54

Version 1701307

created: 2026-04-03 05:15:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-03/1775211042'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstoggle_details/2026-04-03/1775211042
id: 1701307
processed: 1

raw_data:

{
    "accompanying_toggles": 7,
    "additional_notes": 11,
    "billing_impact": 5,
    "category": 2,
    "description": 6,
    "disable_risk_level": 4,
    "enable_risk_level": 3,
    "known_conflicts": 8,
    "specific_clients": 9,
    "tenant": 0,
    "testing_instructions": 10,
    "toggle_name": 1
}

schema_attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

schema_name_id: 1506
schema_scan_id: 161404907
updated: 2026-04-03 05:15:47

Schema Scans: 15

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

Scan 162169326

duration: 0:00:12.044350

exit_message:

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

id: 162169326

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_imstoggle_details/2026-04-17/1776419655",
        "key": "raw/stellar_imstoggle_details/2026-04-17/1776419655/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6422872706411307727,
        "service_name": "drive-thru",
        "span_id": 10605003915679008558,
        "trace_id": 498487336991344688
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-17 04:57:36
success: True
trace_id: 498487336991344688

Scan 162114440

duration: 0:00:14.736784

exit_message:

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

id: 162114440

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_imstoggle_details/2026-04-16/1776334555",
        "key": "raw/stellar_imstoggle_details/2026-04-16/1776334555/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11804130132591551047,
        "service_name": "drive-thru",
        "span_id": 17330820016197864310,
        "trace_id": 1544242123184363879
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-16 05:18:56
success: True
trace_id: 1544242123184363879

Scan 162056421

duration: 0:00:14.450659

exit_message:

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

id: 162056421

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_imstoggle_details/2026-04-15/1776242369",
        "key": "raw/stellar_imstoggle_details/2026-04-15/1776242369/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11529978836713147255,
        "service_name": "drive-thru",
        "span_id": 4884471713413716958,
        "trace_id": 2329525132521900183
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-15 03:43:01
success: True
trace_id: 2329525132521900183

Scan 162003163

duration: 0:00:14.425227

exit_message:

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

id: 162003163

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_imstoggle_details/2026-04-14/1776160764",
        "key": "raw/stellar_imstoggle_details/2026-04-14/1776160764/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3275392031832564655,
        "service_name": "drive-thru",
        "span_id": 3531128922222666126,
        "trace_id": 14169494866905135059
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-14 05:05:22
success: True
trace_id: 14169494866905135059

Scan 161945379

duration: 0:00:14.591183

exit_message:

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

id: 161945379

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_imstoggle_details/2026-04-13/1776074809",
        "key": "raw/stellar_imstoggle_details/2026-04-13/1776074809/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16803622855879493930,
        "service_name": "drive-thru",
        "span_id": 9540635218924222215,
        "trace_id": 4732217625305448878
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-13 05:11:00
success: True
trace_id: 4732217625305448878

Scan 161896425

duration: 0:00:14.498378

exit_message:

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

id: 161896425

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_imstoggle_details/2026-04-12/1775988167",
        "key": "raw/stellar_imstoggle_details/2026-04-12/1775988167/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5995084201644272653,
        "service_name": "drive-thru",
        "span_id": 13989203253241817919,
        "trace_id": 9765204852360654574
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-12 05:07:30
success: True
trace_id: 9765204852360654574

Scan 161844019

duration: 0:00:11.864690

exit_message:

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

id: 161844019

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_imstoggle_details/2026-04-11/1775902582",
        "key": "raw/stellar_imstoggle_details/2026-04-11/1775902582/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10554612360423352111,
        "service_name": "drive-thru",
        "span_id": 3955971408916388773,
        "trace_id": 7722442622786090168
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-11 05:20:51
success: True
trace_id: 7722442622786090168

Scan 161788685

duration: 0:00:14.398439

exit_message:

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

id: 161788685

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_imstoggle_details/2026-04-10/1775815222",
        "key": "raw/stellar_imstoggle_details/2026-04-10/1775815222/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14694300452268553125,
        "service_name": "drive-thru",
        "span_id": 8005459374805926406,
        "trace_id": 2145505525905859383
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-10 05:05:03
success: True
trace_id: 2145505525905859383

Scan 161733012

duration: 0:00:14.540264

exit_message:

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

id: 161733012

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_imstoggle_details/2026-04-09/1775728844",
        "key": "raw/stellar_imstoggle_details/2026-04-09/1775728844/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7579019108483220422,
        "service_name": "drive-thru",
        "span_id": 16887665037672708684,
        "trace_id": 11463595119577227048
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-09 05:04:14
success: True
trace_id: 11463595119577227048

Scan 161678365

duration: 0:00:14.542017

exit_message:

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

id: 161678365

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_imstoggle_details/2026-04-08/1775642994",
        "key": "raw/stellar_imstoggle_details/2026-04-08/1775642994/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14945195198279826550,
        "service_name": "drive-thru",
        "span_id": 12653383152557596354,
        "trace_id": 16646420880117196861
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-08 05:12:52
success: True
trace_id: 16646420880117196861

Scan 161622176

duration: 0:00:14.359960

exit_message:

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

id: 161622176

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_imstoggle_details/2026-04-07/1775556863",
        "key": "raw/stellar_imstoggle_details/2026-04-07/1775556863/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4944105033259164709,
        "service_name": "drive-thru",
        "span_id": 9125876569620386253,
        "trace_id": 382989332874806232
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-07 05:18:54
success: True
trace_id: 382989332874806232

Scan 161564324

duration: 0:00:11.898918

exit_message:

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

id: 161564324

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_imstoggle_details/2026-04-06/1775470540",
        "key": "raw/stellar_imstoggle_details/2026-04-06/1775470540/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12438774157727810173,
        "service_name": "drive-thru",
        "span_id": 787598901976713425,
        "trace_id": 9642039775481241922
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-06 05:19:36
success: True
trace_id: 9642039775481241922

Scan 161516697

duration: 0:00:14.410336

exit_message:

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

id: 161516697

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_imstoggle_details/2026-04-05/1775382952",
        "key": "raw/stellar_imstoggle_details/2026-04-05/1775382952/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8373478992978409535,
        "service_name": "drive-thru",
        "span_id": 2152128368222466693,
        "trace_id": 4156712152341979410
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-05 04:59:51
success: True
trace_id: 4156712152341979410

Scan 161462170

duration: 0:00:11.928749

exit_message:

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

id: 161462170

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_imstoggle_details/2026-04-04/1775296475",
        "key": "raw/stellar_imstoggle_details/2026-04-04/1775296475/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 424073923070567130,
        "service_name": "drive-thru",
        "span_id": 13786870464933468658,
        "trace_id": 13423806043586634281
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-04 04:57:43
success: True
trace_id: 13423806043586634281

Scan 161404907

duration: 0:00:14.521315

exit_message:

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

id: 161404907

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_imstoggle_details/2026-04-03/1775211042",
        "key": "raw/stellar_imstoggle_details/2026-04-03/1775211042/toggle_details.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstoggle_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15695936511580846069,
        "service_name": "drive-thru",
        "span_id": 8076958478186267158,
        "trace_id": 11918925666881087739
    }
}

running: False
schema_name_id: 1506
start_time: 2026-04-03 05:15:32
success: True
trace_id: 11918925666881087739

Partitions:

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

Schema:

attributes:

{
    "accompanying_toggles": "string",
    "additional_notes": "string",
    "billing_impact": "string",
    "category": "string",
    "description": "string",
    "disable_risk_level": "string",
    "enable_risk_level": "string",
    "known_conflicts": "string",
    "specific_clients": "string",
    "tenant": "string",
    "testing_instructions": "string",
    "toggle_name": "string"
}

created: 2026-04-17 04:57:37

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
}

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:49:00",
        "disabled": false,
        "format": "raw",
        "id": 1506,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imstoggle_details"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accompanying_toggles": "string",
            "additional_notes": "string",
            "billing_impact": "string",
            "category": "string",
            "description": "string",
            "disable_risk_level": "string",
            "enable_risk_level": "string",
            "known_conflicts": "string",
            "specific_clients": "string",
            "tenant": "string",
            "testing_instructions": "string",
            "toggle_name": "string"
        },
        "created": "2026-04-17 04:57:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstoggle_details`\n(\n `tenant`  string , `toggle_name`  string , `category`  string , `enable_risk_level`  string , `disable_risk_level`  string , `billing_impact`  string , `description`  string , `accompanying_toggles`  string , `known_conflicts`  string , `specific_clients`  string , `testing_instructions`  string , `additional_notes`  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_imstoggle_details/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstoggle_details`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstoggle_details"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}