Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_dim_account_manager

created: 2018-05-09 10:28:41
disabled: False
format: raw
id: 521
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906617

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-17/1776415001'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-17/1776415001
id: 906617
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6415197
updated: 2026-04-17 03:37:07

Version 906412

created: 2026-04-16 03:59:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-16/1776329951'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-16/1776329951
id: 906412
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6414662
updated: 2026-04-16 03:59:52

Version 906193

created: 2026-04-15 03:46:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-15/1776242748'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-15/1776242748
id: 906193
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6414169
updated: 2026-04-15 03:46:17

Version 905975

created: 2026-04-14 03:39:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-14/1776155950'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-14/1776155950
id: 905975
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6413661
updated: 2026-04-14 03:39:38

Version 905767

created: 2026-04-13 03:32:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-13/1776069144'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-13/1776069144
id: 905767
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6413123
updated: 2026-04-13 03:32:46

Version 905569

created: 2026-04-12 03:39:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-12/1775983150'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-12/1775983150
id: 905569
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6412732
updated: 2026-04-12 03:39:35

Version 905353

created: 2026-04-11 03:25:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-11/1775895925'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-11/1775895925
id: 905353
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6412338
updated: 2026-04-11 03:25:54

Version 905150

created: 2026-04-10 03:38:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-10/1775810318'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-10/1775810318
id: 905150
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6411855
updated: 2026-04-10 03:39:07

Version 904943

created: 2026-04-09 03:56:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-09/1775724999'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-09/1775724999
id: 904943
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6411345
updated: 2026-04-09 03:57:13

Version 904750

created: 2026-04-08 04:02:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-08/1775638892'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-08/1775638892
id: 904750
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6410873
updated: 2026-04-08 04:02:14

Version 904509

created: 2026-04-07 03:34:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-07/1775550812'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-07/1775550812
id: 904509
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6410332
updated: 2026-04-07 03:34:36

Version 904298

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-06/1775465707'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-06/1775465707
id: 904298
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6409792
updated: 2026-04-06 03:55:35

Version 904081

created: 2026-04-05 03:26:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-05/1775377588'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-05/1775377588
id: 904081
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6409388
updated: 2026-04-05 03:26:52

Version 903884

created: 2026-04-04 03:23:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-04/1775291018'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-04/1775291018
id: 903884
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6409013
updated: 2026-04-04 03:24:02

Version 903672

created: 2026-04-03 03:44:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-03/1775205861'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-03/1775205861
id: 903672
processed: 1

raw_data:

