Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostatementspreferenceset

created: 2023-10-17 01:57:43
disabled: False
format: raw
id: 1668
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717769

created: 2026-04-17 03:10:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-17/1776412852
id: 1717769
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 162167792
updated: 2026-04-17 03:10:27

Version 1716524

created: 2026-04-16 03:12:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-16/1776326606
id: 1716524
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 162111976
updated: 2026-04-16 03:12:45

Version 1715280

created: 2026-04-15 03:08:01

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-15/1776240076
id: 1715280
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 162056031
updated: 2026-04-15 03:08:15

Version 1714145

created: 2026-04-14 03:11:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-14/1776153841
id: 1714145
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 162000665
updated: 2026-04-14 03:11:18

Version 1712834

created: 2026-04-13 03:00:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-13/1776067000
id: 1712834
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161941866
updated: 2026-04-13 03:00:26

Version 1711666

created: 2026-04-12 03:03:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-12/1775980711
id: 1711666
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161893042
updated: 2026-04-12 03:03:24

Version 1710478

created: 2026-04-11 03:07:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-11/1775894479
id: 1710478
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161841267
updated: 2026-04-11 03:07:48

Version 1709244

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-10/1775808237
id: 1709244
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161785930
updated: 2026-04-10 03:06:17

Version 1708193

created: 2026-04-09 03:06:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-09/1775721569
id: 1708193
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161730433
updated: 2026-04-09 03:06:50

Version 1707022

created: 2026-04-08 03:10:21

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-08/1775635398
id: 1707022
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161675687
updated: 2026-04-08 03:10:32

Version 1705780

created: 2026-04-07 02:59:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-07/1775548553
id: 1705780
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161618689
updated: 2026-04-07 03:00:07

Version 1704627

created: 2026-04-06 03:11:14

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-06/1775462513
id: 1704627
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161561775
updated: 2026-04-06 03:11:25

Version 1703300

created: 2026-04-05 03:05:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-05/1775376140
id: 1703300
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161514877
updated: 2026-04-05 03:05:21

Version 1702150

created: 2026-04-04 03:04:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-04/1775289624
id: 1702150
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161460342
updated: 2026-04-04 03:05:04

Version 1700964

created: 2026-04-03 03:10:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStatementsPreferenceSet/2026-04-03/1775203396
id: 1700964
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1668
schema_scan_id: 161401926
updated: 2026-04-03 03:10:52

Schema Scans: 15

Last at 2026-04-17 03:10:15

Scan 162167792

duration: 0:00:11.818975

exit_message:

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

id: 162167792

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/molo_moloStatementsPreferenceSet/2026-04-17/1776412852",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-17/1776412852/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4427176046124728194,
        "service_name": "drive-thru",
        "span_id": 10167021885582141129,
        "trace_id": 11297621675051046639
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-17 03:10:15
success: True
trace_id: 11297621675051046639

Scan 162111976

duration: 0:00:13.989844

exit_message:

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

id: 162111976

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/molo_moloStatementsPreferenceSet/2026-04-16/1776326606",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-16/1776326606/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 558027196749240566,
        "service_name": "drive-thru",
        "span_id": 2790496425080463402,
        "trace_id": 15872109496333720806
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-16 03:12:31
success: True
trace_id: 15872109496333720806

Scan 162056031

duration: 0:00:14.063744

exit_message:

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

id: 162056031

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/molo_moloStatementsPreferenceSet/2026-04-15/1776240076",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-15/1776240076/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17202802917879714526,
        "service_name": "drive-thru",
        "span_id": 17917534361533992702,
        "trace_id": 10651510178814873212
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-15 03:08:01
success: True
trace_id: 10651510178814873212

Scan 162000665

duration: 0:00:14.251118

exit_message:

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

id: 162000665

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/molo_moloStatementsPreferenceSet/2026-04-14/1776153841",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-14/1776153841/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12194436516064671904,
        "service_name": "drive-thru",
        "span_id": 677517738566619990,
        "trace_id": 7010423443653935871
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-14 03:11:04
success: True
trace_id: 7010423443653935871

Scan 161941866

duration: 0:00:11.405700

exit_message:

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

id: 161941866

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/molo_moloStatementsPreferenceSet/2026-04-13/1776067000",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-13/1776067000/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 618724314037968103,
        "service_name": "drive-thru",
        "span_id": 9904297379965320005,
        "trace_id": 3671608362014918347
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-13 03:00:15
success: True
trace_id: 3671608362014918347

