Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloaspnetuserroles

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717578

created: 2026-04-17 03:00:38

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-17/1776412691
id: 1717578
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 162167217
updated: 2026-04-17 03:00:50

Version 1716325

created: 2026-04-16 03:04:02

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-16/1776326452
id: 1716325
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 162111677
updated: 2026-04-16 03:04:15

Version 1715137

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-15/1776239927
id: 1715137
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 162055665
updated: 2026-04-15 03:01:21

Version 1713988

created: 2026-04-14 03:04:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-14/1776153647
id: 1713988
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 162000429
updated: 2026-04-14 03:04:55

Version 1712687

created: 2026-04-13 02:54:26

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-13/1776066840
id: 1712687
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161941442
updated: 2026-04-13 02:54:39

Version 1711490

created: 2026-04-12 02:56:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-12/1775980557
id: 1711490
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161892235
updated: 2026-04-12 02:56:18

Version 1710321

created: 2026-04-11 03:00:55

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-11/1775894318
id: 1710321
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161840965
updated: 2026-04-11 03:01:07

Version 1709138

created: 2026-04-10 03:01:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-10/1775808073
id: 1709138
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161785762
updated: 2026-04-10 03:01:44

Version 1708012

created: 2026-04-09 02:58:29

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-09/1775721414
id: 1708012
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161729773
updated: 2026-04-09 02:58:43

Version 1706806

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-08/1775635222
id: 1706806
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161675331
updated: 2026-04-08 03:01:34

Version 1705622

created: 2026-04-07 02:53:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-07/1775548395
id: 1705622
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161618299
updated: 2026-04-07 02:54:10

Version 1704409

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-06/1775462359
id: 1704409
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161561387
updated: 2026-04-06 03:02:06

Version 1703204

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-05/1775375986
id: 1703204
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161514763
updated: 2026-04-05 03:01:30

Version 1702047

created: 2026-04-04 03:00:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-04/1775289469
id: 1702047
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161459852
updated: 2026-04-04 03:00:44

Version 1700893

created: 2026-04-03 03:07:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAspNetUserRoles/2026-04-03/1775203244
id: 1700893
processed: 1

raw_data:

{
    "AspNetRoles_Id": 0,
    "AspNetUsers_Id": 1
}

schema_attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

schema_name_id: 1584
schema_scan_id: 161401829
updated: 2026-04-03 03:08:07

Schema Scans: 15

Last at 2026-04-17 03:00:38

Scan 162167217

duration: 0:00:11.659231

exit_message:

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

id: 162167217

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_moloAspNetUserRoles/2026-04-17/1776412691",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-17/1776412691/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6819402471598550300,
        "service_name": "drive-thru",
        "span_id": 7857907788013081663,
        "trace_id": 12844987022191500302
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-17 03:00:38
success: True
trace_id: 12844987022191500302

Scan 162111677

duration: 0:00:14.184733

exit_message:

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

id: 162111677

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_moloAspNetUserRoles/2026-04-16/1776326452",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-16/1776326452/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17325173308762738488,
        "service_name": "drive-thru",
        "span_id": 10740734556977032945,
        "trace_id": 6303530626582777145
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-16 03:04:01
success: True
trace_id: 6303530626582777145

Scan 162055665

duration: 0:00:14.138109

exit_message:

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

id: 162055665

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_moloAspNetUserRoles/2026-04-15/1776239927",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-15/1776239927/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11485007713375316812,
        "service_name": "drive-thru",
        "span_id": 6608889286961377792,
        "trace_id": 14648029640651094656
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-15 03:01:07
success: True
trace_id: 14648029640651094656

Scan 162000429

duration: 0:00:11.589141

exit_message:

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

id: 162000429

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_moloAspNetUserRoles/2026-04-14/1776153647",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-14/1776153647/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5330828052711880967,
        "service_name": "drive-thru",
        "span_id": 18250485641086706690,
        "trace_id": 14997266284762582642
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-14 03:04:44
success: True
trace_id: 14997266284762582642

Scan 161941442

duration: 0:00:14.214631

exit_message:

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

id: 161941442

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_moloAspNetUserRoles/2026-04-13/1776066840",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-13/1776066840/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15229300374291896998,
        "service_name": "drive-thru",
        "span_id": 2947395300529728985,
        "trace_id": 5953587759152535000
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-13 02:54:25
success: True
trace_id: 5953587759152535000

