Schema Info

Schema Name: sfdl_prod_drivethru.molo_molotermsacceptedlocationset

created: 2025-07-11 02:21:03
disabled: False
format: raw
id: 4263
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717805

created: 2026-04-17 03:12:24

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 162167841
updated: 2026-04-17 03:12:38

Version 1716460

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 162111895
updated: 2026-04-16 03:10:15

Version 1715343

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 162056136
updated: 2026-04-15 03:11:25

Version 1714120

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 162000636
updated: 2026-04-14 03:10:21

Version 1712941

created: 2026-04-13 03:05:40

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161942733
updated: 2026-04-13 03:05:52

Version 1711722

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161893392
updated: 2026-04-12 03:06:54

Version 1710578

created: 2026-04-11 03:11:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161841387
updated: 2026-04-11 03:12:05

Version 1709320

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161786019
updated: 2026-04-10 03:09:10

Version 1708213

created: 2026-04-09 03:07:27

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161730462
updated: 2026-04-09 03:07:38

Version 1706920

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161675553
updated: 2026-04-08 03:06:36

Version 1705838

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161619311
updated: 2026-04-07 03:03:06

Version 1704562

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161561681
updated: 2026-04-06 03:08:48

Version 1703443

created: 2026-04-05 03:10:41

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161515033
updated: 2026-04-05 03:10:55

Version 1702255

created: 2026-04-04 03:09:55

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161460555
updated: 2026-04-04 03:10:06

Version 1700922

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 4263
schema_scan_id: 161401876
updated: 2026-04-03 03:09:16

Schema Scans: 15

Last at 2026-04-17 03:12:24

Scan 162167841

duration: 0:00:14.066308

exit_message:

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

id: 162167841

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_moloTermsAcceptedLocationSet/2026-04-17/1776413135",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-17/1776413135/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2925554761470422661,
        "service_name": "drive-thru",
        "span_id": 5791256138393257627,
        "trace_id": 15911356915741672744
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-17 03:12:24
success: True
trace_id: 15911356915741672744

Scan 162111895

duration: 0:00:11.479177

exit_message:

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

id: 162111895

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_moloTermsAcceptedLocationSet/2026-04-16/1776326734",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-16/1776326734/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10908731768599130110,
        "service_name": "drive-thru",
        "span_id": 7652438501841255250,
        "trace_id": 3061421364554664258
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-16 03:10:03
success: True
trace_id: 3061421364554664258

Scan 162056136

duration: 0:00:14.161682

exit_message:

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

id: 162056136

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_moloTermsAcceptedLocationSet/2026-04-15/1776240200",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-15/1776240200/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4395202668292189440,
        "service_name": "drive-thru",
        "span_id": 17822449351389141081,
        "trace_id": 2954934187267335918
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-15 03:11:11
success: True
trace_id: 2954934187267335918

Scan 162000636

duration: 0:00:14.129891

exit_message:

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

id: 162000636

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_moloTermsAcceptedLocationSet/2026-04-14/1776154167",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-14/1776154167/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14552072332263669427,
        "service_name": "drive-thru",
        "span_id": 6974875820708089248,
        "trace_id": 7057838759862194866
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-14 03:10:07
success: True
trace_id: 7057838759862194866

Scan 161942733

duration: 0:00:11.485285

exit_message:

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

id: 161942733

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_moloTermsAcceptedLocationSet/2026-04-13/1776067161",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-13/1776067161/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2211062938592033483,
        "service_name": "drive-thru",
        "span_id": 4305816521491971618,
        "trace_id": 12897808787082874163
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-13 03:05:40
success: True
trace_id: 12897808787082874163

Scan 161893392

duration: 0:00:14.057685

exit_message:

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

id: 161893392

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_moloTermsAcceptedLocationSet/2026-04-12/1775980861",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-12/1775980861/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11132252503613130818,
        "service_name": "drive-thru",
        "span_id": 12289801042316971484,
        "trace_id": 7447879021733056701
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-12 03:06:40
success: True
trace_id: 7447879021733056701

