Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocurrenciesset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717588

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-17/1776412699
id: 1717588
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 162167244
updated: 2026-04-17 03:01:20

Version 1716330

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-16/1776326463
id: 1716330
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 162111682
updated: 2026-04-16 03:04:28

Version 1715156

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-15/1776239933
id: 1715156
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 162055722
updated: 2026-04-15 03:02:19

Version 1713933

created: 2026-04-14 03:01:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-14/1776153658
id: 1713933
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 162000321
updated: 2026-04-14 03:02:02

Version 1712727

created: 2026-04-13 02:56:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-13/1776066851
id: 1712727
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161941505
updated: 2026-04-13 02:56:16

Version 1711524

created: 2026-04-12 02:57:22

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-12/1775980567
id: 1711524
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161892294
updated: 2026-04-12 02:57:33

Version 1710375

created: 2026-04-11 03:03:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-11/1775894327
id: 1710375
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161841114
updated: 2026-04-11 03:03:39

Version 1709209

created: 2026-04-10 03:04:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-10/1775808083
id: 1709209
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161785891
updated: 2026-04-10 03:04:57

Version 1708058

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-09/1775721422
id: 1708058
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161729958
updated: 2026-04-09 03:01:02

Version 1706800

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-08/1775635230
id: 1706800
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161675301
updated: 2026-04-08 03:01:17

Version 1705673

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-07/1775548404
id: 1705673
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161618357
updated: 2026-04-07 02:56:05

Version 1704412

created: 2026-04-06 03:02:00

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-06/1775462366
id: 1704412
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161561395
updated: 2026-04-06 03:02:11

Version 1703248

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-05/1775375994
id: 1703248
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161514817
updated: 2026-04-05 03:03:14

Version 1702026

created: 2026-04-04 02:59:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-04/1775289478
id: 1702026
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161459794
updated: 2026-04-04 02:59:46

Version 1700825

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCurrenciesSet/2026-04-03/1775203251
id: 1700825
processed: 1

raw_data:

{
    "Code": 1,
    "Id": 0,
    "Name": 3,
    "Symbol": 2
}

schema_attributes:

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

schema_name_id: 1579
schema_scan_id: 161401687
updated: 2026-04-03 03:04:23

Schema Scans: 15

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

Scan 162167244

duration: 0:00:14.213920

exit_message:

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

id: 162167244

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_moloCurrenciesSet/2026-04-17/1776412699",
        "key": "raw/molo_moloCurrenciesSet/2026-04-17/1776412699/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14922870034281858017,
        "service_name": "drive-thru",
        "span_id": 16713618041138274042,
        "trace_id": 6658875470685312464
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-17 03:01:06
success: True
trace_id: 6658875470685312464

Scan 162111682

duration: 0:00:14.210326

exit_message:

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

id: 162111682

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_moloCurrenciesSet/2026-04-16/1776326463",
        "key": "raw/molo_moloCurrenciesSet/2026-04-16/1776326463/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14324044736186099347,
        "service_name": "drive-thru",
        "span_id": 8685076239941597390,
        "trace_id": 4631557537571245972
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-16 03:04:14
success: True
trace_id: 4631557537571245972

Scan 162055722

duration: 0:00:14.192678

exit_message:

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

id: 162055722

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_moloCurrenciesSet/2026-04-15/1776239933",
        "key": "raw/molo_moloCurrenciesSet/2026-04-15/1776239933/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16867688807731483212,
        "service_name": "drive-thru",
        "span_id": 2438151332388805895,
        "trace_id": 14861280887163729844
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-15 03:02:05
success: True
trace_id: 14861280887163729844

Scan 162000321

duration: 0:00:11.600259

exit_message:

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

id: 162000321

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_moloCurrenciesSet/2026-04-14/1776153658",
        "key": "raw/molo_moloCurrenciesSet/2026-04-14/1776153658/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17907120455680762364,
        "service_name": "drive-thru",
        "span_id": 3440604534038848368,
        "trace_id": 8375809215987082625
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-14 03:01:50
success: True
trace_id: 8375809215987082625

Scan 161941505

duration: 0:00:11.606613

exit_message:

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

id: 161941505

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_moloCurrenciesSet/2026-04-13/1776066851",
        "key": "raw/molo_moloCurrenciesSet/2026-04-13/1776066851/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1119938448916052025,
        "service_name": "drive-thru",
        "span_id": 9387418506742115256,
        "trace_id": 1181504662689358652
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-13 02:56:04
success: True
trace_id: 1181504662689358652

Scan 161892294

duration: 0:00:11.568088

exit_message:

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

