Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_traffic_source

created: 2018-02-20 23:59:02
disabled: False
format: raw
id: 388
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906653

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-17/1776415830'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-17/1776415830
id: 906653
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6415233
updated: 2026-04-17 03:50:52

Version 906429

created: 2026-04-16 04:01:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-16/1776330040'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-16/1776330040
id: 906429
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6414679
updated: 2026-04-16 04:01:18

Version 906192

created: 2026-04-15 03:46:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-15/1776242743'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-15/1776242743
id: 906192
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6414168
updated: 2026-04-15 03:46:11

Version 906004

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-14/1776156930'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-14/1776156930
id: 906004
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6413690
updated: 2026-04-14 03:55:53

Version 905782

created: 2026-04-13 03:35:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-13/1776069297'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-13/1776069297
id: 905782
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6413138
updated: 2026-04-13 03:35:15

Version 905574

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-12/1775984104'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-12/1775984104
id: 905574
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6412738
updated: 2026-04-12 03:55:35

Version 905369

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-11/1775896323'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-11/1775896323
id: 905369
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6412354
updated: 2026-04-11 03:32:35

Version 905147

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-10/1775809471'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-10/1775809471
id: 905147
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6411851
updated: 2026-04-10 03:25:02

Version 904930

created: 2026-04-09 03:55:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-09/1775724916'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-09/1775724916
id: 904930
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6411332
updated: 2026-04-09 03:55:52

Version 904717

created: 2026-04-08 03:38:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-08/1775637498'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-08/1775637498
id: 904717
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6410838
updated: 2026-04-08 03:38:40

Version 904526

created: 2026-04-07 03:48:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-07/1775551676'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-07/1775551676
id: 904526
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6410352
updated: 2026-04-07 03:48:15

Version 904310

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-06/1775465787'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-06/1775465787
id: 904310
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6409804
updated: 2026-04-06 03:56:48

Version 904118

created: 2026-04-05 04:05:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-05/1775379874'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-05/1775379874
id: 904118
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6409426
updated: 2026-04-05 04:05:18

Version 903905

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-04/1775291974'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-04/1775291974
id: 903905
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6409034
updated: 2026-04-04 03:40:06

Version 903677

created: 2026-04-03 03:44:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-03/1775205883'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_traffic_source/2026-04-03/1775205883
id: 903677
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "first_appearance": "4",
    "last_modified": "5",
    "traffic_source": "2",
    "traffic_source_key": "1",
    "traffic_source_op_id": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

schema_name_id: 388
schema_scan_id: 6408531
updated: 2026-04-03 03:45:01

Schema Scans: 15

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

Scan 6415233

duration: 0:00:14.408376

exit_message:

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

id: 6415233

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-17/1776415830/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_traffic_source/2026-04-17/1776415830",
        "key": "raw/dwh_dim_traffic_source/2026-04-17/1776415830/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12869943207096895560,
        "service_name": "redshift_unloads",
        "span_id": 14525625872432820500,
        "trace_id": 10623741544881056596
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-17 03:50:37
success: True
trace_id: 10623741544881056596

Scan 6414679

duration: 0:00:11.750546

exit_message:

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

id: 6414679

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-16/1776330040/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_traffic_source/2026-04-16/1776330040",
        "key": "raw/dwh_dim_traffic_source/2026-04-16/1776330040/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15076645923303971292,
        "service_name": "redshift_unloads",
        "span_id": 11143950702474058882,
        "trace_id": 16059360152019536940
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-16 04:01:07
success: True
trace_id: 16059360152019536940

Scan 6414168

duration: 0:00:11.745622

exit_message:

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

id: 6414168

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-15/1776242743/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_traffic_source/2026-04-15/1776242743",
        "key": "raw/dwh_dim_traffic_source/2026-04-15/1776242743/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3610492085691314544,
        "service_name": "redshift_unloads",
        "span_id": 4015567544816572446,
        "trace_id": 17357566413954875330
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-15 03:45:59
success: True
trace_id: 17357566413954875330

Scan 6413690

duration: 0:00:11.744990

exit_message:

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

id: 6413690

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-14/1776156930/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_traffic_source/2026-04-14/1776156930",
        "key": "raw/dwh_dim_traffic_source/2026-04-14/1776156930/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10223931265372883167,
        "service_name": "redshift_unloads",
        "span_id": 13349046652413848576,
        "trace_id": 2972025567295139326
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-14 03:55:41
success: True
trace_id: 2972025567295139326

Scan 6413138

duration: 0:00:11.878919

exit_message:

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

id: 6413138

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-13/1776069297/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_traffic_source/2026-04-13/1776069297",
        "key": "raw/dwh_dim_traffic_source/2026-04-13/1776069297/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9057944668603833034,
        "service_name": "redshift_unloads",
        "span_id": 13914672463298808308,
        "trace_id": 12700156181441762314
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-13 03:35:03
success: True
trace_id: 12700156181441762314

Scan 6412738

duration: 0:00:14.369600

exit_message:

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

id: 6412738

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-12/1775984104/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_traffic_source/2026-04-12/1775984104",
        "key": "raw/dwh_dim_traffic_source/2026-04-12/1775984104/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16321476648244408823,
        "service_name": "redshift_unloads",
        "span_id": 3602661077243541250,
        "trace_id": 14014686478660889719
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-12 03:55:21
success: True
trace_id: 14014686478660889719

Scan 6412354

