Schema Info

Schema Name: sfdl_dev_csv.payrixess_entity_refs

created: 2024-07-22 12:58:01
disabled: False
format: raw
id: 2348
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773336

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-17/1776436229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-17/1776436229
id: 4773336
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6867667
updated: 2026-04-17 09:30:50

Version 4773287

created: 2026-04-16 09:34:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-16/1776350014'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-16/1776350014
id: 4773287
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6867461
updated: 2026-04-16 09:34:39

Version 4773216

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-15/1776263684'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-15/1776263684
id: 4773216
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6867167
updated: 2026-04-15 09:35:08

Version 4773155

created: 2026-04-14 09:41:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-14/1776177686'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-14/1776177686
id: 4773155
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6866893
updated: 2026-04-14 09:42:05

Version 4773098

created: 2026-04-13 09:30:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-13/1776090621'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-13/1776090621
id: 4773098
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6866591
updated: 2026-04-13 09:30:42

Version 4773046

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-12/1776004130'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-12/1776004130
id: 4773046
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6866384
updated: 2026-04-12 09:29:17

Version 4772994

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-11/1775917680'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-11/1775917680
id: 4772994
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6866219
updated: 2026-04-11 09:28:21

Version 4772934

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-10/1775831216'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-10/1775831216
id: 4772934
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6865960
updated: 2026-04-10 09:27:35

Version 4772875

created: 2026-04-09 09:30:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-09/1775744984'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-09/1775744984
id: 4772875
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6865702
updated: 2026-04-09 09:30:55

Version 4772822

created: 2026-04-08 09:29:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-08/1775658526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-08/1775658526
id: 4772822
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6865467
updated: 2026-04-08 09:30:07

Version 4772753

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-07/1775572105'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-07/1775572105
id: 4772753
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6865187
updated: 2026-04-07 09:28:43

Version 4772695

created: 2026-04-06 09:31:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-06/1775485906'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-06/1775485906
id: 4772695
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6864840
updated: 2026-04-06 09:32:08

Version 4772643

created: 2026-04-05 09:29:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-05/1775399322'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-05/1775399322
id: 4772643
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6864644
updated: 2026-04-05 09:29:18

Version 4772595

created: 2026-04-04 09:27:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-04/1775312841'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-04/1775312841
id: 4772595
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6864468
updated: 2026-04-04 09:28:00

Version 4772535

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-03/1775226943'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/entity_refs/2026-04-03/1775226943
id: 4772535
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "created": 7,
    "creator": 8,
    "currency": 11,
    "default": 12,
    "entity": 6,
    "entity_ref_id": 5,
    "fbo": 16,
    "frozen": 17,
    "fundingcurrency": 18,
    "inactive": 19,
    "modified": 9,
    "modifier": 10,
    "options": 20,
    "platform": 13,
    "ref": 15,
    "stage": 14,
    "staging": 21
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

schema_name_id: 2348
schema_scan_id: 6864277
updated: 2026-04-03 09:36:03

Schema Scans: 15

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

Scan 6867667

duration: 0:00:12.256762

exit_message:

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

id: 6867667

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/entity_refs/2026-04-17/1776436229",
        "key": "raw/entity_refs/2026-04-17/1776436229/f336b99c-1fe8-4a95-a4c0-9b1dd79f51a0.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 726188113078694164,
        "service_name": "drive-thru",
        "span_id": 8966357651012871158,
        "trace_id": 14527468801731792354
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-17 09:30:38
success: True
trace_id: 14527468801731792354

Scan 6867461

duration: 0:00:14.894092

exit_message:

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

id: 6867461

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/entity_refs/2026-04-16/1776350014",
        "key": "raw/entity_refs/2026-04-16/1776350014/c56f4a4c-d192-4cd9-8f66-e2916f944bca.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4461495301490091560,
        "service_name": "drive-thru",
        "span_id": 11357705842060167937,
        "trace_id": 1995172977212580854
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-16 09:34:24
success: True
trace_id: 1995172977212580854

