Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocashdraweractionsset

created: 2023-10-17 01:55:10
disabled: False
format: raw
id: 1596
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717580

created: 2026-04-17 03:00:43

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 162167219
updated: 2026-04-17 03:00:54

Version 1716318

created: 2026-04-16 03:03:30

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 162111665
updated: 2026-04-16 03:03:41

Version 1715136

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 162055663
updated: 2026-04-15 03:01:20

Version 1714003

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 162000465
updated: 2026-04-14 03:05:40

Version 1712705

created: 2026-04-13 02:55:11

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161941470
updated: 2026-04-13 02:55:24

Version 1711526

created: 2026-04-12 02:57:29

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161892298
updated: 2026-04-12 02:57:42

Version 1710326

created: 2026-04-11 03:01:09

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161840977
updated: 2026-04-11 03:01:23

Version 1709149

created: 2026-04-10 03:01:59

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161785780
updated: 2026-04-10 03:02:11

Version 1708003

created: 2026-04-09 02:57:46

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161729697
updated: 2026-04-09 02:57:57

Version 1706817

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161675353
updated: 2026-04-08 03:02:05

Version 1705623

created: 2026-04-07 02:54:00

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161618300
updated: 2026-04-07 02:54:14

Version 1704391

created: 2026-04-06 03:01:03

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161561341
updated: 2026-04-06 03:01:17

Version 1703177

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161514685
updated: 2026-04-05 03:00:11

Version 1702031

created: 2026-04-04 02:59:48

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161459805
updated: 2026-04-04 02:59:59

Version 1700889

created: 2026-04-03 03:07:40

ddl:

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

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

schema_attributes:

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

schema_name_id: 1596
schema_scan_id: 161401819
updated: 2026-04-03 03:07:51

Schema Scans: 15

Last at 2026-04-17 03:00:43

Scan 162167219

duration: 0:00:11.803935

exit_message:

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

id: 162167219

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_moloCashDrawerActionsSet/2026-04-17/1776412694",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-17/1776412694/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7407279268513593837,
        "service_name": "drive-thru",
        "span_id": 713507879407379792,
        "trace_id": 12866258765108345192
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-17 03:00:43
success: True
trace_id: 12866258765108345192

Scan 162111665

duration: 0:00:11.603214

exit_message:

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

id: 162111665

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_moloCashDrawerActionsSet/2026-04-16/1776326459",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-16/1776326459/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9633784916868352382,
        "service_name": "drive-thru",
        "span_id": 1908738457817784768,
        "trace_id": 1421841738257816469
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-16 03:03:30
success: True
trace_id: 1421841738257816469

Scan 162055663

duration: 0:00:14.114199

exit_message:

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

id: 162055663

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_moloCashDrawerActionsSet/2026-04-15/1776239929",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-15/1776239929/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15640335624279687966,
        "service_name": "drive-thru",
        "span_id": 1909030042067791322,
        "trace_id": 4634589234350134922
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-15 03:01:06
success: True
trace_id: 4634589234350134922

Scan 162000465

duration: 0:00:14.037053

exit_message:

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

id: 162000465

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_moloCashDrawerActionsSet/2026-04-14/1776153653",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-14/1776153653/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6249852638446620686,
        "service_name": "drive-thru",
        "span_id": 10635940656497502860,
        "trace_id": 5131458338011295867
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-14 03:05:26
success: True
trace_id: 5131458338011295867

Scan 161941470

duration: 0:00:14.216837

exit_message:

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

id: 161941470

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_moloCashDrawerActionsSet/2026-04-13/1776066847",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-13/1776066847/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8499244555890735613,
        "service_name": "drive-thru",
        "span_id": 1598583616461991868,
        "trace_id": 11860934841699123582
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-13 02:55:10
success: True
trace_id: 11860934841699123582

Scan 161892298

duration: 0:00:13.975037

exit_message:

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

