Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_user

created: 2019-07-31 10:37:35
disabled: False
format: raw
id: 859
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906624

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-17/1776415071'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-17/1776415071
id: 906624
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6415204
updated: 2026-04-17 03:38:35

Version 906403

created: 2026-04-16 03:58:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-16/1776329900'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-16/1776329900
id: 906403
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6414653
updated: 2026-04-16 03:59:06

Version 906202

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-15/1776242778'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-15/1776242778
id: 906202
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6414178
updated: 2026-04-15 03:47:14

Version 905994

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-14/1776156824'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-14/1776156824
id: 905994
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6413680
updated: 2026-04-14 03:54:25

Version 905798

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-13/1776070679'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-13/1776070679
id: 905798
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6413154
updated: 2026-04-13 03:58:43

Version 905553

created: 2026-04-12 03:37:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-12/1775983003'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-12/1775983003
id: 905553
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6412716
updated: 2026-04-12 03:37:29

Version 905391

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-11/1775897345'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-11/1775897345
id: 905391
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6412376
updated: 2026-04-11 03:49:44

Version 905162

created: 2026-04-10 03:55:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-10/1775811289'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-10/1775811289
id: 905162
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6411867
updated: 2026-04-10 03:55:33

Version 904957

created: 2026-04-09 04:00:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-09/1775725223'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-09/1775725223
id: 904957
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6411360
updated: 2026-04-09 04:01:10

Version 904727

created: 2026-04-08 03:52:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-08/1775638334'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-08/1775638334
id: 904727
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6410849
updated: 2026-04-08 03:52:58

Version 904511

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-07/1775550830'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-07/1775550830
id: 904511
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6410334
updated: 2026-04-07 03:34:42

Version 904323

created: 2026-04-06 04:05:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-06/1775466254'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-06/1775466254
id: 904323
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6409818
updated: 2026-04-06 04:05:23

Version 904087

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-05/1775377652'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-05/1775377652
id: 904087
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6409395
updated: 2026-04-05 03:28:18

Version 903883

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-04/1775290994'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-04/1775290994
id: 903883
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6409012
updated: 2026-04-04 03:24:04

Version 903701

created: 2026-04-03 03:58:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-03/1775206704'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-03/1775206704
id: 903701
processed: 1

raw_data:

