Schema Info

Schema Name: sfdl_dev_csv.payrixess_orgs

created: 2024-07-22 12:58:59
disabled: False
format: raw
id: 2352
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773362

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-17/1776437409'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-17/1776437409
id: 4773362
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6867776
updated: 2026-04-17 09:50:24

Version 4773295

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-16/1776350383'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-16/1776350383
id: 4773295
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6867531
updated: 2026-04-16 09:40:14

Version 4773246

created: 2026-04-15 10:05:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-15/1776265536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-15/1776265536
id: 4773246
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6867286
updated: 2026-04-15 10:05:51

Version 4773151

created: 2026-04-14 09:40:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-14/1776177620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-14/1776177620
id: 4773151
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6866876
updated: 2026-04-14 09:40:49

Version 4773122

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-13/1776091766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-13/1776091766
id: 4773122
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6866711
updated: 2026-04-13 09:50:04

Version 4773060

created: 2026-04-12 09:46:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-12/1776005200'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-12/1776005200
id: 4773060
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6866493
updated: 2026-04-12 09:47:04

Version 4773021

created: 2026-04-11 09:47:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-11/1775918818'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-11/1775918818
id: 4773021
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6866326
updated: 2026-04-11 09:47:28

Version 4772963

created: 2026-04-10 09:47:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-10/1775832400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-10/1775832400
id: 4772963
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6866096
updated: 2026-04-10 09:47:17

Version 4772904

created: 2026-04-09 09:51:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-09/1775746276'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-09/1775746276
id: 4772904
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6865825
updated: 2026-04-09 09:51:46

Version 4772815

created: 2026-04-08 09:27:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-08/1775658439'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-08/1775658439
id: 4772815
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6865433
updated: 2026-04-08 09:28:07

Version 4772748

created: 2026-04-07 09:26:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-07/1775572016'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-07/1775572016
id: 4772748
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6865151
updated: 2026-04-07 09:27:11

Version 4772714

created: 2026-04-06 09:46:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-06/1775486785'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-06/1775486785
id: 4772714
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6864940
updated: 2026-04-06 09:46:54

Version 4772639

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-05/1775399267'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-05/1775399267
id: 4772639
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6864628
updated: 2026-04-05 09:28:18

Version 4772586

created: 2026-04-04 09:25:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-04/1775312752'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-04/1775312752
id: 4772586
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6864450
updated: 2026-04-04 09:26:13

Version 4772542

created: 2026-04-03 09:47:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-03/1775227634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/orgs/2026-04-03/1775227634
id: 4772542
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": 6,
    "creator": 5,
    "description": 10,
    "login_id": 12,
    "modified": 9,
    "modifier": 7,
    "name": 8,
    "org_id": 11
}

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

schema_name_id: 2352
schema_scan_id: 6864310
updated: 2026-04-03 09:48:03

Schema Scans: 15

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

Scan 6867776

duration: 0:00:12.044383

exit_message:

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

id: 6867776

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/orgs/2026-04-17/1776437409",
        "key": "raw/orgs/2026-04-17/1776437409/e1b33b91-0c00-41ae-941f-496171cda298.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18197691415167893390,
        "service_name": "drive-thru",
        "span_id": 2132737910055703617,
        "trace_id": 15219983494134756527
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-17 09:50:12
success: True
trace_id: 15219983494134756527

Scan 6867531

duration: 0:00:14.648128

exit_message:

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

id: 6867531

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/orgs/2026-04-16/1776350383",
        "key": "raw/orgs/2026-04-16/1776350383/ee9cc374-97c4-4a97-8db9-0556fb8183c4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12583227320335448863,
        "service_name": "drive-thru",
        "span_id": 13381507393062034877,
        "trace_id": 14467927915187037354
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-16 09:40:00
success: True
trace_id: 14467927915187037354

Scan 6867286

duration: 0:00:12.071676

exit_message:

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

id: 6867286

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/orgs/2026-04-15/1776265536",
        "key": "raw/orgs/2026-04-15/1776265536/bb34aeda-8be8-4b91-9be7-47436f9906f3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12888383111298636982,
        "service_name": "drive-thru",
        "span_id": 4244858677775564499,
        "trace_id": 8902082417891886601
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-15 10:05:39
success: True
trace_id: 8902082417891886601

Scan 6866876

duration: 0:00:12.014271

exit_message:

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

id: 6866876

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/orgs/2026-04-14/1776177620",
        "key": "raw/orgs/2026-04-14/1776177620/bc568918-cf08-43f5-af84-65ab6021d7a4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1790115047360361943,
        "service_name": "drive-thru",
        "span_id": 8231113475524082675,
        "trace_id": 3493779475173385383
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-14 09:40:37
success: True
trace_id: 3493779475173385383

Scan 6866711

duration: 0:00:12.022928

exit_message:

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

id: 6866711

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/orgs/2026-04-13/1776091766",
        "key": "raw/orgs/2026-04-13/1776091766/7af3970c-93bc-4dab-a54e-53b2c1a5cf49.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5313342318700920458,
        "service_name": "drive-thru",
        "span_id": 2503238664147664347,
        "trace_id": 13441783450102765503
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-13 09:49:52
success: True
trace_id: 13441783450102765503

Scan 6866493

duration: 0:00:11.962814

exit_message:

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

