Schema Info

Schema Name: sfdl_prod_csv.payrixess_entities

created: 2024-07-24 10:16:31
disabled: False
format: raw
id: 1935
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_csv",
    "table": "payrixess_entities"
}

type: csv

Schema Versions: 15

Version 1718242

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-17/1776436115'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-17/1776436115
id: 1718242
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: 1935
schema_scan_id: 162178377
updated: 2026-04-17 09:28:50

Version 1717025

created: 2026-04-16 09:30:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-16/1776349837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-16/1776349837
id: 1717025
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: 1935
schema_scan_id: 162122762
updated: 2026-04-16 09:30:55

Version 1715824

created: 2026-04-15 09:27:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-15/1776263229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-15/1776263229
id: 1715824
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: 1935
schema_scan_id: 162066870
updated: 2026-04-15 09:27:25

Version 1714627

created: 2026-04-14 09:40:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-14/1776177598'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-14/1776177598
id: 1714627
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: 1935
schema_scan_id: 162011359
updated: 2026-04-14 09:40:20

Version 1713416

created: 2026-04-13 09:33:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-13/1776090786'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-13/1776090786
id: 1713416
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: 1935
schema_scan_id: 161953733
updated: 2026-04-13 09:33:32

Version 1712218

created: 2026-04-12 09:30:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-12/1776004212'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-12/1776004212
id: 1712218
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: 1935
schema_scan_id: 161903450
updated: 2026-04-12 09:30:36

Version 1711029

created: 2026-04-11 09:43:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-11/1775918629'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-11/1775918629
id: 1711029
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: 1935
schema_scan_id: 161852110
updated: 2026-04-11 09:44:06

Version 1709859

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-10/1775832251'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-10/1775832251
id: 1709859
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: 1935
schema_scan_id: 161797544
updated: 2026-04-10 09:46:21

Version 1708681

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-09/1775744947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-09/1775744947
id: 1708681
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: 1935
schema_scan_id: 161741345
updated: 2026-04-09 09:29:25

Version 1707505

created: 2026-04-08 09:31:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-08/1775658656'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-08/1775658656
id: 1707505
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: 1935
schema_scan_id: 161686223
updated: 2026-04-08 09:31:32

Version 1706303

created: 2026-04-07 09:28:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-07/1775572108'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-07/1775572108
id: 1706303
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: 1935
schema_scan_id: 161630210
updated: 2026-04-07 09:28:59

Version 1705110

created: 2026-04-06 09:43:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-06/1775486571'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-06/1775486571
id: 1705110
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: 1935
schema_scan_id: 161572938
updated: 2026-04-06 09:43:26

Version 1703892

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-05/1775400429'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-05/1775400429
id: 1703892
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: 1935
schema_scan_id: 161524028
updated: 2026-04-05 09:47:29

Version 1702707

created: 2026-04-04 09:27:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-04/1775312874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-04/1775312874
id: 1702707
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: 1935
schema_scan_id: 161471651
updated: 2026-04-04 09:28:10

Version 1701507

created: 2026-04-03 09:28:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-03/1775226492'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-03/1775226492
id: 1701507
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: 1935
schema_scan_id: 161414291
updated: 2026-04-03 09:28:28

Schema Scans: 15

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

Scan 162178377

duration: 0:00:12.473791

exit_message:

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

id: 162178377

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-17/1776436115",
        "key": "raw/entities/2026-04-17/1776436115/fda437d6-d8ed-4b7d-a0c7-889f74048e3f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1116386604899133238,
        "service_name": "drive-thru",
        "span_id": 10676146545813554527,
        "trace_id": 464766596273414935
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-17 09:28:38
success: True
trace_id: 464766596273414935

Scan 162122762

duration: 0:00:15.087824

exit_message:

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

id: 162122762

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-16/1776349837",
        "key": "raw/entities/2026-04-16/1776349837/ddea7e19-a50d-42fb-83e0-a7cbd6a899c7.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2096416125902874407,
        "service_name": "drive-thru",
        "span_id": 8774319846136755481,
        "trace_id": 4760133133061799647
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-16 09:30:40
success: True
trace_id: 4760133133061799647

Scan 162066870

duration: 0:00:12.551243

exit_message:

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

id: 162066870

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-15/1776263229",
        "key": "raw/entities/2026-04-15/1776263229/2374e665-23dd-4c41-b379-326c3da10c54.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5901592332941211960,
        "service_name": "drive-thru",
        "span_id": 11197656203321417656,
        "trace_id": 16723243550224819882
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-15 09:27:12
success: True
trace_id: 16723243550224819882

Scan 162011359

duration: 0:00:14.938491

exit_message:

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

id: 162011359

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-14/1776177598",
        "key": "raw/entities/2026-04-14/1776177598/d965d7ef-f77e-4da2-8699-d98f3f280f97.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 346694608038021580,
        "service_name": "drive-thru",
        "span_id": 15053873773600257264,
        "trace_id": 18134170161146685219
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-14 09:40:05
success: True
trace_id: 18134170161146685219

Scan 161953733

duration: 0:00:12.497232

exit_message:

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