{
    "_origin": "18",
    "access_to_all_facilities": "16",
    "account_key": "12",
    "audit_id": "0",
    "email": "4",
    "first_name": "2",
    "gets_emails": "10",
    "gets_inquiries": "11",
    "gets_statements": "9",
    "incontact_agent_no": "17",
    "last_login": "6",
    "last_name": "3",
    "myfoot_role": "13",
    "netsuite_contact_id": "7",
    "netsuite_customer_id": "8",
    "partner_portal_role": "15",
    "phone": "5",
    "pita_role": "14",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

schema_name_id: 859
schema_scan_id: 6408555
updated: 2026-04-03 03:59:06

Schema Scans: 15

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

Scan 6415204

duration: 0:00:12.183744

exit_message:

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

id: 6415204

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-17/1776415071/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-17/1776415071",
        "key": "raw/dwh_dim_user/2026-04-17/1776415071/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7957862417681773391,
        "service_name": "redshift_unloads",
        "span_id": 6749741724856075771,
        "trace_id": 16206982343966696675
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-17 03:38:23
success: True
trace_id: 16206982343966696675

Scan 6414653

duration: 0:00:14.693780

exit_message:

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

id: 6414653

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-16/1776329900/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-16/1776329900",
        "key": "raw/dwh_dim_user/2026-04-16/1776329900/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11821910677899855474,
        "service_name": "redshift_unloads",
        "span_id": 3028673641093168325,
        "trace_id": 7848618394282051894
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-16 03:58:51
success: True
trace_id: 7848618394282051894

Scan 6414178

duration: 0:00:12.092998

exit_message:

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

id: 6414178

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-15/1776242778/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-15/1776242778",
        "key": "raw/dwh_dim_user/2026-04-15/1776242778/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16338207063412663497,
        "service_name": "redshift_unloads",
        "span_id": 18220892467650852734,
        "trace_id": 8636810317652929563
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-15 03:47:02
success: True
trace_id: 8636810317652929563

Scan 6413680

duration: 0:00:12.146341

exit_message:

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

id: 6413680

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-14/1776156824/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-14/1776156824",
        "key": "raw/dwh_dim_user/2026-04-14/1776156824/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12473256783449124798,
        "service_name": "redshift_unloads",
        "span_id": 6446011798676616153,
        "trace_id": 3056056520957552813
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-14 03:54:13
success: True
trace_id: 3056056520957552813

Scan 6413154

duration: 0:00:14.683979

exit_message:

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

id: 6413154

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-13/1776070679/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-13/1776070679",
        "key": "raw/dwh_dim_user/2026-04-13/1776070679/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13347556747952693483,
        "service_name": "redshift_unloads",
        "span_id": 1648889623631225049,
        "trace_id": 14762486393105572616
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-13 03:58:28
success: True
trace_id: 14762486393105572616

Scan 6412716

duration: 0:00:14.586336

exit_message:

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

id: 6412716

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-12/1775983003/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-12/1775983003",
        "key": "raw/dwh_dim_user/2026-04-12/1775983003/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3286725235782207659,
        "service_name": "redshift_unloads",
        "span_id": 7388198909876845290,
        "trace_id": 13359747504145058383
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-12 03:37:14
success: True
trace_id: 13359747504145058383

Scan 6412376

duration: 0:00:12.092937

exit_message:

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

id: 6412376

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-11/1775897345/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-11/1775897345",
        "key": "raw/dwh_dim_user/2026-04-11/1775897345/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3445118802119695894,
        "service_name": "redshift_unloads",
        "span_id": 4645008709080387243,
        "trace_id": 15107694245926422671
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-11 03:49:32
success: True
trace_id: 15107694245926422671

Scan 6411867

duration: 0:00:12.168024

exit_message:

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

id: 6411867

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-10/1775811289/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-10/1775811289",
        "key": "raw/dwh_dim_user/2026-04-10/1775811289/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9976576809149709258,
        "service_name": "redshift_unloads",
        "span_id": 6334028277341719491,
        "trace_id": 1058776390228037994
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-10 03:55:21
success: True
trace_id: 1058776390228037994

Scan 6411360

duration: 0:00:14.645289

exit_message:

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

id: 6411360

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-09/1775725223/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-09/1775725223",
        "key": "raw/dwh_dim_user/2026-04-09/1775725223/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5332068701856601471,
        "service_name": "redshift_unloads",
        "span_id": 18203390251815546326,
        "trace_id": 5696217943528306434
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-09 04:00:56
success: True
trace_id: 5696217943528306434

Scan 6410849

duration: 0:00:12.129255

exit_message:

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

id: 6410849

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-08/1775638334/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-08/1775638334",
        "key": "raw/dwh_dim_user/2026-04-08/1775638334/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13383289788501780277,
        "service_name": "redshift_unloads",
        "span_id": 2193135459694432889,
        "trace_id": 16923566727572958357
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-08 03:52:46
success: True
trace_id: 16923566727572958357

Scan 6410334

duration: 0:00:14.618597

exit_message:

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

id: 6410334

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-07/1775550830/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-07/1775550830",
        "key": "raw/dwh_dim_user/2026-04-07/1775550830/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8054075332414754029,
        "service_name": "redshift_unloads",
        "span_id": 16519690885847708628,
        "trace_id": 12127645347540089136
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-07 03:34:28
success: True
trace_id: 12127645347540089136

Scan 6409818

duration: 0:00:14.692169

exit_message:

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

id: 6409818

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-06/1775466254/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-06/1775466254",
        "key": "raw/dwh_dim_user/2026-04-06/1775466254/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7287819440341456085,
        "service_name": "redshift_unloads",
        "span_id": 6820007816361128990,
        "trace_id": 15926921137581849670
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-06 04:05:08
success: True
trace_id: 15926921137581849670

Scan 6409395

duration: 0:00:11.962234

exit_message:

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

id: 6409395

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-05/1775377652/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-05/1775377652",
        "key": "raw/dwh_dim_user/2026-04-05/1775377652/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1021620543000062878,
        "service_name": "redshift_unloads",
        "span_id": 17048266448128467086,
        "trace_id": 16927009855153376351
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-05 03:28:06
success: True
trace_id: 16927009855153376351

Scan 6409012

duration: 0:00:14.771921

exit_message:

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

id: 6409012

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-04/1775290994/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-04/1775290994",
        "key": "raw/dwh_dim_user/2026-04-04/1775290994/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17400873070882557898,
        "service_name": "redshift_unloads",
        "span_id": 18254715898997182730,
        "trace_id": 3040720180629895330
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-04 03:23:49
success: True
trace_id: 3040720180629895330

Scan 6408555

duration: 0:00:12.010906

exit_message:

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

id: 6408555

payload:

{
    "datatype_dict": {
        "access_to_all_facilities": "int",
        "account_key": "int",
        "audit_id": "bigint",
        "email": "varchar(128)",
        "first_name": "varchar(128)",
        "gets_emails": "int",
        "gets_inquiries": "int",
        "gets_statements": "int",
        "incontact_agent_no": "int",
        "last_login": "timestamp",
        "last_name": "varchar(128)",
        "myfoot_role": "varchar(20)",
        "netsuite_contact_id": "int",
        "netsuite_customer_id": "int",
        "origin_key": "varchar",
        "partner_portal_role": "varchar(20)",
        "phone": "varchar(16)",
        "pita_role": "varchar(20)",
        "user_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_user/2026-04-03/1775206704/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-03/1775206704",
        "key": "raw/dwh_dim_user/2026-04-03/1775206704/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_user",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3823870835549170200,
        "service_name": "redshift_unloads",
        "span_id": 7935037166061696807,
        "trace_id": 8989337077013091904
    }
}

running: False
schema_name_id: 859
start_time: 2026-04-03 03:58:54
success: True
trace_id: 8989337077013091904

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "access_to_all_facilities": "int",
    "account_key": "int",
    "audit_id": "bigint",
    "email": "varchar(128)",
    "first_name": "varchar(128)",
    "gets_emails": "int",
    "gets_inquiries": "int",
    "gets_statements": "int",
    "incontact_agent_no": "int",
    "last_login": "timestamp",
    "last_name": "varchar(128)",
    "myfoot_role": "varchar(20)",
    "netsuite_contact_id": "int",
    "netsuite_customer_id": "int",
    "partner_portal_role": "varchar(20)",
    "phone": "varchar(16)",
    "pita_role": "varchar(20)",
    "user_key": "bigint"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-17/1776415071'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-07-31 10:37:35",
        "disabled": false,
        "format": "raw",
        "id": 859,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_user"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "access_to_all_facilities": "int",
            "account_key": "int",
            "audit_id": "bigint",
            "email": "varchar(128)",
            "first_name": "varchar(128)",
            "gets_emails": "int",
            "gets_inquiries": "int",
            "gets_statements": "int",
            "incontact_agent_no": "int",
            "last_login": "timestamp",
            "last_name": "varchar(128)",
            "myfoot_role": "varchar(20)",
            "netsuite_contact_id": "int",
            "netsuite_customer_id": "int",
            "partner_portal_role": "varchar(20)",
            "phone": "varchar(16)",
            "pita_role": "varchar(20)",
            "user_key": "bigint"
        },
        "created": "2026-04-17 03:38:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_user`\n(\n `audit_id`  bigint , `user_key`  bigint , `first_name`  varchar(128) , `last_name`  varchar(128) , `email`  varchar(128) , `phone`  varchar(16) , `last_login`  timestamp , `netsuite_contact_id`  int , `netsuite_customer_id`  int , `gets_statements`  int , `gets_emails`  int , `gets_inquiries`  int , `account_key`  int , `myfoot_role`  varchar(20) , `pita_role`  varchar(20) , `partner_portal_role`  varchar(20) , `access_to_all_facilities`  int , `incontact_agent_no`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_user/2026-04-17/1776415071'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_user`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_user"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}