Schema Info

Schema Name: sfdl_prod_csv.payrixess_orgs

created: 2024-07-24 10:29:27
disabled: False
format: raw
id: 1974
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718279

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-17/1776437361
id: 1718279
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: 1974
schema_scan_id: 162179111
updated: 2026-04-17 09:50:16

Version 1717053

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-16/1776350732
id: 1717053
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: 1974
schema_scan_id: 162122944
updated: 2026-04-16 09:45:55

Version 1715840

created: 2026-04-15 09:47:07

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-15/1776264414
id: 1715840
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: 1974
schema_scan_id: 162067488
updated: 2026-04-15 09:47:18

Version 1714613

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-14/1776176885
id: 1714613
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: 1974
schema_scan_id: 162011121
updated: 2026-04-14 09:28:25

Version 1713445

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-13/1776091808
id: 1713445
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: 1974
schema_scan_id: 161954375
updated: 2026-04-13 09:52:40

Version 1712244

created: 2026-04-12 09:43:52

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-12/1776005014
id: 1712244
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: 1974
schema_scan_id: 161903635
updated: 2026-04-12 09:44:03

Version 1711013

created: 2026-04-11 09:28:21

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-11/1775917693
id: 1711013
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: 1974
schema_scan_id: 161851991
updated: 2026-04-11 09:28:32

Version 1709868

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-10/1775832352
id: 1709868
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: 1974
schema_scan_id: 161797640
updated: 2026-04-10 09:47:32

Version 1708710

created: 2026-04-09 09:47:43

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-09/1775746054
id: 1708710
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: 1974
schema_scan_id: 161741738
updated: 2026-04-09 09:47:54

Version 1707544

created: 2026-04-08 09:54:00

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-08/1775659830
id: 1707544
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: 1974
schema_scan_id: 161687299
updated: 2026-04-08 09:54:14

Version 1706302

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-07/1775572099
id: 1706302
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: 1974
schema_scan_id: 161630200
updated: 2026-04-07 09:28:34

Version 1705101

created: 2026-04-06 09:41:37

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-06/1775486486
id: 1705101
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: 1974
schema_scan_id: 161572912
updated: 2026-04-06 09:41:49

Version 1703857

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-05/1775399359
id: 1703857
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: 1974
schema_scan_id: 161523770
updated: 2026-04-05 09:29:38

Version 1702705

created: 2026-04-04 09:27:31

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-04/1775312847
id: 1702705
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: 1974
schema_scan_id: 161471636
updated: 2026-04-04 09:27:44

Version 1701514

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-03/1775226540
id: 1701514
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: 1974
schema_scan_id: 161414311
updated: 2026-04-03 09:29:20

Schema Scans: 15

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

Scan 162179111

duration: 0:00:14.723751

exit_message:

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

id: 162179111

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-17/1776437361",
        "key": "raw/orgs/2026-04-17/1776437361/d31e06e7-f3b1-4f31-841c-057101ee3dee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9290840815744044791,
        "service_name": "drive-thru",
        "span_id": 336187671106867113,
        "trace_id": 10076167683226495276
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-17 09:50:01
success: True
trace_id: 10076167683226495276

Scan 162122944

duration: 0:00:12.031320

exit_message:

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

id: 162122944

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-16/1776350732",
        "key": "raw/orgs/2026-04-16/1776350732/1eb9f3a7-3d07-4255-9921-66d3c5b8e375.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7577433670621236235,
        "service_name": "drive-thru",
        "span_id": 2102622145445100919,
        "trace_id": 8104826718951533421
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-16 09:45:43
success: True
trace_id: 8104826718951533421

Scan 162067488

duration: 0:00:11.821841

exit_message:

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

id: 162067488

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-15/1776264414",
        "key": "raw/orgs/2026-04-15/1776264414/08c0fc1a-ee28-4f05-b7d8-d4a9d02ca55b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7241626579415861193,
        "service_name": "drive-thru",
        "span_id": 939658109212254383,
        "trace_id": 16262169913489532073
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-15 09:47:07
success: True
trace_id: 16262169913489532073

Scan 162011121

duration: 0:00:14.602026

exit_message:

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

id: 162011121

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-14/1776176885",
        "key": "raw/orgs/2026-04-14/1776176885/24bff005-8259-40e7-897d-acf53100f436.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2675108422785648957,
        "service_name": "drive-thru",
        "span_id": 4273750557897303330,
        "trace_id": 16578683305667967803
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-14 09:28:10
success: True
trace_id: 16578683305667967803

Scan 161954375

duration: 0:00:14.493210

exit_message:

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

id: 161954375

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-13/1776091808",
        "key": "raw/orgs/2026-04-13/1776091808/36dbddb3-c512-43db-a9c9-07c1f7a8bb66.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12902594024117961792,
        "service_name": "drive-thru",
        "span_id": 16970241160254992050,
        "trace_id": 16039466050855706501
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-13 09:52:25
success: True
trace_id: 16039466050855706501

