Schema Info

Schema Name: sfdl_stage_redshift.analytics_helper_account_customer_segment

created: 2018-02-20 23:57:21
disabled: False
format: raw
id: 384
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906627

created: 2026-04-17 03:42:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-17/1776415346'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-17/1776415346
id: 906627
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6415207
updated: 2026-04-17 03:42:48

Version 906395

created: 2026-04-16 03:54:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-16/1776329671'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-16/1776329671
id: 906395
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6414645
updated: 2026-04-16 03:55:01

Version 906206

created: 2026-04-15 03:47:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-15/1776242818'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-15/1776242818
id: 906206
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6414182
updated: 2026-04-15 03:47:29

Version 905995

created: 2026-04-14 03:54:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-14/1776156855'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-14/1776156855
id: 905995
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6413681
updated: 2026-04-14 03:54:39

Version 905772

created: 2026-04-13 03:33:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-13/1776069196'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-13/1776069196
id: 905772
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6413128
updated: 2026-04-13 03:33:48

Version 905571

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-12/1775984091'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-12/1775984091
id: 905571
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6412735
updated: 2026-04-12 03:55:20

Version 905345

created: 2026-04-11 03:21:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-11/1775895634'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-11/1775895634
id: 905345
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6412329
updated: 2026-04-11 03:21:13

Version 905141

created: 2026-04-10 03:24:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-10/1775809445'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-10/1775809445
id: 905141
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6411845
updated: 2026-04-10 03:24:35

Version 904936

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-09/1775724940'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-09/1775724940
id: 904936
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6411338
updated: 2026-04-09 03:56:16

Version 904722

created: 2026-04-08 03:42:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-08/1775637725'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-08/1775637725
id: 904722
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6410844
updated: 2026-04-08 03:42:26

Version 904516

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-07/1775551271'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-07/1775551271
id: 904516
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6410342
updated: 2026-04-07 03:41:32

Version 904303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-06/1775465731'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-06/1775465731
id: 904303
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6409797
updated: 2026-04-06 03:55:50

Version 904072

created: 2026-04-05 03:25:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-05/1775377521'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-05/1775377521
id: 904072
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6409379
updated: 2026-04-05 03:25:40

Version 903894

created: 2026-04-04 03:38:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-04/1775291913'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-04/1775291913
id: 903894
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6409023
updated: 2026-04-04 03:39:04

Version 903684

created: 2026-04-03 03:50:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-03/1775206186'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-03/1775206186
id: 903684
processed: 1

raw_data:

