Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostripepayoutadjustmenttypeset

created: 2023-10-17 01:58:05
disabled: False
format: raw
id: 1677
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717700

created: 2026-04-17 03:07:31

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 162167695
updated: 2026-04-17 03:07:45

Version 1716516

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 162111963
updated: 2026-04-16 03:12:27

Version 1715298

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 162056076
updated: 2026-04-15 03:09:09

Version 1714133

created: 2026-04-14 03:10:38

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 162000652
updated: 2026-04-14 03:10:52

Version 1712922

created: 2026-04-13 03:04:40

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161942650
updated: 2026-04-13 03:04:51

Version 1711692

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161893304
updated: 2026-04-12 03:05:14

Version 1710417

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161841198
updated: 2026-04-11 03:05:29

Version 1709401

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161786105
updated: 2026-04-10 03:12:19

Version 1708235

created: 2026-04-09 03:08:22

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161730501
updated: 2026-04-09 03:08:35

Version 1707033

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161675697
updated: 2026-04-08 03:10:56

Version 1705806

created: 2026-04-07 03:01:33

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161619137
updated: 2026-04-07 03:01:44

Version 1704618

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161561766
updated: 2026-04-06 03:11:05

Version 1703418

created: 2026-04-05 03:09:46

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161515003
updated: 2026-04-05 03:10:00

Version 1702288

created: 2026-04-04 03:11:35

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161460617
updated: 2026-04-04 03:11:49

Version 1700977

created: 2026-04-03 03:11:15

ddl:

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

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

schema_attributes:

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

schema_name_id: 1677
schema_scan_id: 161401947
updated: 2026-04-03 03:11:26

Schema Scans: 15

Last at 2026-04-17 03:07:30

Scan 162167695

duration: 0:00:14.168418

exit_message:

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

id: 162167695

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_moloStripePayoutAdjustmentTypeSet/2026-04-17/1776412990",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-17/1776412990/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1810047416806637750,
        "service_name": "drive-thru",
        "span_id": 6173501171423653390,
        "trace_id": 8919812532289164788
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-17 03:07:30
success: True
trace_id: 8919812532289164788

Scan 162111963

duration: 0:00:13.975475

exit_message:

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

id: 162111963

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_moloStripePayoutAdjustmentTypeSet/2026-04-16/1776326692",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-16/1776326692/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10213871952133781454,
        "service_name": "drive-thru",
        "span_id": 590754666484905475,
        "trace_id": 3503212648359396930
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-16 03:12:13
success: True
trace_id: 3503212648359396930

Scan 162056076

duration: 0:00:13.951239

exit_message:

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

id: 162056076

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_moloStripePayoutAdjustmentTypeSet/2026-04-15/1776240178",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-15/1776240178/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5060616311674327545,
        "service_name": "drive-thru",
        "span_id": 2955833381826122260,
        "trace_id": 14523478953187148857
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-15 03:08:55
success: True
trace_id: 14523478953187148857

Scan 162000652

duration: 0:00:14.250309

exit_message:

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

id: 162000652

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_moloStripePayoutAdjustmentTypeSet/2026-04-14/1776154123",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-14/1776154123/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11025622255742149412,
        "service_name": "drive-thru",
        "span_id": 5499278551460568408,
        "trace_id": 15868895768084500705
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-14 03:10:38
success: True
trace_id: 15868895768084500705

Scan 161942650

duration: 0:00:11.578147

exit_message:

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

id: 161942650

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_moloStripePayoutAdjustmentTypeSet/2026-04-13/1776067123",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-13/1776067123/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2118463607812162757,
        "service_name": "drive-thru",
        "span_id": 643246394833583657,
        "trace_id": 5852285884715809099
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-13 03:04:39
success: True
trace_id: 5852285884715809099

Scan 161893304

duration: 0:00:11.498502

exit_message:

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

id: 161893304

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_moloStripePayoutAdjustmentTypeSet/2026-04-12/1775980819",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-12/1775980819/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7243977790469712985,
        "service_name": "drive-thru",
        "span_id": 11839339790121001701,
        "trace_id": 5901283881477080667
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-12 03:05:03
success: True
trace_id: 5901283881477080667

