Schema Info

Schema Name: sfdl_dev_csv.payrix_entity_refs

created: 2023-08-18 15:51:47
disabled: False
format: raw
id: 2232
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773347

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-17/1776436727
id: 4773347
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_id": "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: 2232
schema_scan_id: 6867688
updated: 2026-04-17 09:39:20

Version 4773280

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-16/1776349910
id: 4773280
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_id": "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: 2232
schema_scan_id: 6867420
updated: 2026-04-16 09:32:24

Version 4773232

created: 2026-04-15 09:58:29

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-15/1776265104
id: 4773232
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_id": "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: 2232
schema_scan_id: 6867236
updated: 2026-04-15 09:58:42

Version 4773170

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-14/1776178737
id: 4773170
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_id": "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: 2232
schema_scan_id: 6866923
updated: 2026-04-14 09:59:43

Version 4773108

created: 2026-04-13 09:39:36

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-13/1776091165
id: 4773108
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_id": "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: 2232
schema_scan_id: 6866636
updated: 2026-04-13 09:39:47

Version 4773049

created: 2026-04-12 09:39:09

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-12/1776004735
id: 4773049
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_id": "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: 2232
schema_scan_id: 6866432
updated: 2026-04-12 09:39:21

Version 4773008

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-11/1775918500
id: 4773008
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_id": "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: 2232
schema_scan_id: 6866269
updated: 2026-04-11 09:42:02

Version 4772946

created: 2026-04-10 09:29:52

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-10/1775831386
id: 4772946
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_id": "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: 2232
schema_scan_id: 6866018
updated: 2026-04-10 09:30:03

Version 4772881

created: 2026-04-09 09:34:53

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-09/1775745272
id: 4772881
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_id": "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: 2232
schema_scan_id: 6865750
updated: 2026-04-09 09:35:04

Version 4772809

created: 2026-04-08 09:26:42

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-08/1775658387
id: 4772809
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_id": "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: 2232
schema_scan_id: 6865409
updated: 2026-04-08 09:26:55

Version 4772764

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-07/1775572496
id: 4772764
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_id": "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: 2232
schema_scan_id: 6865258
updated: 2026-04-07 09:35:15

Version 4772701

created: 2026-04-06 09:41:48

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-06/1775486469
id: 4772701
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_id": "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: 2232
schema_scan_id: 6864894
updated: 2026-04-06 09:41:59

Version 4772659

created: 2026-04-05 09:48:22

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-05/1775400490
id: 4772659
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_id": "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: 2232
schema_scan_id: 6864734
updated: 2026-04-05 09:48:36

Version 4772608

created: 2026-04-04 09:44:21

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-04/1775313822
id: 4772608
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_id": "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: 2232
schema_scan_id: 6864514
updated: 2026-04-04 09:44:32

Version 4772541

created: 2026-04-03 09:40:04

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-03/1775227175
id: 4772541
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_id": "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: 2232
schema_scan_id: 6864287
updated: 2026-04-03 09:40:15

Schema Scans: 15

Last at 2026-04-17 09:39:05

Scan 6867688

duration: 0:00:14.837980

exit_message:

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

id: 6867688

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-17/1776436727",
        "key": "raw/entity_refs/2026-04-17/1776436727/ed26fb98-b8ea-43de-9b1c-4bf3b0bc7127.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4570121894252493110,
        "service_name": "drive-thru",
        "span_id": 16365484418351427407,
        "trace_id": 1381903275620369801
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-17 09:39:05
success: True
trace_id: 1381903275620369801

Scan 6867420

duration: 0:00:12.378558

exit_message:

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

id: 6867420

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-16/1776349910",
        "key": "raw/entity_refs/2026-04-16/1776349910/b065a599-d190-49ba-a707-9715589b45a8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2843568720950012386,
        "service_name": "drive-thru",
        "span_id": 11541679025335771766,
        "trace_id": 1243059290366411681
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-16 09:32:11
success: True
trace_id: 1243059290366411681

Scan 6867236

duration: 0:00:14.828531

exit_message:

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

id: 6867236

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-15/1776265104",
        "key": "raw/entity_refs/2026-04-15/1776265104/b46d3dc1-07a4-4198-a17c-0ec477a3998d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 987353393266875,
        "service_name": "drive-thru",
        "span_id": 16415904610931136349,
        "trace_id": 4509318963088113794
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-15 09:58:28
success: True
trace_id: 4509318963088113794

Scan 6866923

duration: 0:00:12.341000

exit_message:

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

id: 6866923

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-14/1776178737",
        "key": "raw/entity_refs/2026-04-14/1776178737/0db32d4c-1e02-4cd6-8fda-4cd54fabc041.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9960640307704695845,
        "service_name": "drive-thru",
        "span_id": 11007872208606349346,
        "trace_id": 3898380064484189560
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-14 09:59:31
success: True
trace_id: 3898380064484189560

Scan 6866636

duration: 0:00:12.277877

exit_message:

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

id: 6866636

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-13/1776091165",
        "key": "raw/entity_refs/2026-04-13/1776091165/9360a8d0-9565-4f2f-964a-defb0ee761ef.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7405031866419922570,
        "service_name": "drive-thru",
        "span_id": 6753115902047122033,
        "trace_id": 13036291520746330438
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-13 09:39:35
success: True
trace_id: 13036291520746330438

