Schema Info

Schema Name: sfdl_dev_csv.payrix_orgs

created: 2024-07-03 14:01:48
disabled: False
format: raw
id: 2311
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773333

created: 2026-04-17 09:27:30

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-17/1776436031
id: 4773333
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: 2311
schema_scan_id: 6867663
updated: 2026-04-17 09:27:44

Version 4773304

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-16/1776351155
id: 4773304
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: 2311
schema_scan_id: 6867546
updated: 2026-04-16 09:52:54

Version 4773236

created: 2026-04-15 10:00:11

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-15/1776265194
id: 4773236
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: 2311
schema_scan_id: 6867249
updated: 2026-04-15 10:00:24

Version 4773182

created: 2026-04-14 10:04:09

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-14/1776179028
id: 4773182
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: 2311
schema_scan_id: 6867008
updated: 2026-04-14 10:04:20

Version 4773116

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-13/1776091587
id: 4773116
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: 2311
schema_scan_id: 6866692
updated: 2026-04-13 09:47:00

Version 4773064

created: 2026-04-12 09:47:39

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-12/1776005251
id: 4773064
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: 2311
schema_scan_id: 6866498
updated: 2026-04-12 09:47:50

Version 4772989

created: 2026-04-11 09:27:30

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-11/1775917625
id: 4772989
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: 2311
schema_scan_id: 6866202
updated: 2026-04-11 09:27:41

Version 4772951

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-10/1775831992
id: 4772951
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: 2311
schema_scan_id: 6866070
updated: 2026-04-10 09:40:14

Version 4772898

created: 2026-04-09 09:50:19

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-09/1775746206
id: 4772898
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: 2311
schema_scan_id: 6865818
updated: 2026-04-09 09:50:33

Version 4772830

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-08/1775659273
id: 4772830
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: 2311
schema_scan_id: 6865510
updated: 2026-04-08 09:41:44

Version 4772757

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-07/1775572178
id: 4772757
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: 2311
schema_scan_id: 6865202
updated: 2026-04-07 09:29:57

Version 4772719

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-06/1775486968
id: 4772719
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: 2311
schema_scan_id: 6864966
updated: 2026-04-06 09:50:19

Version 4772654

created: 2026-04-05 09:47:30

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-05/1775400444
id: 4772654
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: 2311
schema_scan_id: 6864726
updated: 2026-04-05 09:47:43

Version 4772596

created: 2026-04-04 09:30:57

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-04/1775313029
id: 4772596
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: 2311
schema_scan_id: 6864474
updated: 2026-04-04 09:31:08

Version 4772559

created: 2026-04-03 10:00:52

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-03/1775228441
id: 4772559
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: 2311
schema_scan_id: 6864348
updated: 2026-04-03 10:01:06

Schema Scans: 15

Last at 2026-04-17 09:27:29

Scan 6867663

duration: 0:00:14.472288

exit_message:

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

id: 6867663

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-17/1776436031",
        "key": "raw/orgs/2026-04-17/1776436031/e1a9fdae-e33f-4d0d-a260-d1cbc8a81280.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15461931269309829758,
        "service_name": "drive-thru",
        "span_id": 11074630397992483373,
        "trace_id": 5480354490232290157
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-17 09:27:29
success: True
trace_id: 5480354490232290157

Scan 6867546

duration: 0:00:12.087953

exit_message:

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

id: 6867546

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-16/1776351155",
        "key": "raw/orgs/2026-04-16/1776351155/808d6c55-175d-4ced-bdd3-04f0348e319d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12658817057391630429,
        "service_name": "drive-thru",
        "span_id": 56952956312433671,
        "trace_id": 2566752867381555714
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-16 09:52:42
success: True
trace_id: 2566752867381555714

Scan 6867249

duration: 0:00:14.670755

exit_message:

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

id: 6867249

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-15/1776265194",
        "key": "raw/orgs/2026-04-15/1776265194/e011a397-db62-4df9-93a0-a303254a3043.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13429825697149573687,
        "service_name": "drive-thru",
        "span_id": 628073540563360218,
        "trace_id": 4326674676932136653
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-15 10:00:10
success: True
trace_id: 4326674676932136653

Scan 6867008

duration: 0:00:12.044787

exit_message:

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

id: 6867008

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-14/1776179028",
        "key": "raw/orgs/2026-04-14/1776179028/ec97819a-c97e-4eea-8acc-16237e352781.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1542083630743364487,
        "service_name": "drive-thru",
        "span_id": 2184854479932293818,
        "trace_id": 12594333178095400857
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-14 10:04:08
success: True
trace_id: 12594333178095400857

Scan 6866692

duration: 0:00:12.106666

exit_message:

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

id: 6866692

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-13/1776091587",
        "key": "raw/orgs/2026-04-13/1776091587/fc02da8c-cd2b-4d14-91da-6b0cbde388b3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 691858484952464744,
        "service_name": "drive-thru",
        "span_id": 2967827171604338337,
        "trace_id": 501376605461459916
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-13 09:46:48
success: True
trace_id: 501376605461459916

