Schema Info

Schema Name: sfdl_dev_csv.payrixess_denormalized_entities

created: 2024-07-22 13:06:33
disabled: False
format: raw
id: 2367
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773353

created: 2026-04-17 09:44:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-17/1776437033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-17/1776437033
id: 4773353
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6867725
updated: 2026-04-17 09:44:30

Version 4773291

created: 2026-04-16 09:36:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-16/1776350162'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-16/1776350162
id: 4773291
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6867506
updated: 2026-04-16 09:36:32

Version 4773214

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-15/1776263633'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-15/1776263633
id: 4773214
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6867150
updated: 2026-04-15 09:34:38

Version 4773171

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-14/1776178722'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-14/1776178722
id: 4773171
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6866925
updated: 2026-04-14 09:59:50

Version 4773104

created: 2026-04-13 09:34:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-13/1776090797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-13/1776090797
id: 4773104
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6866598
updated: 2026-04-13 09:34:22

Version 4773047

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-12/1776004232'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-12/1776004232
id: 4773047
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6866426
updated: 2026-04-12 09:30:53

Version 4773004

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-11/1775917815'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-11/1775917815
id: 4773004
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6866264
updated: 2026-04-11 09:31:13

Version 4772957

created: 2026-04-10 09:45:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-10/1775832168'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-10/1775832168
id: 4772957
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6866086
updated: 2026-04-10 09:45:35

Version 4772872

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-09/1775744966'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-09/1775744966
id: 4772872
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6865686
updated: 2026-04-09 09:30:22

Version 4772811

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-08/1775658387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-08/1775658387
id: 4772811
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6865416
updated: 2026-04-08 09:27:21

Version 4772762

created: 2026-04-07 09:33:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-07/1775572334'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-07/1775572334
id: 4772762
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6865255
updated: 2026-04-07 09:33:15

Version 4772707

created: 2026-04-06 09:44:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-06/1775486652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-06/1775486652
id: 4772707
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6864918
updated: 2026-04-06 09:44:39

Version 4772656

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-05/1775400469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-05/1775400469
id: 4772656
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6864730
updated: 2026-04-05 09:48:04

Version 4772590

created: 2026-04-04 09:27:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-04/1775312795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-04/1775312795
id: 4772590
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6864458
updated: 2026-04-04 09:27:17

Version 4772533

created: 2026-04-03 09:35:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-03/1775226898'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/denormalized_entities/2026-04-03/1775226898
id: 4772533
processed: 1

raw_data:

{
    "custom": 15,
    "dba": 14,
    "division_id": 7,
    "division_name": 8,
    "entity_created": 1,
    "entity_id": 0,
    "frozen": 18,
    "inactive": 17,
    "is_primary_vendor": 19,
    "login_first_name": 20,
    "login_id": 5,
    "login_last_name": 21,
    "login_username": 6,
    "mcc": 16,
    "merchant_boarded": 2,
    "name": 13,
    "parent_division_id": 9,
    "parent_division_name": 10,
    "partition_id": 11,
    "partition_name": 12,
    "related_id": 3,
    "related_type": 4
}

schema_attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

schema_name_id: 2367
schema_scan_id: 6864270
updated: 2026-04-03 09:35:18

Schema Scans: 15

Last at 2026-04-17 09:44:15

Scan 6867725

duration: 0:00:15.021418

exit_message:

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

id: 6867725

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/denormalized_entities/2026-04-17/1776437033",
        "key": "raw/denormalized_entities/2026-04-17/1776437033/734e61b4-c0f3-4db1-b61a-88bea2fb989f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13561052327303754677,
        "service_name": "drive-thru",
        "span_id": 11876666009399483461,
        "trace_id": 1868202385907561765
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-17 09:44:15
success: True
trace_id: 1868202385907561765

Scan 6867506

duration: 0:00:14.960964

exit_message:

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

id: 6867506

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/denormalized_entities/2026-04-16/1776350162",
        "key": "raw/denormalized_entities/2026-04-16/1776350162/189f6095-3853-4a37-9456-419bf923e590.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12871623098017225867,
        "service_name": "drive-thru",
        "span_id": 14775492365969262239,
        "trace_id": 13789562004967809876
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-16 09:36:17
success: True
trace_id: 13789562004967809876

Scan 6867150

duration: 0:00:12.558382

exit_message:

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

