Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocountries

created: 2023-10-17 01:55:07
disabled: False
format: raw
id: 1594
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717587

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

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 162167242
updated: 2026-04-17 03:01:15

Version 1716350

created: 2026-04-16 03:05:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocountries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocountries`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneCountryCode`  string , `PrimaryFaxCountryCode`  string , `Abbreviation`  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_moloCountries/2026-04-16/1776326462'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocountries"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCountries/2026-04-16/1776326462
id: 1716350
processed: 1

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 162111728
updated: 2026-04-16 03:05:32

Version 1715155

created: 2026-04-15 03:01:55

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 162055708
updated: 2026-04-15 03:02:06

Version 1713992

created: 2026-04-14 03:04:54

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 162000438
updated: 2026-04-14 03:05:05

Version 1712709

created: 2026-04-13 02:55:23

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161941475
updated: 2026-04-13 02:55:35

Version 1711523

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocountries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocountries`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneCountryCode`  string , `PrimaryFaxCountryCode`  string , `Abbreviation`  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_moloCountries/2026-04-12/1775980566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocountries"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCountries/2026-04-12/1775980566
id: 1711523
processed: 1

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161892293
updated: 2026-04-12 02:57:32

Version 1710349

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

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161841040
updated: 2026-04-11 03:02:22

Version 1709161

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

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161785804
updated: 2026-04-10 03:02:56

Version 1708029

created: 2026-04-09 02:59:14

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161729824
updated: 2026-04-09 02:59:25

Version 1706848

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

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161675423
updated: 2026-04-08 03:03:27

Version 1705627

created: 2026-04-07 02:54:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocountries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocountries`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneCountryCode`  string , `PrimaryFaxCountryCode`  string , `Abbreviation`  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_moloCountries/2026-04-07/1775548403'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocountries"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCountries/2026-04-07/1775548403
id: 1705627
processed: 1

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161618304
updated: 2026-04-07 02:54:18

Version 1704513

created: 2026-04-06 03:06:39

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161561608
updated: 2026-04-06 03:06:52

Version 1703208

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

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161514767
updated: 2026-04-05 03:01:42

Version 1702042

created: 2026-04-04 03:00:18

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161459839
updated: 2026-04-04 03:00:32

Version 1700849

created: 2026-04-03 03:05:44

ddl:

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

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

raw_data:

{
    "Abbreviation": 4,
    "Id": 0,
    "Name": 1,
    "PrimaryFaxCountryCode": 3,
    "PrimaryPhoneCountryCode": 2
}

schema_attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

schema_name_id: 1594
schema_scan_id: 161401745
updated: 2026-04-03 03:05:57

Schema Scans: 15

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

Scan 162167242

duration: 0:00:11.557994

exit_message:

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

id: 162167242

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_moloCountries/2026-04-17/1776412699",
        "key": "raw/molo_moloCountries/2026-04-17/1776412699/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2957860394856193097,
        "service_name": "drive-thru",
        "span_id": 11444856875854373075,
        "trace_id": 7422359327072846789
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-17 03:01:04
success: True
trace_id: 7422359327072846789

Scan 162111728

duration: 0:00:11.580388

exit_message:

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

id: 162111728

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_moloCountries/2026-04-16/1776326462",
        "key": "raw/molo_moloCountries/2026-04-16/1776326462/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4033684881473742633,
        "service_name": "drive-thru",
        "span_id": 9582764358897991337,
        "trace_id": 5191701490879061858
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-16 03:05:20
success: True
trace_id: 5191701490879061858

Scan 162055708

duration: 0:00:11.670674

exit_message:

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

id: 162055708

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_moloCountries/2026-04-15/1776239933",
        "key": "raw/molo_moloCountries/2026-04-15/1776239933/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 437249011807169564,
        "service_name": "drive-thru",
        "span_id": 1543841488668568574,
        "trace_id": 18016030404022519305
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-15 03:01:55
success: True
trace_id: 18016030404022519305

Scan 162000438

duration: 0:00:11.652166

exit_message:

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

id: 162000438

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_moloCountries/2026-04-14/1776153658",
        "key": "raw/molo_moloCountries/2026-04-14/1776153658/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4798722619121450634,
        "service_name": "drive-thru",
        "span_id": 17443743695750221992,
        "trace_id": 2421950115187144381
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-14 03:04:54
success: True
trace_id: 2421950115187144381

Scan 161941475

duration: 0:00:11.589671

exit_message:

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

id: 161941475

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_moloCountries/2026-04-13/1776066851",
        "key": "raw/molo_moloCountries/2026-04-13/1776066851/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10554905761323969730,
        "service_name": "drive-thru",
        "span_id": 16525895316295086003,
        "trace_id": 1574204889346755816
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-13 02:55:23
success: True
trace_id: 1574204889346755816