Scan 6866432

duration: 0:00:12.186200

exit_message:

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

id: 6866432

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-12/1776004735",
        "key": "raw/entity_refs/2026-04-12/1776004735/56fb8be7-4bb1-474b-aafd-3efe3a36c842.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5626066173643203998,
        "service_name": "drive-thru",
        "span_id": 16169212986498437926,
        "trace_id": 7579921126106271090
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-12 09:39:08
success: True
trace_id: 7579921126106271090

Scan 6866269

duration: 0:00:12.344800

exit_message:

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

id: 6866269

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-11/1775918500",
        "key": "raw/entity_refs/2026-04-11/1775918500/4bbccb36-8806-4805-8a3b-e01009100cc9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12978948137152198104,
        "service_name": "drive-thru",
        "span_id": 836658120963218587,
        "trace_id": 8664296829328548099
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-11 09:41:50
success: True
trace_id: 8664296829328548099

Scan 6866018

duration: 0:00:12.122568

exit_message:

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

id: 6866018

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-10/1775831386",
        "key": "raw/entity_refs/2026-04-10/1775831386/58ea9b42-6a10-46e9-8a87-8b2f0134d9fc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13507010341803024408,
        "service_name": "drive-thru",
        "span_id": 18170456885489056253,
        "trace_id": 9193285330653948251
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-10 09:29:51
success: True
trace_id: 9193285330653948251

Scan 6865750

duration: 0:00:12.315457

exit_message:

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

id: 6865750

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-09/1775745272",
        "key": "raw/entity_refs/2026-04-09/1775745272/e8a39acb-65d6-4738-800a-3a4ea89a8377.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 396393500875169897,
        "service_name": "drive-thru",
        "span_id": 12405580532143233178,
        "trace_id": 43119671011565462
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-09 09:34:51
success: True
trace_id: 43119671011565462

Scan 6865409

duration: 0:00:14.751885

exit_message:

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

id: 6865409

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-08/1775658387",
        "key": "raw/entity_refs/2026-04-08/1775658387/35ecac1a-39a7-4869-acb9-335fd510502d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10918144520495054141,
        "service_name": "drive-thru",
        "span_id": 14274353758921271167,
        "trace_id": 15688458148973646638
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-08 09:26:41
success: True
trace_id: 15688458148973646638

Scan 6865258

duration: 0:00:12.509933

exit_message:

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

id: 6865258

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-07/1775572496",
        "key": "raw/entity_refs/2026-04-07/1775572496/1c51d0c2-aee6-413d-80c9-73436d3327b8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6079732498172242978,
        "service_name": "drive-thru",
        "span_id": 3599422870326839140,
        "trace_id": 7673685928514118313
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-07 09:35:03
success: True
trace_id: 7673685928514118313

Scan 6864894

duration: 0:00:12.260311

exit_message:

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

id: 6864894

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-06/1775486469",
        "key": "raw/entity_refs/2026-04-06/1775486469/fc2abd31-facf-4d06-a5b8-5ad6ec8c91be.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3722080237618315471,
        "service_name": "drive-thru",
        "span_id": 221484246032658547,
        "trace_id": 14418562913293449899
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-06 09:41:47
success: True
trace_id: 14418562913293449899

Scan 6864734

duration: 0:00:14.940039

exit_message:

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

id: 6864734

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-05/1775400490",
        "key": "raw/entity_refs/2026-04-05/1775400490/104a2623-2caa-4846-96db-34754ef87274.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14801878434720330473,
        "service_name": "drive-thru",
        "span_id": 6755853625017982862,
        "trace_id": 13185999101989394527
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-05 09:48:21
success: True
trace_id: 13185999101989394527

Scan 6864514

duration: 0:00:12.235583

exit_message:

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

id: 6864514

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-04/1775313822",
        "key": "raw/entity_refs/2026-04-04/1775313822/5e06a197-d104-4aeb-8750-5f47ce4181f7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13192529343597216868,
        "service_name": "drive-thru",
        "span_id": 4003868633345849694,
        "trace_id": 6852174790035450581
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-04 09:44:20
success: True
trace_id: 6852174790035450581

Scan 6864287

duration: 0:00:12.637907

exit_message:

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

id: 6864287

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/entity_refs/2026-04-03/1775227175",
        "key": "raw/entity_refs/2026-04-03/1775227175/bf96ff06-6b4c-4c5b-879b-2cda6fd167be.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_entity_refs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14652621996339313570,
        "service_name": "drive-thru",
        "span_id": 14421070965124301648,
        "trace_id": 15318649589903854982
    }
}

running: False
schema_name_id: 2232
start_time: 2026-04-03 09:40:02
success: True
trace_id: 15318649589903854982

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_id": "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:39:06

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_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-payrix-dev/raw/entity_refs/2026-04-17/1776436727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entity_refs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_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": "2023-08-18 15:51:47",
        "disabled": false,
        "format": "raw",
        "id": 2232,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_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_id": "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:39:06",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_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-payrix-dev/raw/entity_refs/2026-04-17/1776436727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_entity_refs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_entity_refs"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}