id: 6867150

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/denormalized_entities/2026-04-15/1776263633",
        "key": "raw/denormalized_entities/2026-04-15/1776263633/de1fa056-7ad9-4740-a80e-e7c9d5ca0584.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4978667266618153959,
        "service_name": "drive-thru",
        "span_id": 11237020626875300640,
        "trace_id": 13461665237322238369
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-15 09:34:25
success: True
trace_id: 13461665237322238369

Scan 6866925

duration: 0:00:14.862927

exit_message:

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

id: 6866925

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/denormalized_entities/2026-04-14/1776178722",
        "key": "raw/denormalized_entities/2026-04-14/1776178722/ec882a42-79ad-4549-b5df-1d9e9689e994.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10901496855406398481,
        "service_name": "drive-thru",
        "span_id": 9566799990794579513,
        "trace_id": 823075336222815919
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-14 09:59:35
success: True
trace_id: 823075336222815919

Scan 6866598

duration: 0:00:15.169362

exit_message:

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

id: 6866598

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/denormalized_entities/2026-04-13/1776090797",
        "key": "raw/denormalized_entities/2026-04-13/1776090797/641d2375-e6ca-46dd-9fcf-841cb490bfa8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11183075792158795646,
        "service_name": "drive-thru",
        "span_id": 11681757838011500403,
        "trace_id": 17355859807443948163
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-13 09:34:07
success: True
trace_id: 17355859807443948163

Scan 6866426

duration: 0:00:12.322982

exit_message:

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

id: 6866426

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/denormalized_entities/2026-04-12/1776004232",
        "key": "raw/denormalized_entities/2026-04-12/1776004232/adbda202-353c-474a-b8da-5bb03557ad08.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11248383075379071579,
        "service_name": "drive-thru",
        "span_id": 9079342752415139087,
        "trace_id": 8882282311271495497
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-12 09:30:41
success: True
trace_id: 8882282311271495497

Scan 6866264

duration: 0:00:14.901739

exit_message:

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

id: 6866264

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/denormalized_entities/2026-04-11/1775917815",
        "key": "raw/denormalized_entities/2026-04-11/1775917815/286b9db8-67eb-46b8-8fa3-aa2e28d02731.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13006054307581922671,
        "service_name": "drive-thru",
        "span_id": 16869405072349193403,
        "trace_id": 14247846204356739678
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-11 09:30:58
success: True
trace_id: 14247846204356739678

Scan 6866086

duration: 0:00:15.099918

exit_message:

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

id: 6866086

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/denormalized_entities/2026-04-10/1775832168",
        "key": "raw/denormalized_entities/2026-04-10/1775832168/be9ba329-8528-40f6-8705-bcba059bc78b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5321804418154892504,
        "service_name": "drive-thru",
        "span_id": 3664043579092381611,
        "trace_id": 11799479275619678273
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-10 09:45:20
success: True
trace_id: 11799479275619678273

Scan 6865686

duration: 0:00:15.069089

exit_message:

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

id: 6865686

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/denormalized_entities/2026-04-09/1775744966",
        "key": "raw/denormalized_entities/2026-04-09/1775744966/f553b185-7b1b-4404-a9fb-c1f8b6828409.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15240198151796956538,
        "service_name": "drive-thru",
        "span_id": 1074647048372007818,
        "trace_id": 428236130239410141
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-09 09:30:07
success: True
trace_id: 428236130239410141

Scan 6865416

duration: 0:00:15.017190

exit_message:

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

id: 6865416

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/denormalized_entities/2026-04-08/1775658387",
        "key": "raw/denormalized_entities/2026-04-08/1775658387/17507012-ccdb-4880-8eab-cf96378c031a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10520659862419853909,
        "service_name": "drive-thru",
        "span_id": 4614343062811880250,
        "trace_id": 9927999259153693460
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-08 09:27:06
success: True
trace_id: 9927999259153693460

Scan 6865255

duration: 0:00:14.994163

exit_message:

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

id: 6865255

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/denormalized_entities/2026-04-07/1775572334",
        "key": "raw/denormalized_entities/2026-04-07/1775572334/9613a221-01a9-4e6f-90a4-8b378e79d334.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13413095766972229022,
        "service_name": "drive-thru",
        "span_id": 17659564570723624118,
        "trace_id": 12869215172431197845
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-07 09:33:00
success: True
trace_id: 12869215172431197845

Scan 6864918

duration: 0:00:15.013001

exit_message:

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

