Schema Info

Schema Name: sfdl_dev_csv.payrixess_customers

created: 2024-07-22 13:01:50
disabled: False
format: raw
id: 2358
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_csv",
    "table": "payrixess_customers"
}

type: csv

Schema Versions: 15

Version 4773364

created: 2026-04-17 09:53:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-17/1776437609'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-17/1776437609
id: 4773364
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6867805
updated: 2026-04-17 09:54:08

Version 4773292

created: 2026-04-16 09:38:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-16/1776350301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-16/1776350301
id: 4773292
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6867516
updated: 2026-04-16 09:38:46

Version 4773228

created: 2026-04-15 09:52:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-15/1776264711'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-15/1776264711
id: 4773228
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6867182
updated: 2026-04-15 09:52:45

Version 4773160

created: 2026-04-14 09:42:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-14/1776177750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-14/1776177750
id: 4773160
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6866902
updated: 2026-04-14 09:42:54

Version 4773105

created: 2026-04-13 09:34:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-13/1776090791'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-13/1776090791
id: 4773105
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6866602
updated: 2026-04-13 09:34:37

Version 4773058

created: 2026-04-12 09:45:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-12/1776005121'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-12/1776005121
id: 4773058
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6866491
updated: 2026-04-12 09:45:43

Version 4772996

created: 2026-04-11 09:29:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-11/1775917754'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-11/1775917754
id: 4772996
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6866239
updated: 2026-04-11 09:29:48

Version 4772962

created: 2026-04-10 09:46:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-10/1775832382'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-10/1775832382
id: 4772962
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6866095
updated: 2026-04-10 09:47:03

Version 4772877

created: 2026-04-09 09:32:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-09/1775745088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-09/1775745088
id: 4772877
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6865718
updated: 2026-04-09 09:32:18

Version 4772829

created: 2026-04-08 09:32:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-08/1775658689'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-08/1775658689
id: 4772829
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6865488
updated: 2026-04-08 09:32:14

Version 4772780

created: 2026-04-07 09:49:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-07/1775573322'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-07/1775573322
id: 4772780
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6865283
updated: 2026-04-07 09:49:26

Version 4772706

created: 2026-04-06 09:44:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-06/1775486646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-06/1775486646
id: 4772706
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6864917
updated: 2026-04-06 09:44:35

Version 4772657

created: 2026-04-05 09:47:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-05/1775400464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-05/1775400464
id: 4772657
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6864731
updated: 2026-04-05 09:48:06

Version 4772597

created: 2026-04-04 09:32:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-04/1775313121'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-04/1775313121
id: 4772597
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6864476
updated: 2026-04-04 09:32:45

Version 4772548

created: 2026-04-03 09:51:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-03/1775227879'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-03/1775227879
id: 4772548
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "address1": 31,
    "address2": 29,
    "authtokencustomer": 35,
    "city": 9,
    "company": 17,
    "country": 5,
    "created": 30,
    "creator": 26,
    "custom": 32,
    "customer_id": 19,
    "email": 23,
    "entity": 40,
    "fax": 21,
    "first": 39,
    "frozen": 34,
    "inactive": 13,
    "last": 28,
    "login_id": 41,
    "merchant": 33,
    "middle": 27,
    "modified": 16,
    "modifier": 10,
    "phone": 37,
    "shippingaddress1": 12,
    "shippingaddress2": 11,
    "shippingcity": 7,
    "shippingcompany": 6,
    "shippingcountry": 14,
    "shippingfax": 8,
    "shippingfirst": 22,
    "shippinglast": 15,
    "shippingmiddle": 18,
    "shippingphone": 36,
    "shippingstate": 38,
    "shippingzip": 24,
    "state": 20,
    "zip": 25
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

schema_name_id: 2358
schema_scan_id: 6864327
updated: 2026-04-03 09:52:10

Schema Scans: 15

Last at 2026-04-17 09:53:55

Scan 6867805

duration: 0:00:13.038865

exit_message:

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

id: 6867805

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-17/1776437609",
        "key": "raw/customers/2026-04-17/1776437609/14334ed4-22c9-4738-b717-04fbd1b565ae.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4931780182171594382,
        "service_name": "drive-thru",
        "span_id": 16235665176115687671,
        "trace_id": 829448753308747125
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-17 09:53:55
success: True
trace_id: 829448753308747125

Scan 6867516

duration: 0:00:12.783474

exit_message:

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

id: 6867516

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-16/1776350301",
        "key": "raw/customers/2026-04-16/1776350301/75640ab5-0bb8-4dbe-a5a4-b8a04fb49ef4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5435537854091837489,
        "service_name": "drive-thru",
        "span_id": 11932374991486311880,
        "trace_id": 148513085770399028
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-16 09:38:33
success: True
trace_id: 148513085770399028

