Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloinventoryadjustmenttypeset

created: 2023-10-17 01:56:36
disabled: False
format: raw
id: 1636
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717608

created: 2026-04-17 03:02:33

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 162167388
updated: 2026-04-17 03:02:47

Version 1716386

created: 2026-04-16 03:07:15

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 162111799
updated: 2026-04-16 03:07:26

Version 1715177

created: 2026-04-15 03:03:21

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 162055840
updated: 2026-04-15 03:03:34

Version 1714002

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 162000462
updated: 2026-04-14 03:05:35

Version 1712759

created: 2026-04-13 02:57:26

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161941573
updated: 2026-04-13 02:57:40

Version 1711553

created: 2026-04-12 02:59:04

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161892409
updated: 2026-04-12 02:59:15

Version 1710363

created: 2026-04-11 03:02:52

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161841083
updated: 2026-04-11 03:03:03

Version 1709188

created: 2026-04-10 03:03:58

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161785868
updated: 2026-04-10 03:04:12

Version 1708066

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161730034
updated: 2026-04-09 03:01:24

Version 1706909

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161675531
updated: 2026-04-08 03:06:02

Version 1705679

created: 2026-04-07 02:56:06

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161618368
updated: 2026-04-07 02:56:17

Version 1704426

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161561440
updated: 2026-04-06 03:02:54

Version 1703195

created: 2026-04-05 03:00:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161514745
updated: 2026-04-05 03:01:02

Version 1702088

created: 2026-04-04 03:02:07

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161460028
updated: 2026-04-04 03:02:20

Version 1700897

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1636
schema_scan_id: 161401839
updated: 2026-04-03 03:08:21

Schema Scans: 15

Last at 2026-04-17 03:02:32

Scan 162167388

duration: 0:00:14.342262

exit_message:

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

id: 162167388

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_moloInventoryAdjustmentTypeSet/2026-04-17/1776412733",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-17/1776412733/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11550011666208224651,
        "service_name": "drive-thru",
        "span_id": 8505642576703793708,
        "trace_id": 7624774598829971565
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-17 03:02:32
success: True
trace_id: 7624774598829971565

Scan 162111799

duration: 0:00:11.520629

exit_message:

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

id: 162111799

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_moloInventoryAdjustmentTypeSet/2026-04-16/1776326491",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-16/1776326491/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17379658040534520401,
        "service_name": "drive-thru",
        "span_id": 2971626080465569215,
        "trace_id": 14674335307005181698
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-16 03:07:15
success: True
trace_id: 14674335307005181698

Scan 162055840

duration: 0:00:13.965427

exit_message:

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

id: 162055840

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_moloInventoryAdjustmentTypeSet/2026-04-15/1776239961",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-15/1776239961/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1285260965082523996,
        "service_name": "drive-thru",
        "span_id": 15860165560519081714,
        "trace_id": 1998106711443545697
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-15 03:03:20
success: True
trace_id: 1998106711443545697

Scan 162000462

duration: 0:00:11.521867

exit_message:

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

id: 162000462

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_moloInventoryAdjustmentTypeSet/2026-04-14/1776153688",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-14/1776153688/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10110117491432190179,
        "service_name": "drive-thru",
        "span_id": 17967936857836958463,
        "trace_id": 12393258003334024293
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-14 03:05:24
success: True
trace_id: 12393258003334024293

Scan 161941573

duration: 0:00:14.000991

exit_message:

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

id: 161941573

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_moloInventoryAdjustmentTypeSet/2026-04-13/1776066881",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-13/1776066881/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4524552973169029424,
        "service_name": "drive-thru",
        "span_id": 2485920596641744862,
        "trace_id": 13443194922562906840
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-13 02:57:26
success: True
trace_id: 13443194922562906840

Scan 161892409

duration: 0:00:11.415920

exit_message:

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

id: 161892409

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_moloInventoryAdjustmentTypeSet/2026-04-12/1775980596",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-12/1775980596/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9302580525032895974,
        "service_name": "drive-thru",
        "span_id": 15282724052008057825,
        "trace_id": 2392028837343198343
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-12 02:59:04
success: True
trace_id: 2392028837343198343

