Schema Info

Schema Name: sfdl_stage_csv.payrixess_orgs

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

name:

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

type: csv

Schema Versions: 15

Version 906707

created: 2026-04-17 09:39:15

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-17/1776436733
id: 906707
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: 2157
schema_scan_id: 6415460
updated: 2026-04-17 09:39:26

Version 906494

created: 2026-04-16 09:46:20

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-16/1776350752
id: 906494
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: 2157
schema_scan_id: 6414939
updated: 2026-04-16 09:46:31

Version 906254

created: 2026-04-15 09:26:49

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-15/1776263191
id: 906254
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: 2157
schema_scan_id: 6414289
updated: 2026-04-15 09:27:03

Version 906074

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-14/1776178032
id: 906074
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: 2157
schema_scan_id: 6413945
updated: 2026-04-14 09:47:29

Version 905860

created: 2026-04-13 09:47:51

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-13/1776091651
id: 905860
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: 2157
schema_scan_id: 6413390
updated: 2026-04-13 09:48:05

Version 905631

created: 2026-04-12 09:30:00

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-12/1776004196
id: 905631
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: 2157
schema_scan_id: 6412870
updated: 2026-04-12 09:30:11

Version 905422

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-11/1775917596
id: 905422
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: 2157
schema_scan_id: 6412452
updated: 2026-04-11 09:26:59

Version 905208

created: 2026-04-10 09:26:54

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-10/1775831210
id: 905208
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: 2157
schema_scan_id: 6411998
updated: 2026-04-10 09:27:07

Version 905025

created: 2026-04-09 09:48:23

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-09/1775746080
id: 905025
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: 2157
schema_scan_id: 6411599
updated: 2026-04-09 09:48:37

Version 904810

created: 2026-04-08 09:44:30

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-08/1775659399
id: 904810
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: 2157
schema_scan_id: 6411102
updated: 2026-04-08 09:44:41

Version 904588

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-07/1775572797
id: 904588
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: 2157
schema_scan_id: 6410553
updated: 2026-04-07 09:40:47

Version 904379

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-06/1775486585
id: 904379
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: 2157
schema_scan_id: 6410049
updated: 2026-04-06 09:43:24

Version 904170

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-05/1775400253
id: 904170
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: 2157
schema_scan_id: 6409616
updated: 2026-04-05 09:44:31

Version 903971

created: 2026-04-04 09:51:24

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-04/1775314260
id: 903971
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: 2157
schema_scan_id: 6409241
updated: 2026-04-04 09:51:35

Version 903753

created: 2026-04-03 09:55:00

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-03/1775228094
id: 903753
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: 2157
schema_scan_id: 6408745
updated: 2026-04-03 09:55:14

Schema Scans: 15

Last at 2026-04-17 09:39:14

Scan 6415460

duration: 0:00:12.108271

exit_message:

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

id: 6415460

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-17/1776436733",
        "key": "raw/orgs/2026-04-17/1776436733/45d307a8-cd1a-4f50-a466-6e0edb859c46.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10866578857332491350,
        "service_name": "drive-thru",
        "span_id": 15809386472658117709,
        "trace_id": 4292969549244665739
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-17 09:39:14
success: True
trace_id: 4292969549244665739

Scan 6414939

duration: 0:00:11.956079

exit_message:

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

id: 6414939

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-16/1776350752",
        "key": "raw/orgs/2026-04-16/1776350752/11a0a87b-49ae-4602-978b-1714edac404f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14273672691148745490,
        "service_name": "drive-thru",
        "span_id": 15898720899712311750,
        "trace_id": 337934042623227515
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-16 09:46:19
success: True
trace_id: 337934042623227515

Scan 6414289

duration: 0:00:14.696323

exit_message:

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

id: 6414289

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-15/1776263191",
        "key": "raw/orgs/2026-04-15/1776263191/62043073-c6c3-4f0e-b2d4-79a9f8fa347e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11579050221887754536,
        "service_name": "drive-thru",
        "span_id": 8440491449867728228,
        "trace_id": 3849602666954287156
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-15 09:26:48
success: True
trace_id: 3849602666954287156

Scan 6413945

duration: 0:00:14.605766

exit_message:

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

id: 6413945

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-14/1776178032",
        "key": "raw/orgs/2026-04-14/1776178032/3012e78c-6788-404a-8d22-7834656fc054.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2900720312428292311,
        "service_name": "drive-thru",
        "span_id": 1512359182824227157,
        "trace_id": 4484888287194629725
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-14 09:47:15
success: True
trace_id: 4484888287194629725

Scan 6413390

duration: 0:00:14.578021

exit_message:

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

id: 6413390

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-13/1776091651",
        "key": "raw/orgs/2026-04-13/1776091651/478f5d5d-daad-4c68-a4c0-421503665dbc.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3034691529841612528,
        "service_name": "drive-thru",
        "span_id": 18235228237461940258,
        "trace_id": 3326937437599121931
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-13 09:47:51
success: True
trace_id: 3326937437599121931

