Schema Info

Schema Name: sfdl_dev_csv.payrixess_entities

created: 2024-07-22 12:57:46
disabled: False
format: raw
id: 2346
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773338

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-17/1776436235
id: 4773338
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: 2346
schema_scan_id: 6867672
updated: 2026-04-17 09:31:08

Version 4773288

created: 2026-04-16 09:35:06

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-16/1776350102
id: 4773288
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: 2346
schema_scan_id: 6867488
updated: 2026-04-16 09:35:17

Version 4773215

created: 2026-04-15 09:34:41

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-15/1776263669
id: 4773215
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: 2346
schema_scan_id: 6867158
updated: 2026-04-15 09:34:54

Version 4773159

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-14/1776177691
id: 4773159
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: 2346
schema_scan_id: 6866899
updated: 2026-04-14 09:42:42

Version 4773095

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-13/1776090580
id: 4773095
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: 2346
schema_scan_id: 6866582
updated: 2026-04-13 09:30:05

Version 4773044

created: 2026-04-12 09:28:51

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-12/1776004122
id: 4773044
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: 2346
schema_scan_id: 6866381
updated: 2026-04-12 09:29:02

Version 4772993

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-11/1775917672
id: 4772993
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: 2346
schema_scan_id: 6866218
updated: 2026-04-11 09:28:18

Version 4772932

created: 2026-04-10 09:27:09

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-10/1775831221
id: 4772932
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: 2346
schema_scan_id: 6865958
updated: 2026-04-10 09:27:23

Version 4772888

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-09/1775746024
id: 4772888
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: 2346
schema_scan_id: 6865796
updated: 2026-04-09 09:47:22

Version 4772824

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-08/1775658586
id: 4772824
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: 2346
schema_scan_id: 6865474
updated: 2026-04-08 09:30:30

Version 4772754

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-07/1775572110
id: 4772754
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: 2346
schema_scan_id: 6865189
updated: 2026-04-07 09:28:49

Version 4772696

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-06/1775485912
id: 4772696
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: 2346
schema_scan_id: 6864843
updated: 2026-04-06 09:32:20

Version 4772641

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-05/1775399311
id: 4772641
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: 2346
schema_scan_id: 6864635
updated: 2026-04-05 09:28:54

Version 4772585

created: 2026-04-04 09:25:26

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-04/1775312715
id: 4772585
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: 2346
schema_scan_id: 6864442
updated: 2026-04-04 09:25:37

Version 4772528

created: 2026-04-03 09:29:45

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-03/1775226581
id: 4772528
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: 2346
schema_scan_id: 6864223
updated: 2026-04-03 09:29:56

Schema Scans: 15

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

Scan 6867672

duration: 0:00:12.595956

exit_message:

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

id: 6867672

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-17/1776436235",
        "key": "raw/entities/2026-04-17/1776436235/4d13194c-af9b-4a85-aca0-7f4f63e2d3a5.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3080038888152730213,
        "service_name": "drive-thru",
        "span_id": 2895472691358084997,
        "trace_id": 17186827826568157371
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-17 09:30:55
success: True
trace_id: 17186827826568157371

Scan 6867488

duration: 0:00:12.522975

exit_message:

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

id: 6867488

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-16/1776350102",
        "key": "raw/entities/2026-04-16/1776350102/0c767634-9bbc-4a15-8a25-ef46196f44ec.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14992070472721524181,
        "service_name": "drive-thru",
        "span_id": 12149328678489518507,
        "trace_id": 14225344075309502640
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-16 09:35:05
success: True
trace_id: 14225344075309502640

Scan 6867158

duration: 0:00:15.166812

exit_message:

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

id: 6867158

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-15/1776263669",
        "key": "raw/entities/2026-04-15/1776263669/96423c4f-3fa9-44ca-ad99-caa6ddb3d127.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16468095802195365626,
        "service_name": "drive-thru",
        "span_id": 6387627272326819237,
        "trace_id": 9407998644861044042
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-15 09:34:39
success: True
trace_id: 9407998644861044042

Scan 6866899

duration: 0:00:15.248344

exit_message:

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

id: 6866899

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-14/1776177691",
        "key": "raw/entities/2026-04-14/1776177691/289ce8fe-6231-41ee-b529-4a7ff4b7372f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13830474952988620176,
        "service_name": "drive-thru",
        "span_id": 5510306863138761504,
        "trace_id": 4716773314099204302
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-14 09:42:26
success: True
trace_id: 4716773314099204302

Scan 6866582

duration: 0:00:15.091650

exit_message:

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

id: 6866582

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-13/1776090580",
        "key": "raw/entities/2026-04-13/1776090580/ed918b49-0d3a-4225-98b4-dafb2e967e85.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1077503348595955843,
        "service_name": "drive-thru",
        "span_id": 10048555602767263756,
        "trace_id": 15649696560648035015
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-13 09:29:50
success: True
trace_id: 15649696560648035015

