Schema Info

Schema Name: sfdl_prod_csv.payrix_entities

created: 2022-10-26 15:43:23
disabled: False
format: raw
id: 1200
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718257

created: 2026-04-17 09:33:23

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-17/1776436394
id: 1718257
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: 1200
schema_scan_id: 162178469
updated: 2026-04-17 09:33:36

Version 1717014

created: 2026-04-16 09:26:54

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-16/1776349607
id: 1717014
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: 1200
schema_scan_id: 162122644
updated: 2026-04-16 09:27:05

Version 1715871

created: 2026-04-15 11:18:18

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-15/1776269884
id: 1715871
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: 1200
schema_scan_id: 162072628
updated: 2026-04-15 11:18:37

Version 1714944

created: 2026-04-14 21:08:38

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-14/1776218913
id: 1714944
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: 1200
schema_scan_id: 162046363
updated: 2026-04-14 21:08:49

Version 1713412

created: 2026-04-13 09:32:20

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-13/1776090729
id: 1713412
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: 1200
schema_scan_id: 161953725
updated: 2026-04-13 09:32:34

Version 1712239

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-12/1776004995
id: 1712239
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: 1200
schema_scan_id: 161903627
updated: 2026-04-12 09:43:42

Version 1711019

created: 2026-04-11 09:31:10

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-11/1775917857
id: 1711019
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: 1200
schema_scan_id: 161852039
updated: 2026-04-11 09:31:21

Version 1709834

created: 2026-04-10 09:26:57

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-10/1775831202
id: 1709834
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: 1200
schema_scan_id: 161797246
updated: 2026-04-10 09:27:08

Version 1708697

created: 2026-04-09 09:38:21

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-09/1775745497
id: 1708697
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: 1200
schema_scan_id: 161741481
updated: 2026-04-09 09:38:33

Version 1707517

created: 2026-04-08 09:35:39

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-08/1775658897
id: 1707517
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: 1200
schema_scan_id: 161686314
updated: 2026-04-08 09:35:53

Version 1706323

created: 2026-04-07 09:42:23

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-07/1775572937
id: 1706323
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: 1200
schema_scan_id: 161630541
updated: 2026-04-07 09:42:37

Version 1705091

created: 2026-04-06 09:33:30

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-06/1775485998
id: 1705091
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: 1200
schema_scan_id: 161572773
updated: 2026-04-06 09:33:42

Version 1703854

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-05/1775399272
id: 1703854
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: 1200
schema_scan_id: 161523752
updated: 2026-04-05 09:28:17

Version 1702728

created: 2026-04-04 09:42:23

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-04/1775313737
id: 1702728
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: 1200
schema_scan_id: 161471817
updated: 2026-04-04 09:42:34

Version 1701544

created: 2026-04-03 09:55:26

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/entities/2026-04-03/1775228112
id: 1701544
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: 1200
schema_scan_id: 161415318
updated: 2026-04-03 09:55:40

Schema Scans: 15

Last at 2026-04-17 09:33:21

Scan 162178469

duration: 0:00:15.055949

exit_message:

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

id: 162178469

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-17/1776436394",
        "key": "raw/entities/2026-04-17/1776436394/316b13f9-0f9a-4538-874d-792a6e824742.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 58269614574418583,
        "service_name": "drive-thru",
        "span_id": 9342572409854489911,
        "trace_id": 16149976337899407066
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-17 09:33:21
success: True
trace_id: 16149976337899407066

Scan 162122644

duration: 0:00:12.495836

exit_message:

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

id: 162122644

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-16/1776349607",
        "key": "raw/entities/2026-04-16/1776349607/c8fad33d-580a-4b46-8b13-bfe746a9ed0e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9845290568062135359,
        "service_name": "drive-thru",
        "span_id": 5290317649677623464,
        "trace_id": 17956050226988666591
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-16 09:26:53
success: True
trace_id: 17956050226988666591

Scan 162072628

duration: 0:00:20.281836

exit_message:

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

id: 162072628

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-15/1776269884",
        "key": "raw/entities/2026-04-15/1776269884/6f89a0e4-a2cc-429a-ad67-4d914c9eb91a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11344417982614448281,
        "service_name": "drive-thru",
        "span_id": 4828173867494785303,
        "trace_id": 14798419985118950191
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-15 11:18:17
success: True
trace_id: 14798419985118950191

Scan 162046363

duration: 0:00:12.476081

exit_message:

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

id: 162046363

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-14/1776218913",
        "key": "raw/entities/2026-04-14/1776218913/205634f4-8caf-4568-9d7c-260d39ca2a7f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10815275921746556703,
        "service_name": "drive-thru",
        "span_id": 7334555107966136796,
        "trace_id": 2969372886581407270
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-14 21:08:37
success: True
trace_id: 2969372886581407270

Scan 161953725

duration: 0:00:15.054588

exit_message:

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

