Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_employeestatusset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717770

created: 2026-04-17 03:10:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-17/1776412995
id: 1717770
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 162167793
updated: 2026-04-17 03:10:27

Version 1716574

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-16/1776326695
id: 1716574
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 162112037
updated: 2026-04-16 03:14:35

Version 1715320

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-15/1776240185
id: 1715320
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 162056108
updated: 2026-04-15 03:10:09

Version 1714134

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-14/1776154137
id: 1714134
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 162000653
updated: 2026-04-14 03:10:52

Version 1712884

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

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161942510
updated: 2026-04-13 03:03:18

Version 1711701

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

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161893351
updated: 2026-04-12 03:05:52

Version 1710432

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

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161841217
updated: 2026-04-11 03:06:03

Version 1709259

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-10/1775808361
id: 1709259
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161785946
updated: 2026-04-10 03:06:47

Version 1708197

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

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161730438
updated: 2026-04-09 03:06:58

Version 1707063

created: 2026-04-08 03:12:23

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161675736
updated: 2026-04-08 03:12:37

Version 1705817

created: 2026-04-07 03:02:02

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-07/1775548685
id: 1705817
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161619207
updated: 2026-04-07 03:02:16

Version 1704623

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-06/1775462636
id: 1704623
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161561771
updated: 2026-04-06 03:11:17

Version 1703370

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

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161514955
updated: 2026-04-05 03:08:13

Version 1702269

