Schema Info

Schema Name: sfdl_dev_csv.payrix_entities

created: 2022-10-18 12:05:52
disabled: False
format: raw
id: 2035
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773346

created: 2026-04-17 09:38:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-17/1776436687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-17/1776436687
id: 4773346
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6867685
updated: 2026-04-17 09:39:05

Version 4773281

created: 2026-04-16 09:32:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-16/1776349935'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-16/1776349935
id: 4773281
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6867422
updated: 2026-04-16 09:32:34

Version 4773237

created: 2026-04-15 10:00:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-15/1776265220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-15/1776265220
id: 4773237
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6867251
updated: 2026-04-15 10:00:35

Version 4773169

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-14/1776178737'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-14/1776178737
id: 4773169
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6866916
updated: 2026-04-14 09:59:22

Version 4773110

created: 2026-04-13 09:39:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-13/1776091170'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-13/1776091170
id: 4773110
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6866638
updated: 2026-04-13 09:40:05

Version 4773050

created: 2026-04-12 09:39:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-12/1776004741'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-12/1776004741
id: 4773050
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6866433
updated: 2026-04-12 09:39:29

Version 4773007

created: 2026-04-11 09:41:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-11/1775918482'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-11/1775918482
id: 4773007
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6866268
updated: 2026-04-11 09:41:49

Version 4772945

created: 2026-04-10 09:29:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-10/1775831371'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-10/1775831371
id: 4772945
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6866017
updated: 2026-04-10 09:30:00

Version 4772893

created: 2026-04-09 09:48:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-09/1775746105'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-09/1775746105
id: 4772893
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6865812
updated: 2026-04-09 09:48:51

Version 4772813

created: 2026-04-08 09:27:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-08/1775658414'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-08/1775658414
id: 4772813
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6865428
updated: 2026-04-08 09:27:47

Version 4772750

created: 2026-04-07 09:27:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-07/1775572020'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-07/1775572020
id: 4772750
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6865161
updated: 2026-04-07 09:27:43

Version 4772699

created: 2026-04-06 09:41:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-06/1775486475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-06/1775486475
id: 4772699
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6864892
updated: 2026-04-06 09:41:37

Version 4772658

created: 2026-04-05 09:48:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-05/1775400477'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-05/1775400477
id: 4772658
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6864732
updated: 2026-04-05 09:48:17

Version 4772605

created: 2026-04-04 09:43:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-04/1775313828'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-04/1775313828
id: 4772605
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6864510
updated: 2026-04-04 09:44:07

Version 4772540

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-03/1775227180'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/entities/2026-04-03/1775227180
id: 4772540
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": 13,
    "address2": 14,
    "city": 15,
    "country": 18,
    "created": 6,
    "creator": 8,
    "currency": 31,
    "custom": 24,
    "email": 22,
    "entity_id": 5,
    "fax": 21,
    "frozen": 26,
    "inactive": 25,
    "industry": 30,
    "locations": 29,
    "modified": 7,
    "modifier": 9,
    "name": 12,
    "parameter": 10,
    "phone": 20,
    "public": 28,
    "reserved": 27,
    "state": 16,
    "timezone": 19,
    "type": 11,
    "website": 23,
    "zip": 17
}

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

schema_name_id: 2035
schema_scan_id: 6864286
updated: 2026-04-03 09:40:02

Schema Scans: 15

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

Scan 6867685

duration: 0:00:12.530576

exit_message:

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

id: 6867685

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-17/1776436687",
        "key": "raw/entities/2026-04-17/1776436687/3a3056f6-4cc6-4630-8df5-a3914050cd87.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13556168789361157907,
        "service_name": "drive-thru",
        "span_id": 13499914944989121531,
        "trace_id": 1619498399177333531
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-17 09:38:53
success: True
trace_id: 1619498399177333531

Scan 6867422

duration: 0:00:12.593301

exit_message:

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

