Schema Info

Schema Name: sfdl_dev_csv.payrix_org_entities

created: 2024-07-03 14:00:48
disabled: False
format: raw
id: 2308
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773344

created: 2026-04-17 09:36:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-17/1776436552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-17/1776436552
id: 4773344
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6867681
updated: 2026-04-17 09:36:19

Version 4773303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-16/1776351148'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-16/1776351148
id: 4773303
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6867545
updated: 2026-04-16 09:52:45

Version 4773218

created: 2026-04-15 09:35:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-15/1776263705'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-15/1776263705
id: 4773218
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6867170
updated: 2026-04-15 09:35:20

Version 4773156

created: 2026-04-14 09:42:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-14/1776177698'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-14/1776177698
id: 4773156
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6866895
updated: 2026-04-14 09:42:21

Version 4773115

created: 2026-04-13 09:45:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-13/1776091546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-13/1776091546
id: 4773115
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6866690
updated: 2026-04-13 09:46:03

Version 4773063

created: 2026-04-12 09:47:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-12/1776005246'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-12/1776005246
id: 4773063
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6866497
updated: 2026-04-12 09:47:44

Version 4773018

created: 2026-04-11 09:46:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-11/1775918782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-11/1775918782
id: 4773018
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6866317
updated: 2026-04-11 09:46:45

Version 4772938

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-10/1775831274'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-10/1775831274
id: 4772938
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6865976
updated: 2026-04-10 09:28:16

Version 4772894

created: 2026-04-09 09:48:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-09/1775746081'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-09/1775746081
id: 4772894
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6865813
updated: 2026-04-09 09:48:57

Version 4772842

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-08/1775659650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-08/1775659650
id: 4772842
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6865551
updated: 2026-04-08 09:47:48

Version 4772756

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-07/1775572158'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-07/1775572158
id: 4772756
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6865199
updated: 2026-04-07 09:29:38

Version 4772716

created: 2026-04-06 09:49:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-06/1775486952'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-06/1775486952
id: 4772716
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6864961
updated: 2026-04-06 09:49:34

Version 4772635

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-05/1775399200'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-05/1775399200
id: 4772635
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6864621
updated: 2026-04-05 09:27:26

Version 4772617

created: 2026-04-04 09:55:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-04/1775314534'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-04/1775314534
id: 4772617
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6864578
updated: 2026-04-04 09:56:13

Version 4772557

created: 2026-04-03 10:00:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-03/1775228396'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/org_entities/2026-04-03/1775228396
id: 4772557
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": 5,
    "entity_id": 11,
    "modified": 9,
    "modifier": 8,
    "org": 6,
    "org_entity_id": 10
}

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

schema_name_id: 2308
schema_scan_id: 6864346
updated: 2026-04-03 10:00:24

Schema Scans: 15

Last at 2026-04-17 09:36:04

Scan 6867681

duration: 0:00:14.630689

exit_message:

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

id: 6867681

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/org_entities/2026-04-17/1776436552",
        "key": "raw/org_entities/2026-04-17/1776436552/c05b5ea2-4d58-4e23-add6-93355cd210a6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12391248828761156455,
        "service_name": "drive-thru",
        "span_id": 8418305376947032478,
        "trace_id": 1579741930244711901
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-17 09:36:04
success: True
trace_id: 1579741930244711901

Scan 6867545

duration: 0:00:14.471117

exit_message:

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

id: 6867545

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/org_entities/2026-04-16/1776351148",
        "key": "raw/org_entities/2026-04-16/1776351148/23f81ecd-dc49-4d31-a9f2-864f2acc16ba.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4741219983858854794,
        "service_name": "drive-thru",
        "span_id": 16413821306035232382,
        "trace_id": 1287825902146250456
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-16 09:52:31
success: True
trace_id: 1287825902146250456

Scan 6867170

duration: 0:00:11.923175

exit_message:

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

id: 6867170

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/org_entities/2026-04-15/1776263705",
        "key": "raw/org_entities/2026-04-15/1776263705/d64fd47f-7542-425e-b63c-1232a3234630.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9418281310362288278,
        "service_name": "drive-thru",
        "span_id": 6327647530072518805,
        "trace_id": 7106726257965947191
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-15 09:35:09
success: True
trace_id: 7106726257965947191

Scan 6866895

duration: 0:00:14.624988

exit_message:

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

id: 6866895

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/org_entities/2026-04-14/1776177698",
        "key": "raw/org_entities/2026-04-14/1776177698/fe1c806e-2ec3-416c-9e89-65d050e4435c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5116335809097583753,
        "service_name": "drive-thru",
        "span_id": 8829260045684776167,
        "trace_id": 1715041052550304312
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-14 09:42:06
success: True
trace_id: 1715041052550304312

Scan 6866690

duration: 0:00:14.426330

exit_message:

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

id: 6866690

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/org_entities/2026-04-13/1776091546",
        "key": "raw/org_entities/2026-04-13/1776091546/c39e879d-6bb2-49de-9708-2dab4a979aa2.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6371024876990763175,
        "service_name": "drive-thru",
        "span_id": 11735863788835791,
        "trace_id": 893544150164721851
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-13 09:45:49
success: True
trace_id: 893544150164721851

Scan 6866497

duration: 0:00:11.886569

exit_message:

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

id: 6866497

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/org_entities/2026-04-12/1776005246",
        "key": "raw/org_entities/2026-04-12/1776005246/b26ef647-0179-4742-84f8-9428e7862c46.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13790303694334897974,
        "service_name": "drive-thru",
        "span_id": 3798182127815099434,
        "trace_id": 10005324036169064809
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-12 09:47:32
success: True
trace_id: 10005324036169064809