created: 2026-04-04 03:10:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EmployeeStatusSet/2026-04-04/1775289748
id: 1702269
processed: 1
raw_data:
```
{
    "Id": 0,
    "Status": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161460576
updated: 2026-04-04 03:10:44

Version 1700884

created: 2026-04-03 03:07:28

ddl:

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

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

schema_attributes:

{
    "Id": "string",
    "Status": "string"
}

schema_name_id: 1701
schema_scan_id: 161401814
updated: 2026-04-03 03:07:39

Schema Scans: 15

Last at 2026-04-17 03:10:16

Scan 162167793

duration: 0:00:11.527681

exit_message:

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

id: 162167793

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_EmployeeStatusSet/2026-04-17/1776412995",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-17/1776412995/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7835756585326246097,
        "service_name": "drive-thru",
        "span_id": 9494415557331628372,
        "trace_id": 2675354965142515364
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-17 03:10:16
success: True
trace_id: 2675354965142515364

Scan 162112037

duration: 0:00:14.057738

exit_message:

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

id: 162112037

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_EmployeeStatusSet/2026-04-16/1776326695",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-16/1776326695/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5053580134300859743,
        "service_name": "drive-thru",
        "span_id": 17256083575008949484,
        "trace_id": 4594206679229697073
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-16 03:14:21
success: True
trace_id: 4594206679229697073

Scan 162056108

duration: 0:00:11.441452

exit_message:

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

id: 162056108

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_EmployeeStatusSet/2026-04-15/1776240185",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-15/1776240185/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9604036752931001084,
        "service_name": "drive-thru",
        "span_id": 14981361567285313246,
        "trace_id": 531119497059929187
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-15 03:09:58
success: True
trace_id: 531119497059929187

Scan 162000653

duration: 0:00:14.061976

exit_message:

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

id: 162000653

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_EmployeeStatusSet/2026-04-14/1776154137",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-14/1776154137/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14212131078997536610,
        "service_name": "drive-thru",
        "span_id": 18134624505311369400,
        "trace_id": 17257829460458304654
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-14 03:10:38
success: True
trace_id: 17257829460458304654

Scan 161942510

duration: 0:00:13.928384

exit_message:

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

id: 161942510

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_EmployeeStatusSet/2026-04-13/1776067133",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-13/1776067133/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14612323061979486856,
        "service_name": "drive-thru",
        "span_id": 11886990448009461284,
        "trace_id": 11341920738095510186
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-13 03:03:04
success: True
trace_id: 11341920738095510186

Scan 161893351

duration: 0:00:14.072536

exit_message:

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

id: 161893351

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_EmployeeStatusSet/2026-04-12/1775980828",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-12/1775980828/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16257136457040711597,
        "service_name": "drive-thru",
        "span_id": 404526178435037514,
        "trace_id": 14375202178240873221
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-12 03:05:38
success: True
trace_id: 14375202178240873221

Scan 161841217

duration: 0:00:14.067937

exit_message:

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

id: 161841217

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_EmployeeStatusSet/2026-04-11/1775894599",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-11/1775894599/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14277374840151802451,
        "service_name": "drive-thru",
        "span_id": 14068505748490697775,
        "trace_id": 863943869041758850
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-11 03:05:49
success: True
trace_id: 863943869041758850

Scan 161785946

duration: 0:00:11.511283

exit_message:

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

id: 161785946

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_EmployeeStatusSet/2026-04-10/1775808361",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-10/1775808361/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6748250681060673877,
        "service_name": "drive-thru",
        "span_id": 3773543054281808821,
        "trace_id": 8803767512880715395
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-10 03:06:35
success: True
trace_id: 8803767512880715395

Scan 161730438

duration: 0:00:11.628456

exit_message:

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

id: 161730438

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_EmployeeStatusSet/2026-04-09/1775721687",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-09/1775721687/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15938065780957413314,
        "service_name": "drive-thru",
        "span_id": 6417379024165044423,
        "trace_id": 163496691832324450
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-09 03:06:46
success: True
trace_id: 163496691832324450

Scan 161675736

duration: 0:00:14.178421

exit_message:

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

id: 161675736

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_EmployeeStatusSet/2026-04-08/1775635523",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-08/1775635523/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2476718161853051790,
        "service_name": "drive-thru",
        "span_id": 5489062255518312871,
        "trace_id": 2309986119952934189
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-08 03:12:22
success: True
trace_id: 2309986119952934189

Scan 161619207

duration: 0:00:13.964347

exit_message:

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

id: 161619207

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_EmployeeStatusSet/2026-04-07/1775548685",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-07/1775548685/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14237168153463015297,
        "service_name": "drive-thru",
        "span_id": 17255821783170980436,
        "trace_id": 17433210366007914096
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-07 03:02:02
success: True
trace_id: 17433210366007914096

Scan 161561771

duration: 0:00:14.066713

exit_message:

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

id: 161561771

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_EmployeeStatusSet/2026-04-06/1775462636",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-06/1775462636/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10645993155180481377,
        "service_name": "drive-thru",
        "span_id": 7461408213689733888,
        "trace_id": 10698982235132836419
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-06 03:11:03
success: True
trace_id: 10698982235132836419

Scan 161514955

duration: 0:00:11.562415

exit_message:

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

id: 161514955

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_EmployeeStatusSet/2026-04-05/1775376268",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-05/1775376268/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2719245375079403460,
        "service_name": "drive-thru",
        "span_id": 8240738107378857067,
        "trace_id": 5813436830382945735
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-05 03:08:01
success: True
trace_id: 5813436830382945735

Scan 161460576

duration: 0:00:14.002685

exit_message:

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

id: 161460576

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_EmployeeStatusSet/2026-04-04/1775289748",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-04/1775289748/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18049793025231303937,
        "service_name": "drive-thru",
        "span_id": 9179054048120103101,
        "trace_id": 18028533218804836659
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-04 03:10:30
success: True
trace_id: 18028533218804836659

Scan 161401814

duration: 0:00:11.475795

exit_message:

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

id: 161401814

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_EmployeeStatusSet/2026-04-03/1775203516",
        "key": "raw/molo_moloSV_EmployeeStatusSet/2026-04-03/1775203516/SV_EmployeeStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EmployeeStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3693929460829128775,
        "service_name": "drive-thru",
        "span_id": 10674685037416797278,
        "trace_id": 8756581508560188497
    }
}

running: False
schema_name_id: 1701
start_time: 2026-04-03 03:07:28
success: True
trace_id: 8756581508560188497

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "Status": "string"
}

created: 2026-04-17 03:10:16

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_employeestatusset`\n(\n `Id`  string , `Status`  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_EmployeeStatusSet/2026-04-17/1776412995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_employeestatusset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_employeestatusset"
}

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