id: 161892298

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_moloCashDrawerActionsSet/2026-04-12/1775980562",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-12/1775980562/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10069819104721728356,
        "service_name": "drive-thru",
        "span_id": 13040218035228157772,
        "trace_id": 2238663645558495227
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-12 02:57:28
success: True
trace_id: 2238663645558495227

Scan 161840977

duration: 0:00:14.018530

exit_message:

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

id: 161840977

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_moloCashDrawerActionsSet/2026-04-11/1775894323",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-11/1775894323/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10186496574138981918,
        "service_name": "drive-thru",
        "span_id": 15954032135116379488,
        "trace_id": 8298831961822888590
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-11 03:01:09
success: True
trace_id: 8298831961822888590

Scan 161785780

duration: 0:00:11.485831

exit_message:

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

id: 161785780

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_moloCashDrawerActionsSet/2026-04-10/1775808078",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-10/1775808078/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15323994944790531140,
        "service_name": "drive-thru",
        "span_id": 12515418234584606738,
        "trace_id": 2152504349595744492
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-10 03:01:59
success: True
trace_id: 2152504349595744492

Scan 161729697

duration: 0:00:11.583186

exit_message:

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

id: 161729697

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_moloCashDrawerActionsSet/2026-04-09/1775721418",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-09/1775721418/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6412942820535992566,
        "service_name": "drive-thru",
        "span_id": 4133888699105078342,
        "trace_id": 1111698886829401033
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-09 02:57:46
success: True
trace_id: 1111698886829401033

Scan 161675353

duration: 0:00:14.009900

exit_message:

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

id: 161675353

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_moloCashDrawerActionsSet/2026-04-08/1775635225",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-08/1775635225/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14356828865811797616,
        "service_name": "drive-thru",
        "span_id": 6366052148045739514,
        "trace_id": 12187186911021316497
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-08 03:01:51
success: True
trace_id: 12187186911021316497

Scan 161618300

duration: 0:00:13.991739

exit_message:

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

id: 161618300

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_moloCashDrawerActionsSet/2026-04-07/1775548398",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-07/1775548398/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16406850703578835109,
        "service_name": "drive-thru",
        "span_id": 16337246610272028136,
        "trace_id": 18338085269048736314
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-07 02:54:00
success: True
trace_id: 18338085269048736314

Scan 161561341

duration: 0:00:14.154410

exit_message:

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

id: 161561341

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_moloCashDrawerActionsSet/2026-04-06/1775462362",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-06/1775462362/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6264279162925709214,
        "service_name": "drive-thru",
        "span_id": 6351508024446185908,
        "trace_id": 2241921140981722616
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-06 03:01:03
success: True
trace_id: 2241921140981722616

Scan 161514685

duration: 0:00:14.126431

exit_message:

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

id: 161514685

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_moloCashDrawerActionsSet/2026-04-05/1775375990",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-05/1775375990/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15357363430827664125,
        "service_name": "drive-thru",
        "span_id": 13076682620019064515,
        "trace_id": 15951967509602600660
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-05 02:59:57
success: True
trace_id: 15951967509602600660

Scan 161459805

duration: 0:00:11.405713

exit_message:

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

id: 161459805

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_moloCashDrawerActionsSet/2026-04-04/1775289476",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-04/1775289476/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16543333100139526084,
        "service_name": "drive-thru",
        "span_id": 3093593545309234291,
        "trace_id": 1876045223827038098
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-04 02:59:47
success: True
trace_id: 1876045223827038098

Scan 161401819

duration: 0:00:11.515964

exit_message:

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

id: 161401819

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_moloCashDrawerActionsSet/2026-04-03/1775203247",
        "key": "raw/molo_moloCashDrawerActionsSet/2026-04-03/1775203247/CashDrawerActionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCashDrawerActionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4066090219566213281,
        "service_name": "drive-thru",
        "span_id": 14845422033165789687,
        "trace_id": 5928636107090817173
    }
}

running: False
schema_name_id: 1596
start_time: 2026-04-03 03:07:39
success: True
trace_id: 5928636107090817173

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:00:43

ddl:

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

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