Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_location

created: 2018-02-28 10:49:46
disabled: False
format: raw
id: 242
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717900

created: 2026-04-17 03:53:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-17/1776414589'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-17/1776414589
id: 1717900
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 162168128
updated: 2026-04-17 03:53:43

Version 1716680

created: 2026-04-16 04:29:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-16/1776330575'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-16/1776330575
id: 1716680
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 162113363
updated: 2026-04-16 04:30:03

Version 1715594

created: 2026-04-15 04:18:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-15/1776243308'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-15/1776243308
id: 1715594
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 162057655
updated: 2026-04-15 04:18:45

Version 1714294

created: 2026-04-14 04:14:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-14/1776156576'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-14/1776156576
id: 1714294
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 162001955
updated: 2026-04-14 04:14:31

Version 1713051

created: 2026-04-13 04:22:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-13/1776070709'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-13/1776070709
id: 1713051
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161944098
updated: 2026-04-13 04:23:00

Version 1711864

created: 2026-04-12 04:19:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-12/1775984201'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-12/1775984201
id: 1711864
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161894945
updated: 2026-04-12 04:19:39

Version 1710657

created: 2026-04-11 04:07:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-11/1775896922'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-11/1775896922
id: 1710657
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161842669
updated: 2026-04-11 04:07:57

Version 1709450

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-10/1775809485'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-10/1775809485
id: 1709450
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161786235
updated: 2026-04-10 03:48:20

Version 1708354

created: 2026-04-09 04:14:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-09/1775724667'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-09/1775724667
id: 1708354
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161731821
updated: 2026-04-09 04:14:31

Version 1707153

created: 2026-04-08 04:25:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-08/1775638872'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-08/1775638872
id: 1707153
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161677041
updated: 2026-04-08 04:25:21

Version 1705965

created: 2026-04-07 04:06:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-07/1775551238'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-07/1775551238
id: 1705965
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161620893
updated: 2026-04-07 04:06:33

Version 1704740

created: 2026-04-06 04:09:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-06/1775465051'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-06/1775465051
id: 1704740
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161562956
updated: 2026-04-06 04:10:00

Version 1703529

created: 2026-04-05 04:26:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-05/1775379652'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-05/1775379652
id: 1703529
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161516238
updated: 2026-04-05 04:26:12

Version 1702356

created: 2026-04-04 03:48:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-04/1775291274'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-04/1775291274
id: 1702356
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161460748
updated: 2026-04-04 03:48:49

Version 1701178

created: 2026-04-03 04:16:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-03/1775206348'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-03/1775206348
id: 1701178
processed: 1

raw_data:

