Schema Info

Schema Name: sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717630

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-17/1776412809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-17/1776412809
id: 1717630
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 162167539
updated: 2026-04-17 03:04:17

Version 1716416

created: 2026-04-16 03:08:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-16/1776326566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-16/1776326566
id: 1716416
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 162111850
updated: 2026-04-16 03:08:38

Version 1715237

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-15/1776240035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-15/1776240035
id: 1715237
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 162055971
updated: 2026-04-15 03:06:28

Version 1714077

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-14/1776153764'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-14/1776153764
id: 1714077
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 162000578
updated: 2026-04-14 03:08:36

Version 1712783

created: 2026-04-13 02:58:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-13/1776066958'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-13/1776066958
id: 1712783
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161941711
updated: 2026-04-13 02:58:59

Version 1711623

created: 2026-04-12 03:01:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-12/1775980671'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-12/1775980671
id: 1711623
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161892787
updated: 2026-04-12 03:01:58

Version 1710495

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-11/1775894432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-11/1775894432
id: 1710495
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161841284
updated: 2026-04-11 03:08:26

Version 1709355

created: 2026-04-10 03:10:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-10/1775808189'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-10/1775808189
id: 1709355
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161786054
updated: 2026-04-10 03:10:33

Version 1708182

created: 2026-04-09 03:06:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-09/1775721529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-09/1775721529
id: 1708182
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161730411
updated: 2026-04-09 03:06:23

Version 1706992

created: 2026-04-08 03:09:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-08/1775635355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-08/1775635355
id: 1706992
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161675649
updated: 2026-04-08 03:09:29

Version 1705748

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-07/1775548506'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-07/1775548506
id: 1705748
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161618515
updated: 2026-04-07 02:59:00

Version 1704586

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-06/1775462473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-06/1775462473
id: 1704586
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161561725
updated: 2026-04-06 03:09:50

Version 1703366

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-05/1775376099'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-05/1775376099
id: 1703366
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161514948
updated: 2026-04-05 03:08:01

Version 1702138

created: 2026-04-04 03:04:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-04/1775289582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-04/1775289582
id: 1702138
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161460320
updated: 2026-04-04 03:04:33

Version 1700847

created: 2026-04-03 03:05:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-03/1775203355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPaymentTermsAcceptanceSet/2026-04-03/1775203355
id: 1700847
processed: 1

raw_data:

{
    "ContactId": 5,
    "Id": 0,
    "PaymentTermsAcceptedDateTime": 1,
    "PaymentTermsAcceptedDevice": 3,
    "PaymentTermsAcceptedHTML": 4,
    "PaymentTermsAcceptedIPAddress": 2,
    "ReservationId": 6,
    "ResourceBookingId": 7
}

schema_attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

schema_name_id: 1729
schema_scan_id: 161401738
updated: 2026-04-03 03:05:45

Schema Scans: 15

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

Scan 162167539

duration: 0:00:14.458834

exit_message:

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

id: 162167539

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_moloPaymentTermsAcceptanceSet/2026-04-17/1776412809",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-17/1776412809/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 283902737885298606,
        "service_name": "drive-thru",
        "span_id": 9956143634271763478,
        "trace_id": 133473903323168920
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-17 03:04:02
success: True
trace_id: 133473903323168920

Scan 162111850

duration: 0:00:11.911641

exit_message:

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

id: 162111850

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_moloPaymentTermsAcceptanceSet/2026-04-16/1776326566",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-16/1776326566/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4829738004449286405,
        "service_name": "drive-thru",
        "span_id": 6547281372255374664,
        "trace_id": 16417152121101526369
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-16 03:08:26
success: True
trace_id: 16417152121101526369

Scan 162055971

duration: 0:00:14.512233

exit_message:

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

id: 162055971

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_moloPaymentTermsAcceptanceSet/2026-04-15/1776240035",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-15/1776240035/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1223967648591803500,
        "service_name": "drive-thru",
        "span_id": 17131718459648449185,
        "trace_id": 14338181803727859300
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-15 03:06:13
success: True
trace_id: 14338181803727859300

Scan 162000578

duration: 0:00:11.834267

exit_message:

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

id: 162000578

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_moloPaymentTermsAcceptanceSet/2026-04-14/1776153764",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-14/1776153764/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9061050551283935234,
        "service_name": "drive-thru",
        "span_id": 1025910220004602312,
        "trace_id": 3821675422999399784
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-14 03:08:24
success: True
trace_id: 3821675422999399784

Scan 161941711

duration: 0:00:11.861357

exit_message:

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

id: 161941711

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_moloPaymentTermsAcceptanceSet/2026-04-13/1776066958",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-13/1776066958/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9722147993689308460,
        "service_name": "drive-thru",
        "span_id": 13894329110831126223,
        "trace_id": 4747375112365847506
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-13 02:58:47
success: True
trace_id: 4747375112365847506

Scan 161892787

duration: 0:00:14.411417

exit_message:

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