Scan 161841083

duration: 0:00:11.555691

exit_message:

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

id: 161841083

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_moloInventoryAdjustmentTypeSet/2026-04-11/1775894357",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-11/1775894357/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 170845628198266149,
        "service_name": "drive-thru",
        "span_id": 7014167573703907209,
        "trace_id": 8688482488938054235
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-11 03:02:51
success: True
trace_id: 8688482488938054235

Scan 161785868

duration: 0:00:14.178973

exit_message:

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

id: 161785868

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_moloInventoryAdjustmentTypeSet/2026-04-10/1775808112",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-10/1775808112/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9148952661443106759,
        "service_name": "drive-thru",
        "span_id": 7975264830921380593,
        "trace_id": 13840338272103837695
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-10 03:03:58
success: True
trace_id: 13840338272103837695

Scan 161730034

duration: 0:00:14.150289

exit_message:

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

id: 161730034

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_moloInventoryAdjustmentTypeSet/2026-04-09/1775721451",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-09/1775721451/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5887290016515245931,
        "service_name": "drive-thru",
        "span_id": 15504272103210533163,
        "trace_id": 13497882146255811891
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-09 03:01:10
success: True
trace_id: 13497882146255811891

Scan 161675531

duration: 0:00:11.586392

exit_message:

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

id: 161675531

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_moloInventoryAdjustmentTypeSet/2026-04-08/1775635259",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-08/1775635259/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8807725492192175884,
        "service_name": "drive-thru",
        "span_id": 16831990994941661880,
        "trace_id": 1150266783014896264
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-08 03:05:51
success: True
trace_id: 1150266783014896264

Scan 161618368

duration: 0:00:11.543917

exit_message:

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

id: 161618368

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_moloInventoryAdjustmentTypeSet/2026-04-07/1775548432",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-07/1775548432/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1755206983808688135,
        "service_name": "drive-thru",
        "span_id": 5353873473415431736,
        "trace_id": 2686655939280087774
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-07 02:56:06
success: True
trace_id: 2686655939280087774

Scan 161561440

duration: 0:00:11.461939

exit_message:

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

id: 161561440

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_moloInventoryAdjustmentTypeSet/2026-04-06/1775462399",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-06/1775462399/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16577573843264750540,
        "service_name": "drive-thru",
        "span_id": 7495034141799477421,
        "trace_id": 5399731751373915237
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-06 03:02:42
success: True
trace_id: 5399731751373915237

Scan 161514745

duration: 0:00:11.478353

exit_message:

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

id: 161514745

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_moloInventoryAdjustmentTypeSet/2026-04-05/1775376023",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-05/1775376023/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17668582857404097387,
        "service_name": "drive-thru",
        "span_id": 16730114452818435576,
        "trace_id": 4123309058819221830
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-05 03:00:51
success: True
trace_id: 4123309058819221830

Scan 161460028

duration: 0:00:14.040190

exit_message:

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

id: 161460028

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_moloInventoryAdjustmentTypeSet/2026-04-04/1775289507",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-04/1775289507/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11806054486511408426,
        "service_name": "drive-thru",
        "span_id": 17624311999577601730,
        "trace_id": 12446958804847392724
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-04 03:02:06
success: True
trace_id: 12446958804847392724

Scan 161401839

duration: 0:00:11.436018

exit_message:

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

id: 161401839

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_moloInventoryAdjustmentTypeSet/2026-04-03/1775203280",
        "key": "raw/molo_moloInventoryAdjustmentTypeSet/2026-04-03/1775203280/InventoryAdjustmentTypeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInventoryAdjustmentTypeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1393847073224287541,
        "service_name": "drive-thru",
        "span_id": 18437419629116495097,
        "trace_id": 2023992202297822102
    }
}

running: False
schema_name_id: 1636
start_time: 2026-04-03 03:08:09
success: True
trace_id: 2023992202297822102

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:02:33

ddl:

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

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