id: 6867422

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-16/1776349935",
        "key": "raw/entities/2026-04-16/1776349935/db635f6f-d3ee-4f75-88ab-14ae2de97173.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16442577846987001591,
        "service_name": "drive-thru",
        "span_id": 8087022162258807437,
        "trace_id": 14106117184402407450
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-16 09:32:21
success: True
trace_id: 14106117184402407450

Scan 6867251

duration: 0:00:12.498666

exit_message:

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

id: 6867251

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-15/1776265220",
        "key": "raw/entities/2026-04-15/1776265220/5a2576e0-0e63-4084-9405-2bcfb0731655.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4288279627641170910,
        "service_name": "drive-thru",
        "span_id": 10285239008718398301,
        "trace_id": 9771461993584065279
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-15 10:00:23
success: True
trace_id: 9771461993584065279

Scan 6866916

duration: 0:00:12.520770

exit_message:

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

id: 6866916

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-14/1776178737",
        "key": "raw/entities/2026-04-14/1776178737/fb865ef9-1d97-44c2-9df5-17ab91b40036.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5674977153868585094,
        "service_name": "drive-thru",
        "span_id": 11198842251566454008,
        "trace_id": 12276095621238960535
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-14 09:59:10
success: True
trace_id: 12276095621238960535

Scan 6866638

duration: 0:00:15.184198

exit_message:

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

id: 6866638

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-13/1776091170",
        "key": "raw/entities/2026-04-13/1776091170/f065f0d0-3218-47e4-b8db-9929b8747efa.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11509716393403104293,
        "service_name": "drive-thru",
        "span_id": 11977784551137187824,
        "trace_id": 132961475605935745
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-13 09:39:50
success: True
trace_id: 132961475605935745

Scan 6866433

duration: 0:00:12.602984

exit_message:

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

id: 6866433

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-12/1776004741",
        "key": "raw/entities/2026-04-12/1776004741/bbf953a0-68e3-44e9-b931-1aea8931f6b9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7408173557996362535,
        "service_name": "drive-thru",
        "span_id": 449103375296134411,
        "trace_id": 1071262018553916763
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-12 09:39:16
success: True
trace_id: 1071262018553916763

Scan 6866268

duration: 0:00:12.467139

exit_message:

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

id: 6866268

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-11/1775918482",
        "key": "raw/entities/2026-04-11/1775918482/532b27e5-a4ec-4929-8e56-71b5c5f1ec11.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10974398712051935357,
        "service_name": "drive-thru",
        "span_id": 9292038805732274672,
        "trace_id": 17911250921789450322
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-11 09:41:37
success: True
trace_id: 17911250921789450322

Scan 6866017

duration: 0:00:15.171501

exit_message:

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

id: 6866017

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-10/1775831371",
        "key": "raw/entities/2026-04-10/1775831371/288efd8b-d200-45d2-9c69-3e308a6391d7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1643582240313014803,
        "service_name": "drive-thru",
        "span_id": 11630720642617031625,
        "trace_id": 5844182056305499161
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-10 09:29:45
success: True
trace_id: 5844182056305499161

Scan 6865812

duration: 0:00:15.076423

exit_message:

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

id: 6865812

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-09/1775746105",
        "key": "raw/entities/2026-04-09/1775746105/b63e29ee-5180-4ea9-a708-d424490f387d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11812897381648824478,
        "service_name": "drive-thru",
        "span_id": 1262133157487989741,
        "trace_id": 12748458447144642446
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-09 09:48:35
success: True
trace_id: 12748458447144642446

Scan 6865428

duration: 0:00:15.096296

exit_message:

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

id: 6865428

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-08/1775658414",
        "key": "raw/entities/2026-04-08/1775658414/c99a47da-077a-44ea-af7b-a7b1b76743e9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17143975011773502119,
        "service_name": "drive-thru",
        "span_id": 15658796689852535315,
        "trace_id": 12320374803426226310
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-08 09:27:32
success: True
trace_id: 12320374803426226310

Scan 6865161

duration: 0:00:12.656413

exit_message:

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

