Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_client

created: 2018-02-28 10:53:18
disabled: False
format: raw
id: 257
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717886

created: 2026-04-17 03:34:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-17/1776414884'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-17/1776414884
id: 1717886
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 162167999
updated: 2026-04-17 03:35:11

Version 1716647

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-16/1776330313'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-16/1776330313
id: 1716647
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 162113294
updated: 2026-04-16 04:05:36

Version 1715565

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-15/1776243011'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-15/1776243011
id: 1715565
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 162056516
updated: 2026-04-15 03:50:30

Version 1714289

created: 2026-04-14 04:03:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-14/1776157414'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-14/1776157414
id: 1714289
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 162001928
updated: 2026-04-14 04:03:57

Version 1713040

created: 2026-04-13 03:59:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-13/1776070696'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-13/1776070696
id: 1713040
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161943699
updated: 2026-04-13 03:59:15

Version 1711848

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-12/1775984169'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-12/1775984169
id: 1711848
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161893916
updated: 2026-04-12 03:56:37

Version 1710615

created: 2026-04-11 03:41:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-11/1775896884'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-11/1775896884
id: 1710615
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161841458
updated: 2026-04-11 03:41:43

Version 1709442

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-10/1775809818'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-10/1775809818
id: 1709442
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161786191
updated: 2026-04-10 03:30:37

Version 1708345

created: 2026-04-09 03:51:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-09/1775724648'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-09/1775724648
id: 1708345
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161730728
updated: 2026-04-09 03:51:14

Version 1707135

created: 2026-04-08 04:01:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-08/1775638854'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-08/1775638854
id: 1707135
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161676887
updated: 2026-04-08 04:02:10

Version 1705949

created: 2026-04-07 03:53:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-07/1775552022'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-07/1775552022
id: 1705949
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161619842
updated: 2026-04-07 03:54:03

Version 1704700

created: 2026-04-06 03:50:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-06/1775465432'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-06/1775465432
id: 1704700
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161561924
updated: 2026-04-06 03:50:52

Version 1703478

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-05/1775378019'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-05/1775378019
id: 1703478
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161515091
updated: 2026-04-05 03:34:01

Version 1702326

created: 2026-04-04 03:32:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-04/1775291523'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-04/1775291523
id: 1702326
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161460697
updated: 2026-04-04 03:32:32

Version 1701167

created: 2026-04-03 03:52:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-03/1775206331'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-03/1775206331
id: 1701167
processed: 1

raw_data:

{
    "_origin": "6",
    "account_key": "3",
    "account_pricing_model": "4",
    "audit_id": "0",
    "client_key": "1",
    "client_name": "2",
    "residual_percent": "5"
}

schema_attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

schema_name_id: 257
schema_scan_id: 161402361
updated: 2026-04-03 03:53:03

Schema Scans: 15

Last at 2026-04-17 03:34:59

Scan 162167999

duration: 0:00:11.803790

exit_message:

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

id: 162167999

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-17/1776414884/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-17/1776414884",
        "key": "raw/dwh_dim_client/2026-04-17/1776414884/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9371337382588020829,
        "service_name": "redshift_unloads",
        "span_id": 12113651984480121820,
        "trace_id": 12117762203105017756
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-17 03:34:59
success: True
trace_id: 12117762203105017756

Scan 162113294

duration: 0:00:14.362292

exit_message:

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

id: 162113294

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-16/1776330313/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-16/1776330313",
        "key": "raw/dwh_dim_client/2026-04-16/1776330313/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14369561712742896483,
        "service_name": "redshift_unloads",
        "span_id": 15269917780157119848,
        "trace_id": 12936946527573783048
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-16 04:05:22
success: True
trace_id: 12936946527573783048

Scan 162056516

duration: 0:00:11.689760

exit_message:

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

id: 162056516

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-15/1776243011/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-15/1776243011",
        "key": "raw/dwh_dim_client/2026-04-15/1776243011/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14534857604664942504,
        "service_name": "redshift_unloads",
        "span_id": 16033258230113000000,
        "trace_id": 7040040968112957289
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-15 03:50:18
success: True
trace_id: 7040040968112957289

Scan 162001928

duration: 0:00:14.226709

exit_message:

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

id: 162001928

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-14/1776157414/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-14/1776157414",
        "key": "raw/dwh_dim_client/2026-04-14/1776157414/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7746381930648687648,
        "service_name": "redshift_unloads",
        "span_id": 1512184804990224881,
        "trace_id": 10898354517891302670
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-14 04:03:43
success: True
trace_id: 10898354517891302670

Scan 161943699

duration: 0:00:11.701623

exit_message:

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

id: 161943699

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-13/1776070696/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-13/1776070696",
        "key": "raw/dwh_dim_client/2026-04-13/1776070696/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18048760074577704160,
        "service_name": "redshift_unloads",
        "span_id": 16668228375306331827,
        "trace_id": 13977859915847332361
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-13 03:59:03
success: True
trace_id: 13977859915847332361

Scan 161893916

duration: 0:00:14.221721

exit_message:

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

id: 161893916

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-12/1775984169/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-12/1775984169",
        "key": "raw/dwh_dim_client/2026-04-12/1775984169/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13126881144093152900,
        "service_name": "redshift_unloads",
        "span_id": 12369255606182889833,
        "trace_id": 2017631722884666986
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-12 03:56:23
success: True
trace_id: 2017631722884666986

