Schema Info

Schema Name: sfdl_prod_csv.payrix_org_entities

created: 2024-07-10 09:31:55
disabled: False
format: raw
id: 1912
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718273

created: 2026-04-17 09:47:50

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-17/1776437254
id: 1718273
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: 1912
schema_scan_id: 162178944
updated: 2026-04-17 09:48:02

Version 1717038

created: 2026-04-16 09:40:33

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-16/1776350419
id: 1717038
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: 1912
schema_scan_id: 162122881
updated: 2026-04-16 09:40:44

Version 1715888

created: 2026-04-15 11:34:14

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-15/1776270840
id: 1715888
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: 1912
schema_scan_id: 162072901
updated: 2026-04-15 11:34:28

Version 1714956

created: 2026-04-14 21:13:57

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-14/1776219225
id: 1714956
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: 1912
schema_scan_id: 162046418
updated: 2026-04-14 21:14:11

Version 1713435

created: 2026-04-13 09:50:52

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-13/1776091758
id: 1713435
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: 1912
schema_scan_id: 161954229
updated: 2026-04-13 09:51:05

Version 1712214

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-12/1776004158
id: 1712214
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: 1912
schema_scan_id: 161903434
updated: 2026-04-12 09:29:37

Version 1711034

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-11/1775918705
id: 1711034
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: 1912
schema_scan_id: 161852130
updated: 2026-04-11 09:45:26

Version 1709857

created: 2026-04-10 09:41:40

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-10/1775832094
id: 1709857
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: 1912
schema_scan_id: 161797506
updated: 2026-04-10 09:41:56

Version 1708673

created: 2026-04-09 09:26:55

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-09/1775744810
id: 1708673
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: 1912
schema_scan_id: 161741325
updated: 2026-04-09 09:27:09

Version 1707513

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-08/1775658847
id: 1707513
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: 1912
schema_scan_id: 161686277
updated: 2026-04-08 09:34:39

Version 1706298

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-07/1775572035
id: 1706298
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: 1912
schema_scan_id: 161630153
updated: 2026-04-07 09:27:36

Version 1705121

created: 2026-04-06 09:45:08

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-06/1775486700
id: 1705121
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: 1912
schema_scan_id: 161572972
updated: 2026-04-06 09:45:22

Version 1703880

created: 2026-04-05 09:43:07

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-05/1775400180
id: 1703880
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: 1912
schema_scan_id: 161523907
updated: 2026-04-05 09:43:20

Version 1702751

created: 2026-04-04 10:04:24

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-04/1775315060
id: 1702751
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: 1912
schema_scan_id: 161474395
updated: 2026-04-04 10:04:38

Version 1701547

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-03/1775228188
id: 1701547
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: 1912
schema_scan_id: 161415705
updated: 2026-04-03 09:57:54

Schema Scans: 15

Last at 2026-04-17 09:47:50

Scan 162178944

duration: 0:00:11.983932

exit_message:

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

id: 162178944

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-17/1776437254",
        "key": "raw/org_entities/2026-04-17/1776437254/cca54b74-72d8-463a-853b-890ab07987c9.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8176596421895262055,
        "service_name": "drive-thru",
        "span_id": 14574520899555099707,
        "trace_id": 1695082942457166715
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-17 09:47:50
success: True
trace_id: 1695082942457166715

Scan 162122881

duration: 0:00:12.041616

exit_message:

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

id: 162122881

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-16/1776350419",
        "key": "raw/org_entities/2026-04-16/1776350419/b8d33614-d751-4b7b-811d-47bf7adfc836.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1694973915348229458,
        "service_name": "drive-thru",
        "span_id": 12077463345486592566,
        "trace_id": 3917063164821855024
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-16 09:40:32
success: True
trace_id: 3917063164821855024

Scan 162072901

duration: 0:00:14.587439

exit_message:

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

id: 162072901

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-15/1776270840",
        "key": "raw/org_entities/2026-04-15/1776270840/92c394ad-7453-4b55-808e-7ecb394096cb.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12946770051874484918,
        "service_name": "drive-thru",
        "span_id": 5237204953964788025,
        "trace_id": 3260685971331425304
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-15 11:34:13
success: True
trace_id: 3260685971331425304

Scan 162046418

duration: 0:00:14.508504

exit_message:

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

id: 162046418

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-14/1776219225",
        "key": "raw/org_entities/2026-04-14/1776219225/e5e03b58-5d92-4498-bd2d-666e86e6ae99.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16934002203657282261,
        "service_name": "drive-thru",
        "span_id": 880579083330364245,
        "trace_id": 13602536993917386005
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-14 21:13:56
success: True
trace_id: 13602536993917386005

Scan 161954229

duration: 0:00:14.495633

exit_message:

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

id: 161954229

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-13/1776091758",
        "key": "raw/org_entities/2026-04-13/1776091758/29fa890e-ceb8-47e7-b331-686f38b66622.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17389039727360124999,
        "service_name": "drive-thru",
        "span_id": 5445959215958956814,
        "trace_id": 8482900025134034402
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-13 09:50:51
success: True
trace_id: 8482900025134034402

