Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_statement

created: 2018-02-20 23:55:17
disabled: False
format: raw
id: 376
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_redshift",
    "table": "analytics_dwh_dim_statement"
}

type: redshift

Schema Versions: 15

Version 906625

created: 2026-04-17 03:38:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-17/1776415095'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-17/1776415095
id: 906625
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6415205
updated: 2026-04-17 03:38:46

Version 906438

created: 2026-04-16 04:10:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-16/1776330634'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-16/1776330634
id: 906438
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6414688
updated: 2026-04-16 04:11:06

Version 906227

created: 2026-04-15 04:03:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-15/1776243813'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-15/1776243813
id: 906227
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6414203
updated: 2026-04-15 04:03:55

Version 905988

created: 2026-04-14 03:53:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-14/1776156772'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-14/1776156772
id: 905988
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6413674
updated: 2026-04-14 03:53:31

Version 905796

created: 2026-04-13 03:58:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-13/1776070671'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-13/1776070671
id: 905796
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6413152
updated: 2026-04-13 03:58:26

Version 905581

created: 2026-04-12 03:58:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-12/1775984305'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-12/1775984305
id: 905581
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6412745
updated: 2026-04-12 03:58:44

Version 905389

created: 2026-04-11 03:49:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-11/1775897336'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-11/1775897336
id: 905389
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6412374
updated: 2026-04-11 03:49:14

Version 905158

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-10/1775811131'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-10/1775811131
id: 905158
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6411863
updated: 2026-04-10 03:52:41

Version 904956

created: 2026-04-09 04:00:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-09/1775725205'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-09/1775725205
id: 904956
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6411359
updated: 2026-04-09 04:00:48

Version 904728

created: 2026-04-08 03:53:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-08/1775638391'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-08/1775638391
id: 904728
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6410850
updated: 2026-04-08 03:53:37

Version 904537

created: 2026-04-07 03:57:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-07/1775552219'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-07/1775552219
id: 904537
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6410363
updated: 2026-04-07 03:57:29

Version 904320

created: 2026-04-06 04:04:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-06/1775466244'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-06/1775466244
id: 904320
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6409815
updated: 2026-04-06 04:04:26

Version 904091

created: 2026-04-05 03:33:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-05/1775377982'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-05/1775377982
id: 904091
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6409399
updated: 2026-04-05 03:33:34

Version 903916

created: 2026-04-04 03:47:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-04/1775292408'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-04/1775292408
id: 903916
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6409045
updated: 2026-04-04 03:47:34

Version 903698

created: 2026-04-03 03:58:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-03/1775206696'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-03/1775206696
id: 903698
processed: 1

raw_data:

