Schema Info

Schema Name: sfdl_dev_csv.payrixess_merchants
  • created: 2024-07-22 13:07:46
  • disabled: False
  • format: raw
  • id: 2375
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "payrixess_merchants"
    }
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 09:30:35
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-17/1776436221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-17/1776436221
    • id: 4773335
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6867666
    • updated: 2026-04-17 09:30:46
    • created: 2026-04-16 09:32:29
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-16/1776349925'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-16/1776349925
    • id: 4773282
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6867425
    • updated: 2026-04-16 09:32:41
    • created: 2026-04-15 09:49:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-15/1776264551'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-15/1776264551
    • id: 4773226
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6867179
    • updated: 2026-04-15 09:49:47
    • created: 2026-04-14 09:42:11
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-14/1776177678'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-14/1776177678
    • id: 4773157
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6866896
    • updated: 2026-04-14 09:42:22
    • created: 2026-04-13 09:34:40
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-13/1776090876'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-13/1776090876
    • id: 4773106
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6866609
    • updated: 2026-04-13 09:34:54
    • created: 2026-04-12 09:28:40
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-12/1776004116'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-12/1776004116
    • id: 4773043
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6866380
    • updated: 2026-04-12 09:28:51
    • created: 2026-04-11 09:27:43
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-11/1775917620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-11/1775917620
    • id: 4772991
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6866210
    • updated: 2026-04-11 09:27:54
    • created: 2026-04-10 09:27:19
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-10/1775831228'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-10/1775831228
    • id: 4772933
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6865959
    • updated: 2026-04-10 09:27:33
    • created: 2026-04-09 09:31:43
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-09/1775745094'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-09/1775745094
    • id: 4772876
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6865711
    • updated: 2026-04-09 09:31:57
    • created: 2026-04-08 09:30:09
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-08/1775658580'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-08/1775658580
    • id: 4772823
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6865472
    • updated: 2026-04-08 09:30:22
    • created: 2026-04-07 09:28:51
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-07/1775572122'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-07/1775572122
    • id: 4772755
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6865191
    • updated: 2026-04-07 09:29:02
    • created: 2026-04-06 09:33:21
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-06/1775485993'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-06/1775485993
    • id: 4772698
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6864856
    • updated: 2026-04-06 09:33:33
    • created: 2026-04-05 09:27:21
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-05/1775399235'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-05/1775399235
    • id: 4772636
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6864622
    • updated: 2026-04-05 09:27:35
    • created: 2026-04-04 09:27:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-04/1775312833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-04/1775312833
    • id: 4772593
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6864465
    • updated: 2026-04-04 09:27:45
    • created: 2026-04-03 09:48:35
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-03/1775227696'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/merchants/2026-04-03/1775227696
    • id: 4772546
    • processed: 1
    • raw_data:
      {
          "_hoodie_commit_seqno": 1,
          "_hoodie_commit_time": 0,
          "_hoodie_file_name": 4,
          "_hoodie_partition_path": 3,
          "_hoodie_record_key": 2,
          "amex": 14,
          "boarded": 18,
          "created": 6,
          "creator": 8,
          "dba": 11,
          "discover": 15,
          "entity_id": 10,
          "environment": 21,
          "established": 13,
          "expressbatchclosemethod": 25,
          "expressbatchclosetime": 24,
          "frozen": 20,
          "inactive": 19,
          "mcc": 16,
          "merchant_id": 5,
          "modified": 7,
          "modifier": 9,
          "new": 12,
          "qsa": 22,
          "seasonal": 23,
          "status": 17
      }
    • schema_attributes:
      {
          "_hoodie_commit_seqno": "string",
          "_hoodie_commit_time": "string",
          "_hoodie_file_name": "string",
          "_hoodie_partition_path": "string",
          "_hoodie_record_key": "string",
          "amex": "string",
          "boarded": "string",
          "created": "string",
          "creator": "string",
          "dba": "string",
          "discover": "string",
          "entity_id": "string",
          "environment": "string",
          "established": "string",
          "expressbatchclosemethod": "string",
          "expressbatchclosetime": "string",
          "frozen": "string",
          "inactive": "string",
          "mcc": "string",
          "merchant_id": "string",
          "modified": "string",
          "modifier": "string",
          "new": "string",
          "qsa": "string",
          "seasonal": "string",
          "status": "string"
      }
    • schema_name_id: 2375
    • schema_scan_id: 6864317
    • updated: 2026-04-03 09:48:48
