Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_statement

created: 2018-02-28 10:49:55
disabled: False
format: raw
id: 243
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717892

created: 2026-04-17 03:40:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-17/1776415188'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-17/1776415188
id: 1717892
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: 243
schema_scan_id: 162168009
updated: 2026-04-17 03:40:13

Version 1716651

created: 2026-04-16 04:06:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-16/1776330391'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-16/1776330391
id: 1716651
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: 243
schema_scan_id: 162113303
updated: 2026-04-16 04:06:51

Version 1715567

created: 2026-04-15 03:50:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-15/1776243020'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-15/1776243020
id: 1715567
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: 243
schema_scan_id: 162056519
updated: 2026-04-15 03:50:41

Version 1714254

created: 2026-04-14 03:42:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-14/1776156141'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-14/1776156141
id: 1714254
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: 243
schema_scan_id: 162000822
updated: 2026-04-14 03:42:42

Version 1713045

created: 2026-04-13 04:00:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-13/1776070729'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-13/1776070729
id: 1713045
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: 243
schema_scan_id: 161943973
updated: 2026-04-13 04:00:53

Version 1711844

created: 2026-04-12 03:55:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-12/1775984139'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-12/1775984139
id: 1711844
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: 243
schema_scan_id: 161893853
updated: 2026-04-12 03:56:10

Version 1710626

created: 2026-04-11 03:46:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-11/1775897155'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-11/1775897155
id: 1710626
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: 243
schema_scan_id: 161841485
updated: 2026-04-11 03:46:31

Version 1709443

created: 2026-04-10 03:30:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-10/1775809823'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-10/1775809823
id: 1709443
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: 243
schema_scan_id: 161786192
updated: 2026-04-10 03:30:42

Version 1708330

created: 2026-04-09 03:46:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-09/1775724343'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-09/1775724343
id: 1708330
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: 243
schema_scan_id: 161730690
updated: 2026-04-09 03:46:13

Version 1707148

created: 2026-04-08 04:06:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-08/1775639156'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-08/1775639156
id: 1707148
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: 243
schema_scan_id: 161677005
updated: 2026-04-08 04:06:19

Version 1705953

created: 2026-04-07 03:54:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-07/1775552038'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-07/1775552038
id: 1705953
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: 243
schema_scan_id: 161619846
updated: 2026-04-07 03:54:17

Version 1704694

created: 2026-04-06 03:41:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-06/1775464872'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-06/1775464872
id: 1704694
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: 243
schema_scan_id: 161561890
updated: 2026-04-06 03:41:35

Version 1703521

created: 2026-04-05 04:04:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-05/1775379843'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-05/1775379843
id: 1703521
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: 243
schema_scan_id: 161516202
updated: 2026-04-05 04:04:33

Version 1702318

created: 2026-04-04 03:25:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-04/1775291099'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-04/1775291099
id: 1702318
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: 243
schema_scan_id: 161460679
updated: 2026-04-04 03:25:26

Version 1701171

created: 2026-04-03 03:58:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-03/1775206631'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-03/1775206631
id: 1701171
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: 243
schema_scan_id: 161402765
updated: 2026-04-03 03:58:58

Schema Scans: 15

Last at 2026-04-17 03:40:01

Scan 162168009

duration: 0:00:11.869278

exit_message:

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

id: 162168009

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-17/1776415188/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-17/1776415188",
        "key": "raw/dwh_dim_statement/2026-04-17/1776415188/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15658396645647507289,
        "service_name": "redshift_unloads",
        "span_id": 14910973098545988728,
        "trace_id": 13593672395620894824
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-17 03:40:01
success: True
trace_id: 13593672395620894824

Scan 162113303

duration: 0:00:11.783031

exit_message:

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

id: 162113303

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-16/1776330391/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-16/1776330391",
        "key": "raw/dwh_dim_statement/2026-04-16/1776330391/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3443841862619167621,
        "service_name": "redshift_unloads",
        "span_id": 13930183352918934008,
        "trace_id": 15358464893714700610
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-16 04:06:39
success: True
trace_id: 15358464893714700610

Scan 162056519

duration: 0:00:14.099224

exit_message:

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

id: 162056519

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-15/1776243020/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-15/1776243020",
        "key": "raw/dwh_dim_statement/2026-04-15/1776243020/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16042998056078252520,
        "service_name": "redshift_unloads",
        "span_id": 8439200110925856323,
        "trace_id": 5928902549068140461
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-15 03:50:27
success: True
trace_id: 5928902549068140461

Scan 162000822

duration: 0:00:14.170746

exit_message:

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

id: 162000822

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-14/1776156141/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-14/1776156141",
        "key": "raw/dwh_dim_statement/2026-04-14/1776156141/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12138492051163615539,
        "service_name": "redshift_unloads",
        "span_id": 5342243587806676001,
        "trace_id": 4185960423849786615
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-14 03:42:28
success: True
trace_id: 4185960423849786615

Scan 161943973

duration: 0:00:14.294555

exit_message:

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

