Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloresourcestatusstationaryset

created: 2023-10-17 01:57:48
disabled: False
format: raw
id: 1669
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717741

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 162167746
updated: 2026-04-17 03:09:20

Version 1716556

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 162112015
updated: 2026-04-16 03:13:55

Version 1715238

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 162055972
updated: 2026-04-15 03:06:29

Version 1714090

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 162000596
updated: 2026-04-14 03:09:09

Version 1712839

created: 2026-04-13 03:00:23

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161941891
updated: 2026-04-13 03:00:37

Version 1711667

created: 2026-04-12 03:03:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161893050
updated: 2026-04-12 03:03:33

Version 1710467

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161841256
updated: 2026-04-11 03:07:20

Version 1709380

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161786081
updated: 2026-04-10 03:11:26

Version 1708109

created: 2026-04-09 03:02:42

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161730208
updated: 2026-04-09 03:02:56

Version 1706976

created: 2026-04-08 03:08:34

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161675632
updated: 2026-04-08 03:08:45

Version 1705749

created: 2026-04-07 02:58:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161618520
updated: 2026-04-07 02:59:02

Version 1704468

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161561543
updated: 2026-04-06 03:04:57

Version 1703320

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161514900
updated: 2026-04-05 03:06:17

Version 1702176

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161460413
updated: 2026-04-04 03:06:19

Version 1700955

created: 2026-04-03 03:10:21

ddl:

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

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

schema_attributes:

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

schema_name_id: 1669
schema_scan_id: 161401914
updated: 2026-04-03 03:10:32

Schema Scans: 15

Last at 2026-04-17 03:09:06

Scan 162167746

duration: 0:00:14.021351

exit_message:

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

id: 162167746

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_moloResourceStatusStationarySet/2026-04-17/1776412848",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-17/1776412848/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2635826764392765125,
        "service_name": "drive-thru",
        "span_id": 10594718558631559376,
        "trace_id": 2698859588604367678
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-17 03:09:06
success: True
trace_id: 2698859588604367678

Scan 162112015

duration: 0:00:14.232593

exit_message:

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

id: 162112015

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_moloResourceStatusStationarySet/2026-04-16/1776326603",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-16/1776326603/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4651974257585039587,
        "service_name": "drive-thru",
        "span_id": 1153672952633904765,
        "trace_id": 503846214962955029
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-16 03:13:41
success: True
trace_id: 503846214962955029

Scan 162055972

duration: 0:00:11.563729

exit_message:

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

id: 162055972

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_moloResourceStatusStationarySet/2026-04-15/1776240071",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-15/1776240071/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3407065266673129800,
        "service_name": "drive-thru",
        "span_id": 12039821168223875780,
        "trace_id": 5404289593416194775
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-15 03:06:17
success: True
trace_id: 5404289593416194775

Scan 162000596

duration: 0:00:14.022234

exit_message:

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

id: 162000596

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_moloResourceStatusStationarySet/2026-04-14/1776153838",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-14/1776153838/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16250116414562133659,
        "service_name": "drive-thru",
        "span_id": 16469772194133099180,
        "trace_id": 8572573441784729525
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-14 03:08:55
success: True
trace_id: 8572573441784729525

Scan 161941891

duration: 0:00:13.998317

exit_message:

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

id: 161941891

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_moloResourceStatusStationarySet/2026-04-13/1776066996",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-13/1776066996/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14919746658076154042,
        "service_name": "drive-thru",
        "span_id": 5790593330572621396,
        "trace_id": 8098111827767607507
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-13 03:00:23
success: True
trace_id: 8098111827767607507

Scan 161893050

duration: 0:00:13.931609

exit_message:

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

id: 161893050

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_moloResourceStatusStationarySet/2026-04-12/1775980707",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-12/1775980707/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9998134734073054379,
        "service_name": "drive-thru",
        "span_id": 3062076021754052394,
        "trace_id": 8025863457752779760
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-12 03:03:19
success: True
trace_id: 8025863457752779760

Scan 161841256

duration: 0:00:11.454709

exit_message:

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

id: 161841256

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_moloResourceStatusStationarySet/2026-04-11/1775894474",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-11/1775894474/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2571401189227529799,
        "service_name": "drive-thru",
        "span_id": 13207375394110904330,
        "trace_id": 1515749045458410847
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-11 03:07:08
success: True
trace_id: 1515749045458410847

Scan 161786081

duration: 0:00:14.041717

exit_message:

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

id: 161786081

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_moloResourceStatusStationarySet/2026-04-10/1775808233",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-10/1775808233/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18032121762225735729,
        "service_name": "drive-thru",
        "span_id": 9354679828681636182,
        "trace_id": 16305717181999298356
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-10 03:11:12
success: True
trace_id: 16305717181999298356

Scan 161730208

duration: 0:00:14.005294

exit_message:

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

id: 161730208

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_moloResourceStatusStationarySet/2026-04-09/1775721565",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-09/1775721565/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14863364329263251997,
        "service_name": "drive-thru",
        "span_id": 11829698600606359472,
        "trace_id": 14650924489823007536
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-09 03:02:42
success: True
trace_id: 14650924489823007536

Scan 161675632

duration: 0:00:11.474512

exit_message:

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

id: 161675632

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_moloResourceStatusStationarySet/2026-04-08/1775635393",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-08/1775635393/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15706140754480448428,
        "service_name": "drive-thru",
        "span_id": 2063061530079640674,
        "trace_id": 10828454877247334641
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-08 03:08:34
success: True
trace_id: 10828454877247334641

Scan 161618520

duration: 0:00:11.560744

exit_message:

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

id: 161618520

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_moloResourceStatusStationarySet/2026-04-07/1775548549",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-07/1775548549/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4115688201445599334,
        "service_name": "drive-thru",
        "span_id": 17387604559615459602,
        "trace_id": 10819248385336490246
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-07 02:58:51
success: True
trace_id: 10819248385336490246

Scan 161561543

duration: 0:00:13.919389

exit_message:

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

id: 161561543

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_moloResourceStatusStationarySet/2026-04-06/1775462509",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-06/1775462509/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14482391262208408132,
        "service_name": "drive-thru",
        "span_id": 16360864201232970065,
        "trace_id": 2697494620222427889
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-06 03:04:43
success: True
trace_id: 2697494620222427889

Scan 161514900

duration: 0:00:11.455446

exit_message:

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

id: 161514900

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_moloResourceStatusStationarySet/2026-04-05/1775376136",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-05/1775376136/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13196431447999591257,
        "service_name": "drive-thru",
        "span_id": 5983283893915512467,
        "trace_id": 7950649051086039978
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-05 03:06:05
success: True
trace_id: 7950649051086039978

Scan 161460413

duration: 0:00:11.583453

exit_message:

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

id: 161460413

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_moloResourceStatusStationarySet/2026-04-04/1775289619",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-04/1775289619/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4717314373421468787,
        "service_name": "drive-thru",
        "span_id": 6244075688594178824,
        "trace_id": 1586780869867531909
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-04 03:06:08
success: True
trace_id: 1586780869867531909

Scan 161401914

duration: 0:00:11.602006

exit_message:

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

id: 161401914

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_moloResourceStatusStationarySet/2026-04-03/1775203391",
        "key": "raw/molo_moloResourceStatusStationarySet/2026-04-03/1775203391/ResourceStatusStationarySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusStationarySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15882615552517251843,
        "service_name": "drive-thru",
        "span_id": 11095048370977085859,
        "trace_id": 11588054950961711951
    }
}

running: False
schema_name_id: 1669
start_time: 2026-04-03 03:10:21
success: True
trace_id: 11588054950961711951

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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