Scan 161903635

duration: 0:00:11.847654

exit_message:

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

id: 161903635

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-12/1776005014",
        "key": "raw/orgs/2026-04-12/1776005014/e6c93ee9-66c8-4915-9d29-6de4860e2297.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4476824430454925088,
        "service_name": "drive-thru",
        "span_id": 15015458095661417120,
        "trace_id": 1188097534255914792
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-12 09:43:51
success: True
trace_id: 1188097534255914792

Scan 161851991

duration: 0:00:11.794454

exit_message:

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

id: 161851991

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-11/1775917693",
        "key": "raw/orgs/2026-04-11/1775917693/8b407b7f-ce15-47ca-9d93-6fb943264104.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3865154252803160625,
        "service_name": "drive-thru",
        "span_id": 4317180919156367127,
        "trace_id": 15792992447667592476
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-11 09:28:20
success: True
trace_id: 15792992447667592476

Scan 161797640

duration: 0:00:14.496158

exit_message:

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

id: 161797640

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-10/1775832352",
        "key": "raw/orgs/2026-04-10/1775832352/ddf14264-7b1d-4db1-8d87-beedb6c61472.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17752326268075945540,
        "service_name": "drive-thru",
        "span_id": 4925855357359681078,
        "trace_id": 7260335325844274194
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-10 09:47:17
success: True
trace_id: 7260335325844274194

Scan 161741738

duration: 0:00:11.976087

exit_message:

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

id: 161741738

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-09/1775746054",
        "key": "raw/orgs/2026-04-09/1775746054/8df3ddce-9f0e-4538-88a0-3e32e74b0d49.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8320641492880196163,
        "service_name": "drive-thru",
        "span_id": 12165913340091342375,
        "trace_id": 368410320546045046
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-09 09:47:42
success: True
trace_id: 368410320546045046

Scan 161687299

duration: 0:00:14.765832

exit_message:

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

id: 161687299

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-08/1775659830",
        "key": "raw/orgs/2026-04-08/1775659830/4df3c5d0-f4e3-41bc-b60c-a4fc3e26309d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4730957856642969312,
        "service_name": "drive-thru",
        "span_id": 8178202195075028368,
        "trace_id": 585937235503636987
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-08 09:53:59
success: True
trace_id: 585937235503636987

Scan 161630200

duration: 0:00:11.992509

exit_message:

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

id: 161630200

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-07/1775572099",
        "key": "raw/orgs/2026-04-07/1775572099/8ca52ed1-d9b5-4f03-998f-ca4d65ac3d16.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8825934102416052368,
        "service_name": "drive-thru",
        "span_id": 12670781848667685848,
        "trace_id": 7198729667072536944
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-07 09:28:22
success: True
trace_id: 7198729667072536944

Scan 161572912

duration: 0:00:11.885379

exit_message:

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

id: 161572912

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-06/1775486486",
        "key": "raw/orgs/2026-04-06/1775486486/7c5c893e-1fc0-4281-a0a8-e152d218e904.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1871846693944607763,
        "service_name": "drive-thru",
        "span_id": 17949678550620158989,
        "trace_id": 11668307625534383120
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-06 09:41:37
success: True
trace_id: 11668307625534383120

Scan 161523770

duration: 0:00:11.808024

exit_message:

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

id: 161523770

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-05/1775399359",
        "key": "raw/orgs/2026-04-05/1775399359/c1ba3e44-9d6a-456e-b8d9-b71cc6eb1bb6.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6665969888565539735,
        "service_name": "drive-thru",
        "span_id": 16725156183905639590,
        "trace_id": 1399130831217976693
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-05 09:29:26
success: True
trace_id: 1399130831217976693

Scan 161471636

duration: 0:00:14.364945

exit_message:

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

id: 161471636

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-04/1775312847",
        "key": "raw/orgs/2026-04-04/1775312847/d4d601db-1737-40ad-a65e-20307dbdf5a4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13447603932019881541,
        "service_name": "drive-thru",
        "span_id": 5275612443325713927,
        "trace_id": 13414132571209002930
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-04 09:27:30
success: True
trace_id: 13414132571209002930

Scan 161414311

duration: 0:00:14.495994

exit_message:

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

id: 161414311

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/orgs/2026-04-03/1775226540",
        "key": "raw/orgs/2026-04-03/1775226540/fce50866-b5ec-4f0a-93d9-447a3c58ce89.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14626576558251196996,
        "service_name": "drive-thru",
        "span_id": 9515229923144862861,
        "trace_id": 17810123734391485981
    }
}

running: False
schema_name_id: 1974
start_time: 2026-04-03 09:29:06
success: True
trace_id: 17810123734391485981

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:02

ddl:

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

Server:

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

Raw:

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