Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloresourcestatusmoveableset

created: 2023-10-17 02:01:24
disabled: False
format: raw
id: 1771
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717711

created: 2026-04-17 03:07:54

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 162167711
updated: 2026-04-17 03:08:08

Version 1716506

created: 2026-04-16 03:11:50

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 162111950
updated: 2026-04-16 03:12:04

Version 1715225

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 162055956
updated: 2026-04-15 03:06:00

Version 1714066

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 162000565
updated: 2026-04-14 03:08:14

Version 1712837

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161941885
updated: 2026-04-13 03:00:33

Version 1711650

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161892951
updated: 2026-04-12 03:02:52

Version 1710371

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161841107
updated: 2026-04-11 03:03:28

Version 1709378

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161786079
updated: 2026-04-10 03:11:22

Version 1708110

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161730210
updated: 2026-04-09 03:02:57

Version 1707003

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161675662
updated: 2026-04-08 03:09:47

Version 1705771

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161618665
updated: 2026-04-07 02:59:54

Version 1704540

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161561650
updated: 2026-04-06 03:08:01

Version 1703409

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161514994
updated: 2026-04-05 03:09:36

Version 1702209

created: 2026-04-04 03:08:01

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161460495
updated: 2026-04-04 03:08:12

Version 1701002

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1771
schema_scan_id: 161401975
updated: 2026-04-03 03:12:26

Schema Scans: 15

Last at 2026-04-17 03:07:54

Scan 162167711

duration: 0:00:14.113019

exit_message:

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

id: 162167711

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_moloResourceStatusMoveableSet/2026-04-17/1776412848",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-17/1776412848/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17425047840248817931,
        "service_name": "drive-thru",
        "span_id": 7306123718636489901,
        "trace_id": 6101288040732917501
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-17 03:07:54
success: True
trace_id: 6101288040732917501

Scan 162111950

duration: 0:00:14.062245

exit_message:

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

id: 162111950

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_moloResourceStatusMoveableSet/2026-04-16/1776326601",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-16/1776326601/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17309611816638178157,
        "service_name": "drive-thru",
        "span_id": 5587407950784805331,
        "trace_id": 3092949270825452832
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-16 03:11:50
success: True
trace_id: 3092949270825452832

Scan 162055956

duration: 0:00:11.503829

exit_message:

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

id: 162055956

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_moloResourceStatusMoveableSet/2026-04-15/1776240071",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-15/1776240071/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2723788749397038563,
        "service_name": "drive-thru",
        "span_id": 1284954457784277560,
        "trace_id": 4455002447594953011
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-15 03:05:48
success: True
trace_id: 4455002447594953011

Scan 162000565

duration: 0:00:14.353486

exit_message:

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

id: 162000565

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_moloResourceStatusMoveableSet/2026-04-14/1776153836",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-14/1776153836/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8194987837521953540,
        "service_name": "drive-thru",
        "span_id": 12281466327253834919,
        "trace_id": 7620481053769558432
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-14 03:07:59
success: True
trace_id: 7620481053769558432

Scan 161941885

duration: 0:00:11.457791

exit_message:

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

id: 161941885

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_moloResourceStatusMoveableSet/2026-04-13/1776066996",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-13/1776066996/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9903877928884328475,
        "service_name": "drive-thru",
        "span_id": 12879836432372284287,
        "trace_id": 16481490261469324843
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-13 03:00:22
success: True
trace_id: 16481490261469324843

Scan 161892951

duration: 0:00:13.877207

exit_message:

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

id: 161892951

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_moloResourceStatusMoveableSet/2026-04-12/1775980707",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-12/1775980707/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1232155390222116164,
        "service_name": "drive-thru",
        "span_id": 14970458210490826804,
        "trace_id": 4932590933453290439
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-12 03:02:38
success: True
trace_id: 4932590933453290439

Scan 161841107

duration: 0:00:13.929363

exit_message:

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

id: 161841107

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_moloResourceStatusMoveableSet/2026-04-11/1775894474",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-11/1775894474/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9477083784430111687,
        "service_name": "drive-thru",
        "span_id": 12171159813499303689,
        "trace_id": 17111063047915410482
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-11 03:03:15
success: True
trace_id: 17111063047915410482

Scan 161786079

duration: 0:00:11.685537

exit_message:

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

id: 161786079

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_moloResourceStatusMoveableSet/2026-04-10/1775808233",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-10/1775808233/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17651593519272507387,
        "service_name": "drive-thru",
        "span_id": 5181803224069428729,
        "trace_id": 1719905115312644812
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-10 03:11:11
success: True
trace_id: 1719905115312644812

Scan 161730210

duration: 0:00:14.026389

exit_message:

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

id: 161730210

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_moloResourceStatusMoveableSet/2026-04-09/1775721564",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-09/1775721564/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3397452074869697842,
        "service_name": "drive-thru",
        "span_id": 2434419840989636889,
        "trace_id": 16376421015836718910
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-09 03:02:44
success: True
trace_id: 16376421015836718910

Scan 161675662

duration: 0:00:13.980251

exit_message:

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

id: 161675662

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_moloResourceStatusMoveableSet/2026-04-08/1775635392",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-08/1775635392/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4435210176393413822,
        "service_name": "drive-thru",
        "span_id": 1652780212640694444,
        "trace_id": 2846450885357278517
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-08 03:09:33
success: True
trace_id: 2846450885357278517

Scan 161618665

duration: 0:00:11.626928

exit_message:

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

id: 161618665

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_moloResourceStatusMoveableSet/2026-04-07/1775548550",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-07/1775548550/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6773711636012505075,
        "service_name": "drive-thru",
        "span_id": 16277483403965759175,
        "trace_id": 16973946614831003790
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-07 02:59:43
success: True
trace_id: 16973946614831003790

Scan 161561650

duration: 0:00:14.032640

exit_message:

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

id: 161561650

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_moloResourceStatusMoveableSet/2026-04-06/1775462509",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-06/1775462509/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6647076831824060215,
        "service_name": "drive-thru",
        "span_id": 8514673650172910923,
        "trace_id": 17868308126767820668
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-06 03:07:47
success: True
trace_id: 17868308126767820668

Scan 161514994

duration: 0:00:11.396414

exit_message:

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

id: 161514994

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_moloResourceStatusMoveableSet/2026-04-05/1775376135",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-05/1775376135/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13083295542088711461,
        "service_name": "drive-thru",
        "span_id": 14123303396148946177,
        "trace_id": 11236395084665172349
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-05 03:09:24
success: True
trace_id: 11236395084665172349

Scan 161460495

duration: 0:00:11.622323

exit_message:

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

id: 161460495

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_moloResourceStatusMoveableSet/2026-04-04/1775289619",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-04/1775289619/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16128457489475703206,
        "service_name": "drive-thru",
        "span_id": 2840723846576130615,
        "trace_id": 2009008210400304256
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-04 03:08:00
success: True
trace_id: 2009008210400304256

Scan 161401975

duration: 0:00:11.754117

exit_message:

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

id: 161401975

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_moloResourceStatusMoveableSet/2026-04-03/1775203391",
        "key": "raw/molo_moloResourceStatusMoveableSet/2026-04-03/1775203391/ResourceStatusMoveableSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusMoveableSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17210731732338888567,
        "service_name": "drive-thru",
        "span_id": 16330338883170746236,
        "trace_id": 6727675987430497217
    }
}

running: False
schema_name_id: 1771
start_time: 2026-04-03 03:12:15
success: True
trace_id: 6727675987430497217

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:07:54

ddl:

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

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