id: 161892294

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_moloCurrenciesSet/2026-04-12/1775980567",
        "key": "raw/molo_moloCurrenciesSet/2026-04-12/1775980567/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3602910078775778457,
        "service_name": "drive-thru",
        "span_id": 5468690792464780759,
        "trace_id": 18227242070191847657
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-12 02:57:21
success: True
trace_id: 18227242070191847657

Scan 161841114

duration: 0:00:14.064166

exit_message:

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

id: 161841114

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_moloCurrenciesSet/2026-04-11/1775894327",
        "key": "raw/molo_moloCurrenciesSet/2026-04-11/1775894327/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17368548361432782563,
        "service_name": "drive-thru",
        "span_id": 9538008995531314652,
        "trace_id": 17798077947024957692
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-11 03:03:25
success: True
trace_id: 17798077947024957692

Scan 161785891

duration: 0:00:14.179936

exit_message:

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

id: 161785891

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_moloCurrenciesSet/2026-04-10/1775808083",
        "key": "raw/molo_moloCurrenciesSet/2026-04-10/1775808083/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17190481256965730655,
        "service_name": "drive-thru",
        "span_id": 10474910387109081909,
        "trace_id": 10287228083791472586
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-10 03:04:42
success: True
trace_id: 10287228083791472586

Scan 161729958

duration: 0:00:20.237773

exit_message:

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

id: 161729958

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_moloCurrenciesSet/2026-04-09/1775721422",
        "key": "raw/molo_moloCurrenciesSet/2026-04-09/1775721422/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12833034747411203257,
        "service_name": "drive-thru",
        "span_id": 15270562698810537257,
        "trace_id": 6047343743988227748
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-09 03:00:42
success: True
trace_id: 6047343743988227748

Scan 161675301

duration: 0:00:14.148209

exit_message:

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

id: 161675301

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_moloCurrenciesSet/2026-04-08/1775635230",
        "key": "raw/molo_moloCurrenciesSet/2026-04-08/1775635230/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11929716700615176194,
        "service_name": "drive-thru",
        "span_id": 6384900592980026231,
        "trace_id": 14557849923031482082
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-08 03:01:03
success: True
trace_id: 14557849923031482082

Scan 161618357

duration: 0:00:14.143142

exit_message:

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

id: 161618357

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_moloCurrenciesSet/2026-04-07/1775548404",
        "key": "raw/molo_moloCurrenciesSet/2026-04-07/1775548404/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15056669079654000154,
        "service_name": "drive-thru",
        "span_id": 18387225244131840623,
        "trace_id": 7898578687795471553
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-07 02:55:51
success: True
trace_id: 7898578687795471553

Scan 161561395

duration: 0:00:11.740247

exit_message:

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

id: 161561395

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_moloCurrenciesSet/2026-04-06/1775462366",
        "key": "raw/molo_moloCurrenciesSet/2026-04-06/1775462366/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11687800283469976325,
        "service_name": "drive-thru",
        "span_id": 10005945559832888858,
        "trace_id": 12918708212230790024
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-06 03:01:59
success: True
trace_id: 12918708212230790024

Scan 161514817

duration: 0:00:14.196627

exit_message:

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

id: 161514817

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_moloCurrenciesSet/2026-04-05/1775375994",
        "key": "raw/molo_moloCurrenciesSet/2026-04-05/1775375994/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12523546968483192460,
        "service_name": "drive-thru",
        "span_id": 9895378288430977839,
        "trace_id": 14308263472634174706
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-05 03:03:00
success: True
trace_id: 14308263472634174706

Scan 161459794

duration: 0:00:11.574828

exit_message:

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

id: 161459794

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_moloCurrenciesSet/2026-04-04/1775289478",
        "key": "raw/molo_moloCurrenciesSet/2026-04-04/1775289478/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1076824346847840880,
        "service_name": "drive-thru",
        "span_id": 9594705393834976595,
        "trace_id": 6469577825763952263
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-04 02:59:34
success: True
trace_id: 6469577825763952263

Scan 161401687

duration: 0:00:14.172665

exit_message:

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

id: 161401687

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_moloCurrenciesSet/2026-04-03/1775203251",
        "key": "raw/molo_moloCurrenciesSet/2026-04-03/1775203251/CurrenciesSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCurrenciesSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10706094647582592460,
        "service_name": "drive-thru",
        "span_id": 1327604950736793876,
        "trace_id": 13585324507359767650
    }
}

running: False
schema_name_id: 1579
start_time: 2026-04-03 03:04:09
success: True
trace_id: 13585324507359767650

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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