Scan 6867182

duration: 0:00:18.001233

exit_message:

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

id: 6867182

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-15/1776264711",
        "key": "raw/customers/2026-04-15/1776264711/33a6140c-e936-44ad-b34e-cc7b7472843b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15093159308231121248,
        "service_name": "drive-thru",
        "span_id": 3121729401919271779,
        "trace_id": 16853888234097661900
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-15 09:52:27
success: True
trace_id: 16853888234097661900

Scan 6866902

duration: 0:00:12.679362

exit_message:

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

id: 6866902

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-14/1776177750",
        "key": "raw/customers/2026-04-14/1776177750/ecb2abfb-9769-4f0a-b03a-1a801484bdfc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8883579329059506977,
        "service_name": "drive-thru",
        "span_id": 2814722168921762624,
        "trace_id": 9144854133938703878
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-14 09:42:41
success: True
trace_id: 9144854133938703878

Scan 6866602

duration: 0:00:13.021363

exit_message:

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

id: 6866602

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-13/1776090791",
        "key": "raw/customers/2026-04-13/1776090791/75822982-85e8-4c0d-809f-c6594c2394ee.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7849064538273828333,
        "service_name": "drive-thru",
        "span_id": 17625086392930213539,
        "trace_id": 2996386844460899130
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-13 09:34:24
success: True
trace_id: 2996386844460899130

Scan 6866491

duration: 0:00:12.896813

exit_message:

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

id: 6866491

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-12/1776005121",
        "key": "raw/customers/2026-04-12/1776005121/59b9fe7e-616f-4a09-bdcd-35b19fdf3443.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13061009877321157640,
        "service_name": "drive-thru",
        "span_id": 7911901672515205331,
        "trace_id": 6214796197467436921
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-12 09:45:30
success: True
trace_id: 6214796197467436921

Scan 6866239

duration: 0:00:12.849633

exit_message:

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

id: 6866239

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-11/1775917754",
        "key": "raw/customers/2026-04-11/1775917754/fdd0a572-3c00-420a-b7b4-f689682b71c6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7288616974723295691,
        "service_name": "drive-thru",
        "span_id": 17173066123243728816,
        "trace_id": 13262950612736291449
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-11 09:29:35
success: True
trace_id: 13262950612736291449

Scan 6866095

duration: 0:00:15.318504

exit_message:

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

id: 6866095

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-10/1775832382",
        "key": "raw/customers/2026-04-10/1775832382/968fd45b-17bf-4f62-a62c-bc95bade0d45.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5392658748038201646,
        "service_name": "drive-thru",
        "span_id": 8895811574102862863,
        "trace_id": 16396478513662408436
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-10 09:46:47
success: True
trace_id: 16396478513662408436

Scan 6865718

duration: 0:00:15.528919

exit_message:

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

id: 6865718

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-09/1775745088",
        "key": "raw/customers/2026-04-09/1775745088/9b3f5d08-bc3e-4acf-bcfc-f50f9c7a693c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6242115179869594947,
        "service_name": "drive-thru",
        "span_id": 11163934076798153847,
        "trace_id": 17449482172650977176
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-09 09:32:02
success: True
trace_id: 17449482172650977176

Scan 6865488

duration: 0:00:15.383436

exit_message:

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

id: 6865488

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-08/1775658689",
        "key": "raw/customers/2026-04-08/1775658689/29772e56-4750-48a3-bd4d-a307a3c7034e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1236748273468022622,
        "service_name": "drive-thru",
        "span_id": 18217175364910375851,
        "trace_id": 15276027564570897072
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-08 09:31:59
success: True
trace_id: 15276027564570897072

Scan 6865283

duration: 0:00:13.020571

exit_message:

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

id: 6865283

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-07/1775573322",
        "key": "raw/customers/2026-04-07/1775573322/5b06d141-bc2d-48bc-98b1-da9ec7e63181.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3579817864857730887,
        "service_name": "drive-thru",
        "span_id": 2341399328848505941,
        "trace_id": 605068879364307380
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-07 09:49:13
success: True
trace_id: 605068879364307380

Scan 6864917

duration: 0:00:15.397619

exit_message:

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

id: 6864917

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-06/1775486646",
        "key": "raw/customers/2026-04-06/1775486646/bebeb6ce-ecbc-41e6-a07d-cb27c95a950d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2670826299169126353,
        "service_name": "drive-thru",
        "span_id": 17791754489576503389,
        "trace_id": 16009813568355202866
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-06 09:44:20
success: True
trace_id: 16009813568355202866