Scan 6412870

duration: 0:00:12.150912

exit_message:

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

id: 6412870

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-12/1776004196",
        "key": "raw/orgs/2026-04-12/1776004196/293ee3f8-63b6-4a5a-a94a-c959006bc032.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17134945138533887508,
        "service_name": "drive-thru",
        "span_id": 15482870490010790958,
        "trace_id": 2359205011725788655
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-12 09:29:59
success: True
trace_id: 2359205011725788655

Scan 6412452

duration: 0:00:12.070253

exit_message:

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

id: 6412452

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-11/1775917596",
        "key": "raw/orgs/2026-04-11/1775917596/73079787-9795-4975-b1dc-c6afffb4a5e9.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17548736686195847885,
        "service_name": "drive-thru",
        "span_id": 15463847693980806382,
        "trace_id": 14282348875990931781
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-11 09:26:47
success: True
trace_id: 14282348875990931781

Scan 6411998

duration: 0:00:14.452620

exit_message:

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

id: 6411998

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-10/1775831210",
        "key": "raw/orgs/2026-04-10/1775831210/aed0cded-fd46-4f0f-ba56-bfbbab74a5e1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4264889202708030953,
        "service_name": "drive-thru",
        "span_id": 2016745823655428148,
        "trace_id": 32242177980089299
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-10 09:26:53
success: True
trace_id: 32242177980089299

Scan 6411599

duration: 0:00:14.698774

exit_message:

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

id: 6411599

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-09/1775746080",
        "key": "raw/orgs/2026-04-09/1775746080/4f9d2a7d-f71b-4913-a549-b2ec6985f1fa.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3019545430217414320,
        "service_name": "drive-thru",
        "span_id": 9034624108488672077,
        "trace_id": 17135494672029806195
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-09 09:48:22
success: True
trace_id: 17135494672029806195

Scan 6411102

duration: 0:00:12.000340

exit_message:

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

id: 6411102

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-08/1775659399",
        "key": "raw/orgs/2026-04-08/1775659399/f78e8fa9-9ce0-4a7f-a11a-0ebb9b610715.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10346408773723998729,
        "service_name": "drive-thru",
        "span_id": 2086197366293496254,
        "trace_id": 15731640407790742411
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-08 09:44:29
success: True
trace_id: 15731640407790742411

Scan 6410553

duration: 0:00:14.732215

exit_message:

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

id: 6410553

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-07/1775572797",
        "key": "raw/orgs/2026-04-07/1775572797/40edfd34-b64d-4eeb-af14-58adb4750ea4.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2110223475544199731,
        "service_name": "drive-thru",
        "span_id": 7048833068393580387,
        "trace_id": 2251153735189283400
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-07 09:40:32
success: True
trace_id: 2251153735189283400

Scan 6410049

duration: 0:00:14.460068

exit_message:

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

id: 6410049

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-06/1775486585",
        "key": "raw/orgs/2026-04-06/1775486585/dfd8503f-1fa2-41fc-ba16-c5fcda745527.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8226713868917786338,
        "service_name": "drive-thru",
        "span_id": 5894183518935839988,
        "trace_id": 1535873835542092288
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-06 09:43:09
success: True
trace_id: 1535873835542092288

Scan 6409616

duration: 0:00:14.487731

exit_message:

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

id: 6409616

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-05/1775400253",
        "key": "raw/orgs/2026-04-05/1775400253/8e1e632e-ea1c-4d52-bfad-c3047c1f2ae5.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3644408618278767740,
        "service_name": "drive-thru",
        "span_id": 3520918969088337143,
        "trace_id": 6475425635768356358
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-05 09:44:17
success: True
trace_id: 6475425635768356358

Scan 6409241

duration: 0:00:12.160932

exit_message:

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

id: 6409241

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-04/1775314260",
        "key": "raw/orgs/2026-04-04/1775314260/aa4093fd-576f-4a99-a878-d75f5a64f971.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2194519421456656187,
        "service_name": "drive-thru",
        "span_id": 10315899433900179495,
        "trace_id": 14426598307945899822
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-04 09:51:23
success: True
trace_id: 14426598307945899822

Scan 6408745

duration: 0:00:14.535663

exit_message:

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

id: 6408745

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/orgs/2026-04-03/1775228094",
        "key": "raw/orgs/2026-04-03/1775228094/5e40b1e8-cebb-4f18-a690-3a611a772a96.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_orgs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14298369945964145414,
        "service_name": "drive-thru",
        "span_id": 14353403050871022345,
        "trace_id": 17319987509559947382
    }
}

running: False
schema_name_id: 2157
start_time: 2026-04-03 09:55:00
success: True
trace_id: 17319987509559947382

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:39:15

ddl:

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

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-22 13:08:07",
        "disabled": false,
        "format": "raw",
        "id": 2157,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:39:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/orgs/2026-04-17/1776436733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_orgs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_orgs"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}