id: 161892787

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_moloPaymentTermsAcceptanceSet/2026-04-12/1775980671",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-12/1775980671/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14765861602762235410,
        "service_name": "drive-thru",
        "span_id": 9808425363751507649,
        "trace_id": 2701229750553936590
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-12 03:01:43
success: True
trace_id: 2701229750553936590

Scan 161841284

duration: 0:00:14.272454

exit_message:

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

id: 161841284

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_moloPaymentTermsAcceptanceSet/2026-04-11/1775894432",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-11/1775894432/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1660171094377296517,
        "service_name": "drive-thru",
        "span_id": 8983013042602121004,
        "trace_id": 13496562799924244044
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-11 03:08:11
success: True
trace_id: 13496562799924244044

Scan 161786054

duration: 0:00:14.534087

exit_message:

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

id: 161786054

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_moloPaymentTermsAcceptanceSet/2026-04-10/1775808189",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-10/1775808189/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4823033819555140991,
        "service_name": "drive-thru",
        "span_id": 1579676261354390042,
        "trace_id": 9118046157039142934
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-10 03:10:18
success: True
trace_id: 9118046157039142934

Scan 161730411

duration: 0:00:14.379116

exit_message:

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

id: 161730411

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_moloPaymentTermsAcceptanceSet/2026-04-09/1775721529",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-09/1775721529/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13441142313702666539,
        "service_name": "drive-thru",
        "span_id": 17472369965499264150,
        "trace_id": 4544136248797374202
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-09 03:06:09
success: True
trace_id: 4544136248797374202

Scan 161675649

duration: 0:00:14.616114

exit_message:

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

id: 161675649

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_moloPaymentTermsAcceptanceSet/2026-04-08/1775635355",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-08/1775635355/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18013929110805810017,
        "service_name": "drive-thru",
        "span_id": 13013298811823273799,
        "trace_id": 14491790506571341349
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-08 03:09:14
success: True
trace_id: 14491790506571341349

Scan 161618515

duration: 0:00:11.997090

exit_message:

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

id: 161618515

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_moloPaymentTermsAcceptanceSet/2026-04-07/1775548506",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-07/1775548506/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17265879256275445152,
        "service_name": "drive-thru",
        "span_id": 13958086192530203650,
        "trace_id": 15128250743422225692
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-07 02:58:48
success: True
trace_id: 15128250743422225692

Scan 161561725

duration: 0:00:11.947841

exit_message:

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

id: 161561725

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_moloPaymentTermsAcceptanceSet/2026-04-06/1775462473",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-06/1775462473/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4785566820889891634,
        "service_name": "drive-thru",
        "span_id": 5082355260541849282,
        "trace_id": 10979876094289726378
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-06 03:09:38
success: True
trace_id: 10979876094289726378

Scan 161514948

duration: 0:00:14.415487

exit_message:

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

id: 161514948

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_moloPaymentTermsAcceptanceSet/2026-04-05/1775376099",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-05/1775376099/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8957331654022264922,
        "service_name": "drive-thru",
        "span_id": 894390655098758660,
        "trace_id": 18072059634309904694
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-05 03:07:47
success: True
trace_id: 18072059634309904694

Scan 161460320

duration: 0:00:11.816032

exit_message:

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

id: 161460320

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_moloPaymentTermsAcceptanceSet/2026-04-04/1775289582",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-04/1775289582/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15740720414365751101,
        "service_name": "drive-thru",
        "span_id": 15326098873480291929,
        "trace_id": 8533534938029191133
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-04 03:04:21
success: True
trace_id: 8533534938029191133

Scan 161401738

duration: 0:00:14.428947

exit_message:

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

id: 161401738

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_moloPaymentTermsAcceptanceSet/2026-04-03/1775203355",
        "key": "raw/molo_moloPaymentTermsAcceptanceSet/2026-04-03/1775203355/PaymentTermsAcceptanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPaymentTermsAcceptanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15096136286340604608,
        "service_name": "drive-thru",
        "span_id": 4838230086186051702,
        "trace_id": 5045379755177367430
    }
}

running: False
schema_name_id: 1729
start_time: 2026-04-03 03:05:30
success: True
trace_id: 5045379755177367430

Partitions:

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

Schema:

attributes:

{
    "ContactId": "string",
    "Id": "string",
    "PaymentTermsAcceptedDateTime": "string",
    "PaymentTermsAcceptedDevice": "string",
    "PaymentTermsAcceptedHTML": "string",
    "PaymentTermsAcceptedIPAddress": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`\n(\n `Id`  string , `PaymentTermsAcceptedDateTime`  string , `PaymentTermsAcceptedIPAddress`  string , `PaymentTermsAcceptedDevice`  string , `PaymentTermsAcceptedHTML`  string , `ContactId`  string , `ReservationId`  string , `ResourceBookingId`  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_moloPaymentTermsAcceptanceSet/2026-04-17/1776412809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopaymenttermsacceptanceset"
}

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