Schema Info

Schema Name: sfdl_dev_csv.payrixess_org_entities

created: 2024-07-22 13:08:48
disabled: False
format: raw
id: 2379
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773367

created: 2026-04-17 09:54:44

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-17/1776437662
id: 4773367
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: 2379
schema_scan_id: 6867814
updated: 2026-04-17 09:54:58

Version 4773279

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-16/1776349890
id: 4773279
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: 2379
schema_scan_id: 6867419
updated: 2026-04-16 09:32:17

Version 4773241

created: 2026-04-15 10:04:10

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-15/1776265446
id: 4773241
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: 2379
schema_scan_id: 6867279
updated: 2026-04-15 10:04:21

Version 4773176

created: 2026-04-14 10:02:35

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-14/1776178946
id: 4773176
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: 2379
schema_scan_id: 6866992
updated: 2026-04-14 10:02:46

Version 4773120

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-13/1776091762
id: 4773120
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: 2379
schema_scan_id: 6866707
updated: 2026-04-13 09:49:48

Version 4773070

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-12/1776005295
id: 4773070
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: 2379
schema_scan_id: 6866507
updated: 2026-04-12 09:48:33

Version 4773015

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-11/1775918697
id: 4773015
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: 2379
schema_scan_id: 6866295
updated: 2026-04-11 09:45:18

Version 4772953

created: 2026-04-10 09:43:30

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-10/1775832200
id: 4772953
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: 2379
schema_scan_id: 6866082
updated: 2026-04-10 09:45:08

Version 4772870

created: 2026-04-09 09:29:37

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-09/1775744961
id: 4772870
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: 2379
schema_scan_id: 6865679
updated: 2026-04-09 09:29:51

Version 4772819

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-08/1775658548
id: 4772819
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: 2379
schema_scan_id: 6865454
updated: 2026-04-08 09:29:33

Version 4772749

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-07/1775572021
id: 4772749
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: 2379
schema_scan_id: 6865155
updated: 2026-04-07 09:27:26

Version 4772689

created: 2026-04-06 09:30:34

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-06/1775485787
id: 4772689
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: 2379
schema_scan_id: 6864831
updated: 2026-04-06 09:30:45

Version 4772664

created: 2026-04-05 09:49:08

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-05/1775400520
id: 4772664
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: 2379
schema_scan_id: 6864745
updated: 2026-04-05 09:49:20

Version 4772615

created: 2026-04-04 09:52:34

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-04/1775314347
id: 4772615
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: 2379
schema_scan_id: 6864556
updated: 2026-04-04 09:52:47

Version 4772538

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-03/1775227044
id: 4772538
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: 2379
schema_scan_id: 6864283
updated: 2026-04-03 09:37:49

Schema Scans: 15

Last at 2026-04-17 09:54:43

Scan 6867814

duration: 0:00:14.664491

exit_message:

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

id: 6867814

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-17/1776437662",
        "key": "raw/org_entities/2026-04-17/1776437662/b519f3a3-50e3-4010-87f5-23258dea5554.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10491918015539861412,
        "service_name": "drive-thru",
        "span_id": 4090015184696060886,
        "trace_id": 6537214445249298932
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-17 09:54:43
success: True
trace_id: 6537214445249298932

Scan 6867419

duration: 0:00:14.662583

exit_message:

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

id: 6867419

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-16/1776349890",
        "key": "raw/org_entities/2026-04-16/1776349890/ab797a03-79fa-49bd-86d6-e0a26f87b34c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13112904079769577734,
        "service_name": "drive-thru",
        "span_id": 8636929303243399455,
        "trace_id": 10921068842723244610
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-16 09:32:03
success: True
trace_id: 10921068842723244610

Scan 6867279

duration: 0:00:11.846252

exit_message:

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

id: 6867279

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-15/1776265446",
        "key": "raw/org_entities/2026-04-15/1776265446/1a4bc0d9-a036-4d04-8893-58791a96deaa.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12583119139715661289,
        "service_name": "drive-thru",
        "span_id": 7524765041676499337,
        "trace_id": 11684365653890999641
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-15 10:04:10
success: True
trace_id: 11684365653890999641

Scan 6866992

duration: 0:00:11.972329

exit_message:

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

id: 6866992

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-14/1776178946",
        "key": "raw/org_entities/2026-04-14/1776178946/d858e9c2-36c8-423f-90fb-e273ef1687fd.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6210858914336739283,
        "service_name": "drive-thru",
        "span_id": 3087979160823145774,
        "trace_id": 10853351510806708227
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-14 10:02:34
success: True
trace_id: 10853351510806708227

Scan 6866707

duration: 0:00:14.381827

exit_message:

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

id: 6866707

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-13/1776091762",
        "key": "raw/org_entities/2026-04-13/1776091762/3601f327-5a37-4b9a-8c3f-4f87bf3b1345.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6943421236793182700,
        "service_name": "drive-thru",
        "span_id": 12884263966806164959,
        "trace_id": 12960098039767046435
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-13 09:49:34
success: True
trace_id: 12960098039767046435

