Schema Info

Schema Name: sfdl_prod_drivethru.molo_molotransientinvoicingmethodset

created: 2023-10-17 02:00:06
disabled: False
format: raw
id: 1735
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717825

created: 2026-04-17 03:13:32

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 162167861
updated: 2026-04-17 03:13:43

Version 1716510

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 162111955
updated: 2026-04-16 03:12:15

Version 1715383

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 162056192
updated: 2026-04-15 03:13:24

Version 1714194

created: 2026-04-14 03:12:54

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 162000718
updated: 2026-04-14 03:13:05

Version 1712959

created: 2026-04-13 03:06:29

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161942771
updated: 2026-04-13 03:06:43

Version 1711713

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161893376
updated: 2026-04-12 03:06:27

Version 1710567

created: 2026-04-11 03:11:13

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161841375
updated: 2026-04-11 03:11:24

Version 1709370

created: 2026-04-10 03:10:52

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161786070
updated: 2026-04-10 03:11:03

Version 1708185

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161730421
updated: 2026-04-09 03:06:32

Version 1706968

created: 2026-04-08 03:08:17

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161675624
updated: 2026-04-08 03:08:28

Version 1705843

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161619328
updated: 2026-04-07 03:03:19

Version 1704565

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161561685
updated: 2026-04-06 03:08:59

Version 1703420

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161515005
updated: 2026-04-05 03:10:02

Version 1702252

created: 2026-04-04 03:09:52

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161460551
updated: 2026-04-04 03:10:06

Version 1701090

created: 2026-04-03 03:18:48

ddl:

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

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

schema_attributes:

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

schema_name_id: 1735
schema_scan_id: 161402093
updated: 2026-04-03 03:19:02

Schema Scans: 15

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

Scan 162167861

duration: 0:00:11.496396

exit_message:

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

id: 162167861

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_moloTransientInvoicingMethodSet/2026-04-17/1776413223",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-17/1776413223/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8438008929587684988,
        "service_name": "drive-thru",
        "span_id": 10986690268897959142,
        "trace_id": 279422609538121772
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-17 03:13:32
success: True
trace_id: 279422609538121772

Scan 162111955

duration: 0:00:14.119186

exit_message:

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

id: 162111955

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_moloTransientInvoicingMethodSet/2026-04-16/1776326746",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-16/1776326746/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8618423126920710486,
        "service_name": "drive-thru",
        "span_id": 13167435012144766405,
        "trace_id": 8405261741016772980
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-16 03:12:01
success: True
trace_id: 8405261741016772980

Scan 162056192

duration: 0:00:11.548916

exit_message:

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

id: 162056192

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_moloTransientInvoicingMethodSet/2026-04-15/1776240206",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-15/1776240206/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16169028541136628332,
        "service_name": "drive-thru",
        "span_id": 1231357481637455867,
        "trace_id": 15385089051983775547
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-15 03:13:12
success: True
trace_id: 15385089051983775547

Scan 162000718

duration: 0:00:11.584396

exit_message:

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

id: 162000718

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_moloTransientInvoicingMethodSet/2026-04-14/1776154171",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-14/1776154171/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10460411496547649891,
        "service_name": "drive-thru",
        "span_id": 10698333467207403140,
        "trace_id": 1570269727868883428
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-14 03:12:54
success: True
trace_id: 1570269727868883428

Scan 161942771

duration: 0:00:14.035248

exit_message:

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

id: 161942771

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_moloTransientInvoicingMethodSet/2026-04-13/1776067166",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-13/1776067166/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17257896726343675819,
        "service_name": "drive-thru",
        "span_id": 17763029518757854718,
        "trace_id": 11531177378033123957
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-13 03:06:29
success: True
trace_id: 11531177378033123957

Scan 161893376

duration: 0:00:11.442154

exit_message:

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

id: 161893376

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_moloTransientInvoicingMethodSet/2026-04-12/1775980867",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-12/1775980867/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7188680082428719185,
        "service_name": "drive-thru",
        "span_id": 7896882282030037192,
        "trace_id": 10416590671444817609
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-12 03:06:15
success: True
trace_id: 10416590671444817609