Scan 161903434

duration: 0:00:11.920238

exit_message:

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

id: 161903434

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-12/1776004158",
        "key": "raw/org_entities/2026-04-12/1776004158/a8baa9c2-f008-44fe-a3d4-57abfad2e26f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6182182672334021155,
        "service_name": "drive-thru",
        "span_id": 10279873457536710174,
        "trace_id": 16191557073705355572
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-12 09:29:25
success: True
trace_id: 16191557073705355572

Scan 161852130

duration: 0:00:14.422605

exit_message:

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

id: 161852130

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-11/1775918705",
        "key": "raw/org_entities/2026-04-11/1775918705/7c219032-2bea-43e8-a448-36a3466f97f1.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2607938840538263817,
        "service_name": "drive-thru",
        "span_id": 10340523202593670196,
        "trace_id": 15214906985609359974
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-11 09:45:11
success: True
trace_id: 15214906985609359974

Scan 161797506

duration: 0:00:17.137290

exit_message:

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

id: 161797506

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-10/1775832094",
        "key": "raw/org_entities/2026-04-10/1775832094/fe28551f-4321-4a97-83de-556946bae4fb.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10679982265544056976,
        "service_name": "drive-thru",
        "span_id": 8552855893401867974,
        "trace_id": 16980983754072045336
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-10 09:41:39
success: True
trace_id: 16980983754072045336

Scan 161741325

duration: 0:00:14.527517

exit_message:

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

id: 161741325

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-09/1775744810",
        "key": "raw/org_entities/2026-04-09/1775744810/bae423c5-ac81-4d01-8711-e8f51de773fe.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13541683117379600382,
        "service_name": "drive-thru",
        "span_id": 3166886425371219404,
        "trace_id": 6544264253215573022
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-09 09:26:54
success: True
trace_id: 6544264253215573022

Scan 161686277

duration: 0:00:16.985480

exit_message:

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

id: 161686277

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-08/1775658847",
        "key": "raw/org_entities/2026-04-08/1775658847/8558b1e1-655c-450c-b639-5cbe0aae8e4a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13332570244995101778,
        "service_name": "drive-thru",
        "span_id": 3464437315645264106,
        "trace_id": 10463408306437936617
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-08 09:34:22
success: True
trace_id: 10463408306437936617

Scan 161630153

duration: 0:00:14.493588

exit_message:

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

id: 161630153

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-07/1775572035",
        "key": "raw/org_entities/2026-04-07/1775572035/4e945810-75f9-410f-b8f4-d8f5f7a6407b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10922759913790123256,
        "service_name": "drive-thru",
        "span_id": 2786228362459332768,
        "trace_id": 8190002451373493641
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-07 09:27:22
success: True
trace_id: 8190002451373493641

Scan 161572972

duration: 0:00:14.749566

exit_message:

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

id: 161572972

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-06/1775486700",
        "key": "raw/org_entities/2026-04-06/1775486700/9c048b89-3c2b-48a1-9b88-1fd1a1dbae99.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 801579330043531662,
        "service_name": "drive-thru",
        "span_id": 5070003142784549643,
        "trace_id": 16286119636461943380
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-06 09:45:07
success: True
trace_id: 16286119636461943380

Scan 161523907

duration: 0:00:14.421249

exit_message:

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

id: 161523907

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-05/1775400180",
        "key": "raw/org_entities/2026-04-05/1775400180/6a0707f8-8169-4966-a14f-94c588b4daa9.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8956937944748954162,
        "service_name": "drive-thru",
        "span_id": 12157177559062524536,
        "trace_id": 7162413267257388254
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-05 09:43:06
success: True
trace_id: 7162413267257388254

Scan 161474395

duration: 0:00:14.377094

exit_message:

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

id: 161474395

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-04/1775315060",
        "key": "raw/org_entities/2026-04-04/1775315060/8b2926c4-8c7a-4a58-84ab-028779e8eb71.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17056273158259734215,
        "service_name": "drive-thru",
        "span_id": 16446791582413522985,
        "trace_id": 6583541706405148415
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-04 10:04:23
success: True
trace_id: 6583541706405148415

Scan 161415705

duration: 0:00:14.550106

exit_message:

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

id: 161415705

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/org_entities/2026-04-03/1775228188",
        "key": "raw/org_entities/2026-04-03/1775228188/2f084ba5-3675-4e46-aed6-dcbd25f22f29.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10308620390029202115,
        "service_name": "drive-thru",
        "span_id": 17654818773061867902,
        "trace_id": 8200687454629904069
    }
}

running: False
schema_name_id: 1912
start_time: 2026-04-03 09:57:40
success: True
trace_id: 8200687454629904069

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:47:50

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-10 09:31:55",
        "disabled": false,
        "format": "raw",
        "id": 1912,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:47:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/org_entities/2026-04-17/1776437254'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_org_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_org_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}