Schema Info

Schema Name: sfdl_prod_drivethru.molo_molousertermsacceptanceauditset

created: 2023-10-17 02:03:20
disabled: False
format: raw
id: 1816
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717827

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-17/1776413271
id: 1717827
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 162167864
updated: 2026-04-17 03:13:49

Version 1716486

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-16/1776326748'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-16/1776326748
id: 1716486
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 162111928
updated: 2026-04-16 03:11:19

Version 1715390

created: 2026-04-15 03:13:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-15/1776240209'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-15/1776240209
id: 1715390
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 162056199
updated: 2026-04-15 03:13:39

Version 1714212

created: 2026-04-14 03:13:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-14/1776154173'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-14/1776154173
id: 1714212
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 162000736
updated: 2026-04-14 03:13:47

Version 1712908

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-13/1776067167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-13/1776067167
id: 1712908
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161942606
updated: 2026-04-13 03:04:13

Version 1711735

created: 2026-04-12 03:07:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-12/1775980869'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-12/1775980869
id: 1711735
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161893425
updated: 2026-04-12 03:07:29

Version 1710490

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-11/1775894645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-11/1775894645
id: 1710490
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161841279
updated: 2026-04-11 03:08:14

Version 1709375

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-10/1775808400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-10/1775808400
id: 1709375
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161786076
updated: 2026-04-10 03:11:14

Version 1708150

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-09/1775721730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-09/1775721730
id: 1708150
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161730335
updated: 2026-04-09 03:04:45

Version 1706969

created: 2026-04-08 03:08:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-08/1775635559'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-08/1775635559
id: 1706969
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161675625
updated: 2026-04-08 03:08:31

Version 1705895

created: 2026-04-07 03:06:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-07/1775548719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-07/1775548719
id: 1705895
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161619555
updated: 2026-04-07 03:06:25

Version 1704530

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-06/1775462670'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-06/1775462670
id: 1704530
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161561637
updated: 2026-04-06 03:07:36

Version 1703361

created: 2026-04-05 03:07:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-05/1775376300'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-05/1775376300
id: 1703361
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161514944
updated: 2026-04-05 03:07:49

Version 1702246

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-04/1775289785'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-04/1775289785
id: 1702246
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161460541
updated: 2026-04-04 03:09:50

Version 1700971

created: 2026-04-03 03:11:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-03/1775203550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-03/1775203550
id: 1700971
processed: 1

raw_data:

{
    "AspNetUser_Id": 5,
    "Id": 0,
    "TermsAcceptedDateTime": 1,
    "TermsAcceptedDevice": 3,
    "TermsAcceptedIpAddress": 2,
    "TermsContent": 4
}

schema_attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

schema_name_id: 1816
schema_scan_id: 161401938
updated: 2026-04-03 03:11:15

Schema Scans: 15

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

Scan 162167864

duration: 0:00:11.746713

exit_message:

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

id: 162167864

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_moloUserTermsAcceptanceAuditSet/2026-04-17/1776413271",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-17/1776413271/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14234731109261607085,
        "service_name": "drive-thru",
        "span_id": 4291137142719332593,
        "trace_id": 7215001952846183654
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-17 03:13:38
success: True
trace_id: 7215001952846183654

Scan 162111928

duration: 0:00:14.414150

exit_message:

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

id: 162111928

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_moloUserTermsAcceptanceAuditSet/2026-04-16/1776326748",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-16/1776326748/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14236067868194983119,
        "service_name": "drive-thru",
        "span_id": 14424627587908773753,
        "trace_id": 17567498896913888850
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-16 03:11:05
success: True
trace_id: 17567498896913888850

Scan 162056199

duration: 0:00:11.742811

exit_message:

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

id: 162056199

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_moloUserTermsAcceptanceAuditSet/2026-04-15/1776240209",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-15/1776240209/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3067510200746741317,
        "service_name": "drive-thru",
        "span_id": 17378306619810104200,
        "trace_id": 16851419191977390566
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-15 03:13:28
success: True
trace_id: 16851419191977390566

Scan 162000736

duration: 0:00:14.285355

exit_message:

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

id: 162000736

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_moloUserTermsAcceptanceAuditSet/2026-04-14/1776154173",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-14/1776154173/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4345701976333825038,
        "service_name": "drive-thru",
        "span_id": 3257708484306294783,
        "trace_id": 8449618880838390597
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-14 03:13:33
success: True
trace_id: 8449618880838390597

Scan 161942606

duration: 0:00:14.248564

exit_message:

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

id: 161942606

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_moloUserTermsAcceptanceAuditSet/2026-04-13/1776067167",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-13/1776067167/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17481133336350324149,
        "service_name": "drive-thru",
        "span_id": 16797947019232658495,
        "trace_id": 1034525755651692561
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-13 03:03:59
success: True
trace_id: 1034525755651692561

Scan 161893425

duration: 0:00:11.906015

exit_message:

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