Scan 161892293

duration: 0:00:11.549155

exit_message:

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

id: 161892293

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_moloCountries/2026-04-12/1775980566",
        "key": "raw/molo_moloCountries/2026-04-12/1775980566/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15070065193534509205,
        "service_name": "drive-thru",
        "span_id": 17785943984346210448,
        "trace_id": 5506479764099618210
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-12 02:57:20
success: True
trace_id: 5506479764099618210

Scan 161841040

duration: 0:00:14.065581

exit_message:

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

id: 161841040

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_moloCountries/2026-04-11/1775894327",
        "key": "raw/molo_moloCountries/2026-04-11/1775894327/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16874266234907273243,
        "service_name": "drive-thru",
        "span_id": 3038937671660183518,
        "trace_id": 12964803445194500381
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-11 03:02:08
success: True
trace_id: 12964803445194500381

Scan 161785804

duration: 0:00:14.062509

exit_message:

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

id: 161785804

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_moloCountries/2026-04-10/1775808083",
        "key": "raw/molo_moloCountries/2026-04-10/1775808083/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13981908762696389466,
        "service_name": "drive-thru",
        "span_id": 8464198863886310613,
        "trace_id": 5210713124447848264
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-10 03:02:42
success: True
trace_id: 5210713124447848264

Scan 161729824

duration: 0:00:11.568388

exit_message:

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

id: 161729824

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_moloCountries/2026-04-09/1775721422",
        "key": "raw/molo_moloCountries/2026-04-09/1775721422/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13778246138472256397,
        "service_name": "drive-thru",
        "span_id": 11097663241716985403,
        "trace_id": 15661739303200747752
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-09 02:59:14
success: True
trace_id: 15661739303200747752

Scan 161675423

duration: 0:00:14.174952

exit_message:

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

id: 161675423

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_moloCountries/2026-04-08/1775635230",
        "key": "raw/molo_moloCountries/2026-04-08/1775635230/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7123345314255710482,
        "service_name": "drive-thru",
        "span_id": 12495330991592067101,
        "trace_id": 14496025258855679430
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-08 03:03:13
success: True
trace_id: 14496025258855679430

Scan 161618304

duration: 0:00:14.160057

exit_message:

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

id: 161618304

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_moloCountries/2026-04-07/1775548403",
        "key": "raw/molo_moloCountries/2026-04-07/1775548403/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10488398848473744175,
        "service_name": "drive-thru",
        "span_id": 5038260665560501123,
        "trace_id": 16839819044130089428
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-07 02:54:04
success: True
trace_id: 16839819044130089428

Scan 161561608

duration: 0:00:14.239891

exit_message:

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

id: 161561608

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_moloCountries/2026-04-06/1775462366",
        "key": "raw/molo_moloCountries/2026-04-06/1775462366/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12609533860789910678,
        "service_name": "drive-thru",
        "span_id": 13580037962412453936,
        "trace_id": 237349673372127531
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-06 03:06:38
success: True
trace_id: 237349673372127531

Scan 161514767

duration: 0:00:14.114492

exit_message:

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

id: 161514767

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_moloCountries/2026-04-05/1775375994",
        "key": "raw/molo_moloCountries/2026-04-05/1775375994/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2692482120623616360,
        "service_name": "drive-thru",
        "span_id": 11594701804570533369,
        "trace_id": 10772918512070719403
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-05 03:01:28
success: True
trace_id: 10772918512070719403

Scan 161459839

duration: 0:00:14.026703

exit_message:

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

id: 161459839

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_moloCountries/2026-04-04/1775289478",
        "key": "raw/molo_moloCountries/2026-04-04/1775289478/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17619841477602805826,
        "service_name": "drive-thru",
        "span_id": 14045055395916784373,
        "trace_id": 10001059288796559017
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-04 03:00:18
success: True
trace_id: 10001059288796559017

Scan 161401745

duration: 0:00:14.202621

exit_message:

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

id: 161401745

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_moloCountries/2026-04-03/1775203251",
        "key": "raw/molo_moloCountries/2026-04-03/1775203251/Countries.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCountries",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3016409798254291138,
        "service_name": "drive-thru",
        "span_id": 12990920489943307116,
        "trace_id": 7397111965757127872
    }
}

running: False
schema_name_id: 1594
start_time: 2026-04-03 03:05:43
success: True
trace_id: 7397111965757127872

Partitions:

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

Schema:

attributes:

{
    "Abbreviation": "string",
    "Id": "string",
    "Name": "string",
    "PrimaryFaxCountryCode": "string",
    "PrimaryPhoneCountryCode": "string"
}

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

ddl:

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

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