{
    "_origin": "3",
    "account_customer_segment": "1",
    "account_lifetime_customer_segment": "2",
    "client_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

schema_name_id: 384
schema_scan_id: 6408538
updated: 2026-04-03 03:50:19

Schema Scans: 15

Last at 2026-04-17 03:42:37

Scan 6415207

duration: 0:00:11.685827

exit_message:

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

id: 6415207

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-17/1776415346/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-17/1776415346",
        "key": "raw/helper_account_customer_segment/2026-04-17/1776415346/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7001815750546253596,
        "service_name": "redshift_unloads",
        "span_id": 4381862742397941315,
        "trace_id": 8000585243909288476
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-17 03:42:37
success: True
trace_id: 8000585243909288476

Scan 6414645

duration: 0:00:11.626673

exit_message:

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

id: 6414645

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-16/1776329671/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-16/1776329671",
        "key": "raw/helper_account_customer_segment/2026-04-16/1776329671/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14051345357716673414,
        "service_name": "redshift_unloads",
        "span_id": 2248512351851655632,
        "trace_id": 15059193776280052918
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-16 03:54:50
success: True
trace_id: 15059193776280052918

Scan 6414182

duration: 0:00:14.657740

exit_message:

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

id: 6414182

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-15/1776242818/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-15/1776242818",
        "key": "raw/helper_account_customer_segment/2026-04-15/1776242818/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10886243142154441529,
        "service_name": "redshift_unloads",
        "span_id": 17819491093476704190,
        "trace_id": 6794223411248548371
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-15 03:47:14
success: True
trace_id: 6794223411248548371

Scan 6413681

duration: 0:00:11.706995

exit_message:

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

id: 6413681

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-14/1776156855/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-14/1776156855",
        "key": "raw/helper_account_customer_segment/2026-04-14/1776156855/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 503619539956503359,
        "service_name": "redshift_unloads",
        "span_id": 2877165862368742569,
        "trace_id": 17024144760252439699
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-14 03:54:27
success: True
trace_id: 17024144760252439699

Scan 6413128

duration: 0:00:11.727304

exit_message:

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

id: 6413128

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-13/1776069196/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-13/1776069196",
        "key": "raw/helper_account_customer_segment/2026-04-13/1776069196/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3259907804385974056,
        "service_name": "redshift_unloads",
        "span_id": 5213640347294088329,
        "trace_id": 3419205027010023910
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-13 03:33:36
success: True
trace_id: 3419205027010023910

Scan 6412735

duration: 0:00:14.209182

exit_message:

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

id: 6412735

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-12/1775984091/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-12/1775984091",
        "key": "raw/helper_account_customer_segment/2026-04-12/1775984091/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3313587483943324215,
        "service_name": "redshift_unloads",
        "span_id": 9818051734544593905,
        "trace_id": 1427993782543524013
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-12 03:55:06
success: True
trace_id: 1427993782543524013

Scan 6412329

duration: 0:00:11.679643

exit_message:

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

id: 6412329

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-11/1775895634/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-11/1775895634",
        "key": "raw/helper_account_customer_segment/2026-04-11/1775895634/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13750689241859847704,
        "service_name": "redshift_unloads",
        "span_id": 16023269404377681505,
        "trace_id": 15883399600747573708
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-11 03:21:01
success: True
trace_id: 15883399600747573708

Scan 6411845

duration: 0:00:14.204739

exit_message:

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

id: 6411845

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-10/1775809445/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-10/1775809445",
        "key": "raw/helper_account_customer_segment/2026-04-10/1775809445/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11264366322487968982,
        "service_name": "redshift_unloads",
        "span_id": 13077415613863396776,
        "trace_id": 4017465352116609828
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-10 03:24:21
success: True
trace_id: 4017465352116609828

Scan 6411338

duration: 0:00:11.651581

exit_message:

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

id: 6411338

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-09/1775724940/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-09/1775724940",
        "key": "raw/helper_account_customer_segment/2026-04-09/1775724940/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3674451467697739467,
        "service_name": "redshift_unloads",
        "span_id": 9194607608803987959,
        "trace_id": 11455287984507651127
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-09 03:56:04
success: True
trace_id: 11455287984507651127

Scan 6410844

duration: 0:00:14.216296

exit_message:

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

id: 6410844

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-08/1775637725/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-08/1775637725",
        "key": "raw/helper_account_customer_segment/2026-04-08/1775637725/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11274140902507611686,
        "service_name": "redshift_unloads",
        "span_id": 5186021998742271818,
        "trace_id": 7946175527230994355
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-08 03:42:11
success: True
trace_id: 7946175527230994355

Scan 6410342

duration: 0:00:14.209520

exit_message:

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

id: 6410342

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-07/1775551271/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-07/1775551271",
        "key": "raw/helper_account_customer_segment/2026-04-07/1775551271/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11166794424530585550,
        "service_name": "redshift_unloads",
        "span_id": 14224291849826760936,
        "trace_id": 18204156211437763376
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-07 03:41:18
success: True
trace_id: 18204156211437763376

Scan 6409797

duration: 0:00:11.659552

exit_message:

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

id: 6409797

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-06/1775465731/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-06/1775465731",
        "key": "raw/helper_account_customer_segment/2026-04-06/1775465731/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8286338166144955792,
        "service_name": "redshift_unloads",
        "span_id": 15303594655453906840,
        "trace_id": 3496654068555512915
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-06 03:55:38
success: True
trace_id: 3496654068555512915

Scan 6409379

duration: 0:00:11.699583

exit_message:

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

id: 6409379

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-05/1775377521/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-05/1775377521",
        "key": "raw/helper_account_customer_segment/2026-04-05/1775377521/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8719274796100919125,
        "service_name": "redshift_unloads",
        "span_id": 1797194787632395189,
        "trace_id": 11487704463030683059
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-05 03:25:29
success: True
trace_id: 11487704463030683059

Scan 6409023

duration: 0:00:14.264568

exit_message:

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

id: 6409023

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-04/1775291913/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-04/1775291913",
        "key": "raw/helper_account_customer_segment/2026-04-04/1775291913/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5969927514548555666,
        "service_name": "redshift_unloads",
        "span_id": 12326031241529519033,
        "trace_id": 7003679681239896037
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-04 03:38:50
success: True
trace_id: 7003679681239896037

Scan 6408538

duration: 0:00:11.837332

exit_message:

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

id: 6408538

payload:

{
    "datatype_dict": {
        "account_customer_segment": "varchar(30)",
        "account_lifetime_customer_segment": "varchar(30)",
        "client_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_account_customer_segment/2026-04-03/1775206186/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_account_customer_segment/2026-04-03/1775206186",
        "key": "raw/helper_account_customer_segment/2026-04-03/1775206186/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_account_customer_segment",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8670525048072944987,
        "service_name": "redshift_unloads",
        "span_id": 13015821674937564524,
        "trace_id": 15443061879001625377
    }
}

running: False
schema_name_id: 384
start_time: 2026-04-03 03:50:07
success: True
trace_id: 15443061879001625377

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "account_customer_segment": "varchar(30)",
    "account_lifetime_customer_segment": "varchar(30)",
    "client_key": "bigint"
}

created: 2026-04-17 03:42:37

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-17/1776415346'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
}

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:57:21",
        "disabled": false,
        "format": "raw",
        "id": 384,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_helper_account_customer_segment"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "account_customer_segment": "varchar(30)",
            "account_lifetime_customer_segment": "varchar(30)",
            "client_key": "bigint"
        },
        "created": "2026-04-17 03:42:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_account_customer_segment`\n(\n `client_key`  bigint , `account_customer_segment`  varchar(30) , `account_lifetime_customer_segment`  varchar(30) , `_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/helper_account_customer_segment/2026-04-17/1776415346'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_account_customer_segment`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_account_customer_segment"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}