Scan 161841458

duration: 0:00:11.697866

exit_message:

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

id: 161841458

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-11/1775896884/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-11/1775896884",
        "key": "raw/dwh_dim_client/2026-04-11/1775896884/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17192702202911099647,
        "service_name": "redshift_unloads",
        "span_id": 2882361918636440786,
        "trace_id": 12600321476762227871
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-11 03:41:31
success: True
trace_id: 12600321476762227871

Scan 161786191

duration: 0:00:11.895157

exit_message:

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

id: 161786191

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-10/1775809818/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-10/1775809818",
        "key": "raw/dwh_dim_client/2026-04-10/1775809818/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7216568873784156116,
        "service_name": "redshift_unloads",
        "span_id": 4018648092445397981,
        "trace_id": 2617854148602088001
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-10 03:30:25
success: True
trace_id: 2617854148602088001

Scan 161730728

duration: 0:00:14.229612

exit_message:

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

id: 161730728

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-09/1775724648/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-09/1775724648",
        "key": "raw/dwh_dim_client/2026-04-09/1775724648/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17908132826816830078,
        "service_name": "redshift_unloads",
        "span_id": 17214951981185334976,
        "trace_id": 11357236760606365924
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-09 03:50:59
success: True
trace_id: 11357236760606365924

Scan 161676887

duration: 0:00:14.247285

exit_message:

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

id: 161676887

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-08/1775638854/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-08/1775638854",
        "key": "raw/dwh_dim_client/2026-04-08/1775638854/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8681929097111570790,
        "service_name": "redshift_unloads",
        "span_id": 8835859398969027970,
        "trace_id": 15757822714974943065
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-08 04:01:56
success: True
trace_id: 15757822714974943065

Scan 161619842

duration: 0:00:14.227114

exit_message:

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

id: 161619842

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-07/1775552022/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-07/1775552022",
        "key": "raw/dwh_dim_client/2026-04-07/1775552022/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8903351820386714033,
        "service_name": "redshift_unloads",
        "span_id": 2228861413669607306,
        "trace_id": 11114218904775124266
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-07 03:53:49
success: True
trace_id: 11114218904775124266

Scan 161561924

duration: 0:00:11.734931

exit_message:

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

id: 161561924

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-06/1775465432/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-06/1775465432",
        "key": "raw/dwh_dim_client/2026-04-06/1775465432/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4740563922004119355,
        "service_name": "redshift_unloads",
        "span_id": 9604488093849445091,
        "trace_id": 9715141494632556986
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-06 03:50:40
success: True
trace_id: 9715141494632556986

Scan 161515091

duration: 0:00:11.616884

exit_message:

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

id: 161515091

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-05/1775378019/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-05/1775378019",
        "key": "raw/dwh_dim_client/2026-04-05/1775378019/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13852705410021386922,
        "service_name": "redshift_unloads",
        "span_id": 550169488356079490,
        "trace_id": 12014580984822281290
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-05 03:33:49
success: True
trace_id: 12014580984822281290

Scan 161460697

duration: 0:00:14.270169

exit_message:

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

id: 161460697

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-04/1775291523/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-04/1775291523",
        "key": "raw/dwh_dim_client/2026-04-04/1775291523/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12752017477518608313,
        "service_name": "redshift_unloads",
        "span_id": 12263724336921773371,
        "trace_id": 16039156322272630215
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-04 03:32:18
success: True
trace_id: 16039156322272630215

Scan 161402361

duration: 0:00:14.113964

exit_message:

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

id: 161402361

payload:

{
    "datatype_dict": {
        "account_key": "int",
        "account_pricing_model": "varchar(10)",
        "audit_id": "bigint",
        "client_key": "bigint",
        "client_name": "varchar(255)",
        "origin_key": "varchar",
        "residual_percent": "double"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_client/2026-04-03/1775206331/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-03/1775206331",
        "key": "raw/dwh_dim_client/2026-04-03/1775206331/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_client",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16258037359420677577,
        "service_name": "redshift_unloads",
        "span_id": 14736937241996836794,
        "trace_id": 2993105707895356979
    }
}

running: False
schema_name_id: 257
start_time: 2026-04-03 03:52:49
success: True
trace_id: 2993105707895356979

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "account_key": "int",
    "account_pricing_model": "varchar(10)",
    "audit_id": "bigint",
    "client_key": "bigint",
    "client_name": "varchar(255)",
    "residual_percent": "double"
}

created: 2026-04-17 03:34:59

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-17/1776414884'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-28 10:53:18",
        "disabled": false,
        "format": "raw",
        "id": 257,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_client"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "account_key": "int",
            "account_pricing_model": "varchar(10)",
            "audit_id": "bigint",
            "client_key": "bigint",
            "client_name": "varchar(255)",
            "residual_percent": "double"
        },
        "created": "2026-04-17 03:34:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_client`\n(\n `audit_id`  bigint , `client_key`  bigint , `client_name`  varchar(255) , `account_key`  int , `account_pricing_model`  varchar(10) , `residual_percent`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_client/2026-04-17/1776414884'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_client`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_client"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}