Scan 161893042

duration: 0:00:11.495496

exit_message:

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

id: 161893042

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/molo_moloStatementsPreferenceSet/2026-04-12/1775980711",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-12/1775980711/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 420675586756546836,
        "service_name": "drive-thru",
        "span_id": 14493853341409546169,
        "trace_id": 5974765704506287463
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-12 03:03:12
success: True
trace_id: 5974765704506287463

Scan 161841267

duration: 0:00:13.972833

exit_message:

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

id: 161841267

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/molo_moloStatementsPreferenceSet/2026-04-11/1775894479",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-11/1775894479/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17517763755121473591,
        "service_name": "drive-thru",
        "span_id": 8697385452102528948,
        "trace_id": 7780747462700455566
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-11 03:07:34
success: True
trace_id: 7780747462700455566

Scan 161785930

duration: 0:00:11.531450

exit_message:

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

id: 161785930

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/molo_moloStatementsPreferenceSet/2026-04-10/1775808237",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-10/1775808237/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15566309415406287531,
        "service_name": "drive-thru",
        "span_id": 15619281237867667985,
        "trace_id": 17792495886074468724
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-10 03:06:05
success: True
trace_id: 17792495886074468724

Scan 161730433

duration: 0:00:11.415536

exit_message:

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

id: 161730433

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/molo_moloStatementsPreferenceSet/2026-04-09/1775721569",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-09/1775721569/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3676997066513854323,
        "service_name": "drive-thru",
        "span_id": 3084905115146330275,
        "trace_id": 18172128924917690844
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-09 03:06:39
success: True
trace_id: 18172128924917690844

Scan 161675687

duration: 0:00:11.482298

exit_message:

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

id: 161675687

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/molo_moloStatementsPreferenceSet/2026-04-08/1775635398",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-08/1775635398/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14384486024266107601,
        "service_name": "drive-thru",
        "span_id": 15719770066340784373,
        "trace_id": 5396811456884828512
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-08 03:10:21
success: True
trace_id: 5396811456884828512

Scan 161618689

duration: 0:00:14.015626

exit_message:

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

id: 161618689

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/molo_moloStatementsPreferenceSet/2026-04-07/1775548553",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-07/1775548553/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9549392416470376572,
        "service_name": "drive-thru",
        "span_id": 1241265523488655595,
        "trace_id": 7085707780204642061
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-07 02:59:53
success: True
trace_id: 7085707780204642061

Scan 161561775

duration: 0:00:11.652544

exit_message:

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

id: 161561775

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/molo_moloStatementsPreferenceSet/2026-04-06/1775462513",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-06/1775462513/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1615327594271325570,
        "service_name": "drive-thru",
        "span_id": 7024988736806543371,
        "trace_id": 8415467338033722120
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-06 03:11:13
success: True
trace_id: 8415467338033722120

Scan 161514877

duration: 0:00:14.061275

exit_message:

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

id: 161514877

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/molo_moloStatementsPreferenceSet/2026-04-05/1775376140",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-05/1775376140/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2106878942643660317,
        "service_name": "drive-thru",
        "span_id": 5226395212208151450,
        "trace_id": 2007705082288992506
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-05 03:05:07
success: True
trace_id: 2007705082288992506

Scan 161460342

duration: 0:00:11.408878

exit_message:

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

id: 161460342

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/molo_moloStatementsPreferenceSet/2026-04-04/1775289624",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-04/1775289624/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5377992882282098441,
        "service_name": "drive-thru",
        "span_id": 16917307218611144952,
        "trace_id": 17731075216855786196
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-04 03:04:53
success: True
trace_id: 17731075216855786196

Scan 161401926

duration: 0:00:11.506030

exit_message:

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

id: 161401926

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/molo_moloStatementsPreferenceSet/2026-04-03/1775203396",
        "key": "raw/molo_moloStatementsPreferenceSet/2026-04-03/1775203396/StatementsPreferenceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStatementsPreferenceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7881038781623936769,
        "service_name": "drive-thru",
        "span_id": 9270247791926326662,
        "trace_id": 894021344986604801
    }
}

running: False
schema_name_id: 1668
start_time: 2026-04-03 03:10:41
success: True
trace_id: 894021344986604801

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "Name": "string"
}

created: 2026-04-17 03:10:16

ddl:

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

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