Scan 6866317

duration: 0:00:11.898256

exit_message:

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

id: 6866317

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/org_entities/2026-04-11/1775918782",
        "key": "raw/org_entities/2026-04-11/1775918782/d6df1279-2e02-4007-9077-a902bf196d91.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14838435992635863099,
        "service_name": "drive-thru",
        "span_id": 4510362645036979758,
        "trace_id": 2052552918155549567
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-11 09:46:33
success: True
trace_id: 2052552918155549567

Scan 6865976

duration: 0:00:11.960603

exit_message:

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

id: 6865976

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/org_entities/2026-04-10/1775831274",
        "key": "raw/org_entities/2026-04-10/1775831274/b8c5d4cf-13d5-4106-af04-7554b6213b1a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6396909524430386933,
        "service_name": "drive-thru",
        "span_id": 1341604361670531141,
        "trace_id": 2560673133652145225
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-10 09:28:04
success: True
trace_id: 2560673133652145225

Scan 6865813

duration: 0:00:14.463499

exit_message:

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

id: 6865813

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/org_entities/2026-04-09/1775746081",
        "key": "raw/org_entities/2026-04-09/1775746081/4e6850b5-5717-416e-9fb1-34664d717216.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14126920043905832730,
        "service_name": "drive-thru",
        "span_id": 18101133399613943446,
        "trace_id": 8036145519237529759
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-09 09:48:43
success: True
trace_id: 8036145519237529759

Scan 6865551

duration: 0:00:14.517753

exit_message:

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

id: 6865551

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/org_entities/2026-04-08/1775659650",
        "key": "raw/org_entities/2026-04-08/1775659650/9cd6668e-1b9d-4ebc-9f22-6a3db4d5cb76.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18380453344733077232,
        "service_name": "drive-thru",
        "span_id": 1488839651709906448,
        "trace_id": 3198702744781356712
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-08 09:47:33
success: True
trace_id: 3198702744781356712

Scan 6865199

duration: 0:00:17.108751

exit_message:

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

id: 6865199

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/org_entities/2026-04-07/1775572158",
        "key": "raw/org_entities/2026-04-07/1775572158/8986c262-190f-4e29-8822-8b3d0562dae3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5735530172387846682,
        "service_name": "drive-thru",
        "span_id": 2251234136093319191,
        "trace_id": 8783551974027926787
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-07 09:29:21
success: True
trace_id: 8783551974027926787

Scan 6864961

duration: 0:00:14.426074

exit_message:

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

id: 6864961

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/org_entities/2026-04-06/1775486952",
        "key": "raw/org_entities/2026-04-06/1775486952/f9af5361-aad5-480a-9fb1-8dc7d21f94f7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6964288542306208085,
        "service_name": "drive-thru",
        "span_id": 7106873447795242889,
        "trace_id": 4993236898891534703
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-06 09:49:20
success: True
trace_id: 4993236898891534703

Scan 6864621

duration: 0:00:14.576122

exit_message:

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

id: 6864621

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/org_entities/2026-04-05/1775399200",
        "key": "raw/org_entities/2026-04-05/1775399200/fb2be15f-c7ac-4b27-a7fb-d2ab131f93fc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9080129405562801254,
        "service_name": "drive-thru",
        "span_id": 5744424192544493463,
        "trace_id": 15851965272164465004
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-05 09:27:11
success: True
trace_id: 15851965272164465004

Scan 6864578

duration: 0:00:14.580038

exit_message:

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

id: 6864578

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/org_entities/2026-04-04/1775314534",
        "key": "raw/org_entities/2026-04-04/1775314534/fe9ba67d-7821-4229-b59d-b64712bca679.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11201274664398417069,
        "service_name": "drive-thru",
        "span_id": 5048444241515539809,
        "trace_id": 18103750762763928788
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-04 09:55:58
success: True
trace_id: 18103750762763928788

Scan 6864346

duration: 0:00:14.574524

exit_message:

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

id: 6864346

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/org_entities/2026-04-03/1775228396",
        "key": "raw/org_entities/2026-04-03/1775228396/e2993913-2df2-49b4-a8ae-c89b9d82c485.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18036516903058291877,
        "service_name": "drive-thru",
        "span_id": 6944368864110247058,
        "trace_id": 5864970563063088465
    }
}

running: False
schema_name_id: 2308
start_time: 2026-04-03 10:00:09
success: True
trace_id: 5864970563063088465

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",
    "entity_id": "string",
    "modified": "string",
    "modifier": "string",
    "org": "string",
    "org_entity_id": "string"
}

created: 2026-04-17 09:36:05

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-17/1776436552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-03 14:00:48",
        "disabled": false,
        "format": "raw",
        "id": 2308,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_org_entities"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_hoodie_commit_seqno": "string",
            "_hoodie_commit_time": "string",
            "_hoodie_file_name": "string",
            "_hoodie_partition_path": "string",
            "_hoodie_record_key": "string",
            "created": "string",
            "creator": "string",
            "entity_id": "string",
            "modified": "string",
            "modifier": "string",
            "org": "string",
            "org_entity_id": "string"
        },
        "created": "2026-04-17 09:36:05",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_org_entities`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `org`  string , `created`  string , `modifier`  string , `modified`  string , `org_entity_id`  string , `entity_id`  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/org_entities/2026-04-17/1776436552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_org_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_org_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}