Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_filtered_ip

created: 2018-02-28 10:54:10
disabled: False
format: raw
id: 260
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717864

created: 2026-04-17 03:19:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-17/1776413976'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-17/1776413976
id: 1717864
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: 260
schema_scan_id: 162167910
updated: 2026-04-17 03:20:11

Version 1716632

created: 2026-04-16 03:55:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-16/1776329726'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-16/1776329726
id: 1716632
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: 260
schema_scan_id: 162112380
updated: 2026-04-16 03:55:49

Version 1715580

created: 2026-04-15 04:01:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-15/1776243657'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-15/1776243657
id: 1715580
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: 260
schema_scan_id: 162057549
updated: 2026-04-15 04:02:04

Version 1714253

created: 2026-04-14 03:42:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-14/1776156125'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-14/1776156125
id: 1714253
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: 260
schema_scan_id: 162000821
updated: 2026-04-14 03:42:31

Version 1713036

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-13/1776070670'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-13/1776070670
id: 1713036
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: 260
schema_scan_id: 161943562
updated: 2026-04-13 03:58:20

Version 1711821

created: 2026-04-12 03:47:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-12/1775983625'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-12/1775983625
id: 1711821
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: 260
schema_scan_id: 161893635
updated: 2026-04-12 03:47:26

Version 1710611

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-11/1775896859'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-11/1775896859
id: 1710611
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: 260
schema_scan_id: 161841448
updated: 2026-04-11 03:41:22

Version 1709449

created: 2026-04-10 03:47:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-10/1775810858'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-10/1775810858
id: 1709449
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: 260
schema_scan_id: 161786233
updated: 2026-04-10 03:48:04

Version 1708310

created: 2026-04-09 03:29:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-09/1775723384'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-09/1775723384
id: 1708310
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: 260
schema_scan_id: 161730628
updated: 2026-04-09 03:30:08

Version 1707108

created: 2026-04-08 03:35:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-08/1775637327'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-08/1775637327
id: 1707108
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: 260
schema_scan_id: 161675817
updated: 2026-04-08 03:35:54

Version 1705946

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-07/1775552001'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-07/1775552001
id: 1705946
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: 260
schema_scan_id: 161619839
updated: 2026-04-07 03:53:50

Version 1704729

created: 2026-04-06 04:01:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-06/1775466091'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-06/1775466091
id: 1704729
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: 260
schema_scan_id: 161562922
updated: 2026-04-06 04:01:55

Version 1703501

created: 2026-04-05 03:56:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-05/1775379366'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-05/1775379366
id: 1703501
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: 260
schema_scan_id: 161515455
updated: 2026-04-05 03:56:33

Version 1702329

created: 2026-04-04 03:32:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-04/1775291539'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-04/1775291539
id: 1702329
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: 260
schema_scan_id: 161460700
updated: 2026-04-04 03:32:42

Version 1701161

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_filtered_ip/2026-04-03/1775206308'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_filtered_ip/2026-04-03/1775206308
id: 1701161
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: 260
schema_scan_id: 161402352
updated: 2026-04-03 03:52:15

Schema Scans: 15

Last at 2026-04-17 03:19:57

Scan 162167910

duration: 0:00:14.373563

exit_message:

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

id: 162167910

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-17/1776413976/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_filtered_ip/2026-04-17/1776413976",
        "key": "raw/dwh_dim_filtered_ip/2026-04-17/1776413976/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8080197996532841195,
        "service_name": "redshift_unloads",
        "span_id": 15943969613935957820,
        "trace_id": 17386814598796037367
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-17 03:19:57
success: True
trace_id: 17386814598796037367

Scan 162112380

duration: 0:00:14.176799

exit_message:

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

id: 162112380

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-16/1776329726/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_filtered_ip/2026-04-16/1776329726",
        "key": "raw/dwh_dim_filtered_ip/2026-04-16/1776329726/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12816798742517297945,
        "service_name": "redshift_unloads",
        "span_id": 14655343225899514603,
        "trace_id": 13471086677551257196
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-16 03:55:35
success: True
trace_id: 13471086677551257196

Scan 162057549

duration: 0:00:14.140562

exit_message:

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

id: 162057549

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-15/1776243657/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_filtered_ip/2026-04-15/1776243657",
        "key": "raw/dwh_dim_filtered_ip/2026-04-15/1776243657/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3485836527851218718,
        "service_name": "redshift_unloads",
        "span_id": 9590187066370749517,
        "trace_id": 16224102496767819930
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-15 04:01:50
success: True
trace_id: 16224102496767819930

Scan 162000821

duration: 0:00:11.682486

exit_message:

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

id: 162000821

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-14/1776156125/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_filtered_ip/2026-04-14/1776156125",
        "key": "raw/dwh_dim_filtered_ip/2026-04-14/1776156125/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6795664345810619207,
        "service_name": "redshift_unloads",
        "span_id": 11323983273392827578,
        "trace_id": 8196038091461584189
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-14 03:42:19
success: True
trace_id: 8196038091461584189

Scan 161943562

duration: 0:00:11.622632

exit_message:

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

id: 161943562

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-13/1776070670/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_filtered_ip/2026-04-13/1776070670",
        "key": "raw/dwh_dim_filtered_ip/2026-04-13/1776070670/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5057332644383849225,
        "service_name": "redshift_unloads",
        "span_id": 2346636711660363755,
        "trace_id": 13512498294852623023
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-13 03:58:08
success: True
trace_id: 13512498294852623023

