Schema Info

Schema Name: sfdl_stage_csv.payrix_org_entities

created: 2024-07-08 15:31:15
disabled: False
format: raw
id: 2109
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906713

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-17/1776436797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-17/1776436797
id: 906713
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: 2109
schema_scan_id: 6415467
updated: 2026-04-17 09:40:26

Version 906489

created: 2026-04-16 09:43:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-16/1776350588'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-16/1776350588
id: 906489
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: 2109
schema_scan_id: 6414910
updated: 2026-04-16 09:43:30

Version 906265

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-15/1776263541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-15/1776263541
id: 906265
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: 2109
schema_scan_id: 6414405
updated: 2026-04-15 09:32:40

Version 906067

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-14/1776177711'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-14/1776177711
id: 906067
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: 2109
schema_scan_id: 6413936
updated: 2026-04-14 09:42:09

Version 905831

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-13/1776090597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-13/1776090597
id: 905831
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: 2109
schema_scan_id: 6413255
updated: 2026-04-13 09:30:16

Version 905651

created: 2026-04-12 09:45:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-12/1776005142'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-12/1776005142
id: 905651
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: 2109
schema_scan_id: 6412955
updated: 2026-04-12 09:46:00

Version 905418

created: 2026-04-11 09:25:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-11/1775917522'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-11/1775917522
id: 905418
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: 2109
schema_scan_id: 6412432
updated: 2026-04-11 09:25:53

Version 905232

created: 2026-04-10 09:44:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-10/1775832243'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-10/1775832243
id: 905232
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: 2109
schema_scan_id: 6412113
updated: 2026-04-10 09:45:14

Version 905009

created: 2026-04-09 09:42:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-09/1775745713'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-09/1775745713
id: 905009
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: 2109
schema_scan_id: 6411527
updated: 2026-04-09 09:42:20

Version 904782

created: 2026-04-08 09:28:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-08/1775658519'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-08/1775658519
id: 904782
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: 2109
schema_scan_id: 6410996
updated: 2026-04-08 09:28:54

Version 904594

created: 2026-04-07 09:44:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-07/1775573079'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-07/1775573079
id: 904594
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: 2109
schema_scan_id: 6410588
updated: 2026-04-07 09:45:07

Version 904363

created: 2026-04-06 09:33:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-06/1775485951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-06/1775485951
id: 904363
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: 2109
schema_scan_id: 6410026
updated: 2026-04-06 09:33:14

Version 904154

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-05/1775399369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-05/1775399369
id: 904154
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: 2109
schema_scan_id: 6409544
updated: 2026-04-05 09:30:01

Version 903977

created: 2026-04-04 09:53:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-04/1775314379'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-04/1775314379
id: 903977
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: 2109
schema_scan_id: 6409247
updated: 2026-04-04 09:53:29

Version 903765

created: 2026-04-03 10:04:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-03/1775228654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-03/1775228654
id: 903765
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: 2109
schema_scan_id: 6408792
updated: 2026-04-03 10:04:30

Schema Scans: 15

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

Scan 6415467

duration: 0:00:21.842298

exit_message:

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

id: 6415467

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-17/1776436797",
        "key": "raw/org_entities/2026-04-17/1776436797/e50fcf95-8889-4891-b5d1-a0d73d28b4a8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13810937074278853053,
        "service_name": "drive-thru",
        "span_id": 2376634834481045051,
        "trace_id": 8958582146011603487
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-17 09:40:04
success: True
trace_id: 8958582146011603487

Scan 6414910

duration: 0:00:14.591413

exit_message:

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

id: 6414910

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-16/1776350588",
        "key": "raw/org_entities/2026-04-16/1776350588/5da1e8e7-bd2c-4630-8a68-6d1d2a807b41.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10003715461617686752,
        "service_name": "drive-thru",
        "span_id": 16605486274820594349,
        "trace_id": 227533721862078937
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-16 09:43:16
success: True
trace_id: 227533721862078937

Scan 6414405

duration: 0:00:14.594737

exit_message:

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

id: 6414405

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-15/1776263541",
        "key": "raw/org_entities/2026-04-15/1776263541/90e71600-c1aa-4ce4-ba63-11aa7b440c24.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15562641047078683363,
        "service_name": "drive-thru",
        "span_id": 13498169951676976271,
        "trace_id": 9896626782308774010
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-15 09:32:25
success: True
trace_id: 9896626782308774010

Scan 6413936

duration: 0:00:14.515049

exit_message:

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

id: 6413936

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-14/1776177711",
        "key": "raw/org_entities/2026-04-14/1776177711/c05c26bd-0f91-42d1-8744-2ead3bc83c32.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9129408857551746531,
        "service_name": "drive-thru",
        "span_id": 9236134903761181157,
        "trace_id": 14852892630033563319
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-14 09:41:54
success: True
trace_id: 14852892630033563319

Scan 6413255

duration: 0:00:12.038103

exit_message:

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