Scan 6866507

duration: 0:00:14.483495

exit_message:

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

id: 6866507

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-12/1776005295",
        "key": "raw/org_entities/2026-04-12/1776005295/766097d5-d3d4-4b03-9753-f95524d28161.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14472692673948919089,
        "service_name": "drive-thru",
        "span_id": 16096754682303650184,
        "trace_id": 1982990960339740147
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-12 09:48:19
success: True
trace_id: 1982990960339740147

Scan 6866295

duration: 0:00:11.769313

exit_message:

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

id: 6866295

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-11/1775918697",
        "key": "raw/org_entities/2026-04-11/1775918697/36e331cd-e1e3-4956-bad8-7a31f209030b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7474172435221604831,
        "service_name": "drive-thru",
        "span_id": 9668153228561473881,
        "trace_id": 638727631137807254
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-11 09:45:06
success: True
trace_id: 638727631137807254

Scan 6866082

duration: 0:01:38.565056

exit_message:

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

id: 6866082

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-10/1775832200",
        "key": "raw/org_entities/2026-04-10/1775832200/0179df5f-cb75-4f6c-8362-c25439cb19bf.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2688577017676301755,
        "service_name": "drive-thru",
        "span_id": 13263880055452014583,
        "trace_id": 15663892475312306799
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-10 09:43:29
success: True
trace_id: 15663892475312306799

Scan 6865679

duration: 0:00:14.599315

exit_message:

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

id: 6865679

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-09/1775744961",
        "key": "raw/org_entities/2026-04-09/1775744961/caf9f7f6-28e5-4a7b-b385-e353ca55eb0e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5602226575274601545,
        "service_name": "drive-thru",
        "span_id": 5342077451717654749,
        "trace_id": 15412027408802012720
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-09 09:29:36
success: True
trace_id: 15412027408802012720

Scan 6865454

duration: 0:00:14.472661

exit_message:

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

id: 6865454

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-08/1775658548",
        "key": "raw/org_entities/2026-04-08/1775658548/9bb16381-8331-4f01-b86c-24a93f3e6741.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2063128789976657469,
        "service_name": "drive-thru",
        "span_id": 8499717817721765333,
        "trace_id": 2755482880412922178
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-08 09:29:19
success: True
trace_id: 2755482880412922178

Scan 6865155

duration: 0:00:14.782966

exit_message:

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

id: 6865155

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-07/1775572021",
        "key": "raw/org_entities/2026-04-07/1775572021/5f246f14-886e-4a39-8882-04b09a2afb81.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4786395910045559391,
        "service_name": "drive-thru",
        "span_id": 13015902345770500787,
        "trace_id": 5653303326329815581
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-07 09:27:11
success: True
trace_id: 5653303326329815581

Scan 6864831

duration: 0:00:11.874702

exit_message:

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

id: 6864831

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-06/1775485787",
        "key": "raw/org_entities/2026-04-06/1775485787/224fcb41-aeb3-4564-a1e3-bd67390001d3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1716395065595345626,
        "service_name": "drive-thru",
        "span_id": 12250589115242319932,
        "trace_id": 6576918133179375272
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-06 09:30:34
success: True
trace_id: 6576918133179375272

Scan 6864745

duration: 0:00:11.956743

exit_message:

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

id: 6864745

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-05/1775400520",
        "key": "raw/org_entities/2026-04-05/1775400520/a56c0d35-580c-4e3c-92c4-b34011677f87.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2089460279419858657,
        "service_name": "drive-thru",
        "span_id": 2087766666961053847,
        "trace_id": 13582345127675543072
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-05 09:49:08
success: True
trace_id: 13582345127675543072

Scan 6864556

duration: 0:00:14.364228

exit_message:

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

id: 6864556

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-04/1775314347",
        "key": "raw/org_entities/2026-04-04/1775314347/71ec7409-de1f-4d45-be77-6663cf67c9ec.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7128597572621983665,
        "service_name": "drive-thru",
        "span_id": 11361649378885149272,
        "trace_id": 1618694396126997370
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-04 09:52:33
success: True
trace_id: 1618694396126997370

Scan 6864283

duration: 0:00:14.655591

exit_message:

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

id: 6864283

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/org_entities/2026-04-03/1775227044",
        "key": "raw/org_entities/2026-04-03/1775227044/dbcd5885-ce2d-49e5-979b-ce22052f83c2.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_org_entities",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12600662616710223719,
        "service_name": "drive-thru",
        "span_id": 975265357922984072,
        "trace_id": 17536309919960353816
    }
}

running: False
schema_name_id: 2379
start_time: 2026-04-03 09:37:35
success: True
trace_id: 17536309919960353816

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:54:44

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-22 13:08:48",
        "disabled": false,
        "format": "raw",
        "id": 2379,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_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:54:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/org_entities/2026-04-17/1776437662'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_org_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_org_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}