Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imstemp_toggles

created: 2023-06-30 03:31:31
disabled: False
format: raw
id: 1540
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718016

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-17/1776419654
id: 1718016
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 162169372
updated: 2026-04-17 04:58:59

Version 1716772

created: 2026-04-16 05:19:05

ddl:

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

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

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 162114444
updated: 2026-04-16 05:19:16

Version 1715551

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-15/1776242368
id: 1715551
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 162056439
updated: 2026-04-15 03:43:55

Version 1714405

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-14/1776160763
id: 1714405
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 162003146
updated: 2026-04-14 05:05:14

Version 1713174

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

ddl:

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

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

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161945386
updated: 2026-04-13 05:11:30

Version 1711926

created: 2026-04-12 05:05:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-12/1775988166
id: 1711926
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161896375
updated: 2026-04-12 05:05:45

Version 1710764

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-11/1775902581
id: 1710764
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161843986
updated: 2026-04-11 05:20:08

Version 1709593

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

ddl:

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

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

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161788642
updated: 2026-04-10 05:04:17

Version 1708448

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

ddl:

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

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

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161733013
updated: 2026-04-09 05:04:29

Version 1707211

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

ddl:

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

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

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161678370
updated: 2026-04-08 05:13:18

Version 1706046

created: 2026-04-07 05:17:17

ddl:

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

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

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161622124
updated: 2026-04-07 05:17:31

Version 1704839

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-06/1775470539
id: 1704839
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161564314
updated: 2026-04-06 05:19:29

Version 1703599

created: 2026-04-05 04:58:38

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-05/1775382951
id: 1703599
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161516598
updated: 2026-04-05 04:58:49

Version 1702481