id: 161893425

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_moloUserTermsAcceptanceAuditSet/2026-04-12/1775980869",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-12/1775980869/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14562407550394544773,
        "service_name": "drive-thru",
        "span_id": 11338157034184424220,
        "trace_id": 18334642427185210967
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-12 03:07:17
success: True
trace_id: 18334642427185210967

Scan 161841279

duration: 0:00:14.247345

exit_message:

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

id: 161841279

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_moloUserTermsAcceptanceAuditSet/2026-04-11/1775894645",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-11/1775894645/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9258862578498112760,
        "service_name": "drive-thru",
        "span_id": 9561473162341859180,
        "trace_id": 16664088805116598932
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-11 03:08:00
success: True
trace_id: 16664088805116598932

Scan 161786076

duration: 0:00:11.883871

exit_message:

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

id: 161786076

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_moloUserTermsAcceptanceAuditSet/2026-04-10/1775808400",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-10/1775808400/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2602620563575787646,
        "service_name": "drive-thru",
        "span_id": 2689466619692564139,
        "trace_id": 17956290031208224838
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-10 03:11:02
success: True
trace_id: 17956290031208224838

Scan 161730335

duration: 0:00:11.762421

exit_message:

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

id: 161730335

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_moloUserTermsAcceptanceAuditSet/2026-04-09/1775721730",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-09/1775721730/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1148149216698782469,
        "service_name": "drive-thru",
        "span_id": 8566441019994081799,
        "trace_id": 7450579655538228628
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-09 03:04:33
success: True
trace_id: 7450579655538228628

Scan 161675625

duration: 0:00:14.313598

exit_message:

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

id: 161675625

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_moloUserTermsAcceptanceAuditSet/2026-04-08/1775635559",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-08/1775635559/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10979554817291441691,
        "service_name": "drive-thru",
        "span_id": 1323492564695812023,
        "trace_id": 11118600845989793482
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-08 03:08:17
success: True
trace_id: 11118600845989793482

Scan 161619555

duration: 0:00:11.862622

exit_message:

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

id: 161619555

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_moloUserTermsAcceptanceAuditSet/2026-04-07/1775548719",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-07/1775548719/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8458590248497199205,
        "service_name": "drive-thru",
        "span_id": 12255626422249710305,
        "trace_id": 2710459853832115447
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-07 03:06:13
success: True
trace_id: 2710459853832115447

Scan 161561637

duration: 0:00:14.268746

exit_message:

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

id: 161561637

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_moloUserTermsAcceptanceAuditSet/2026-04-06/1775462670",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-06/1775462670/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18349214185753157753,
        "service_name": "drive-thru",
        "span_id": 7343137479063299617,
        "trace_id": 5049465631261020409
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-06 03:07:21
success: True
trace_id: 5049465631261020409

Scan 161514944

duration: 0:00:14.298561

exit_message:

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

id: 161514944

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_moloUserTermsAcceptanceAuditSet/2026-04-05/1775376300",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-05/1775376300/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5859767735611353536,
        "service_name": "drive-thru",
        "span_id": 10229399457414785448,
        "trace_id": 6923337638357327065
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-05 03:07:35
success: True
trace_id: 6923337638357327065

Scan 161460541

duration: 0:00:14.181407

exit_message:

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

id: 161460541

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_moloUserTermsAcceptanceAuditSet/2026-04-04/1775289785",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-04/1775289785/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10722992509943869194,
        "service_name": "drive-thru",
        "span_id": 13094028900344973971,
        "trace_id": 9166223881060317630
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-04 03:09:36
success: True
trace_id: 9166223881060317630

Scan 161401938

duration: 0:00:14.330047

exit_message:

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

id: 161401938

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_moloUserTermsAcceptanceAuditSet/2026-04-03/1775203550",
        "key": "raw/molo_moloUserTermsAcceptanceAuditSet/2026-04-03/1775203550/UserTermsAcceptanceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloUserTermsAcceptanceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4479045107976303865,
        "service_name": "drive-thru",
        "span_id": 6346954438449176414,
        "trace_id": 15622829334181558440
    }
}

running: False
schema_name_id: 1816
start_time: 2026-04-03 03:11:00
success: True
trace_id: 15622829334181558440

Partitions:

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

Schema:

attributes:

{
    "AspNetUser_Id": "string",
    "Id": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedDevice": "string",
    "TermsAcceptedIpAddress": "string",
    "TermsContent": "string"
}

created: 2026-04-17 03:13: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_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
}

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 02:03:20",
        "disabled": false,
        "format": "raw",
        "id": 1816,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molousertermsacceptanceauditset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AspNetUser_Id": "string",
            "Id": "string",
            "TermsAcceptedDateTime": "string",
            "TermsAcceptedDevice": "string",
            "TermsAcceptedIpAddress": "string",
            "TermsContent": "string"
        },
        "created": "2026-04-17 03:13: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_molousertermsacceptanceauditset`\n(\n `Id`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedIpAddress`  string , `TermsAcceptedDevice`  string , `TermsContent`  string , `AspNetUser_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_moloUserTermsAcceptanceAuditSet/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molousertermsacceptanceauditset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molousertermsacceptanceauditset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}