id: 6413255

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-13/1776090597",
        "key": "raw/org_entities/2026-04-13/1776090597/992e1b9a-5dbc-483a-a0fb-31028b6b24cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4156144070506941550,
        "service_name": "drive-thru",
        "span_id": 3724201822206674759,
        "trace_id": 9828636441904292215
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-13 09:30:04
success: True
trace_id: 9828636441904292215

Scan 6412955

duration: 0:00:12.158561

exit_message:

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

id: 6412955

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-12/1776005142",
        "key": "raw/org_entities/2026-04-12/1776005142/35b2c8a3-a33f-4339-88b7-5eaaae4dd81b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15700905939244693785,
        "service_name": "drive-thru",
        "span_id": 4814982112496351716,
        "trace_id": 5391254617899520991
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-12 09:45:48
success: True
trace_id: 5391254617899520991

Scan 6412432

duration: 0:00:12.002160

exit_message:

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

id: 6412432

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-11/1775917522",
        "key": "raw/org_entities/2026-04-11/1775917522/72b90727-28c2-4648-bbd5-14a2c4c501ce.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1920419828938804446,
        "service_name": "drive-thru",
        "span_id": 16007953301662585784,
        "trace_id": 9352335202597339074
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-11 09:25:41
success: True
trace_id: 9352335202597339074

Scan 6412113

duration: 0:01:02.836191

exit_message:

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

id: 6412113

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-10/1775832243",
        "key": "raw/org_entities/2026-04-10/1775832243/d20cf796-6f11-41c3-b0a0-0ec21bf29889.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15250958646425436026,
        "service_name": "drive-thru",
        "span_id": 5515814115003353868,
        "trace_id": 542843467953216133
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-10 09:44:11
success: True
trace_id: 542843467953216133

Scan 6411527

duration: 0:00:14.682368

exit_message:

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

id: 6411527

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-09/1775745713",
        "key": "raw/org_entities/2026-04-09/1775745713/9f573fee-a0fe-4dad-ba0c-ca1930e9e520.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2720280085917989681,
        "service_name": "drive-thru",
        "span_id": 1602543387098133168,
        "trace_id": 17542524357065407347
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-09 09:42:05
success: True
trace_id: 17542524357065407347

Scan 6410996

duration: 0:00:11.914338

exit_message:

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

id: 6410996

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-08/1775658519",
        "key": "raw/org_entities/2026-04-08/1775658519/56017ec5-ac9c-45d6-b3a5-e0152d10881b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2753628716649740679,
        "service_name": "drive-thru",
        "span_id": 4506055113558312272,
        "trace_id": 18378057341678380202
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-08 09:28:42
success: True
trace_id: 18378057341678380202

Scan 6410588

duration: 0:00:11.959580

exit_message:

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

id: 6410588

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-07/1775573079",
        "key": "raw/org_entities/2026-04-07/1775573079/ef70d2c8-e6b6-434e-86ae-319e59b4dc58.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16810479045683510230,
        "service_name": "drive-thru",
        "span_id": 3148426047679230416,
        "trace_id": 7957849363494141402
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-07 09:44:55
success: True
trace_id: 7957849363494141402

Scan 6410026

duration: 0:00:12.143322

exit_message:

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

id: 6410026

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-06/1775485951",
        "key": "raw/org_entities/2026-04-06/1775485951/3e96391f-33b5-4f55-b333-b89efcdd637d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3405806549869215377,
        "service_name": "drive-thru",
        "span_id": 1420305938294099076,
        "trace_id": 6246299022798053040
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-06 09:33:02
success: True
trace_id: 6246299022798053040

Scan 6409544

duration: 0:00:12.126309

exit_message:

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

id: 6409544

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-05/1775399369",
        "key": "raw/org_entities/2026-04-05/1775399369/7cd0e6b6-1339-4c56-85f9-7278494418a5.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15438842171928220759,
        "service_name": "drive-thru",
        "span_id": 18303655053102575200,
        "trace_id": 1076780400704131690
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-05 09:29:49
success: True
trace_id: 1076780400704131690

Scan 6409247

duration: 0:00:11.933862

exit_message:

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

id: 6409247

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-04/1775314379",
        "key": "raw/org_entities/2026-04-04/1775314379/716936ed-ffb7-4175-9e56-1e9d614aaa56.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8287777727160261577,
        "service_name": "drive-thru",
        "span_id": 6309435416206792354,
        "trace_id": 2207121315549662492
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-04 09:53:17
success: True
trace_id: 2207121315549662492

Scan 6408792

duration: 0:00:12.119061

exit_message:

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

id: 6408792

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/org_entities/2026-04-03/1775228654",
        "key": "raw/org_entities/2026-04-03/1775228654/26681eaa-0fd7-4b9d-bead-8c38c8e56efe.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9703494142100845817,
        "service_name": "drive-thru",
        "span_id": 5946345588337331061,
        "trace_id": 10701967986599815993
    }
}

running: False
schema_name_id: 2109
start_time: 2026-04-03 10:04:18
success: True
trace_id: 10701967986599815993

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:40:05

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-17/1776436797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-08 15:31:15",
        "disabled": false,
        "format": "raw",
        "id": 2109,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:40:05",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/org_entities/2026-04-17/1776436797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_org_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_org_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}