Scan 161893635

duration: 0:00:11.576737

exit_message:

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

id: 161893635

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-12/1775983625/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_filtered_ip/2026-04-12/1775983625",
        "key": "raw/dwh_dim_filtered_ip/2026-04-12/1775983625/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 597287252117659870,
        "service_name": "redshift_unloads",
        "span_id": 4253757293723351671,
        "trace_id": 15479316909795994387
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-12 03:47:14
success: True
trace_id: 15479316909795994387

Scan 161841448

duration: 0:00:14.154046

exit_message:

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

id: 161841448

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-11/1775896859/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_filtered_ip/2026-04-11/1775896859",
        "key": "raw/dwh_dim_filtered_ip/2026-04-11/1775896859/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14051211667303487177,
        "service_name": "redshift_unloads",
        "span_id": 1393913788711796159,
        "trace_id": 7028382022229576692
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-11 03:41:08
success: True
trace_id: 7028382022229576692

Scan 161786233

duration: 0:00:14.228172

exit_message:

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

id: 161786233

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-10/1775810858/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_filtered_ip/2026-04-10/1775810858",
        "key": "raw/dwh_dim_filtered_ip/2026-04-10/1775810858/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3760154508408860296,
        "service_name": "redshift_unloads",
        "span_id": 5580719426162267095,
        "trace_id": 8953772173258763388
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-10 03:47:50
success: True
trace_id: 8953772173258763388

Scan 161730628

duration: 0:00:11.608116

exit_message:

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

id: 161730628

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-09/1775723384/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_filtered_ip/2026-04-09/1775723384",
        "key": "raw/dwh_dim_filtered_ip/2026-04-09/1775723384/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7116925559996435862,
        "service_name": "redshift_unloads",
        "span_id": 5244635156260677676,
        "trace_id": 1260132511147505058
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-09 03:29:56
success: True
trace_id: 1260132511147505058

Scan 161675817

duration: 0:00:14.253647

exit_message:

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

id: 161675817

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-08/1775637327/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_filtered_ip/2026-04-08/1775637327",
        "key": "raw/dwh_dim_filtered_ip/2026-04-08/1775637327/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16886436260148903555,
        "service_name": "redshift_unloads",
        "span_id": 3644514268887953969,
        "trace_id": 3814861016031070730
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-08 03:35:40
success: True
trace_id: 3814861016031070730

Scan 161619839

duration: 0:00:11.810835

exit_message:

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

id: 161619839

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-07/1775552001/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_filtered_ip/2026-04-07/1775552001",
        "key": "raw/dwh_dim_filtered_ip/2026-04-07/1775552001/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12874762625281601998,
        "service_name": "redshift_unloads",
        "span_id": 1297649561435579222,
        "trace_id": 17957092076899872394
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-07 03:53:38
success: True
trace_id: 17957092076899872394

Scan 161562922

duration: 0:00:14.227991

exit_message:

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

id: 161562922

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-06/1775466091/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_filtered_ip/2026-04-06/1775466091",
        "key": "raw/dwh_dim_filtered_ip/2026-04-06/1775466091/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15823986452757290587,
        "service_name": "redshift_unloads",
        "span_id": 8665295413533184705,
        "trace_id": 11935308928870853515
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-06 04:01:41
success: True
trace_id: 11935308928870853515

Scan 161515455

duration: 0:00:11.649023

exit_message:

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

id: 161515455

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-05/1775379366/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_filtered_ip/2026-04-05/1775379366",
        "key": "raw/dwh_dim_filtered_ip/2026-04-05/1775379366/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8018884146536608380,
        "service_name": "redshift_unloads",
        "span_id": 16432898380736985995,
        "trace_id": 16013480168086219052
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-05 03:56:21
success: True
trace_id: 16013480168086219052

Scan 161460700

duration: 0:00:14.229485

exit_message:

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

id: 161460700

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-04/1775291539/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_filtered_ip/2026-04-04/1775291539",
        "key": "raw/dwh_dim_filtered_ip/2026-04-04/1775291539/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2601713316466910782,
        "service_name": "redshift_unloads",
        "span_id": 13840183940738068261,
        "trace_id": 13330077737102473066
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-04 03:32:28
success: True
trace_id: 13330077737102473066

Scan 161402352

duration: 0:00:11.600138

exit_message:

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

id: 161402352

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-prod",
            "key": "meta/dwh_dim_filtered_ip/2026-04-03/1775206308/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_filtered_ip/2026-04-03/1775206308",
        "key": "raw/dwh_dim_filtered_ip/2026-04-03/1775206308/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_filtered_ip",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8187096090677713390,
        "service_name": "redshift_unloads",
        "span_id": 15373535152510292278,
        "trace_id": 5616137220239956026
    }
}

running: False
schema_name_id: 260
start_time: 2026-04-03 03:52:03
success: True
trace_id: 5616137220239956026

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:19:57

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_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-prod/raw/dwh_dim_filtered_ip/2026-04-17/1776413976'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
}

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:54:10",
        "disabled": false,
        "format": "raw",
        "id": 260,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:19:57",
        "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_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-prod/raw/dwh_dim_filtered_ip/2026-04-17/1776413976'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_filtered_ip`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_filtered_ip"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}