Scan 6867167

duration: 0:00:12.258661

exit_message:

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

id: 6867167

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/entity_refs/2026-04-15/1776263684",
        "key": "raw/entity_refs/2026-04-15/1776263684/51d93c4e-6877-47a9-a695-7e4850b3a58d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14937340401679417993,
        "service_name": "drive-thru",
        "span_id": 10816747486451313613,
        "trace_id": 12898029709014164812
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-15 09:34:55
success: True
trace_id: 12898029709014164812

Scan 6866893

duration: 0:00:14.875466

exit_message:

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

id: 6866893

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/entity_refs/2026-04-14/1776177686",
        "key": "raw/entity_refs/2026-04-14/1776177686/c3a63517-94ce-443b-a214-38863e104580.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6915654504799015383,
        "service_name": "drive-thru",
        "span_id": 16477390562119764931,
        "trace_id": 5394259361371110006
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-14 09:41:50
success: True
trace_id: 5394259361371110006

Scan 6866591

duration: 0:00:14.714911

exit_message:

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

id: 6866591

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/entity_refs/2026-04-13/1776090621",
        "key": "raw/entity_refs/2026-04-13/1776090621/52d7eed8-ff1b-4ce9-86f4-ebc4fb7e1414.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7487713146160833076,
        "service_name": "drive-thru",
        "span_id": 17339796293749992452,
        "trace_id": 5629166036029265725
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-13 09:30:27
success: True
trace_id: 5629166036029265725

Scan 6866384

duration: 0:00:14.795016

exit_message:

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

id: 6866384

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/entity_refs/2026-04-12/1776004130",
        "key": "raw/entity_refs/2026-04-12/1776004130/ea63ca81-baae-411a-8c6f-8a741eca32f9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 510352976528406627,
        "service_name": "drive-thru",
        "span_id": 10177391197308106888,
        "trace_id": 8406528854244902163
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-12 09:29:02
success: True
trace_id: 8406528854244902163

Scan 6866219

duration: 0:00:12.216025

exit_message:

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

id: 6866219

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/entity_refs/2026-04-11/1775917680",
        "key": "raw/entity_refs/2026-04-11/1775917680/ce2fa4e0-a883-4d64-a4d5-667be78abd10.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7489128129216722597,
        "service_name": "drive-thru",
        "span_id": 10467254712066508489,
        "trace_id": 17344378374096575753
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-11 09:28:08
success: True
trace_id: 17344378374096575753

Scan 6865960

duration: 0:00:12.245511

exit_message:

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

id: 6865960

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/entity_refs/2026-04-10/1775831216",
        "key": "raw/entity_refs/2026-04-10/1775831216/73159b26-d844-4552-9a99-43bd5d3dcf9c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6796576993600173618,
        "service_name": "drive-thru",
        "span_id": 11697327602381241302,
        "trace_id": 4390070353736928989
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-10 09:27:23
success: True
trace_id: 4390070353736928989

Scan 6865702

duration: 0:00:12.276563

exit_message:

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

id: 6865702

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/entity_refs/2026-04-09/1775744984",
        "key": "raw/entity_refs/2026-04-09/1775744984/9fea111c-c6c4-41e1-9528-1d1fb2be66bc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4104128622143594575,
        "service_name": "drive-thru",
        "span_id": 18271257881062525485,
        "trace_id": 10713248395507040005
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-09 09:30:43
success: True
trace_id: 10713248395507040005

Scan 6865467

duration: 0:00:12.231875

exit_message:

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

id: 6865467

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/entity_refs/2026-04-08/1775658526",
        "key": "raw/entity_refs/2026-04-08/1775658526/c0e8b765-36af-4081-b10b-2eed765ecfb5.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11950601967132554053,
        "service_name": "drive-thru",
        "span_id": 340133953689662088,
        "trace_id": 8181093769781498014
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-08 09:29:55
success: True
trace_id: 8181093769781498014