{
    "_origin": "3",
    "account_manager": "2",
    "account_manager_key": "1",
    "audit_id": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

schema_name_id: 521
schema_scan_id: 6408526
updated: 2026-04-03 03:44:40

Schema Scans: 15

Last at 2026-04-17 03:36:53

Scan 6415197

duration: 0:00:14.203062

exit_message:

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

id: 6415197

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-17/1776415001/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-17/1776415001",
        "key": "raw/reference_dim_account_manager/2026-04-17/1776415001/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11009867763053751806,
        "service_name": "redshift_unloads",
        "span_id": 11620967455940079280,
        "trace_id": 14395292242213892107
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-17 03:36:53
success: True
trace_id: 14395292242213892107

Scan 6414662

duration: 0:00:11.596882

exit_message:

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

id: 6414662

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-16/1776329951/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-16/1776329951",
        "key": "raw/reference_dim_account_manager/2026-04-16/1776329951/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4028384572665564697,
        "service_name": "redshift_unloads",
        "span_id": 16541430909899119414,
        "trace_id": 17449823122472746052
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-16 03:59:40
success: True
trace_id: 17449823122472746052

Scan 6414169

duration: 0:00:11.675300

exit_message:

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

id: 6414169

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-15/1776242748/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-15/1776242748",
        "key": "raw/reference_dim_account_manager/2026-04-15/1776242748/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2339908831592203529,
        "service_name": "redshift_unloads",
        "span_id": 13550105271036525702,
        "trace_id": 7133536945807374524
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-15 03:46:05
success: True
trace_id: 7133536945807374524

Scan 6413661

duration: 0:00:11.593434

exit_message:

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

id: 6413661

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-14/1776155950/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-14/1776155950",
        "key": "raw/reference_dim_account_manager/2026-04-14/1776155950/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6977639014481202082,
        "service_name": "redshift_unloads",
        "span_id": 15904238869009845224,
        "trace_id": 9951700310596910234
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-14 03:39:27
success: True
trace_id: 9951700310596910234

Scan 6413123

duration: 0:00:11.593472

exit_message:

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

id: 6413123

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-13/1776069144/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-13/1776069144",
        "key": "raw/reference_dim_account_manager/2026-04-13/1776069144/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17701356298137419546,
        "service_name": "redshift_unloads",
        "span_id": 9135300776290151250,
        "trace_id": 8399275908110438478
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-13 03:32:35
success: True
trace_id: 8399275908110438478

Scan 6412732

duration: 0:00:14.083818

exit_message:

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

id: 6412732

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-12/1775983150/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-12/1775983150",
        "key": "raw/reference_dim_account_manager/2026-04-12/1775983150/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11285916386631122412,
        "service_name": "redshift_unloads",
        "span_id": 4074809406402623515,
        "trace_id": 2197677013154383080
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-12 03:39:21
success: True
trace_id: 2197677013154383080

Scan 6412338

duration: 0:00:11.735147

exit_message:

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

id: 6412338

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-11/1775895925/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-11/1775895925",
        "key": "raw/reference_dim_account_manager/2026-04-11/1775895925/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13513425969760450952,
        "service_name": "redshift_unloads",
        "span_id": 1538189768489740748,
        "trace_id": 9113353809519651623
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-11 03:25:42
success: True
trace_id: 9113353809519651623

Scan 6411855

duration: 0:00:14.320053

exit_message:

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

id: 6411855

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-10/1775810318/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-10/1775810318",
        "key": "raw/reference_dim_account_manager/2026-04-10/1775810318/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10701226324525719673,
        "service_name": "redshift_unloads",
        "span_id": 15154436376697213585,
        "trace_id": 5584266612581655103
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-10 03:38:53
success: True
trace_id: 5584266612581655103

Scan 6411345

duration: 0:00:14.256434

exit_message:

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

id: 6411345

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-09/1775724999/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-09/1775724999",
        "key": "raw/reference_dim_account_manager/2026-04-09/1775724999/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5554456039799862278,
        "service_name": "redshift_unloads",
        "span_id": 8493529058350557313,
        "trace_id": 2210488392280045734
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-09 03:56:59
success: True
trace_id: 2210488392280045734

Scan 6410873

duration: 0:00:11.704900

exit_message:

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

id: 6410873

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-08/1775638892/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-08/1775638892",
        "key": "raw/reference_dim_account_manager/2026-04-08/1775638892/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 292049566692627625,
        "service_name": "redshift_unloads",
        "span_id": 10549350480474727674,
        "trace_id": 12594136517270322221
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-08 04:02:02
success: True
trace_id: 12594136517270322221

Scan 6410332

duration: 0:00:14.077711

exit_message:

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

id: 6410332

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-07/1775550812/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-07/1775550812",
        "key": "raw/reference_dim_account_manager/2026-04-07/1775550812/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3957733836708199991,
        "service_name": "redshift_unloads",
        "span_id": 12594770631921797230,
        "trace_id": 7689646265806241211
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-07 03:34:22
success: True
trace_id: 7689646265806241211

Scan 6409792

duration: 0:00:14.220738

exit_message:

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

id: 6409792

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-06/1775465707/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-06/1775465707",
        "key": "raw/reference_dim_account_manager/2026-04-06/1775465707/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15138915984294793524,
        "service_name": "redshift_unloads",
        "span_id": 5756174898042985579,
        "trace_id": 10503357551360086625
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-06 03:55:21
success: True
trace_id: 10503357551360086625

Scan 6409388

duration: 0:00:14.205133

exit_message:

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

id: 6409388

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-05/1775377588/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-05/1775377588",
        "key": "raw/reference_dim_account_manager/2026-04-05/1775377588/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1043471032874459367,
        "service_name": "redshift_unloads",
        "span_id": 3400563942399642019,
        "trace_id": 10801290115443095464
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-05 03:26:38
success: True
trace_id: 10801290115443095464

Scan 6409013

duration: 0:00:11.848558

exit_message:

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

id: 6409013

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-04/1775291018/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-04/1775291018",
        "key": "raw/reference_dim_account_manager/2026-04-04/1775291018/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2809214926055420262,
        "service_name": "redshift_unloads",
        "span_id": 17787804605741246770,
        "trace_id": 13152159165371355760
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-04 03:23:50
success: True
trace_id: 13152159165371355760

Scan 6408526

duration: 0:00:11.542003

exit_message:

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

id: 6408526

payload:

{
    "datatype_dict": {
        "account_manager": "varchar(24)",
        "account_manager_key": "int",
        "audit_id": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_account_manager/2026-04-03/1775205861/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_account_manager/2026-04-03/1775205861",
        "key": "raw/reference_dim_account_manager/2026-04-03/1775205861/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_account_manager",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6832242111475387853,
        "service_name": "redshift_unloads",
        "span_id": 17382973264381489937,
        "trace_id": 18284031132263523954
    }
}

running: False
schema_name_id: 521
start_time: 2026-04-03 03:44:29
success: True
trace_id: 18284031132263523954

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "account_manager": "varchar(24)",
    "account_manager_key": "int",
    "audit_id": "bigint"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-17/1776415001'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
}

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-05-09 10:28:41",
        "disabled": false,
        "format": "raw",
        "id": 521,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_reference_dim_account_manager"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "account_manager": "varchar(24)",
            "account_manager_key": "int",
            "audit_id": "bigint"
        },
        "created": "2026-04-17 03:36:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_account_manager`\n(\n `audit_id`  bigint , `account_manager_key`  int , `account_manager`  varchar(24) , `_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/reference_dim_account_manager/2026-04-17/1776415001'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_account_manager`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_account_manager"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}