id: 161943973

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-13/1776070729/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-13/1776070729",
        "key": "raw/dwh_dim_statement/2026-04-13/1776070729/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4393175213512664227,
        "service_name": "redshift_unloads",
        "span_id": 14437516921689968704,
        "trace_id": 4509955902427314591
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-13 04:00:39
success: True
trace_id: 4509955902427314591

Scan 161893853

duration: 0:00:14.086839

exit_message:

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

id: 161893853

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-12/1775984139/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-12/1775984139",
        "key": "raw/dwh_dim_statement/2026-04-12/1775984139/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15122731749803501686,
        "service_name": "redshift_unloads",
        "span_id": 7663723787095034998,
        "trace_id": 4397329743380494674
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-12 03:55:56
success: True
trace_id: 4397329743380494674

Scan 161841485

duration: 0:00:14.146824

exit_message:

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

id: 161841485

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-11/1775897155/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-11/1775897155",
        "key": "raw/dwh_dim_statement/2026-04-11/1775897155/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5142197080725463864,
        "service_name": "redshift_unloads",
        "span_id": 3528397806974901285,
        "trace_id": 11208486861240238269
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-11 03:46:17
success: True
trace_id: 11208486861240238269

Scan 161786192

duration: 0:00:11.651986

exit_message:

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

id: 161786192

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-10/1775809823/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-10/1775809823",
        "key": "raw/dwh_dim_statement/2026-04-10/1775809823/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4019205265263663122,
        "service_name": "redshift_unloads",
        "span_id": 2049109531865894842,
        "trace_id": 12117145925212169497
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-10 03:30:30
success: True
trace_id: 12117145925212169497

Scan 161730690

duration: 0:00:11.703994

exit_message:

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

id: 161730690

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-09/1775724343/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-09/1775724343",
        "key": "raw/dwh_dim_statement/2026-04-09/1775724343/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11513387179037533300,
        "service_name": "redshift_unloads",
        "span_id": 14662506901652821268,
        "trace_id": 16420942406001006776
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-09 03:46:02
success: True
trace_id: 16420942406001006776

Scan 161677005

duration: 0:00:14.128628

exit_message:

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

id: 161677005

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-08/1775639156/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-08/1775639156",
        "key": "raw/dwh_dim_statement/2026-04-08/1775639156/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17723595290424545282,
        "service_name": "redshift_unloads",
        "span_id": 10786724297789194567,
        "trace_id": 12817433612028185150
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-08 04:06:05
success: True
trace_id: 12817433612028185150

Scan 161619846

duration: 0:00:11.661978

exit_message:

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

id: 161619846

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-07/1775552038/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-07/1775552038",
        "key": "raw/dwh_dim_statement/2026-04-07/1775552038/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11350279277830558456,
        "service_name": "redshift_unloads",
        "span_id": 6079597465928437863,
        "trace_id": 15976597299598384230
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-07 03:54:05
success: True
trace_id: 15976597299598384230

Scan 161561890

duration: 0:00:14.135637

exit_message:

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

id: 161561890

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-06/1775464872/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-06/1775464872",
        "key": "raw/dwh_dim_statement/2026-04-06/1775464872/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15440172046518666454,
        "service_name": "redshift_unloads",
        "span_id": 2367180827643053651,
        "trace_id": 5690529231496240105
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-06 03:41:20
success: True
trace_id: 5690529231496240105

Scan 161516202

duration: 0:00:11.645149

exit_message:

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

id: 161516202

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-05/1775379843/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-05/1775379843",
        "key": "raw/dwh_dim_statement/2026-04-05/1775379843/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1226239282062457700,
        "service_name": "redshift_unloads",
        "span_id": 13975059871205291876,
        "trace_id": 15499476107777793445
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-05 04:04:21
success: True
trace_id: 15499476107777793445

Scan 161460679

duration: 0:00:11.652689

exit_message:

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

id: 161460679

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-04/1775291099/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-04/1775291099",
        "key": "raw/dwh_dim_statement/2026-04-04/1775291099/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13017638654981402595,
        "service_name": "redshift_unloads",
        "span_id": 8070079535868263605,
        "trace_id": 17509669788470733878
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-04 03:25:14
success: True
trace_id: 17509669788470733878

Scan 161402765

duration: 0:00:11.612099

exit_message:

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

id: 161402765

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-prod",
            "key": "meta/dwh_dim_statement/2026-04-03/1775206631/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_statement/2026-04-03/1775206631",
        "key": "raw/dwh_dim_statement/2026-04-03/1775206631/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_statement",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10950399488009320074,
        "service_name": "redshift_unloads",
        "span_id": 2965647346646917653,
        "trace_id": 4529800845455858352
    }
}

running: False
schema_name_id: 243
start_time: 2026-04-03 03:58:46
success: True
trace_id: 4529800845455858352

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:40:01

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-17/1776415188'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-28 10:49:55",
        "disabled": false,
        "format": "raw",
        "id": 243,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:40:01",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_statement/2026-04-17/1776415188'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_statement`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_statement"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}