Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_estimateapprovalmethodset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717787

created: 2026-04-17 03:11:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 162167820
updated: 2026-04-17 03:11:32

Version 1716575

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 162112038
updated: 2026-04-16 03:14:40

Version 1715319

created: 2026-04-15 03:09:57

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 162056107
updated: 2026-04-15 03:10:08

Version 1714152

created: 2026-04-14 03:11:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 162000672
updated: 2026-04-14 03:11:33

Version 1712879

created: 2026-04-13 03:02:35

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161942402
updated: 2026-04-13 03:02:46

Version 1711695

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161893322
updated: 2026-04-12 03:05:28

Version 1710558

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161841364
updated: 2026-04-11 03:11:00

Version 1709261

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161785950
updated: 2026-04-10 03:06:58

Version 1708131

created: 2026-04-09 03:03:33

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161730274
updated: 2026-04-09 03:03:44

Version 1707019

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161675683
updated: 2026-04-08 03:10:22

Version 1705842

created: 2026-04-07 03:03:05

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161619327
updated: 2026-04-07 03:03:19

Version 1704479

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161561561
updated: 2026-04-06 03:05:29

Version 1703326

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161514907
updated: 2026-04-05 03:06:28

Version 1702228

created: 2026-04-04 03:08:50

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161460516
updated: 2026-04-04 03:09:04

Version 1700890

created: 2026-04-03 03:07:44

ddl:

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

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

schema_attributes:

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

schema_name_id: 1681
schema_scan_id: 161401822
updated: 2026-04-03 03:07:58

Schema Scans: 15

Last at 2026-04-17 03:11:18

Scan 162167820

duration: 0:00:14.006266

exit_message:

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

id: 162167820

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_moloSV_EstimateApprovalMethodSet/2026-04-17/1776412997",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-17/1776412997/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6114600363946766230,
        "service_name": "drive-thru",
        "span_id": 14899958639306796083,
        "trace_id": 4122923855519755602
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-17 03:11:18
success: True
trace_id: 4122923855519755602

Scan 162112038

duration: 0:00:14.304612

exit_message:

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

id: 162112038

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_moloSV_EstimateApprovalMethodSet/2026-04-16/1776326696",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-16/1776326696/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14191254740227883315,
        "service_name": "drive-thru",
        "span_id": 5829103178239788319,
        "trace_id": 17797454468282772781
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-16 03:14:25
success: True
trace_id: 17797454468282772781

Scan 162056107

duration: 0:00:11.484112

exit_message:

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

id: 162056107

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_moloSV_EstimateApprovalMethodSet/2026-04-15/1776240183",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-15/1776240183/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16971245365699759737,
        "service_name": "drive-thru",
        "span_id": 16458947816159826536,
        "trace_id": 7377907772055889671
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-15 03:09:57
success: True
trace_id: 7377907772055889671

Scan 162000672

duration: 0:00:14.038385

exit_message:

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

id: 162000672

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_moloSV_EstimateApprovalMethodSet/2026-04-14/1776154138",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-14/1776154138/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6946410897824955798,
        "service_name": "drive-thru",
        "span_id": 16099046187509902631,
        "trace_id": 4663374414465189006
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-14 03:11:19
success: True
trace_id: 4663374414465189006

Scan 161942402

duration: 0:00:11.443687

exit_message:

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

id: 161942402

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_moloSV_EstimateApprovalMethodSet/2026-04-13/1776067133",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-13/1776067133/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15663880653683326859,
        "service_name": "drive-thru",
        "span_id": 2888227876499051620,
        "trace_id": 7681568558710683244
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-13 03:02:35
success: True
trace_id: 7681568558710683244

Scan 161893322

duration: 0:00:14.034396

exit_message:

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

id: 161893322

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_moloSV_EstimateApprovalMethodSet/2026-04-12/1775980828",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-12/1775980828/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14534994857540793101,
        "service_name": "drive-thru",
        "span_id": 16260336988977898722,
        "trace_id": 15664184736554627824
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-12 03:05:14
success: True
trace_id: 15664184736554627824