Schema Scans: 15
Last at 2026-04-17 09:30:34
    • duration: 0:00:12.341703
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867666
    • 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/merchants/2026-04-17/1776436221",
              "key": "raw/merchants/2026-04-17/1776436221/7fb2d248-b9bf-47ff-8936-e94f34b6ebb2.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 3250499224360435506,
              "service_name": "drive-thru",
              "span_id": 11382045589730579592,
              "trace_id": 15944358208423842266
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-17 09:30:34
    • success: True
    • trace_id: 15944358208423842266
    • duration: 0:00:12.460165
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867425
    • 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/merchants/2026-04-16/1776349925",
              "key": "raw/merchants/2026-04-16/1776349925/b5965f2f-5fb7-4789-bc38-eb0beb7b25cb.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17263953344484569492,
              "service_name": "drive-thru",
              "span_id": 13466594617568094532,
              "trace_id": 9015806710724130504
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-16 09:32:28
    • success: True
    • trace_id: 9015806710724130504
    • duration: 0:00:14.998185
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867179
    • 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/merchants/2026-04-15/1776264551",
              "key": "raw/merchants/2026-04-15/1776264551/fd0199f5-2df8-4158-b25a-f38f2b1bc278.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13708345936927918091,
              "service_name": "drive-thru",
              "span_id": 8160329831262398574,
              "trace_id": 4502720606296785702
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-15 09:49:33
    • success: True
    • trace_id: 4502720606296785702
    • duration: 0:00:12.508957
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866896
    • 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/merchants/2026-04-14/1776177678",
              "key": "raw/merchants/2026-04-14/1776177678/4097eb54-81b2-4b05-bd61-2b5651a67abd.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 326775189395875325,
              "service_name": "drive-thru",
              "span_id": 14697508062380187557,
              "trace_id": 11091676813072148039
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-14 09:42:10
    • success: True
    • trace_id: 11091676813072148039
    • duration: 0:00:14.912700
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866609
    • 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/merchants/2026-04-13/1776090876",
              "key": "raw/merchants/2026-04-13/1776090876/12af179b-7e75-4390-89a4-7e8ca9733250.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 18345885718372887272,
              "service_name": "drive-thru",
              "span_id": 6442658430506696632,
              "trace_id": 15535296763239574853
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-13 09:34:39
    • success: True
    • trace_id: 15535296763239574853
    • duration: 0:00:12.451227
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866380
    • 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/merchants/2026-04-12/1776004116",
              "key": "raw/merchants/2026-04-12/1776004116/73334c84-ba9e-4bfd-9fa9-f843e3b160ae.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 7662223150412679840,
              "service_name": "drive-thru",
              "span_id": 8013377492845112686,
              "trace_id": 7808154102198253576
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-12 09:28:39
    • success: True
    • trace_id: 7808154102198253576
    • duration: 0:00:12.283279
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866210
    • 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/merchants/2026-04-11/1775917620",
              "key": "raw/merchants/2026-04-11/1775917620/bdba94b2-8504-4b50-b0ea-93dfa3fb0a5f.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10756185735024543554,
              "service_name": "drive-thru",
              "span_id": 5686983742920718860,
              "trace_id": 18354441006185947246
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-11 09:27:41
    • success: True
    • trace_id: 18354441006185947246
    • duration: 0:00:14.855209
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865959
    • 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/merchants/2026-04-10/1775831228",
              "key": "raw/merchants/2026-04-10/1775831228/a3e1d83d-3b9a-4135-9955-ea39abc8ddec.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17272165464547670798,
              "service_name": "drive-thru",
              "span_id": 3283268112855931345,
              "trace_id": 1078388223701176441
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-10 09:27:18
    • success: True
    • trace_id: 1078388223701176441
    • duration: 0:00:15.019301
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865711
    • 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/merchants/2026-04-09/1775745094",
              "key": "raw/merchants/2026-04-09/1775745094/329f071a-cfc6-4925-afba-7aeceba3dc92.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17353389372055011824,
              "service_name": "drive-thru",
              "span_id": 14666245113824907261,
              "trace_id": 12916707851264918444
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-09 09:31:42
    • success: True
    • trace_id: 12916707851264918444
    • duration: 0:00:14.871684
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865472
    • 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/merchants/2026-04-08/1775658580",
              "key": "raw/merchants/2026-04-08/1775658580/19b30e8e-759c-478c-9f18-72016f052fe0.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 456000787182381363,
              "service_name": "drive-thru",
              "span_id": 1729581687994612954,
              "trace_id": 3512876638592206337
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-08 09:30:07
    • success: True
    • trace_id: 3512876638592206337
    • duration: 0:00:12.337534
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865191
    • 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/merchants/2026-04-07/1775572122",
              "key": "raw/merchants/2026-04-07/1775572122/fd413b3f-e72f-4fde-8a0f-9bf37b3f4cfa.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13905039958475876778,
              "service_name": "drive-thru",
              "span_id": 1967728840665268513,
              "trace_id": 14844726022655013862
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-07 09:28:49
    • success: True
    • trace_id: 14844726022655013862
    • duration: 0:00:12.418900
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864856
    • 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/merchants/2026-04-06/1775485993",
              "key": "raw/merchants/2026-04-06/1775485993/f63f7bf5-f517-4365-bd70-c8dcee40c22d.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 12621825348872336917,
              "service_name": "drive-thru",
              "span_id": 4740952186430284536,
              "trace_id": 2267622806632700743
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-06 09:33:20
    • success: True
    • trace_id: 2267622806632700743
    • duration: 0:00:14.778225
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864622
    • 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/merchants/2026-04-05/1775399235",
              "key": "raw/merchants/2026-04-05/1775399235/81bc9905-7dad-47cd-baf1-a6f9bad7e5c9.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 1753431306618775007,
              "service_name": "drive-thru",
              "span_id": 16678370404153881510,
              "trace_id": 11237983447217601126
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-05 09:27:20
    • success: True
    • trace_id: 11237983447217601126
    • duration: 0:00:12.604447
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864465
    • 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/merchants/2026-04-04/1775312833",
              "key": "raw/merchants/2026-04-04/1775312833/ae813204-ce8f-4e87-a37b-1ff154bfd1b0.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9568033589042235668,
              "service_name": "drive-thru",
              "span_id": 9214947527546126236,
              "trace_id": 7257538989979109566
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-04 09:27:32
    • success: True
    • trace_id: 7257538989979109566
    • duration: 0:00:14.834825
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864317
    • 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/merchants/2026-04-03/1775227696",
              "key": "raw/merchants/2026-04-03/1775227696/d307929a-a557-467f-a231-fd4c8c042028.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_merchants",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17049365798432472827,
              "service_name": "drive-thru",
              "span_id": 9623980770941988124,
              "trace_id": 4397728385829152906
          }
      }
    • running: False
    • schema_name_id: 2375
    • start_time: 2026-04-03 09:48:34
    • success: True
    • trace_id: 4397728385829152906
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",
        "amex": "string",
        "boarded": "string",
        "created": "string",
        "creator": "string",
        "dba": "string",
        "discover": "string",
        "entity_id": "string",
        "environment": "string",
        "established": "string",
        "expressbatchclosemethod": "string",
        "expressbatchclosetime": "string",
        "frozen": "string",
        "inactive": "string",
        "mcc": "string",
        "merchant_id": "string",
        "modified": "string",
        "modifier": "string",
        "new": "string",
        "qsa": "string",
        "seasonal": "string",
        "status": "string"
    }
  • created: 2026-04-17 09:30:35
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-17/1776436221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
    }
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:07:46",
        "disabled": false,
        "format": "raw",
        "id": 2375,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_merchants"
        },
        "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",
            "amex": "string",
            "boarded": "string",
            "created": "string",
            "creator": "string",
            "dba": "string",
            "discover": "string",
            "entity_id": "string",
            "environment": "string",
            "established": "string",
            "expressbatchclosemethod": "string",
            "expressbatchclosetime": "string",
            "frozen": "string",
            "inactive": "string",
            "mcc": "string",
            "merchant_id": "string",
            "modified": "string",
            "modifier": "string",
            "new": "string",
            "qsa": "string",
            "seasonal": "string",
            "status": "string"
        },
        "created": "2026-04-17 09:30:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_merchants`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `merchant_id`  string , `created`  string , `modified`  string , `creator`  string , `modifier`  string , `entity_id`  string , `dba`  string , `new`  string , `established`  string , `amex`  string , `discover`  string , `mcc`  string , `status`  string , `boarded`  string , `inactive`  string , `frozen`  string , `environment`  string , `qsa`  string , `seasonal`  string , `expressbatchclosetime`  string , `expressbatchclosemethod`  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/merchants/2026-04-17/1776436221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_merchants`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_merchants"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}