Schema Info

Schema Name: sfdl_prod_drivethru.molo_molorecurringinvoiceoptionsset

created: 2023-10-17 01:59:04
disabled: False
format: raw
id: 1705
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717646

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 162167608
updated: 2026-04-17 03:05:11

Version 1716370

created: 2026-04-16 03:06:21

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 162111769
updated: 2026-04-16 03:06:35

Version 1715213

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 162055938
updated: 2026-04-15 03:05:33

Version 1714056

created: 2026-04-14 03:07:39

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 162000550
updated: 2026-04-14 03:07:53

Version 1712814

created: 2026-04-13 02:59:40

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161941788
updated: 2026-04-13 02:59:54

Version 1711649

created: 2026-04-12 03:02:36

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161892945
updated: 2026-04-12 03:02:47

Version 1710439

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161841225
updated: 2026-04-11 03:06:21

Version 1709234

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161785919
updated: 2026-04-10 03:05:54

Version 1708179

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161730406
updated: 2026-04-09 03:06:15

Version 1706999

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161675658
updated: 2026-04-08 03:09:43

Version 1705759

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161618578
updated: 2026-04-07 02:59:38

Version 1704616

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161561764
updated: 2026-04-06 03:11:03

Version 1703396

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161514981
updated: 2026-04-05 03:09:07

Version 1702134

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161460314
updated: 2026-04-04 03:04:26

Version 1700945

created: 2026-04-03 03:09:58

ddl:

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

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

schema_attributes:

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

schema_name_id: 1705
schema_scan_id: 161401903
updated: 2026-04-03 03:10:12

Schema Scans: 15

Last at 2026-04-17 03:04:59

Scan 162167608

duration: 0:00:11.613720

exit_message:

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

id: 162167608

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_moloRecurringInvoiceOptionsSet/2026-04-17/1776412841",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-17/1776412841/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9265478950312356737,
        "service_name": "drive-thru",
        "span_id": 17795134345311103135,
        "trace_id": 4046822632358205882
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-17 03:04:59
success: True
trace_id: 4046822632358205882

Scan 162111769

duration: 0:00:13.998751

exit_message:

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

id: 162111769

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_moloRecurringInvoiceOptionsSet/2026-04-16/1776326595",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-16/1776326595/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12369115186435188891,
        "service_name": "drive-thru",
        "span_id": 12026135886822841894,
        "trace_id": 16633156798963278911
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-16 03:06:21
success: True
trace_id: 16633156798963278911

Scan 162055938

duration: 0:00:11.425743

exit_message:

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

id: 162055938

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_moloRecurringInvoiceOptionsSet/2026-04-15/1776240065",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-15/1776240065/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12099703961197508557,
        "service_name": "drive-thru",
        "span_id": 12397945744660313002,
        "trace_id": 10661953444974264274
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-15 03:05:22
success: True
trace_id: 10661953444974264274

Scan 162000550

duration: 0:00:14.118488

exit_message:

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

id: 162000550

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_moloRecurringInvoiceOptionsSet/2026-04-14/1776153825",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-14/1776153825/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11594203283761871264,
        "service_name": "drive-thru",
        "span_id": 7566919309205111353,
        "trace_id": 1008190974524667376
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-14 03:07:39
success: True
trace_id: 1008190974524667376

Scan 161941788

duration: 0:00:13.981794

exit_message:

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

id: 161941788

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_moloRecurringInvoiceOptionsSet/2026-04-13/1776066989",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-13/1776066989/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17393569209824705869,
        "service_name": "drive-thru",
        "span_id": 16157065118808336611,
        "trace_id": 12107033090388500719
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-13 02:59:40
success: True
trace_id: 12107033090388500719

Scan 161892945

duration: 0:00:11.533058

exit_message:

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

id: 161892945

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_moloRecurringInvoiceOptionsSet/2026-04-12/1775980700",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-12/1775980700/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16374359105776855762,
        "service_name": "drive-thru",
        "span_id": 17898961358593434365,
        "trace_id": 11097251759575379818
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-12 03:02:36
success: True
trace_id: 11097251759575379818