Scan 6866381

duration: 0:00:12.556987

exit_message:

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

id: 6866381

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-12/1776004122",
        "key": "raw/entities/2026-04-12/1776004122/a1605dc1-ee92-4c2a-98c2-f057d6bb9b56.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13467729449721638207,
        "service_name": "drive-thru",
        "span_id": 9657292873173957783,
        "trace_id": 15928372346674646243
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-12 09:28:49
success: True
trace_id: 15928372346674646243

Scan 6866218

duration: 0:00:12.425064

exit_message:

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

id: 6866218

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-11/1775917672",
        "key": "raw/entities/2026-04-11/1775917672/189c6a12-70c8-44c1-8d61-d2fddbab1394.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1353554429013672091,
        "service_name": "drive-thru",
        "span_id": 8098323740803567377,
        "trace_id": 13389243770766949582
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-11 09:28:06
success: True
trace_id: 13389243770766949582

Scan 6865958

duration: 0:00:15.039102

exit_message:

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

id: 6865958

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-10/1775831221",
        "key": "raw/entities/2026-04-10/1775831221/07233c44-5420-46be-90bc-5d7aeb989213.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17900621119268188309,
        "service_name": "drive-thru",
        "span_id": 762606982660911754,
        "trace_id": 11867086432784197683
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-10 09:27:08
success: True
trace_id: 11867086432784197683

Scan 6865796

duration: 0:00:12.434626

exit_message:

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

id: 6865796

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-09/1775746024",
        "key": "raw/entities/2026-04-09/1775746024/0ba4803d-e9ab-4b4a-af0d-7f45f2b81f0c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 366338026612502007,
        "service_name": "drive-thru",
        "span_id": 16962923876570072891,
        "trace_id": 3871225120448739383
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-09 09:47:09
success: True
trace_id: 3871225120448739383

Scan 6865474

duration: 0:00:15.127050

exit_message:

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

id: 6865474

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-08/1775658586",
        "key": "raw/entities/2026-04-08/1775658586/502ceb50-0a9d-49ed-980e-54a7af782e4f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9575143332251294903,
        "service_name": "drive-thru",
        "span_id": 5828954619017664886,
        "trace_id": 15261508960246192662
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-08 09:30:15
success: True
trace_id: 15261508960246192662

Scan 6865189

duration: 0:00:12.499711

exit_message:

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

id: 6865189

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-07/1775572110",
        "key": "raw/entities/2026-04-07/1775572110/75105194-af3a-4658-917f-6d446f6e41f4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15334578847591330233,
        "service_name": "drive-thru",
        "span_id": 11670475913037082434,
        "trace_id": 2042434862351467086
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-07 09:28:37
success: True
trace_id: 2042434862351467086

Scan 6864843

duration: 0:00:12.708531

exit_message:

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

id: 6864843

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-06/1775485912",
        "key": "raw/entities/2026-04-06/1775485912/5066ecac-cece-4825-8c6c-e73f3dc4d08b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16709278918938581592,
        "service_name": "drive-thru",
        "span_id": 12761708630809527891,
        "trace_id": 8287759199924753472
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-06 09:32:07
success: True
trace_id: 8287759199924753472

Scan 6864635

duration: 0:00:12.518183

exit_message:

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

id: 6864635

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-05/1775399311",
        "key": "raw/entities/2026-04-05/1775399311/bc132cd8-293e-4642-98e3-ce3c89713a6c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6931442825706065268,
        "service_name": "drive-thru",
        "span_id": 6389656431050911233,
        "trace_id": 7565876222637425143
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-05 09:28:41
success: True
trace_id: 7565876222637425143

Scan 6864442

duration: 0:00:12.468733

exit_message:

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

id: 6864442

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-04/1775312715",
        "key": "raw/entities/2026-04-04/1775312715/f24f6543-de79-4bf3-9d68-9bf6a822b236.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9148642408840984139,
        "service_name": "drive-thru",
        "span_id": 11522691921418484434,
        "trace_id": 18398202025706947816
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-04 09:25:25
success: True
trace_id: 18398202025706947816

Scan 6864223

duration: 0:00:12.499091

exit_message:

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

id: 6864223

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/entities/2026-04-03/1775226581",
        "key": "raw/entities/2026-04-03/1775226581/4d6b6a1d-e571-4707-a45f-aaceee64cc35.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9973031893396146227,
        "service_name": "drive-thru",
        "span_id": 2581146482707666022,
        "trace_id": 5184004927239347965
    }
}

running: False
schema_name_id: 2346
start_time: 2026-04-03 09:29:44
success: True
trace_id: 5184004927239347965

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:30:56

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-22 12:57:46",
        "disabled": false,
        "format": "raw",
        "id": 2346,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:30:56",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-dev/raw/entities/2026-04-17/1776436235'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}