id: 6865161

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-07/1775572020",
        "key": "raw/entities/2026-04-07/1775572020/9cabd8a7-1357-49ba-a673-b27767317889.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2683717231115405758,
        "service_name": "drive-thru",
        "span_id": 14017456430767893042,
        "trace_id": 13440491943532353739
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-07 09:27:30
success: True
trace_id: 13440491943532353739

Scan 6864892

duration: 0:00:15.074642

exit_message:

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

id: 6864892

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-06/1775486475",
        "key": "raw/entities/2026-04-06/1775486475/ed23e5d7-ba35-490b-8990-8279ca7db8ea.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13669656003354846612,
        "service_name": "drive-thru",
        "span_id": 9266219862213709487,
        "trace_id": 2322771394718374166
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-06 09:41:22
success: True
trace_id: 2322771394718374166

Scan 6864732

duration: 0:00:12.435346

exit_message:

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

id: 6864732

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-05/1775400477",
        "key": "raw/entities/2026-04-05/1775400477/20f2bcad-6f27-498f-8dba-d8ed8f96b01f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11804452495839200398,
        "service_name": "drive-thru",
        "span_id": 4445319025532262786,
        "trace_id": 10881155704404637401
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-05 09:48:05
success: True
trace_id: 10881155704404637401

Scan 6864510

duration: 0:00:14.950937

exit_message:

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

id: 6864510

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-04/1775313828",
        "key": "raw/entities/2026-04-04/1775313828/63a10166-5649-418f-bf47-479fe9de79df.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2990479508170934268,
        "service_name": "drive-thru",
        "span_id": 18014686753565980103,
        "trace_id": 1476619695947890628
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-04 09:43:52
success: True
trace_id: 1476619695947890628

Scan 6864286

duration: 0:00:15.089001

exit_message:

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

id: 6864286

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entities/2026-04-03/1775227180",
        "key": "raw/entities/2026-04-03/1775227180/3b2fb971-14d9-4232-a3f7-932c71f5aa08.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13121552800543347785,
        "service_name": "drive-thru",
        "span_id": 6613793075825012462,
        "trace_id": 7546481057910690559
    }
}

running: False
schema_name_id: 2035
start_time: 2026-04-03 09:39:47
success: True
trace_id: 7546481057910690559

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",
    "city": "string",
    "country": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "custom": "string",
    "email": "string",
    "entity_id": "string",
    "fax": "string",
    "frozen": "string",
    "inactive": "string",
    "industry": "string",
    "locations": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "parameter": "string",
    "phone": "string",
    "public": "string",
    "reserved": "string",
    "state": "string",
    "timezone": "string",
    "type": "string",
    "website": "string",
    "zip": "string"
}

created: 2026-04-17 09:38:54

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-17/1776436687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-10-18 12:05:52",
        "disabled": false,
        "format": "raw",
        "id": 2035,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_entities"
        },
        "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",
            "city": "string",
            "country": "string",
            "created": "string",
            "creator": "string",
            "currency": "string",
            "custom": "string",
            "email": "string",
            "entity_id": "string",
            "fax": "string",
            "frozen": "string",
            "inactive": "string",
            "industry": "string",
            "locations": "string",
            "modified": "string",
            "modifier": "string",
            "name": "string",
            "parameter": "string",
            "phone": "string",
            "public": "string",
            "reserved": "string",
            "state": "string",
            "timezone": "string",
            "type": "string",
            "website": "string",
            "zip": "string"
        },
        "created": "2026-04-17 09:38:54",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `parameter`  string , `type`  string , `name`  string , `address1`  string , `address2`  string , `city`  string , `state`  string , `zip`  string , `country`  string , `timezone`  string , `phone`  string , `fax`  string , `email`  string , `website`  string , `custom`  string , `inactive`  string , `frozen`  string , `reserved`  string , `public`  string , `locations`  string , `industry`  string , `currency`  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-payrix-dev/raw/entities/2026-04-17/1776436687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}