Scan 161841198

duration: 0:00:13.954010

exit_message:

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

id: 161841198

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_moloStripePayoutAdjustmentTypeSet/2026-04-11/1775894592",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-11/1775894592/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12506924968601494419,
        "service_name": "drive-thru",
        "span_id": 13813705688924873964,
        "trace_id": 7871982894047303269
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-11 03:05:15
success: True
trace_id: 7871982894047303269

Scan 161786105

duration: 0:00:11.592161

exit_message:

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

id: 161786105

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_moloStripePayoutAdjustmentTypeSet/2026-04-10/1775808352",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-10/1775808352/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6411466777109004682,
        "service_name": "drive-thru",
        "span_id": 15884224626248085177,
        "trace_id": 17958014039639594832
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-10 03:12:07
success: True
trace_id: 17958014039639594832

Scan 161730501

duration: 0:00:14.069644

exit_message:

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

id: 161730501

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_moloStripePayoutAdjustmentTypeSet/2026-04-09/1775721682",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-09/1775721682/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17100664911238049898,
        "service_name": "drive-thru",
        "span_id": 15821240267220667927,
        "trace_id": 7483277956154418570
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-09 03:08:21
success: True
trace_id: 7483277956154418570

Scan 161675697

duration: 0:00:11.493644

exit_message:

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

id: 161675697

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_moloStripePayoutAdjustmentTypeSet/2026-04-08/1775635524",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-08/1775635524/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16068762262995101764,
        "service_name": "drive-thru",
        "span_id": 12668500920351280703,
        "trace_id": 2332748630408230932
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-08 03:10:45
success: True
trace_id: 2332748630408230932

Scan 161619137

duration: 0:00:11.610644

exit_message:

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

id: 161619137

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_moloStripePayoutAdjustmentTypeSet/2026-04-07/1775548677",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-07/1775548677/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12059886734469002719,
        "service_name": "drive-thru",
        "span_id": 3471821964385905100,
        "trace_id": 3310121244656322586
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-07 03:01:33
success: True
trace_id: 3310121244656322586

Scan 161561766

duration: 0:00:11.549376

exit_message:

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

id: 161561766

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_moloStripePayoutAdjustmentTypeSet/2026-04-06/1775462627",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-06/1775462627/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10370402029720284395,
        "service_name": "drive-thru",
        "span_id": 16605994435461496691,
        "trace_id": 6059873188315352547
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-06 03:10:54
success: True
trace_id: 6059873188315352547

Scan 161515003

duration: 0:00:13.957289

exit_message:

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

id: 161515003

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_moloStripePayoutAdjustmentTypeSet/2026-04-05/1775376255",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-05/1775376255/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15593116175881481755,
        "service_name": "drive-thru",
        "span_id": 13248705634975976200,
        "trace_id": 9342915972834567142
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-05 03:09:46
success: True
trace_id: 9342915972834567142

Scan 161460617

duration: 0:00:14.057122

exit_message:

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

id: 161460617

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_moloStripePayoutAdjustmentTypeSet/2026-04-04/1775289739",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-04/1775289739/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13544709636820715801,
        "service_name": "drive-thru",
        "span_id": 8448492279862850214,
        "trace_id": 10638999758132064501
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-04 03:11:35
success: True
trace_id: 10638999758132064501

Scan 161401947

duration: 0:00:11.445078

exit_message:

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

id: 161401947

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_moloStripePayoutAdjustmentTypeSet/2026-04-03/1775203509",
        "key": "raw/molo_moloStripePayoutAdjustmentTypeSet/2026-04-03/1775203509/StripePayoutAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripePayoutAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5783738376713780595,
        "service_name": "drive-thru",
        "span_id": 8370623855749969186,
        "trace_id": 11324658652583848772
    }
}

running: False
schema_name_id: 1677
start_time: 2026-04-03 03:11:15
success: True
trace_id: 11324658652583848772

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:07:31

ddl:

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

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