Scan 6865187

duration: 0:00:14.777088

exit_message:

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

id: 6865187

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/entity_refs/2026-04-07/1775572105",
        "key": "raw/entity_refs/2026-04-07/1775572105/4adca756-4455-41d8-8464-9d5e11c1ae2f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2532313036141691564,
        "service_name": "drive-thru",
        "span_id": 10551828287331575917,
        "trace_id": 8877756440366595063
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-07 09:28:28
success: True
trace_id: 8877756440366595063

Scan 6864840

duration: 0:00:14.894379

exit_message:

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

id: 6864840

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/entity_refs/2026-04-06/1775485906",
        "key": "raw/entity_refs/2026-04-06/1775485906/bf4ef346-8731-4d8a-b3c8-b3d79874f772.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 864887521624220508,
        "service_name": "drive-thru",
        "span_id": 9887155857180715107,
        "trace_id": 7728888612512744100
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-06 09:31:53
success: True
trace_id: 7728888612512744100

Scan 6864644

duration: 0:00:14.870662

exit_message:

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

id: 6864644

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/entity_refs/2026-04-05/1775399322",
        "key": "raw/entity_refs/2026-04-05/1775399322/7ea0ea20-a199-4b2f-8ee6-e26ca0c78a9d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14293273530932760989,
        "service_name": "drive-thru",
        "span_id": 16552783540744827873,
        "trace_id": 7456076087496555289
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-05 09:29:03
success: True
trace_id: 7456076087496555289

Scan 6864468

duration: 0:00:14.848102

exit_message:

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

id: 6864468

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/entity_refs/2026-04-04/1775312841",
        "key": "raw/entity_refs/2026-04-04/1775312841/eb35e4c8-64ef-4b31-aa94-70a9089eda8e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18395174585991134644,
        "service_name": "drive-thru",
        "span_id": 16021081709822939979,
        "trace_id": 264961504792014043
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-04 09:27:45
success: True
trace_id: 264961504792014043

Scan 6864277

duration: 0:00:14.770676

exit_message:

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

id: 6864277

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/entity_refs/2026-04-03/1775226943",
        "key": "raw/entity_refs/2026-04-03/1775226943/d498af60-bfc3-49e9-8f81-b7b2f1a40966.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11767962100825523374,
        "service_name": "drive-thru",
        "span_id": 11147220061448816047,
        "trace_id": 1846288245450940599
    }
}

running: False
schema_name_id: 2348
start_time: 2026-04-03 09:35:48
success: True
trace_id: 1846288245450940599

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",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "default": "string",
    "entity": "string",
    "entity_ref_id": "string",
    "fbo": "string",
    "frozen": "string",
    "fundingcurrency": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "options": "string",
    "platform": "string",
    "ref": "string",
    "stage": "string",
    "staging": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-17/1776436229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-22 12:58:01",
        "disabled": false,
        "format": "raw",
        "id": 2348,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_entity_refs"
        },
        "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",
            "created": "string",
            "creator": "string",
            "currency": "string",
            "default": "string",
            "entity": "string",
            "entity_ref_id": "string",
            "fbo": "string",
            "frozen": "string",
            "fundingcurrency": "string",
            "inactive": "string",
            "modified": "string",
            "modifier": "string",
            "options": "string",
            "platform": "string",
            "ref": "string",
            "stage": "string",
            "staging": "string"
        },
        "created": "2026-04-17 09:30:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_entity_refs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `entity_ref_id`  string , `entity`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `currency`  string , `default`  string , `platform`  string , `stage`  string , `ref`  string , `fbo`  string , `frozen`  string , `fundingcurrency`  string , `inactive`  string , `options`  string , `staging`  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/entity_refs/2026-04-17/1776436229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_entity_refs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_entity_refs"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}