id: 6866493

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/orgs/2026-04-12/1776005200",
        "key": "raw/orgs/2026-04-12/1776005200/cb288f50-13be-47eb-81b0-5ecb16e5f85b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6338909193747657611,
        "service_name": "drive-thru",
        "span_id": 9497444905651925930,
        "trace_id": 16158111736262776893
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-12 09:46:52
success: True
trace_id: 16158111736262776893

Scan 6866326

duration: 0:00:14.555274

exit_message:

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

id: 6866326

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/orgs/2026-04-11/1775918818",
        "key": "raw/orgs/2026-04-11/1775918818/2da4b353-1789-464e-9a4d-6e9ab013b171.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7979029998698894393,
        "service_name": "drive-thru",
        "span_id": 17370622920110577183,
        "trace_id": 8401861942599984524
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-11 09:47:13
success: True
trace_id: 8401861942599984524

Scan 6866096

duration: 0:00:14.554012

exit_message:

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

id: 6866096

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/orgs/2026-04-10/1775832400",
        "key": "raw/orgs/2026-04-10/1775832400/31618d41-ea47-480b-b36a-ae9e54f390e9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16945639622126019062,
        "service_name": "drive-thru",
        "span_id": 13476645298507809105,
        "trace_id": 6801531800179274395
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-10 09:47:03
success: True
trace_id: 6801531800179274395

Scan 6865825

duration: 0:00:12.078840

exit_message:

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

id: 6865825

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/orgs/2026-04-09/1775746276",
        "key": "raw/orgs/2026-04-09/1775746276/dc17a810-f693-4b64-b1ce-61f4b4d77a91.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17225296790310348248,
        "service_name": "drive-thru",
        "span_id": 8110900186421552759,
        "trace_id": 124519219367757430
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-09 09:51:34
success: True
trace_id: 124519219367757430

Scan 6865433

duration: 0:00:14.536232

exit_message:

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

id: 6865433

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/orgs/2026-04-08/1775658439",
        "key": "raw/orgs/2026-04-08/1775658439/25da4d9d-b091-42d3-99f8-ea5b5f401275.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5855882934569680333,
        "service_name": "drive-thru",
        "span_id": 17636425977025606698,
        "trace_id": 1770607581734564646
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-08 09:27:52
success: True
trace_id: 1770607581734564646

Scan 6865151

duration: 0:00:12.099762

exit_message:

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

id: 6865151

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/orgs/2026-04-07/1775572016",
        "key": "raw/orgs/2026-04-07/1775572016/dffe4a2e-2882-41e1-aba0-cfd5ab84953d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5736790173528158876,
        "service_name": "drive-thru",
        "span_id": 11176519534146098179,
        "trace_id": 4674792344036612074
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-07 09:26:59
success: True
trace_id: 4674792344036612074

Scan 6864940

duration: 0:00:22.092413

exit_message:

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

id: 6864940

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/orgs/2026-04-06/1775486785",
        "key": "raw/orgs/2026-04-06/1775486785/52a8dc72-7b56-4c02-93a0-ee5861663ab5.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1201989760913558720,
        "service_name": "drive-thru",
        "span_id": 2938046401974135055,
        "trace_id": 13950984494984510158
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-06 09:46:32
success: True
trace_id: 13950984494984510158

Scan 6864628

duration: 0:00:12.141167

exit_message:

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

id: 6864628

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/orgs/2026-04-05/1775399267",
        "key": "raw/orgs/2026-04-05/1775399267/1c80b4dc-458b-4e45-a830-17b0946c97c6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11120180981621889729,
        "service_name": "drive-thru",
        "span_id": 4364775960556401295,
        "trace_id": 14057722405757582550
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-05 09:28:06
success: True
trace_id: 14057722405757582550

Scan 6864450

duration: 0:00:14.565302

exit_message:

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

id: 6864450

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/orgs/2026-04-04/1775312752",
        "key": "raw/orgs/2026-04-04/1775312752/433fd946-61de-4758-911f-e8167a249512.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 648671938706430821,
        "service_name": "drive-thru",
        "span_id": 2731003082467115155,
        "trace_id": 12419430545564915167
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-04 09:25:58
success: True
trace_id: 12419430545564915167

Scan 6864310

duration: 0:00:11.999982

exit_message:

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

id: 6864310

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/orgs/2026-04-03/1775227634",
        "key": "raw/orgs/2026-04-03/1775227634/ba8fe0d2-da45-4cae-8aae-367b6a8728d2.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14049294892723922767,
        "service_name": "drive-thru",
        "span_id": 18370070794284980516,
        "trace_id": 17201083350209492194
    }
}

running: False
schema_name_id: 2352
start_time: 2026-04-03 09:47:51
success: True
trace_id: 17201083350209492194

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",
    "description": "string",
    "login_id": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string"
}

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

ddl:

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

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 12:58:59",
        "disabled": false,
        "format": "raw",
        "id": 2352,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_orgs"
        },
        "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",
            "description": "string",
            "login_id": "string",
            "modified": "string",
            "modifier": "string",
            "name": "string",
            "org_id": "string"
        },
        "created": "2026-04-17 09:50:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_orgs`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `name`  string , `modified`  string , `description`  string , `org_id`  string , `login_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/orgs/2026-04-17/1776437409'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_orgs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_orgs"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}