Schema Info

Schema Name: sfdl_stage_csv.payrixess_entities

created: 2024-07-22 13:15:47
disabled: False
format: raw
id: 2172
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906699

created: 2026-04-17 09:34:42

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-17/1776436471
id: 906699
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: 2172
schema_scan_id: 6415449
updated: 2026-04-17 09:34:56

Version 906484

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-16/1776350427
id: 906484
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: 2172
schema_scan_id: 6414871
updated: 2026-04-16 09:40:43

Version 906255

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-15/1776263288
id: 906255
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: 2172
schema_scan_id: 6414308
updated: 2026-04-15 09:28:24

Version 906046

created: 2026-04-14 09:30:09

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-14/1776176995
id: 906046
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: 2172
schema_scan_id: 6413841
updated: 2026-04-14 09:30:23

Version 905855

created: 2026-04-13 09:46:23

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-13/1776091576
id: 905855
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: 2172
schema_scan_id: 6413384
updated: 2026-04-13 09:46:37

Version 905622

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-12/1776003964
id: 905622
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: 2172
schema_scan_id: 6412817
updated: 2026-04-12 09:26:51

Version 905432

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-11/1775917787
id: 905432
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: 2172
schema_scan_id: 6412522
updated: 2026-04-11 09:30:02

Version 905219

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-10/1775831956
id: 905219
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: 2172
schema_scan_id: 6412057
updated: 2026-04-10 09:39:40

Version 905018

created: 2026-04-09 09:45:34

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-09/1775745925
id: 905018
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: 2172
schema_scan_id: 6411560
updated: 2026-04-09 09:45:48

Version 904785

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-08/1775658662
id: 904785
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: 2172
schema_scan_id: 6411022
updated: 2026-04-08 09:31:20

Version 904566

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-07/1775572017
id: 904566
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: 2172
schema_scan_id: 6410457
updated: 2026-04-07 09:27:21

Version 904356

created: 2026-04-06 09:29:24

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-06/1775485753
id: 904356
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: 2172
schema_scan_id: 6409953
updated: 2026-04-06 09:29:38

Version 904148

created: 2026-04-05 09:27:09

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-05/1775399225
id: 904148
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: 2172
schema_scan_id: 6409494
updated: 2026-04-05 09:27:23

Version 903970

created: 2026-04-04 09:51:20

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-04/1775314266
id: 903970
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: 2172
schema_scan_id: 6409240
updated: 2026-04-04 09:51:31

Version 903738

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-03/1775226875
id: 903738
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: 2172
schema_scan_id: 6408665
updated: 2026-04-03 09:34:53

Schema Scans: 15

Last at 2026-04-17 09:34:41

Scan 6415449

duration: 0:00:15.095532

exit_message:

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

id: 6415449

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-17/1776436471",
        "key": "raw/entities/2026-04-17/1776436471/19a7beed-e947-4fdd-853d-ce49d6080f73.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6731783839286931217,
        "service_name": "drive-thru",
        "span_id": 9619912687086724326,
        "trace_id": 11050261311624901750
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-17 09:34:41
success: True
trace_id: 11050261311624901750

Scan 6414871

duration: 0:00:12.483752

exit_message:

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

id: 6414871

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-16/1776350427",
        "key": "raw/entities/2026-04-16/1776350427/7c90a342-b8dd-4cf8-92ed-d789ce4062a5.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7698687898530544686,
        "service_name": "drive-thru",
        "span_id": 16710865581393104195,
        "trace_id": 18186831735251524590
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-16 09:40:31
success: True
trace_id: 18186831735251524590

Scan 6414308

duration: 0:00:12.586770

exit_message:

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

id: 6414308

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-15/1776263288",
        "key": "raw/entities/2026-04-15/1776263288/a201a714-5168-4276-944e-15eb0aeb503d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14341325036346993380,
        "service_name": "drive-thru",
        "span_id": 11773354290133706759,
        "trace_id": 2653338493270684499
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-15 09:28:11
success: True
trace_id: 2653338493270684499

Scan 6413841

duration: 0:00:15.310879

exit_message:

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

id: 6413841

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-14/1776176995",
        "key": "raw/entities/2026-04-14/1776176995/01e60df1-39bf-4d14-a29f-efbd16ad0d1f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9984269327613119975,
        "service_name": "drive-thru",
        "span_id": 2683112946570203600,
        "trace_id": 14740645883536881757
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-14 09:30:07
success: True
trace_id: 14740645883536881757

Scan 6413384

duration: 0:00:15.019323

exit_message:

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

id: 6413384

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-13/1776091576",
        "key": "raw/entities/2026-04-13/1776091576/e83eb5dd-c669-458a-96fc-1c9bc44f5183.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11610144489815776836,
        "service_name": "drive-thru",
        "span_id": 11453178025441080167,
        "trace_id": 10491915308919083133
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-13 09:46:22
success: True
trace_id: 10491915308919083133