id: 161953725

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-13/1776090729",
        "key": "raw/entities/2026-04-13/1776090729/629e3b25-bdd5-4777-9c48-9aa578d32ec8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3337010906683949936,
        "service_name": "drive-thru",
        "span_id": 1085621012522945794,
        "trace_id": 9311352053832629343
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-13 09:32:19
success: True
trace_id: 9311352053832629343

Scan 161903627

duration: 0:00:15.011130

exit_message:

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

id: 161903627

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-12/1776004995",
        "key": "raw/entities/2026-04-12/1776004995/e5f1b268-409e-4787-b7fa-39058b3c1981.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2430915950096316569,
        "service_name": "drive-thru",
        "span_id": 17000211892846191680,
        "trace_id": 161229796770160342
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-12 09:43:27
success: True
trace_id: 161229796770160342

Scan 161852039

duration: 0:00:12.419660

exit_message:

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

id: 161852039

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-11/1775917857",
        "key": "raw/entities/2026-04-11/1775917857/87191d96-6316-4372-9e72-2a325960c818.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 275955932632848357,
        "service_name": "drive-thru",
        "span_id": 8676809787783174411,
        "trace_id": 10805043307856451906
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-11 09:31:09
success: True
trace_id: 10805043307856451906

Scan 161797246

duration: 0:00:12.636648

exit_message:

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

id: 161797246

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-10/1775831202",
        "key": "raw/entities/2026-04-10/1775831202/ad55775e-3ecd-43c8-ad08-c47c7a76a3fc.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13799232421110865392,
        "service_name": "drive-thru",
        "span_id": 8311946729812998921,
        "trace_id": 7198770582608565790
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-10 09:26:56
success: True
trace_id: 7198770582608565790

Scan 161741481

duration: 0:00:12.469648

exit_message:

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

id: 161741481

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-09/1775745497",
        "key": "raw/entities/2026-04-09/1775745497/1c0b2dbb-3725-4494-8e2a-f404c4aa8c30.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13526677846843732017,
        "service_name": "drive-thru",
        "span_id": 3540861384633674270,
        "trace_id": 11851159761323457686
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-09 09:38:20
success: True
trace_id: 11851159761323457686

Scan 161686314

duration: 0:00:15.121338

exit_message:

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

id: 161686314

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-08/1775658897",
        "key": "raw/entities/2026-04-08/1775658897/e6e3fd1d-c9d5-48bd-9d51-c2e500dc3b09.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12316660020358367677,
        "service_name": "drive-thru",
        "span_id": 14016004963800184580,
        "trace_id": 16495155316367441596
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-08 09:35:38
success: True
trace_id: 16495155316367441596

Scan 161630541

duration: 0:00:14.983550

exit_message:

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

id: 161630541

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-07/1775572937",
        "key": "raw/entities/2026-04-07/1775572937/0763966d-6724-4bf2-bfb5-6c55f7b98479.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15929825874006176936,
        "service_name": "drive-thru",
        "span_id": 13142423663064334030,
        "trace_id": 10149310755520073958
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-07 09:42:22
success: True
trace_id: 10149310755520073958

Scan 161572773

duration: 0:00:12.530637

exit_message:

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

id: 161572773

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-06/1775485998",
        "key": "raw/entities/2026-04-06/1775485998/64107114-3327-436b-a613-cf57a7f703d9.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2107604131075687903,
        "service_name": "drive-thru",
        "span_id": 9810901135588061690,
        "trace_id": 17519859297727558947
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-06 09:33:29
success: True
trace_id: 17519859297727558947

Scan 161523752

duration: 0:00:15.023732

exit_message:

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

id: 161523752

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-05/1775399272",
        "key": "raw/entities/2026-04-05/1775399272/314a6f09-cfa2-48e5-8190-3518b7524c65.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5799634010108980862,
        "service_name": "drive-thru",
        "span_id": 8941789879925269506,
        "trace_id": 14940205711841662742
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-05 09:28:02
success: True
trace_id: 14940205711841662742

Scan 161471817

duration: 0:00:12.436829

exit_message:

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

id: 161471817

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-04/1775313737",
        "key": "raw/entities/2026-04-04/1775313737/80e40bdc-adf3-42da-bcce-7c7ef0e6a64c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1999623361864018787,
        "service_name": "drive-thru",
        "span_id": 4670539861392037483,
        "trace_id": 13814595834095110970
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-04 09:42:22
success: True
trace_id: 13814595834095110970

Scan 161415318

duration: 0:00:15.103607

exit_message:

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

id: 161415318

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/entities/2026-04-03/1775228112",
        "key": "raw/entities/2026-04-03/1775228112/b5594834-1cc8-445a-a3ac-811f6c17507b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7602390737621320221,
        "service_name": "drive-thru",
        "span_id": 15179358783467142257,
        "trace_id": 5499300800337819339
    }
}

running: False
schema_name_id: 1200
start_time: 2026-04-03 09:55:25
success: True
trace_id: 5499300800337819339

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:33:23

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/entities/2026-04-17/1776436394'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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": "2022-10-26 15:43:23",
        "disabled": false,
        "format": "raw",
        "id": 1200,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:33:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/entities/2026-04-17/1776436394'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}