id: 161953733

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-13/1776090786",
        "key": "raw/entities/2026-04-13/1776090786/af284adf-6c55-4a11-9616-7b77989c9054.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4103907115924051120,
        "service_name": "drive-thru",
        "span_id": 17793458120362862072,
        "trace_id": 782620360380598397
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-13 09:33:19
success: True
trace_id: 782620360380598397

Scan 161903450

duration: 0:00:12.384962

exit_message:

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

id: 161903450

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-12/1776004212",
        "key": "raw/entities/2026-04-12/1776004212/da8b941c-cc53-4393-832e-e09f5467babe.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1489583256177978504,
        "service_name": "drive-thru",
        "span_id": 2136217351425332370,
        "trace_id": 15068075815526492160
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-12 09:30:24
success: True
trace_id: 15068075815526492160

Scan 161852110

duration: 0:00:14.796732

exit_message:

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

id: 161852110

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-11/1775918629",
        "key": "raw/entities/2026-04-11/1775918629/26eaace7-e3b3-4d72-8049-daa66cf187dc.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1504752943746207291,
        "service_name": "drive-thru",
        "span_id": 6116318272714491269,
        "trace_id": 15788265370889588474
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-11 09:43:52
success: True
trace_id: 15788265370889588474

Scan 161797544

duration: 0:00:14.966888

exit_message:

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

id: 161797544

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-10/1775832251",
        "key": "raw/entities/2026-04-10/1775832251/d65712a9-e2c9-4d63-bb89-4f118a3f4ee5.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10435170840516993924,
        "service_name": "drive-thru",
        "span_id": 1363160570816773736,
        "trace_id": 14600332954940054902
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-10 09:46:06
success: True
trace_id: 14600332954940054902

Scan 161741345

duration: 0:00:15.023304

exit_message:

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

id: 161741345

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-09/1775744947",
        "key": "raw/entities/2026-04-09/1775744947/9888a81c-91ef-4f36-a7d4-d86aa632c854.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3065795856037260379,
        "service_name": "drive-thru",
        "span_id": 13355082658346978802,
        "trace_id": 9061368136423461942
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-09 09:29:10
success: True
trace_id: 9061368136423461942

Scan 161686223

duration: 0:00:12.724063

exit_message:

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

id: 161686223

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-08/1775658656",
        "key": "raw/entities/2026-04-08/1775658656/bcf30f3a-9d92-4479-9a65-cb2c9c758ce4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9649300620123719811,
        "service_name": "drive-thru",
        "span_id": 8057080669535856001,
        "trace_id": 13696153444863886223
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-08 09:31:19
success: True
trace_id: 13696153444863886223

Scan 161630210

duration: 0:00:17.752913

exit_message:

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

id: 161630210

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-07/1775572108",
        "key": "raw/entities/2026-04-07/1775572108/55a7bc8f-e587-4655-a5cf-acce8e467066.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14814518104347308513,
        "service_name": "drive-thru",
        "span_id": 13725883982556586106,
        "trace_id": 6449387394293886114
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-07 09:28:42
success: True
trace_id: 6449387394293886114

Scan 161572938

duration: 0:00:15.021518

exit_message:

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

id: 161572938

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-06/1775486571",
        "key": "raw/entities/2026-04-06/1775486571/8334ec0f-4c01-4caf-b7c1-bcaccca950bc.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9650366448737806367,
        "service_name": "drive-thru",
        "span_id": 466526261843607511,
        "trace_id": 1903484015157954108
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-06 09:43:11
success: True
trace_id: 1903484015157954108

Scan 161524028

duration: 0:00:15.052937

exit_message:

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

id: 161524028

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-05/1775400429",
        "key": "raw/entities/2026-04-05/1775400429/d47f2ba5-5528-4654-a01d-a93e328f2aea.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15116060698320333468,
        "service_name": "drive-thru",
        "span_id": 14563866464549082087,
        "trace_id": 10478355842071456266
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-05 09:47:14
success: True
trace_id: 10478355842071456266

Scan 161471651

duration: 0:00:12.388712

exit_message:

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

id: 161471651

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-04/1775312874",
        "key": "raw/entities/2026-04-04/1775312874/4e77b219-8f5a-4fcf-b51f-131c27e57e2e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 332681782883445559,
        "service_name": "drive-thru",
        "span_id": 11686082577060743852,
        "trace_id": 9014409314923098154
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-04 09:27:57
success: True
trace_id: 9014409314923098154

Scan 161414291

duration: 0:00:12.415955

exit_message:

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

id: 161414291

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/entities/2026-04-03/1775226492",
        "key": "raw/entities/2026-04-03/1775226492/184d884a-ef90-4d5b-9e5e-2d77ea196c30.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16296967401591739426,
        "service_name": "drive-thru",
        "span_id": 16683704699121693260,
        "trace_id": 15121712611926050711
    }
}

running: False
schema_name_id: 1935
start_time: 2026-04-03 09:28:15
success: True
trace_id: 15121712611926050711

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:28:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-17/1776436115'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-24 10:16:31",
        "disabled": false,
        "format": "raw",
        "id": 1935,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrixess_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:28:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_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-payrixess-prod/raw/entities/2026-04-17/1776436115'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}