id: 6864918

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/denormalized_entities/2026-04-06/1775486652",
        "key": "raw/denormalized_entities/2026-04-06/1775486652/15e29f01-7b91-4ec8-b61f-05f73263274d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16739500973550087330,
        "service_name": "drive-thru",
        "span_id": 15158937365111255278,
        "trace_id": 12865808181206065483
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-06 09:44:24
success: True
trace_id: 12865808181206065483

Scan 6864730

duration: 0:00:12.399234

exit_message:

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

id: 6864730

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/denormalized_entities/2026-04-05/1775400469",
        "key": "raw/denormalized_entities/2026-04-05/1775400469/7ae39d07-ee19-4b74-97f9-f606f392501f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3459821004767840466,
        "service_name": "drive-thru",
        "span_id": 6663272722093109177,
        "trace_id": 2762617677985468856
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-05 09:47:52
success: True
trace_id: 2762617677985468856

Scan 6864458

duration: 0:00:14.919130

exit_message:

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

id: 6864458

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/denormalized_entities/2026-04-04/1775312795",
        "key": "raw/denormalized_entities/2026-04-04/1775312795/57254cf1-3581-40da-8c21-57573586dc02.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1675444309874662329,
        "service_name": "drive-thru",
        "span_id": 474767375269067754,
        "trace_id": 1839267577196288752
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-04 09:27:02
success: True
trace_id: 1839267577196288752

Scan 6864270

duration: 0:00:12.704794

exit_message:

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

id: 6864270

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/denormalized_entities/2026-04-03/1775226898",
        "key": "raw/denormalized_entities/2026-04-03/1775226898/94329c12-8848-4f4d-b363-697a31c7335a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_denormalized_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1834428480128970582,
        "service_name": "drive-thru",
        "span_id": 8408485877865336885,
        "trace_id": 8976138175126102369
    }
}

running: False
schema_name_id: 2367
start_time: 2026-04-03 09:35:05
success: True
trace_id: 8976138175126102369

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "custom": "string",
    "dba": "string",
    "division_id": "string",
    "division_name": "string",
    "entity_created": "string",
    "entity_custom": "string",
    "entity_id": "string",
    "entity_name": "string",
    "entity_type": "string",
    "first": "string",
    "frozen": "string",
    "inactive": "string",
    "is_primary_vendor": "string",
    "last": "string",
    "login_first_name": "string",
    "login_id": "string",
    "login_last_name": "string",
    "login_username": "string",
    "mcc": "string",
    "merchant_boarded": "string",
    "merchant_dba": "string",
    "merchant_mcc": "string",
    "name": "string",
    "parent_division_id": "string",
    "parent_division_name": "string",
    "partition_id": "string",
    "partition_name": "string",
    "related_id": "string",
    "related_type": "string",
    "username": "string"
}

created: 2026-04-17 09:44:17

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-17/1776437033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_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 13:06:33",
        "disabled": false,
        "format": "raw",
        "id": 2367,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_denormalized_entities"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "custom": "string",
            "dba": "string",
            "division_id": "string",
            "division_name": "string",
            "entity_created": "string",
            "entity_custom": "string",
            "entity_id": "string",
            "entity_name": "string",
            "entity_type": "string",
            "first": "string",
            "frozen": "string",
            "inactive": "string",
            "is_primary_vendor": "string",
            "last": "string",
            "login_first_name": "string",
            "login_id": "string",
            "login_last_name": "string",
            "login_username": "string",
            "mcc": "string",
            "merchant_boarded": "string",
            "merchant_dba": "string",
            "merchant_mcc": "string",
            "name": "string",
            "parent_division_id": "string",
            "parent_division_name": "string",
            "partition_id": "string",
            "partition_name": "string",
            "related_id": "string",
            "related_type": "string",
            "username": "string"
        },
        "created": "2026-04-17 09:44:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_denormalized_entities`\n(\n `entity_id`  string , `entity_created`  string , `merchant_boarded`  string , `related_id`  string , `related_type`  string , `login_id`  string , `login_username`  string , `division_id`  string , `division_name`  string , `parent_division_id`  string , `parent_division_name`  string , `partition_id`  string , `partition_name`  string , `name`  string , `dba`  string , `custom`  string , `mcc`  string , `inactive`  string , `frozen`  string , `is_primary_vendor`  string , `login_first_name`  string , `login_last_name`  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/denormalized_entities/2026-04-17/1776437033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_denormalized_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_denormalized_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}