Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_filtered_ip

created: 2018-02-21 00:00:56
disabled: False
format: raw
id: 392
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906656

created: 2026-04-17 03:55:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-17/1776416127'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-17/1776416127
id: 906656
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6415236
updated: 2026-04-17 03:55:57

Version 906427

created: 2026-04-16 04:01:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-16/1776330046'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-16/1776330046
id: 906427
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6414678
updated: 2026-04-16 04:01:16

Version 906219

created: 2026-04-15 03:58:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-15/1776243500'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-15/1776243500
id: 906219
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6414195
updated: 2026-04-15 03:58:57

Version 906007

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-14/1776156946'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-14/1776156946
id: 906007
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6413693
updated: 2026-04-14 03:56:07

Version 905787

created: 2026-04-13 03:40:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-13/1776069617'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-13/1776069617
id: 905787
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6413143
updated: 2026-04-13 03:40:56

Version 905584

created: 2026-04-12 04:02:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-12/1775984542'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-12/1775984542
id: 905584
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6412748
updated: 2026-04-12 04:02:49

Version 905364

created: 2026-04-11 03:30:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-11/1775896211'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-11/1775896211
id: 905364
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6412349
updated: 2026-04-11 03:31:10

Version 905165

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-10/1775811327'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-10/1775811327
id: 905165
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6411870
updated: 2026-04-10 03:55:59

Version 904927

created: 2026-04-09 03:50:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-09/1775724596'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-09/1775724596
id: 904927
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6411329
updated: 2026-04-09 03:50:20

Version 904714

created: 2026-04-08 03:32:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-08/1775637152'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-08/1775637152
id: 904714
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6410835
updated: 2026-04-08 03:33:03

Version 904529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-07/1775552017'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-07/1775552017
id: 904529
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6410355
updated: 2026-04-07 03:54:06

Version 904312

created: 2026-04-06 03:56:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-06/1775465794'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-06/1775465794
id: 904312
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6409806
updated: 2026-04-06 03:57:03

Version 904102

created: 2026-04-05 03:45:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-05/1775378717'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-05/1775378717
id: 904102
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6409410
updated: 2026-04-05 03:45:46

Version 903908

created: 2026-04-04 03:44:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-04/1775292209'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-04/1775292209
id: 903908
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6409037
updated: 2026-04-04 03:44:20

Version 903690

created: 2026-04-03 03:51:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-03/1775206252'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_filtered_ip/2026-04-03/1775206252
id: 903690
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "created_date": "3",
    "ip_address": "1",
    "job_id": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

schema_name_id: 392
schema_scan_id: 6408544
updated: 2026-04-03 03:51:15

Schema Scans: 15

Last at 2026-04-17 03:55:43

Scan 6415236

duration: 0:00:14.293871

exit_message:

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

id: 6415236

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-17/1776416127/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_filtered_ip/2026-04-17/1776416127",
        "key": "raw/dwh_dim_filtered_ip/2026-04-17/1776416127/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12682012452284135946,
        "service_name": "redshift_unloads",
        "span_id": 3261696701275980483,
        "trace_id": 16977234496822186022
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-17 03:55:43
success: True
trace_id: 16977234496822186022

Scan 6414678

duration: 0:00:14.270780

exit_message:

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

id: 6414678

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-16/1776330046/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_filtered_ip/2026-04-16/1776330046",
        "key": "raw/dwh_dim_filtered_ip/2026-04-16/1776330046/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1712601040692638651,
        "service_name": "redshift_unloads",
        "span_id": 6084642732133681952,
        "trace_id": 5039250256332974766
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-16 04:01:02
success: True
trace_id: 5039250256332974766

Scan 6414195

duration: 0:00:14.372235

exit_message:

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

id: 6414195

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-15/1776243500/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_filtered_ip/2026-04-15/1776243500",
        "key": "raw/dwh_dim_filtered_ip/2026-04-15/1776243500/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9366487453048899140,
        "service_name": "redshift_unloads",
        "span_id": 12235759419370095052,
        "trace_id": 3721859790747956810
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-15 03:58:43
success: True
trace_id: 3721859790747956810

Scan 6413693

duration: 0:00:11.643290

exit_message:

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

id: 6413693

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-14/1776156946/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_filtered_ip/2026-04-14/1776156946",
        "key": "raw/dwh_dim_filtered_ip/2026-04-14/1776156946/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13383460231875313800,
        "service_name": "redshift_unloads",
        "span_id": 14235722392438386996,
        "trace_id": 11733333429586698684
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-14 03:55:56
success: True
trace_id: 11733333429586698684

Scan 6413143

duration: 0:00:11.642762

exit_message:

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

id: 6413143

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-13/1776069617/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_filtered_ip/2026-04-13/1776069617",
        "key": "raw/dwh_dim_filtered_ip/2026-04-13/1776069617/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2589018258832887189,
        "service_name": "redshift_unloads",
        "span_id": 8228113540317239298,
        "trace_id": 3818021836954117457
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-13 03:40:44
success: True
trace_id: 3818021836954117457

Scan 6412748

duration: 0:00:14.336077

exit_message:

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

id: 6412748

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-12/1775984542/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_filtered_ip/2026-04-12/1775984542",
        "key": "raw/dwh_dim_filtered_ip/2026-04-12/1775984542/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17532930175778420029,
        "service_name": "redshift_unloads",
        "span_id": 14024713023836040114,
        "trace_id": 792032517358906557
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-12 04:02:35
success: True
trace_id: 792032517358906557