Scan 6866498

duration: 0:00:11.842586

exit_message:

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

id: 6866498

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-12/1776005251",
        "key": "raw/orgs/2026-04-12/1776005251/988bedcc-3191-4119-b05f-2d542142d3f4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3504782069467790457,
        "service_name": "drive-thru",
        "span_id": 6954451692760811014,
        "trace_id": 8420437013077660443
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-12 09:47:38
success: True
trace_id: 8420437013077660443

Scan 6866202

duration: 0:00:11.889293

exit_message:

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

id: 6866202

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-11/1775917625",
        "key": "raw/orgs/2026-04-11/1775917625/19146f24-751b-4498-8cb9-0c5a813684a3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6647570042568901780,
        "service_name": "drive-thru",
        "span_id": 10254758219729977752,
        "trace_id": 4851083220622431289
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-11 09:27:29
success: True
trace_id: 4851083220622431289

Scan 6866070

duration: 0:00:14.479776

exit_message:

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

id: 6866070

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-10/1775831992",
        "key": "raw/orgs/2026-04-10/1775831992/4365cdc7-e008-4f83-b98f-1d2bbb9516a1.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2587741560757737368,
        "service_name": "drive-thru",
        "span_id": 4973055116882991797,
        "trace_id": 9640857433009229877
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-10 09:39:59
success: True
trace_id: 9640857433009229877

Scan 6865818

duration: 0:00:14.730290

exit_message:

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

id: 6865818

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-09/1775746206",
        "key": "raw/orgs/2026-04-09/1775746206/f9976328-dfc8-4c3d-81d4-f4be1aa78b0e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8427594039704733034,
        "service_name": "drive-thru",
        "span_id": 5119381884492573131,
        "trace_id": 7475447149428611907
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-09 09:50:18
success: True
trace_id: 7475447149428611907

Scan 6865510

duration: 0:00:17.099397

exit_message:

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

id: 6865510

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-08/1775659273",
        "key": "raw/orgs/2026-04-08/1775659273/2d0b2f17-1cd5-46b3-8750-380819328eb4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4487391835356090024,
        "service_name": "drive-thru",
        "span_id": 12392285289906416123,
        "trace_id": 859162670617345303
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-08 09:41:27
success: True
trace_id: 859162670617345303

Scan 6865202

duration: 0:00:14.490282

exit_message:

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

id: 6865202

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-07/1775572178",
        "key": "raw/orgs/2026-04-07/1775572178/8a52c213-2918-423d-80ba-a341a470efdd.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6496334296470681602,
        "service_name": "drive-thru",
        "span_id": 6084480668089473067,
        "trace_id": 11794067480072079271
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-07 09:29:43
success: True
trace_id: 11794067480072079271

Scan 6864966

duration: 0:00:14.504918

exit_message:

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

id: 6864966

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-06/1775486968",
        "key": "raw/orgs/2026-04-06/1775486968/e0fc4815-b7be-4356-b4a1-6e9874edba32.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8576920684444976719,
        "service_name": "drive-thru",
        "span_id": 2659328061888590569,
        "trace_id": 3593744663158927729
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-06 09:50:05
success: True
trace_id: 3593744663158927729

Scan 6864726

duration: 0:00:14.414025

exit_message:

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

id: 6864726

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-05/1775400444",
        "key": "raw/orgs/2026-04-05/1775400444/80925bc8-9b65-4f81-b793-6aebed12f487.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4829639774653009893,
        "service_name": "drive-thru",
        "span_id": 6221528454381660874,
        "trace_id": 10738418840067707322
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-05 09:47:29
success: True
trace_id: 10738418840067707322

Scan 6864474

duration: 0:00:12.026921

exit_message:

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

id: 6864474

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-04/1775313029",
        "key": "raw/orgs/2026-04-04/1775313029/01b2d483-cc03-4fb8-84ce-679d56abb7bb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6948280376019377712,
        "service_name": "drive-thru",
        "span_id": 18304383763876585387,
        "trace_id": 9294647310303436927
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-04 09:30:56
success: True
trace_id: 9294647310303436927

Scan 6864348

duration: 0:00:14.615279

exit_message:

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

id: 6864348

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/orgs/2026-04-03/1775228441",
        "key": "raw/orgs/2026-04-03/1775228441/f0326020-1f1a-4140-86f9-05ad982e6030.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9136131146165808801,
        "service_name": "drive-thru",
        "span_id": 2524712963061233303,
        "trace_id": 5831538898905323439
    }
}

running: False
schema_name_id: 2311
start_time: 2026-04-03 10:00:52
success: True
trace_id: 5831538898905323439

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:27:30

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_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-payrix-dev/raw/orgs/2026-04-17/1776436031'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_orgs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_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-03 14:01:48",
        "disabled": false,
        "format": "raw",
        "id": 2311,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_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:27:30",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_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-payrix-dev/raw/orgs/2026-04-17/1776436031'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_orgs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_orgs"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}