Scan 161841375

duration: 0:00:11.399103

exit_message:

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

id: 161841375

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_moloTransientInvoicingMethodSet/2026-04-11/1775894642",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-11/1775894642/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15453553562880150568,
        "service_name": "drive-thru",
        "span_id": 16189779756321746377,
        "trace_id": 18114038720692352083
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-11 03:11:13
success: True
trace_id: 18114038720692352083

Scan 161786070

duration: 0:00:11.538824

exit_message:

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

id: 161786070

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_moloTransientInvoicingMethodSet/2026-04-10/1775808399",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-10/1775808399/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12670339374977878038,
        "service_name": "drive-thru",
        "span_id": 12708759591176246864,
        "trace_id": 17156812456111003520
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-10 03:10:52
success: True
trace_id: 17156812456111003520

Scan 161730421

duration: 0:00:11.517399

exit_message:

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

id: 161730421

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_moloTransientInvoicingMethodSet/2026-04-09/1775721727",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-09/1775721727/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16521424226582966341,
        "service_name": "drive-thru",
        "span_id": 5425059509487324718,
        "trace_id": 15281472864422755871
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-09 03:06:20
success: True
trace_id: 15281472864422755871

Scan 161675624

duration: 0:00:11.535994

exit_message:

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

id: 161675624

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_moloTransientInvoicingMethodSet/2026-04-08/1775635558",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-08/1775635558/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13774937932914538360,
        "service_name": "drive-thru",
        "span_id": 6652040258289864589,
        "trace_id": 3004135710957459764
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-08 03:08:16
success: True
trace_id: 3004135710957459764

Scan 161619328

duration: 0:00:14.082906

exit_message:

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

id: 161619328

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_moloTransientInvoicingMethodSet/2026-04-07/1775548717",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-07/1775548717/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7099907654374742627,
        "service_name": "drive-thru",
        "span_id": 12322262961559540553,
        "trace_id": 12711497576425321281
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-07 03:03:05
success: True
trace_id: 12711497576425321281

Scan 161561685

duration: 0:00:14.021416

exit_message:

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

id: 161561685

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_moloTransientInvoicingMethodSet/2026-04-06/1775462669",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-06/1775462669/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16826589388544402363,
        "service_name": "drive-thru",
        "span_id": 12423620058182627135,
        "trace_id": 12363318429520503043
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-06 03:08:45
success: True
trace_id: 12363318429520503043

Scan 161515005

duration: 0:00:14.099832

exit_message:

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

id: 161515005

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_moloTransientInvoicingMethodSet/2026-04-05/1775376298",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-05/1775376298/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16302341984571435454,
        "service_name": "drive-thru",
        "span_id": 7980830754607197885,
        "trace_id": 15458302597477038054
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-05 03:09:47
success: True
trace_id: 15458302597477038054

Scan 161460551

duration: 0:00:13.955392

exit_message:

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

id: 161460551

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_moloTransientInvoicingMethodSet/2026-04-04/1775289782",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-04/1775289782/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5047005426288576821,
        "service_name": "drive-thru",
        "span_id": 1334366070787469542,
        "trace_id": 12431428559159486510
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-04 03:09:52
success: True
trace_id: 12431428559159486510

Scan 161402093

duration: 0:00:14.138384

exit_message:

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

id: 161402093

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_moloTransientInvoicingMethodSet/2026-04-03/1775203549",
        "key": "raw/molo_moloTransientInvoicingMethodSet/2026-04-03/1775203549/TransientInvoicingMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInvoicingMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15857340989504095207,
        "service_name": "drive-thru",
        "span_id": 16896077594190977593,
        "trace_id": 10436994462665139034
    }
}

running: False
schema_name_id: 1735
start_time: 2026-04-03 03:18:48
success: True
trace_id: 10436994462665139034

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:13:32

ddl:

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

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