Scan 6412349

duration: 0:00:11.707861

exit_message:

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

id: 6412349

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-11/1775896211/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_filtered_ip/2026-04-11/1775896211",
        "key": "raw/dwh_dim_filtered_ip/2026-04-11/1775896211/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10489688633575416226,
        "service_name": "redshift_unloads",
        "span_id": 7726928799557705106,
        "trace_id": 9086846815222030468
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-11 03:30:58
success: True
trace_id: 9086846815222030468

Scan 6411870

duration: 0:00:14.249566

exit_message:

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

id: 6411870

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-10/1775811327/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_filtered_ip/2026-04-10/1775811327",
        "key": "raw/dwh_dim_filtered_ip/2026-04-10/1775811327/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17046799303681682596,
        "service_name": "redshift_unloads",
        "span_id": 5484699747873602542,
        "trace_id": 6268866710944115438
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-10 03:55:45
success: True
trace_id: 6268866710944115438

Scan 6411329

duration: 0:00:11.683557

exit_message:

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

id: 6411329

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-09/1775724596/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_filtered_ip/2026-04-09/1775724596",
        "key": "raw/dwh_dim_filtered_ip/2026-04-09/1775724596/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4689892877565655632,
        "service_name": "redshift_unloads",
        "span_id": 17112045522282793389,
        "trace_id": 3220368511723728998
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-09 03:50:08
success: True
trace_id: 3220368511723728998

Scan 6410835

duration: 0:00:14.280157

exit_message:

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

id: 6410835

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-08/1775637152/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_filtered_ip/2026-04-08/1775637152",
        "key": "raw/dwh_dim_filtered_ip/2026-04-08/1775637152/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5781829848447816156,
        "service_name": "redshift_unloads",
        "span_id": 12198465093945528439,
        "trace_id": 13898564981145224964
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-08 03:32:49
success: True
trace_id: 13898564981145224964

Scan 6410355

duration: 0:00:14.225684

exit_message:

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

id: 6410355

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-07/1775552017/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_filtered_ip/2026-04-07/1775552017",
        "key": "raw/dwh_dim_filtered_ip/2026-04-07/1775552017/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3626019727672429903,
        "service_name": "redshift_unloads",
        "span_id": 3172345942562078093,
        "trace_id": 10720671180960520522
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-07 03:53:52
success: True
trace_id: 10720671180960520522

Scan 6409806

duration: 0:00:11.629646

exit_message:

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

id: 6409806

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-06/1775465794/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_filtered_ip/2026-04-06/1775465794",
        "key": "raw/dwh_dim_filtered_ip/2026-04-06/1775465794/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6098026142478918446,
        "service_name": "redshift_unloads",
        "span_id": 12249832861031798351,
        "trace_id": 8860485853240662793
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-06 03:56:51
success: True
trace_id: 8860485853240662793

Scan 6409410

duration: 0:00:11.713296

exit_message:

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

id: 6409410

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-05/1775378717/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_filtered_ip/2026-04-05/1775378717",
        "key": "raw/dwh_dim_filtered_ip/2026-04-05/1775378717/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13316888600826339399,
        "service_name": "redshift_unloads",
        "span_id": 3722261116450933490,
        "trace_id": 11361362220855047798
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-05 03:45:34
success: True
trace_id: 11361362220855047798

Scan 6409037

duration: 0:00:14.300582

exit_message:

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

id: 6409037

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-04/1775292209/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_filtered_ip/2026-04-04/1775292209",
        "key": "raw/dwh_dim_filtered_ip/2026-04-04/1775292209/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10046308894382133506,
        "service_name": "redshift_unloads",
        "span_id": 825292269085199963,
        "trace_id": 4264976394422975661
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-04 03:44:06
success: True
trace_id: 4264976394422975661

Scan 6408544

duration: 0:00:11.652595

exit_message:

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

id: 6408544

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "created_date": "timestamp",
        "ip_address": "varchar(32)",
        "job_id": "varchar(13)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_filtered_ip/2026-04-03/1775206252/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_filtered_ip/2026-04-03/1775206252",
        "key": "raw/dwh_dim_filtered_ip/2026-04-03/1775206252/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16872932251698223997,
        "service_name": "redshift_unloads",
        "span_id": 14965590031758988476,
        "trace_id": 17738934028502608351
    }
}

running: False
schema_name_id: 392
start_time: 2026-04-03 03:51:03
success: True
trace_id: 17738934028502608351

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "created_date": "timestamp",
    "ip_address": "varchar(32)",
    "job_id": "varchar(13)"
}

created: 2026-04-17 03:55:43

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_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-17/1776416127'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-21 00:00:56",
        "disabled": false,
        "format": "raw",
        "id": 392,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_filtered_ip"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "created_date": "timestamp",
            "ip_address": "varchar(32)",
            "job_id": "varchar(13)"
        },
        "created": "2026-04-17 03:55:43",
        "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_filtered_ip`\n(\n `audit_id`  bigint , `ip_address`  varchar(32) , `job_id`  varchar(13) , `created_date`  timestamp , `_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_filtered_ip/2026-04-17/1776416127'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_filtered_ip`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_filtered_ip"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}