Scan 161841364

duration: 0:00:11.518538

exit_message:

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

id: 161841364

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_moloSV_EstimateApprovalMethodSet/2026-04-11/1775894599",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-11/1775894599/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8076079746431319432,
        "service_name": "drive-thru",
        "span_id": 2328769688435479665,
        "trace_id": 18175662255134125167
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-11 03:10:49
success: True
trace_id: 18175662255134125167

Scan 161785950

duration: 0:00:14.248077

exit_message:

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

id: 161785950

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_moloSV_EstimateApprovalMethodSet/2026-04-10/1775808362",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-10/1775808362/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7879829706133808863,
        "service_name": "drive-thru",
        "span_id": 7735205095586510289,
        "trace_id": 579546251028581491
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-10 03:06:44
success: True
trace_id: 579546251028581491

Scan 161730274

duration: 0:00:11.513658

exit_message:

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

id: 161730274

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_moloSV_EstimateApprovalMethodSet/2026-04-09/1775721687",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-09/1775721687/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 998515300463579892,
        "service_name": "drive-thru",
        "span_id": 9572191626159904050,
        "trace_id": 16851156998177299292
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-09 03:03:33
success: True
trace_id: 16851156998177299292

Scan 161675683

duration: 0:00:11.445784

exit_message:

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

id: 161675683

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_moloSV_EstimateApprovalMethodSet/2026-04-08/1775635523",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-08/1775635523/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10239895444376320497,
        "service_name": "drive-thru",
        "span_id": 7061472779206890391,
        "trace_id": 1867671225185593585
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-08 03:10:11
success: True
trace_id: 1867671225185593585

Scan 161619327

duration: 0:00:13.934002

exit_message:

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

id: 161619327

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_moloSV_EstimateApprovalMethodSet/2026-04-07/1775548686",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-07/1775548686/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5526064241695150232,
        "service_name": "drive-thru",
        "span_id": 8519597159339400171,
        "trace_id": 15574397134278732840
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-07 03:03:05
success: True
trace_id: 15574397134278732840

Scan 161561561

duration: 0:00:14.103834

exit_message:

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

id: 161561561

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_moloSV_EstimateApprovalMethodSet/2026-04-06/1775462635",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-06/1775462635/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8909882703903651601,
        "service_name": "drive-thru",
        "span_id": 4146666350488514886,
        "trace_id": 17126337891724435715
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-06 03:05:15
success: True
trace_id: 17126337891724435715

Scan 161514907

duration: 0:00:11.510167

exit_message:

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

id: 161514907

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_moloSV_EstimateApprovalMethodSet/2026-04-05/1775376268",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-05/1775376268/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11427374790082965136,
        "service_name": "drive-thru",
        "span_id": 7480782960623863868,
        "trace_id": 1446878716539125524
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-05 03:06:17
success: True
trace_id: 1446878716539125524

Scan 161460516

duration: 0:00:14.107664

exit_message:

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

id: 161460516

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_moloSV_EstimateApprovalMethodSet/2026-04-04/1775289749",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-04/1775289749/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8479939196809557733,
        "service_name": "drive-thru",
        "span_id": 334062389176236065,
        "trace_id": 17718064339886804358
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-04 03:08:50
success: True
trace_id: 17718064339886804358

Scan 161401822

duration: 0:00:13.949229

exit_message:

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

id: 161401822

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_moloSV_EstimateApprovalMethodSet/2026-04-03/1775203516",
        "key": "raw/molo_moloSV_EstimateApprovalMethodSet/2026-04-03/1775203516/SV_EstimateApprovalMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateApprovalMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 37822181292755955,
        "service_name": "drive-thru",
        "span_id": 18068273550169503368,
        "trace_id": 8804470359305933568
    }
}

running: False
schema_name_id: 1681
start_time: 2026-04-03 03:07:44
success: True
trace_id: 8804470359305933568

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:11:19

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

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