{
    "_origin": "10",
    "audit_id": "0",
    "city": "3",
    "country": "7",
    "latitude": "8",
    "location_key": "1",
    "longitude": "9",
    "state": "4",
    "street_address": "2",
    "zip": "5",
    "zip_full": "6"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

schema_name_id: 242
schema_scan_id: 161403544
updated: 2026-04-03 04:16:30

Schema Scans: 15

Last at 2026-04-17 03:53:32

Scan 162168128

duration: 0:00:11.751196

exit_message:

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

id: 162168128

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-17/1776414589/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_location/2026-04-17/1776414589",
        "key": "raw/dwh_dim_location/2026-04-17/1776414589/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16787088831890161503,
        "service_name": "redshift_unloads",
        "span_id": 17658432902578518719,
        "trace_id": 8882897863159000987
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-17 03:53:32
success: True
trace_id: 8882897863159000987

Scan 162113363

duration: 0:00:14.395921

exit_message:

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

id: 162113363

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-16/1776330575/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_location/2026-04-16/1776330575",
        "key": "raw/dwh_dim_location/2026-04-16/1776330575/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6107536495394080875,
        "service_name": "redshift_unloads",
        "span_id": 6966647277331311712,
        "trace_id": 8191667837228239061
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-16 04:29:49
success: True
trace_id: 8191667837228239061

Scan 162057655

duration: 0:00:11.832310

exit_message:

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

id: 162057655

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-15/1776243308/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_location/2026-04-15/1776243308",
        "key": "raw/dwh_dim_location/2026-04-15/1776243308/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13198036123019461618,
        "service_name": "redshift_unloads",
        "span_id": 7853566249923796664,
        "trace_id": 12103529189889144009
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-15 04:18:33
success: True
trace_id: 12103529189889144009

Scan 162001955

duration: 0:00:11.818324

exit_message:

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

id: 162001955

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-14/1776156576/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_location/2026-04-14/1776156576",
        "key": "raw/dwh_dim_location/2026-04-14/1776156576/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17319310654606742712,
        "service_name": "redshift_unloads",
        "span_id": 8615300942772775011,
        "trace_id": 378506508950894982
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-14 04:14:19
success: True
trace_id: 378506508950894982

Scan 161944098

duration: 0:00:14.621891

exit_message:

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

id: 161944098

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-13/1776070709/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_location/2026-04-13/1776070709",
        "key": "raw/dwh_dim_location/2026-04-13/1776070709/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6197576217860309953,
        "service_name": "redshift_unloads",
        "span_id": 1249548394366241505,
        "trace_id": 9893590670926722108
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-13 04:22:45
success: True
trace_id: 9893590670926722108

Scan 161894945

duration: 0:00:14.323945

exit_message:

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

id: 161894945

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-12/1775984201/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_location/2026-04-12/1775984201",
        "key": "raw/dwh_dim_location/2026-04-12/1775984201/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2732973624350913748,
        "service_name": "redshift_unloads",
        "span_id": 7963440461196842994,
        "trace_id": 11001131586656432818
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-12 04:19:25
success: True
trace_id: 11001131586656432818

Scan 161842669

duration: 0:00:11.765311

exit_message:

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

id: 161842669

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-11/1775896922/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_location/2026-04-11/1775896922",
        "key": "raw/dwh_dim_location/2026-04-11/1775896922/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12032614896940273618,
        "service_name": "redshift_unloads",
        "span_id": 12688959782044328711,
        "trace_id": 2426417053909871608
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-11 04:07:45
success: True
trace_id: 2426417053909871608

Scan 161786235

duration: 0:00:14.375992

exit_message:

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

id: 161786235

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-10/1775809485/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_location/2026-04-10/1775809485",
        "key": "raw/dwh_dim_location/2026-04-10/1775809485/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7837593013685496426,
        "service_name": "redshift_unloads",
        "span_id": 8389069509624106995,
        "trace_id": 18258965730831063315
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-10 03:48:06
success: True
trace_id: 18258965730831063315

Scan 161731821

duration: 0:00:11.824851

exit_message:

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

id: 161731821

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-09/1775724667/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_location/2026-04-09/1775724667",
        "key": "raw/dwh_dim_location/2026-04-09/1775724667/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12921484997148942162,
        "service_name": "redshift_unloads",
        "span_id": 1780008086589050783,
        "trace_id": 12786485120328547386
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-09 04:14:19
success: True
trace_id: 12786485120328547386

Scan 161677041

duration: 0:00:14.320586

exit_message:

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

id: 161677041

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-08/1775638872/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_location/2026-04-08/1775638872",
        "key": "raw/dwh_dim_location/2026-04-08/1775638872/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4851257275602983297,
        "service_name": "redshift_unloads",
        "span_id": 3273199770260334095,
        "trace_id": 12078545993014665451
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-08 04:25:07
success: True
trace_id: 12078545993014665451

Scan 161620893

duration: 0:00:14.322661

exit_message:

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

id: 161620893

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-07/1775551238/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_location/2026-04-07/1775551238",
        "key": "raw/dwh_dim_location/2026-04-07/1775551238/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8697400027181686544,
        "service_name": "redshift_unloads",
        "span_id": 2088800545694978137,
        "trace_id": 4534456045533520920
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-07 04:06:19
success: True
trace_id: 4534456045533520920

Scan 161562956

duration: 0:00:11.842072

exit_message:

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

id: 161562956

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-06/1775465051/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_location/2026-04-06/1775465051",
        "key": "raw/dwh_dim_location/2026-04-06/1775465051/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4952742237834933914,
        "service_name": "redshift_unloads",
        "span_id": 11755648589757294762,
        "trace_id": 1985163882216096303
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-06 04:09:49
success: True
trace_id: 1985163882216096303

Scan 161516238

duration: 0:00:11.821265

exit_message:

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

id: 161516238

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-05/1775379652/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_location/2026-04-05/1775379652",
        "key": "raw/dwh_dim_location/2026-04-05/1775379652/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7238824154717612102,
        "service_name": "redshift_unloads",
        "span_id": 10702215551812461431,
        "trace_id": 4667445312220332623
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-05 04:26:00
success: True
trace_id: 4667445312220332623

Scan 161460748

duration: 0:00:14.327512

exit_message:

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

id: 161460748

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-04/1775291274/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_location/2026-04-04/1775291274",
        "key": "raw/dwh_dim_location/2026-04-04/1775291274/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2747029731892780111,
        "service_name": "redshift_unloads",
        "span_id": 6959628894191544430,
        "trace_id": 13290866296261727498
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-04 03:48:35
success: True
trace_id: 13290866296261727498

Scan 161403544

duration: 0:00:11.953982

exit_message:

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

id: 161403544

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "city": "varchar(100)",
        "country": "varchar(2)",
        "latitude": "double",
        "location_key": "int",
        "longitude": "double",
        "origin_key": "varchar",
        "state": "varchar(2)",
        "street_address": "varchar(255)",
        "zip": "varchar(6)",
        "zip_full": "varchar(10)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_location/2026-04-03/1775206348/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_location/2026-04-03/1775206348",
        "key": "raw/dwh_dim_location/2026-04-03/1775206348/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_location",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3136558130717876666,
        "service_name": "redshift_unloads",
        "span_id": 5118488842300848662,
        "trace_id": 13741864837131411359
    }
}

running: False
schema_name_id: 242
start_time: 2026-04-03 04:16:19
success: True
trace_id: 13741864837131411359

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "city": "varchar(100)",
    "country": "varchar(2)",
    "latitude": "double",
    "location_key": "int",
    "longitude": "double",
    "state": "varchar(2)",
    "street_address": "varchar(255)",
    "zip": "varchar(6)",
    "zip_full": "varchar(10)"
}

created: 2026-04-17 03:53:32

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_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-17/1776414589'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
}

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:49:46",
        "disabled": false,
        "format": "raw",
        "id": 242,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_location"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "city": "varchar(100)",
            "country": "varchar(2)",
            "latitude": "double",
            "location_key": "int",
            "longitude": "double",
            "state": "varchar(2)",
            "street_address": "varchar(255)",
            "zip": "varchar(6)",
            "zip_full": "varchar(10)"
        },
        "created": "2026-04-17 03:53:32",
        "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_location`\n(\n `audit_id`  bigint , `location_key`  int , `street_address`  varchar(255) , `city`  varchar(100) , `state`  varchar(2) , `zip`  varchar(6) , `zip_full`  varchar(10) , `country`  varchar(2) , `latitude`  double , `longitude`  double , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_location/2026-04-17/1776414589'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_location`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_location"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}