Scan 161892235

duration: 0:00:14.225717

exit_message:

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

id: 161892235

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_moloAspNetUserRoles/2026-04-12/1775980557",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-12/1775980557/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4238837453459874416,
        "service_name": "drive-thru",
        "span_id": 8806449568405505270,
        "trace_id": 5570608651754622855
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-12 02:56:04
success: True
trace_id: 5570608651754622855

Scan 161840965

duration: 0:00:11.672457

exit_message:

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

id: 161840965

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_moloAspNetUserRoles/2026-04-11/1775894318",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-11/1775894318/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 726819099574330522,
        "service_name": "drive-thru",
        "span_id": 8067705386207947294,
        "trace_id": 2869525981000093136
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-11 03:00:55
success: True
trace_id: 2869525981000093136

Scan 161785762

duration: 0:00:14.370557

exit_message:

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

id: 161785762

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_moloAspNetUserRoles/2026-04-10/1775808073",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-10/1775808073/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4110981909728701338,
        "service_name": "drive-thru",
        "span_id": 16028166821556853784,
        "trace_id": 10971685379852110403
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-10 03:01:30
success: True
trace_id: 10971685379852110403

Scan 161729773

duration: 0:00:14.168539

exit_message:

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

id: 161729773

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_moloAspNetUserRoles/2026-04-09/1775721414",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-09/1775721414/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7759675922841606630,
        "service_name": "drive-thru",
        "span_id": 2093146521837340062,
        "trace_id": 6794007132760436570
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-09 02:58:29
success: True
trace_id: 6794007132760436570

Scan 161675331

duration: 0:00:14.150883

exit_message:

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

id: 161675331

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_moloAspNetUserRoles/2026-04-08/1775635222",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-08/1775635222/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13121402344697270753,
        "service_name": "drive-thru",
        "span_id": 16017442579545551390,
        "trace_id": 7647107137055966702
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-08 03:01:20
success: True
trace_id: 7647107137055966702

Scan 161618299

duration: 0:00:11.736216

exit_message:

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

id: 161618299

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_moloAspNetUserRoles/2026-04-07/1775548395",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-07/1775548395/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17620767191340589140,
        "service_name": "drive-thru",
        "span_id": 3716262914086438145,
        "trace_id": 11093559359915917318
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-07 02:53:58
success: True
trace_id: 11093559359915917318

Scan 161561387

duration: 0:00:14.226015

exit_message:

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

id: 161561387

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_moloAspNetUserRoles/2026-04-06/1775462359",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-06/1775462359/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13464763304027474924,
        "service_name": "drive-thru",
        "span_id": 6009145317756970060,
        "trace_id": 3831521214787083230
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-06 03:01:52
success: True
trace_id: 3831521214787083230

Scan 161514763

duration: 0:00:14.211468

exit_message:

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

id: 161514763

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_moloAspNetUserRoles/2026-04-05/1775375986",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-05/1775375986/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15131481822182862260,
        "service_name": "drive-thru",
        "span_id": 6928471297709889123,
        "trace_id": 14345542773580510297
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-05 03:01:16
success: True
trace_id: 14345542773580510297

Scan 161459852

duration: 0:00:14.132504

exit_message:

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

id: 161459852

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_moloAspNetUserRoles/2026-04-04/1775289469",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-04/1775289469/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7015260636625675540,
        "service_name": "drive-thru",
        "span_id": 13261660033755287090,
        "trace_id": 12693331411130326879
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-04 03:00:30
success: True
trace_id: 12693331411130326879

Scan 161401829

duration: 0:00:14.251446

exit_message:

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

id: 161401829

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_moloAspNetUserRoles/2026-04-03/1775203244",
        "key": "raw/molo_moloAspNetUserRoles/2026-04-03/1775203244/AspNetUserRoles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAspNetUserRoles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2195744699737060294,
        "service_name": "drive-thru",
        "span_id": 18154222777628299839,
        "trace_id": 6530134309082518164
    }
}

running: False
schema_name_id: 1584
start_time: 2026-04-03 03:07:53
success: True
trace_id: 6530134309082518164

Partitions:

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

Schema:

attributes:

{
    "AspNetRoles_Id": "string",
    "AspNetUsers_Id": "string"
}

created: 2026-04-17 03:00:38

ddl:

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

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