{
    "_origin": "4",
    "account_key": "2",
    "audit_id": "0",
    "statement_batch_key": "3",
    "statement_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

schema_name_id: 376
schema_scan_id: 6408552
updated: 2026-04-03 03:58:48

Schema Scans: 15

Last at 2026-04-17 03:38:35

Scan 6415205

duration: 0:00:11.720260

exit_message:

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

id: 6415205

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-17/1776415095/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-17/1776415095",
        "key": "raw/dwh_dim_statement/2026-04-17/1776415095/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12915231037224811938,
        "service_name": "redshift_unloads",
        "span_id": 13501610380766476066,
        "trace_id": 4172752093591724443
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-17 03:38:35
success: True
trace_id: 4172752093591724443

Scan 6414688

duration: 0:00:11.711329

exit_message:

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

id: 6414688

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-16/1776330634/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-16/1776330634",
        "key": "raw/dwh_dim_statement/2026-04-16/1776330634/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8170404206696632891,
        "service_name": "redshift_unloads",
        "span_id": 3795253660177269672,
        "trace_id": 8880663057493089763
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-16 04:10:55
success: True
trace_id: 8880663057493089763

Scan 6414203

duration: 0:00:14.307213

exit_message:

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

id: 6414203

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-15/1776243813/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-15/1776243813",
        "key": "raw/dwh_dim_statement/2026-04-15/1776243813/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3125418924517311700,
        "service_name": "redshift_unloads",
        "span_id": 16842748479345040640,
        "trace_id": 13978453806293679036
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-15 04:03:40
success: True
trace_id: 13978453806293679036

Scan 6413674

duration: 0:00:14.208529

exit_message:

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

id: 6413674

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-14/1776156772/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-14/1776156772",
        "key": "raw/dwh_dim_statement/2026-04-14/1776156772/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14017237724607599910,
        "service_name": "redshift_unloads",
        "span_id": 6475971495632978404,
        "trace_id": 12555859948655589247
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-14 03:53:17
success: True
trace_id: 12555859948655589247

Scan 6413152

duration: 0:00:11.783900

exit_message:

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

id: 6413152

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-13/1776070671/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-13/1776070671",
        "key": "raw/dwh_dim_statement/2026-04-13/1776070671/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14884025767142715747,
        "service_name": "redshift_unloads",
        "span_id": 3675381639368320745,
        "trace_id": 41357887334932043
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-13 03:58:14
success: True
trace_id: 41357887334932043

Scan 6412745

duration: 0:00:11.713961

exit_message:

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

id: 6412745

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-12/1775984305/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-12/1775984305",
        "key": "raw/dwh_dim_statement/2026-04-12/1775984305/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17037300211390449958,
        "service_name": "redshift_unloads",
        "span_id": 2481636936518216593,
        "trace_id": 12151889693309963060
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-12 03:58:32
success: True
trace_id: 12151889693309963060

Scan 6412374

duration: 0:00:11.713012

exit_message:

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

id: 6412374

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-11/1775897336/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-11/1775897336",
        "key": "raw/dwh_dim_statement/2026-04-11/1775897336/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4392013938304148817,
        "service_name": "redshift_unloads",
        "span_id": 13397037455174864497,
        "trace_id": 6888321144954255453
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-11 03:49:03
success: True
trace_id: 6888321144954255453

Scan 6411863

duration: 0:00:14.312405

exit_message:

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

id: 6411863

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-10/1775811131/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-10/1775811131",
        "key": "raw/dwh_dim_statement/2026-04-10/1775811131/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14625388348586372992,
        "service_name": "redshift_unloads",
        "span_id": 6685731972063294149,
        "trace_id": 16936530372417542729
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-10 03:52:26
success: True
trace_id: 16936530372417542729

Scan 6411359

duration: 0:00:14.193181

exit_message:

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

id: 6411359

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-09/1775725205/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-09/1775725205",
        "key": "raw/dwh_dim_statement/2026-04-09/1775725205/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12160799018448434759,
        "service_name": "redshift_unloads",
        "span_id": 14464302350324177726,
        "trace_id": 16103705215451497001
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-09 04:00:33
success: True
trace_id: 16103705215451497001

Scan 6410850

duration: 0:00:11.782942

exit_message:

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

id: 6410850

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-08/1775638391/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-08/1775638391",
        "key": "raw/dwh_dim_statement/2026-04-08/1775638391/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18076827124644010046,
        "service_name": "redshift_unloads",
        "span_id": 10018811529886747732,
        "trace_id": 3461872739649874484
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-08 03:53:25
success: True
trace_id: 3461872739649874484

Scan 6410363

duration: 0:00:11.715277

exit_message:

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

id: 6410363

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-07/1775552219/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-07/1775552219",
        "key": "raw/dwh_dim_statement/2026-04-07/1775552219/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16356452290939966180,
        "service_name": "redshift_unloads",
        "span_id": 9716199405773009303,
        "trace_id": 8071671290257229794
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-07 03:57:18
success: True
trace_id: 8071671290257229794

Scan 6409815

duration: 0:00:14.391978

exit_message:

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

id: 6409815

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-06/1775466244/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-06/1775466244",
        "key": "raw/dwh_dim_statement/2026-04-06/1775466244/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8936042424598660737,
        "service_name": "redshift_unloads",
        "span_id": 15647631679688882071,
        "trace_id": 17893424830091556480
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-06 04:04:12
success: True
trace_id: 17893424830091556480

Scan 6409399

duration: 0:00:14.291202

exit_message:

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

id: 6409399

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-05/1775377982/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-05/1775377982",
        "key": "raw/dwh_dim_statement/2026-04-05/1775377982/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8519834494693581301,
        "service_name": "redshift_unloads",
        "span_id": 16778555710412768165,
        "trace_id": 2420886511956482878
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-05 03:33:19
success: True
trace_id: 2420886511956482878

Scan 6409045

duration: 0:00:14.308415

exit_message:

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

id: 6409045

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-04/1775292408/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-04/1775292408",
        "key": "raw/dwh_dim_statement/2026-04-04/1775292408/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1367403259006956503,
        "service_name": "redshift_unloads",
        "span_id": 3776226131928685123,
        "trace_id": 4969694675608588694
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-04 03:47:20
success: True
trace_id: 4969694675608588694

Scan 6408552

duration: 0:00:14.258026

exit_message:

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

id: 6408552

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "statement_batch_key": "int",
        "statement_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_statement/2026-04-03/1775206696/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-03/1775206696",
        "key": "raw/dwh_dim_statement/2026-04-03/1775206696/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9871049585007345593,
        "service_name": "redshift_unloads",
        "span_id": 17032385935190273920,
        "trace_id": 10125052143410091120
    }
}

running: False
schema_name_id: 376
start_time: 2026-04-03 03:58:33
success: True
trace_id: 10125052143410091120

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "_origin": "string",
    "account_key": "int",
    "audit_id": "bigint",
    "statement_batch_key": "int",
    "statement_key": "int"
}

created: 2026-04-17 03:38:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-17/1776415095'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-20 23:55:17",
        "disabled": false,
        "format": "raw",
        "id": 376,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_statement"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "account_key": "int",
            "audit_id": "bigint",
            "statement_batch_key": "int",
            "statement_key": "int"
        },
        "created": "2026-04-17 03:38:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_statement`\n(\n `audit_id`  bigint , `statement_key`  int , `account_key`  int , `statement_batch_key`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_statement/2026-04-17/1776415095'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_statement`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_statement"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}