Scan 6864731

duration: 0:00:12.658425

exit_message:

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

id: 6864731

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-05/1775400464",
        "key": "raw/customers/2026-04-05/1775400464/f6b92148-a5fc-4662-9bdc-bf91df79bdfa.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9945721415988587585,
        "service_name": "drive-thru",
        "span_id": 16686925607937669334,
        "trace_id": 4055313240454802517
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-05 09:47:53
success: True
trace_id: 4055313240454802517

Scan 6864476

duration: 0:00:15.398576

exit_message:

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

id: 6864476

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-04/1775313121",
        "key": "raw/customers/2026-04-04/1775313121/57651566-eb1c-45f9-b735-ef7307186c54.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16209430213532135424,
        "service_name": "drive-thru",
        "span_id": 7795590709258681310,
        "trace_id": 11756786803816392636
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-04 09:32:29
success: True
trace_id: 11756786803816392636

Scan 6864327

duration: 0:00:15.460461

exit_message:

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

id: 6864327

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/customers/2026-04-03/1775227879",
        "key": "raw/customers/2026-04-03/1775227879/8b92b90d-01f4-41ef-9cf1-f7b480c59e20.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_customers",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7892822733950243412,
        "service_name": "drive-thru",
        "span_id": 11814261615974955760,
        "trace_id": 17348551548737149149
    }
}

running: False
schema_name_id: 2358
start_time: 2026-04-03 09:51:54
success: True
trace_id: 17348551548737149149

Partitions:

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

Schema:

attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "address1": "string",
    "address2": "string",
    "authtokencustomer": "string",
    "city": "string",
    "company": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "custom": "string",
    "customer_id": "string",
    "email": "string",
    "entity": "string",
    "fax": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "last": "string",
    "login_id": "string",
    "merchant": "string",
    "middle": "string",
    "modified": "string",
    "modifier": "string",
    "phone": "string",
    "shippingaddress1": "string",
    "shippingaddress2": "string",
    "shippingcity": "string",
    "shippingcompany": "string",
    "shippingcountry": "string",
    "shippingfax": "string",
    "shippingfirst": "string",
    "shippinglast": "string",
    "shippingmiddle": "string",
    "shippingphone": "string",
    "shippingstate": "string",
    "shippingzip": "string",
    "state": "string",
    "zip": "string"
}

created: 2026-04-17 09:53:56

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-17/1776437609'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-07-22 13:01:50",
        "disabled": false,
        "format": "raw",
        "id": 2358,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_customers"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_hoodie_commit_seqno": "string",
            "_hoodie_commit_time": "string",
            "_hoodie_file_name": "string",
            "_hoodie_partition_path": "string",
            "_hoodie_record_key": "string",
            "address1": "string",
            "address2": "string",
            "authtokencustomer": "string",
            "city": "string",
            "company": "string",
            "country": "string",
            "created": "string",
            "creator": "string",
            "custom": "string",
            "customer_id": "string",
            "email": "string",
            "entity": "string",
            "fax": "string",
            "first": "string",
            "frozen": "string",
            "inactive": "string",
            "last": "string",
            "login_id": "string",
            "merchant": "string",
            "middle": "string",
            "modified": "string",
            "modifier": "string",
            "phone": "string",
            "shippingaddress1": "string",
            "shippingaddress2": "string",
            "shippingcity": "string",
            "shippingcompany": "string",
            "shippingcountry": "string",
            "shippingfax": "string",
            "shippingfirst": "string",
            "shippinglast": "string",
            "shippingmiddle": "string",
            "shippingphone": "string",
            "shippingstate": "string",
            "shippingzip": "string",
            "state": "string",
            "zip": "string"
        },
        "created": "2026-04-17 09:53:56",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_customers`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `country`  string , `shippingcompany`  string , `shippingcity`  string , `shippingfax`  string , `city`  string , `modifier`  string , `shippingaddress2`  string , `shippingaddress1`  string , `inactive`  string , `shippingcountry`  string , `shippinglast`  string , `modified`  string , `company`  string , `shippingmiddle`  string , `customer_id`  string , `state`  string , `fax`  string , `shippingfirst`  string , `email`  string , `shippingzip`  string , `zip`  string , `creator`  string , `middle`  string , `last`  string , `address2`  string , `created`  string , `address1`  string , `custom`  string , `merchant`  string , `frozen`  string , `authtokencustomer`  string , `shippingphone`  string , `phone`  string , `shippingstate`  string , `first`  string , `entity`  string , `login_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-csv-payrixess-dev/raw/customers/2026-04-17/1776437609'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_customers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_customers"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}