duration: 0:00:14.256623

exit_message:

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

id: 6412354

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-11/1775896323/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_traffic_source/2026-04-11/1775896323",
        "key": "raw/dwh_dim_traffic_source/2026-04-11/1775896323/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4642869979966982419,
        "service_name": "redshift_unloads",
        "span_id": 18214525240563821491,
        "trace_id": 11787570892963134195
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-11 03:32:21
success: True
trace_id: 11787570892963134195

Scan 6411851

duration: 0:00:14.292627

exit_message:

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

id: 6411851

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-10/1775809471/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_traffic_source/2026-04-10/1775809471",
        "key": "raw/dwh_dim_traffic_source/2026-04-10/1775809471/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5849501270619296006,
        "service_name": "redshift_unloads",
        "span_id": 1613132355852614001,
        "trace_id": 3539832087272411781
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-10 03:24:48
success: True
trace_id: 3539832087272411781

Scan 6411332

duration: 0:00:11.685604

exit_message:

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

id: 6411332

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-09/1775724916/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_traffic_source/2026-04-09/1775724916",
        "key": "raw/dwh_dim_traffic_source/2026-04-09/1775724916/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14640327956699335294,
        "service_name": "redshift_unloads",
        "span_id": 18260490369075427263,
        "trace_id": 4954662009949109885
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-09 03:55:40
success: True
trace_id: 4954662009949109885

Scan 6410838

duration: 0:00:14.381202

exit_message:

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

id: 6410838

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-08/1775637498/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_traffic_source/2026-04-08/1775637498",
        "key": "raw/dwh_dim_traffic_source/2026-04-08/1775637498/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7919668794247616049,
        "service_name": "redshift_unloads",
        "span_id": 17153268005568927648,
        "trace_id": 8504482252557983287
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-08 03:38:25
success: True
trace_id: 8504482252557983287

Scan 6410352

duration: 0:00:11.812044

exit_message:

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

id: 6410352

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-07/1775551676/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_traffic_source/2026-04-07/1775551676",
        "key": "raw/dwh_dim_traffic_source/2026-04-07/1775551676/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4551248105537959154,
        "service_name": "redshift_unloads",
        "span_id": 947129180405571365,
        "trace_id": 13842893490944357008
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-07 03:48:03
success: True
trace_id: 13842893490944357008

Scan 6409804

duration: 0:00:14.280065

exit_message:

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

id: 6409804

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-06/1775465787/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_traffic_source/2026-04-06/1775465787",
        "key": "raw/dwh_dim_traffic_source/2026-04-06/1775465787/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8200424760491215789,
        "service_name": "redshift_unloads",
        "span_id": 14015203561173571715,
        "trace_id": 9876189308412196000
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-06 03:56:34
success: True
trace_id: 9876189308412196000

Scan 6409426

duration: 0:00:14.221244

exit_message:

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

id: 6409426

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-05/1775379874/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_traffic_source/2026-04-05/1775379874",
        "key": "raw/dwh_dim_traffic_source/2026-04-05/1775379874/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4627373391698508138,
        "service_name": "redshift_unloads",
        "span_id": 9965551624634545116,
        "trace_id": 18349841872934215540
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-05 04:05:04
success: True
trace_id: 18349841872934215540

Scan 6409034

duration: 0:00:11.752321

exit_message:

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

id: 6409034

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-04/1775291974/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_traffic_source/2026-04-04/1775291974",
        "key": "raw/dwh_dim_traffic_source/2026-04-04/1775291974/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1099866364149200388,
        "service_name": "redshift_unloads",
        "span_id": 9217076142416113580,
        "trace_id": 16232568162485055790
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-04 03:39:54
success: True
trace_id: 16232568162485055790

Scan 6408531

duration: 0:00:11.741691

exit_message:

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

id: 6408531

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "first_appearance": "timestamp",
        "last_modified": "timestamp",
        "origin_key": "varchar",
        "traffic_source": "varchar(128)",
        "traffic_source_key": "int",
        "traffic_source_op_id": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_traffic_source/2026-04-03/1775205883/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_traffic_source/2026-04-03/1775205883",
        "key": "raw/dwh_dim_traffic_source/2026-04-03/1775205883/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_traffic_source",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11449047724022270742,
        "service_name": "redshift_unloads",
        "span_id": 15065047891068936130,
        "trace_id": 6312329130313345666
    }
}

running: False
schema_name_id: 388
start_time: 2026-04-03 03:44:50
success: True
trace_id: 6312329130313345666

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "first_appearance": "timestamp",
    "last_modified": "timestamp",
    "traffic_source": "varchar(128)",
    "traffic_source_key": "int",
    "traffic_source_op_id": "varchar(128)"
}

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

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_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-17/1776415830'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-20 23:59:02",
        "disabled": false,
        "format": "raw",
        "id": 388,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_traffic_source"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "first_appearance": "timestamp",
            "last_modified": "timestamp",
            "traffic_source": "varchar(128)",
            "traffic_source_key": "int",
            "traffic_source_op_id": "varchar(128)"
        },
        "created": "2026-04-17 03:50:38",
        "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_traffic_source`\n(\n `audit_id`  bigint , `traffic_source_key`  int , `traffic_source`  varchar(128) , `traffic_source_op_id`  varchar(128) , `first_appearance`  timestamp , `last_modified`  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_traffic_source/2026-04-17/1776415830'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_traffic_source`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_traffic_source"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}