created: 2026-04-04 04:58:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstemp_toggles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstemp_toggles`\n(\n `tenant`  string , `id`  string , `toggle_name`  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_imstemp_toggles/2026-04-04/1775296474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstemp_toggles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-04/1775296474
id: 1702481
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161462222
updated: 2026-04-04 04:58:38

Version 1701283

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstemp_toggles/2026-04-03/1775211041
id: 1701283
processed: 1

raw_data:

{
    "id": 1,
    "tenant": 0,
    "toggle_name": 2
}

schema_attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

schema_name_id: 1540
schema_scan_id: 161404884
updated: 2026-04-03 05:14:43

Schema Scans: 15

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

Scan 162169372

duration: 0:00:11.550851

exit_message:

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

id: 162169372

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_imstemp_toggles/2026-04-17/1776419654",
        "key": "raw/stellar_imstemp_toggles/2026-04-17/1776419654/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17601974850134830998,
        "service_name": "drive-thru",
        "span_id": 16978808645288218817,
        "trace_id": 12377000711363958829
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-17 04:58:48
success: True
trace_id: 12377000711363958829

Scan 162114444

duration: 0:00:11.516015

exit_message:

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

id: 162114444

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_imstemp_toggles/2026-04-16/1776334555",
        "key": "raw/stellar_imstemp_toggles/2026-04-16/1776334555/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12511486367940799683,
        "service_name": "drive-thru",
        "span_id": 7629324808769400876,
        "trace_id": 7264117772616952581
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-16 05:19:05
success: True
trace_id: 7264117772616952581

Scan 162056439

duration: 0:00:11.424933

exit_message:

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

id: 162056439

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_imstemp_toggles/2026-04-15/1776242368",
        "key": "raw/stellar_imstemp_toggles/2026-04-15/1776242368/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8806335199842893125,
        "service_name": "drive-thru",
        "span_id": 6360099603321208432,
        "trace_id": 15699966626831574698
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-15 03:43:44
success: True
trace_id: 15699966626831574698

Scan 162003146

duration: 0:00:14.087039

exit_message:

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

id: 162003146

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_imstemp_toggles/2026-04-14/1776160763",
        "key": "raw/stellar_imstemp_toggles/2026-04-14/1776160763/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8469072137857292389,
        "service_name": "drive-thru",
        "span_id": 12966883392229461854,
        "trace_id": 11479971222171903188
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-14 05:05:00
success: True
trace_id: 11479971222171903188

Scan 161945386

duration: 0:00:14.104998

exit_message:

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

id: 161945386

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_imstemp_toggles/2026-04-13/1776074809",
        "key": "raw/stellar_imstemp_toggles/2026-04-13/1776074809/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7547205007936318131,
        "service_name": "drive-thru",
        "span_id": 14517983900965114750,
        "trace_id": 6881444697156258669
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-13 05:11:16
success: True
trace_id: 6881444697156258669

Scan 161896375

duration: 0:00:11.681168

exit_message:

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

id: 161896375

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_imstemp_toggles/2026-04-12/1775988166",
        "key": "raw/stellar_imstemp_toggles/2026-04-12/1775988166/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15278953207917429757,
        "service_name": "drive-thru",
        "span_id": 7996399410563419479,
        "trace_id": 8537575645881889698
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-12 05:05:33
success: True
trace_id: 8537575645881889698

Scan 161843986

duration: 0:00:14.076329

exit_message:

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

id: 161843986

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_imstemp_toggles/2026-04-11/1775902581",
        "key": "raw/stellar_imstemp_toggles/2026-04-11/1775902581/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12613722023540960371,
        "service_name": "drive-thru",
        "span_id": 15778904311763469703,
        "trace_id": 2673788102956953006
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-11 05:19:54
success: True
trace_id: 2673788102956953006

Scan 161788642

duration: 0:00:11.670139

exit_message:

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

id: 161788642

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_imstemp_toggles/2026-04-10/1775815222",
        "key": "raw/stellar_imstemp_toggles/2026-04-10/1775815222/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11097605838249784572,
        "service_name": "drive-thru",
        "span_id": 13784411570343683727,
        "trace_id": 3540605038947485191
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-10 05:04:05
success: True
trace_id: 3540605038947485191

Scan 161733013

duration: 0:00:14.082316

exit_message:

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

id: 161733013

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_imstemp_toggles/2026-04-09/1775728844",
        "key": "raw/stellar_imstemp_toggles/2026-04-09/1775728844/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14747442838813353401,
        "service_name": "drive-thru",
        "span_id": 2171023635178851205,
        "trace_id": 6016786927236779666
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-09 05:04:15
success: True
trace_id: 6016786927236779666

Scan 161678370

duration: 0:00:11.551283

exit_message:

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

id: 161678370

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_imstemp_toggles/2026-04-08/1775642997",
        "key": "raw/stellar_imstemp_toggles/2026-04-08/1775642997/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6557558146673028157,
        "service_name": "drive-thru",
        "span_id": 6288014194513556446,
        "trace_id": 15270722592266983145
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-08 05:13:06
success: True
trace_id: 15270722592266983145

Scan 161622124

duration: 0:00:14.185313

exit_message:

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

id: 161622124

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_imstemp_toggles/2026-04-07/1775556863",
        "key": "raw/stellar_imstemp_toggles/2026-04-07/1775556863/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5691470443026472279,
        "service_name": "drive-thru",
        "span_id": 17787292196993061500,
        "trace_id": 15727327888565602865
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-07 05:17:17
success: True
trace_id: 15727327888565602865

Scan 161564314

duration: 0:00:11.460412

exit_message:

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

id: 161564314

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_imstemp_toggles/2026-04-06/1775470539",
        "key": "raw/stellar_imstemp_toggles/2026-04-06/1775470539/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5148974781498219328,
        "service_name": "drive-thru",
        "span_id": 15593217341492428643,
        "trace_id": 291591206354010931
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-06 05:19:18
success: True
trace_id: 291591206354010931

Scan 161516598

duration: 0:00:11.527163

exit_message:

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

id: 161516598

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_imstemp_toggles/2026-04-05/1775382951",
        "key": "raw/stellar_imstemp_toggles/2026-04-05/1775382951/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17349244108094162790,
        "service_name": "drive-thru",
        "span_id": 2856978684927731248,
        "trace_id": 11661360295017724454
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-05 04:58:38
success: True
trace_id: 11661360295017724454

Scan 161462222

duration: 0:00:11.432999

exit_message:

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

id: 161462222

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_imstemp_toggles/2026-04-04/1775296474",
        "key": "raw/stellar_imstemp_toggles/2026-04-04/1775296474/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12212888512780339315,
        "service_name": "drive-thru",
        "span_id": 12982171513106839009,
        "trace_id": 2266450541944021894
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-04 04:58:26
success: True
trace_id: 2266450541944021894

Scan 161404884

duration: 0:00:14.043979

exit_message:

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

id: 161404884

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_imstemp_toggles/2026-04-03/1775211041",
        "key": "raw/stellar_imstemp_toggles/2026-04-03/1775211041/temp_toggles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstemp_toggles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8808849488417268850,
        "service_name": "drive-thru",
        "span_id": 12769193770725532293,
        "trace_id": 6735456635153677904
    }
}

running: False
schema_name_id: 1540
start_time: 2026-04-03 05:14:29
success: True
trace_id: 6735456635153677904

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "tenant": "string",
    "toggle_name": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstemp_toggles`\n(\n `tenant`  string , `id`  string , `toggle_name`  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_imstemp_toggles/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstemp_toggles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstemp_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-06-30 03:31:31",
        "disabled": false,
        "format": "raw",
        "id": 1540,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imstemp_toggles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "tenant": "string",
            "toggle_name": "string"
        },
        "created": "2026-04-17 04:58:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstemp_toggles`\n(\n `tenant`  string , `id`  string , `toggle_name`  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_imstemp_toggles/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstemp_toggles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstemp_toggles"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}