Scan 161841387

duration: 0:00:14.077466

exit_message:

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

id: 161841387

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_moloTermsAcceptedLocationSet/2026-04-11/1775894630",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-11/1775894630/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14721283949738358791,
        "service_name": "drive-thru",
        "span_id": 2860869594608207153,
        "trace_id": 4364753248117492774
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-11 03:11:51
success: True
trace_id: 4364753248117492774

Scan 161786019

duration: 0:00:11.383705

exit_message:

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

id: 161786019

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_moloTermsAcceptedLocationSet/2026-04-10/1775808391",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-10/1775808391/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10371780260273535275,
        "service_name": "drive-thru",
        "span_id": 17832902558301556096,
        "trace_id": 18207307684413089766
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-10 03:08:59
success: True
trace_id: 18207307684413089766

Scan 161730462

duration: 0:00:11.521672

exit_message:

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

id: 161730462

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_moloTermsAcceptedLocationSet/2026-04-09/1775721720",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-09/1775721720/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9496807144357112510,
        "service_name": "drive-thru",
        "span_id": 10732954454146865904,
        "trace_id": 5377619680942537355
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-09 03:07:26
success: True
trace_id: 5377619680942537355

Scan 161675553

duration: 0:00:14.135541

exit_message:

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

id: 161675553

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_moloTermsAcceptedLocationSet/2026-04-08/1775635552",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-08/1775635552/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5478151047466817240,
        "service_name": "drive-thru",
        "span_id": 10674117104939279767,
        "trace_id": 2525764979341917770
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-08 03:06:22
success: True
trace_id: 2525764979341917770

Scan 161619311

duration: 0:00:14.047609

exit_message:

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

id: 161619311

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_moloTermsAcceptedLocationSet/2026-04-07/1775548713",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-07/1775548713/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4031219174658110063,
        "service_name": "drive-thru",
        "span_id": 5487399312743338943,
        "trace_id": 7429017725103182388
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-07 03:02:52
success: True
trace_id: 7429017725103182388

Scan 161561681

duration: 0:00:11.424380

exit_message:

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

id: 161561681

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_moloTermsAcceptedLocationSet/2026-04-06/1775462663",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-06/1775462663/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8097938247069883423,
        "service_name": "drive-thru",
        "span_id": 10269974558807593377,
        "trace_id": 9062427836608670335
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-06 03:08:37
success: True
trace_id: 9062427836608670335

Scan 161515033

duration: 0:00:14.049376

exit_message:

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

id: 161515033

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_moloTermsAcceptedLocationSet/2026-04-05/1775376294",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-05/1775376294/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5879199825844050174,
        "service_name": "drive-thru",
        "span_id": 3127524396557844654,
        "trace_id": 10578858148206067899
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-05 03:10:41
success: True
trace_id: 10578858148206067899

Scan 161460555

duration: 0:00:11.521992

exit_message:

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

id: 161460555

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_moloTermsAcceptedLocationSet/2026-04-04/1775289775",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-04/1775289775/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18036393700880616661,
        "service_name": "drive-thru",
        "span_id": 15629591887757055387,
        "trace_id": 12433870558749179400
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-04 03:09:55
success: True
trace_id: 12433870558749179400

Scan 161401876

duration: 0:00:11.425040

exit_message:

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

id: 161401876

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_moloTermsAcceptedLocationSet/2026-04-03/1775203542",
        "key": "raw/molo_moloTermsAcceptedLocationSet/2026-04-03/1775203542/TermsAcceptedLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTermsAcceptedLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9683458168911787699,
        "service_name": "drive-thru",
        "span_id": 10611952111107536855,
        "trace_id": 1555709291561694608
    }
}

running: False
schema_name_id: 4263
start_time: 2026-04-03 03:09:05
success: True
trace_id: 1555709291561694608

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:12:24

ddl:

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

Server:

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

Raw:

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