Scan 6412817

duration: 0:00:22.767377

exit_message:

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

id: 6412817

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-12/1776003964",
        "key": "raw/entities/2026-04-12/1776003964/17ac495e-604b-4a91-b29b-9c69b8b9c909.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1755282103476419973,
        "service_name": "drive-thru",
        "span_id": 18107200057096206176,
        "trace_id": 6519958419997404594
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-12 09:26:28
success: True
trace_id: 6519958419997404594

Scan 6412522

duration: 0:00:12.414237

exit_message:

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

id: 6412522

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-11/1775917787",
        "key": "raw/entities/2026-04-11/1775917787/86d0a44b-7b10-4d52-8423-6a73f38ffa31.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14909026813092423592,
        "service_name": "drive-thru",
        "span_id": 16811507560751155687,
        "trace_id": 7208819833936324280
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-11 09:29:50
success: True
trace_id: 7208819833936324280

Scan 6412057

duration: 0:00:12.589160

exit_message:

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

id: 6412057

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-10/1775831956",
        "key": "raw/entities/2026-04-10/1775831956/0d050278-0723-4448-a2c7-f670d78df483.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17002547678856186534,
        "service_name": "drive-thru",
        "span_id": 4487764948077420326,
        "trace_id": 13215560730978417493
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-10 09:39:27
success: True
trace_id: 13215560730978417493

Scan 6411560

duration: 0:00:15.020903

exit_message:

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

id: 6411560

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-09/1775745925",
        "key": "raw/entities/2026-04-09/1775745925/ba5a62a8-75b0-4835-b173-75c8df5591e6.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7964078395816244514,
        "service_name": "drive-thru",
        "span_id": 2837951989582962735,
        "trace_id": 9866796992817198772
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-09 09:45:33
success: True
trace_id: 9866796992817198772

Scan 6411022

duration: 0:00:12.612397

exit_message:

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

id: 6411022

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-08/1775658662",
        "key": "raw/entities/2026-04-08/1775658662/11d50622-3082-456a-84ea-a65197a3342a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12792485763431189309,
        "service_name": "drive-thru",
        "span_id": 7107651809548778996,
        "trace_id": 5488577192720060306
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-08 09:31:07
success: True
trace_id: 5488577192720060306

Scan 6410457

duration: 0:00:12.691928

exit_message:

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

id: 6410457

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-07/1775572017",
        "key": "raw/entities/2026-04-07/1775572017/24dfd26e-567e-49b1-a9ff-9d9743cbd329.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13246982603500766115,
        "service_name": "drive-thru",
        "span_id": 16469343127742066635,
        "trace_id": 12063860435738608017
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-07 09:27:09
success: True
trace_id: 12063860435738608017

Scan 6409953

duration: 0:00:15.101325

exit_message:

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

id: 6409953

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-06/1775485753",
        "key": "raw/entities/2026-04-06/1775485753/2408ad57-8cfc-48d6-adc8-fdc91a7fbefe.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11822716609448353880,
        "service_name": "drive-thru",
        "span_id": 3487717280535899506,
        "trace_id": 15780157100375999182
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-06 09:29:23
success: True
trace_id: 15780157100375999182

Scan 6409494

duration: 0:00:15.115806

exit_message:

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

id: 6409494

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-05/1775399225",
        "key": "raw/entities/2026-04-05/1775399225/e43e8505-971a-4ec0-94f7-969024dbbc1a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16764403284483124836,
        "service_name": "drive-thru",
        "span_id": 14964137673231709761,
        "trace_id": 1062403155705171492
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-05 09:27:08
success: True
trace_id: 1062403155705171492

Scan 6409240

duration: 0:00:12.567998

exit_message:

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

id: 6409240

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-04/1775314266",
        "key": "raw/entities/2026-04-04/1775314266/6b99e5b7-9204-4a5b-9a57-2d892de779ff.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16901944227136197672,
        "service_name": "drive-thru",
        "span_id": 3854424128527775196,
        "trace_id": 17824394065898600073
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-04 09:51:18
success: True
trace_id: 17824394065898600073

Scan 6408665

duration: 0:00:15.047488

exit_message:

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

id: 6408665

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/entities/2026-04-03/1775226875",
        "key": "raw/entities/2026-04-03/1775226875/0a12eba7-8d3f-4c5d-8053-b9d35dc50af3.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15661807159087266025,
        "service_name": "drive-thru",
        "span_id": 1655746792556773297,
        "trace_id": 5218675490889775803
    }
}

running: False
schema_name_id: 2172
start_time: 2026-04-03 09:34:38
success: True
trace_id: 5218675490889775803

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:34:42

ddl:

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

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-22 13:15:47",
        "disabled": false,
        "format": "raw",
        "id": 2172,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:34:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/entities/2026-04-17/1776436471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}