Scan 161841225

duration: 0:00:14.020893

exit_message:

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

id: 161841225

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_moloRecurringInvoiceOptionsSet/2026-04-11/1775894467",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-11/1775894467/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11950890748615177338,
        "service_name": "drive-thru",
        "span_id": 12298520693799798699,
        "trace_id": 12870516374551421192
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-11 03:06:07
success: True
trace_id: 12870516374551421192

Scan 161785919

duration: 0:00:11.483727

exit_message:

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

id: 161785919

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_moloRecurringInvoiceOptionsSet/2026-04-10/1775808225",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-10/1775808225/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7521027000913602826,
        "service_name": "drive-thru",
        "span_id": 2414559813600867786,
        "trace_id": 13211798111038290383
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-10 03:05:43
success: True
trace_id: 13211798111038290383

Scan 161730406

duration: 0:00:11.478702

exit_message:

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

id: 161730406

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_moloRecurringInvoiceOptionsSet/2026-04-09/1775721558",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-09/1775721558/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17443974258509203342,
        "service_name": "drive-thru",
        "span_id": 17923542660063373935,
        "trace_id": 13035575914240838822
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-09 03:06:04
success: True
trace_id: 13035575914240838822

Scan 161675658

duration: 0:00:14.109555

exit_message:

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

id: 161675658

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_moloRecurringInvoiceOptionsSet/2026-04-08/1775635386",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-08/1775635386/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11252135345135536970,
        "service_name": "drive-thru",
        "span_id": 15511792897302012912,
        "trace_id": 18018552638923736877
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-08 03:09:29
success: True
trace_id: 18018552638923736877

Scan 161618578

duration: 0:00:22.990219

exit_message:

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

id: 161618578

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_moloRecurringInvoiceOptionsSet/2026-04-07/1775548541",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-07/1775548541/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 595557718888701127,
        "service_name": "drive-thru",
        "span_id": 7687718734541009453,
        "trace_id": 2527499654572460400
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-07 02:59:15
success: True
trace_id: 2527499654572460400

Scan 161561764

duration: 0:00:14.126687

exit_message:

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

id: 161561764

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_moloRecurringInvoiceOptionsSet/2026-04-06/1775462503",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-06/1775462503/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10604135891888263844,
        "service_name": "drive-thru",
        "span_id": 15733288764851897523,
        "trace_id": 13201878765252661160
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-06 03:10:49
success: True
trace_id: 13201878765252661160

Scan 161514981

duration: 0:00:11.425962

exit_message:

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

id: 161514981

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_moloRecurringInvoiceOptionsSet/2026-04-05/1775376129",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-05/1775376129/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1788861206175843218,
        "service_name": "drive-thru",
        "span_id": 2954836228501635830,
        "trace_id": 2096829624431862886
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-05 03:08:55
success: True
trace_id: 2096829624431862886

Scan 161460314

duration: 0:00:11.523544

exit_message:

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

id: 161460314

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_moloRecurringInvoiceOptionsSet/2026-04-04/1775289612",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-04/1775289612/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14666985930331045579,
        "service_name": "drive-thru",
        "span_id": 874130009106514042,
        "trace_id": 14566579305783808678
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-04 03:04:15
success: True
trace_id: 14566579305783808678

Scan 161401903

duration: 0:00:14.195367

exit_message:

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

id: 161401903

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_moloRecurringInvoiceOptionsSet/2026-04-03/1775203385",
        "key": "raw/molo_moloRecurringInvoiceOptionsSet/2026-04-03/1775203385/RecurringInvoiceOptionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceOptionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6591514267399857303,
        "service_name": "drive-thru",
        "span_id": 929676853136183914,
        "trace_id": 5639729708411967192
    }
}

running: False
schema_name_id: 1705
start_time: 2026-04-03 03:09:58
success: True
trace_id: 5639729708411967192

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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