Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_dim_bad_api_site

created: 2018-05-09 10:28:27
disabled: False
format: raw
id: 520
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906612

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-17/1776414989'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-17/1776414989
id: 906612
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6415192
updated: 2026-04-17 03:36:52

Version 906404

created: 2026-04-16 03:59:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-16/1776329940'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-16/1776329940
id: 906404
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6414654
updated: 2026-04-16 03:59:26

Version 906190

created: 2026-04-15 03:45:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-15/1776242732'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-15/1776242732
id: 906190
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6414166
updated: 2026-04-15 03:46:11

Version 905971

created: 2026-04-14 03:39:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-14/1776155938'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-14/1776155938
id: 905971
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6413657
updated: 2026-04-14 03:39:20

Version 905763

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-13/1776069131'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-13/1776069131
id: 905763
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6413119
updated: 2026-04-13 03:32:35

Version 905588

created: 2026-04-12 04:02:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-12/1775984560'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-12/1775984560
id: 905588
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6412752
updated: 2026-04-12 04:03:12

Version 905349

created: 2026-04-11 03:25:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-11/1775895912'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-11/1775895912
id: 905349
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6412334
updated: 2026-04-11 03:25:38

Version 905138

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-10/1775809172'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-10/1775809172
id: 905138
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6411842
updated: 2026-04-10 03:20:04

Version 904961

created: 2026-04-09 04:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-09/1775725272'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-09/1775725272
id: 904961
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6411364
updated: 2026-04-09 04:01:37

Version 904713

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-08/1775637143'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-08/1775637143
id: 904713
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6410834
updated: 2026-04-08 03:32:56

Version 904496

created: 2026-04-07 03:33:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-07/1775550800'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-07/1775550800
id: 904496
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6410319
updated: 2026-04-07 03:33:52

Version 904286

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-06/1775465106'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-06/1775465106
id: 904286
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6409780
updated: 2026-04-06 03:45:24

Version 904079

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-05/1775377574'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-05/1775377574
id: 904079
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6409386
updated: 2026-04-05 03:26:32

Version 903881

created: 2026-04-04 03:23:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-04/1775291011'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-04/1775291011
id: 903881
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6409010
updated: 2026-04-04 03:23:50

Version 903670

created: 2026-04-03 03:44:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-03/1775205849'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-03/1775205849
id: 903670
processed: 1

raw_data:

{
    "_origin": "4",
    "affected_end_date": "3",
    "affected_start_date": "2",
    "audit_id": "0",
    "site_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

schema_name_id: 520
schema_scan_id: 6408524
updated: 2026-04-03 03:44:34

Schema Scans: 15

Last at 2026-04-17 03:36:38

Scan 6415192

duration: 0:00:14.330323

exit_message:

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

id: 6415192

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-17/1776414989/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-17/1776414989",
        "key": "raw/reference_dim_bad_api_site/2026-04-17/1776414989/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1294343371785196798,
        "service_name": "redshift_unloads",
        "span_id": 15981768557548725932,
        "trace_id": 2394581383731181922
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-17 03:36:38
success: True
trace_id: 2394581383731181922

Scan 6414654

duration: 0:00:14.238394

exit_message:

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

id: 6414654

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-16/1776329940/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-16/1776329940",
        "key": "raw/reference_dim_bad_api_site/2026-04-16/1776329940/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18298399833456395667,
        "service_name": "redshift_unloads",
        "span_id": 2738343833018734195,
        "trace_id": 12178768859032901769
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-16 03:59:12
success: True
trace_id: 12178768859032901769

Scan 6414166

duration: 0:00:16.849648

exit_message:

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

id: 6414166

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-15/1776242732/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-15/1776242732",
        "key": "raw/reference_dim_bad_api_site/2026-04-15/1776242732/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13993289899305573169,
        "service_name": "redshift_unloads",
        "span_id": 1480105246947849622,
        "trace_id": 9991473341414718494
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-15 03:45:54
success: True
trace_id: 9991473341414718494

Scan 6413657

duration: 0:00:14.228921

exit_message:

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

id: 6413657

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-14/1776155938/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-14/1776155938",
        "key": "raw/reference_dim_bad_api_site/2026-04-14/1776155938/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9259383388816890920,
        "service_name": "redshift_unloads",
        "span_id": 4014869500234455740,
        "trace_id": 2436306698036200379
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-14 03:39:06
success: True
trace_id: 2436306698036200379

Scan 6413119

duration: 0:00:14.394672

exit_message:

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

id: 6413119

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-13/1776069131/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-13/1776069131",
        "key": "raw/reference_dim_bad_api_site/2026-04-13/1776069131/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 88642042550289476,
        "service_name": "redshift_unloads",
        "span_id": 13722517949974420296,
        "trace_id": 5100674642647245765
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-13 03:32:20
success: True
trace_id: 5100674642647245765

Scan 6412752

duration: 0:00:14.230329

exit_message:

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

id: 6412752

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-12/1775984560/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-12/1775984560",
        "key": "raw/reference_dim_bad_api_site/2026-04-12/1775984560/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10053009661548932163,
        "service_name": "redshift_unloads",
        "span_id": 3922379480123234928,
        "trace_id": 6998728857758726358
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-12 04:02:58
success: True
trace_id: 6998728857758726358

Scan 6412334

duration: 0:00:14.190052

exit_message:

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

id: 6412334

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-11/1775895912/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-11/1775895912",
        "key": "raw/reference_dim_bad_api_site/2026-04-11/1775895912/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16996393668793354699,
        "service_name": "redshift_unloads",
        "span_id": 8720037315176885337,
        "trace_id": 9859916817890821392
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-11 03:25:24
success: True
trace_id: 9859916817890821392

Scan 6411842

duration: 0:00:14.186785

exit_message:

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

id: 6411842

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-10/1775809172/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-10/1775809172",
        "key": "raw/reference_dim_bad_api_site/2026-04-10/1775809172/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9266806069154924126,
        "service_name": "redshift_unloads",
        "span_id": 12494134865350284283,
        "trace_id": 4431416495066255295
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-10 03:19:50
success: True
trace_id: 4431416495066255295

Scan 6411364

duration: 0:00:11.669023

exit_message:

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

id: 6411364

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-09/1775725272/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-09/1775725272",
        "key": "raw/reference_dim_bad_api_site/2026-04-09/1775725272/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17098246544419491609,
        "service_name": "redshift_unloads",
        "span_id": 4686031328762586357,
        "trace_id": 3578186084951070387
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-09 04:01:26
success: True
trace_id: 3578186084951070387

Scan 6410834

duration: 0:00:14.234692

exit_message:

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

id: 6410834

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-08/1775637143/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-08/1775637143",
        "key": "raw/reference_dim_bad_api_site/2026-04-08/1775637143/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3170440221081492186,
        "service_name": "redshift_unloads",
        "span_id": 17526694550911608878,
        "trace_id": 1451614198295840573
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-08 03:32:42
success: True
trace_id: 1451614198295840573

Scan 6410319

duration: 0:00:11.920160

exit_message:

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

id: 6410319

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-07/1775550800/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-07/1775550800",
        "key": "raw/reference_dim_bad_api_site/2026-04-07/1775550800/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1854526423201575871,
        "service_name": "redshift_unloads",
        "span_id": 11352660286538600019,
        "trace_id": 9800102493487883097
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-07 03:33:40
success: True
trace_id: 9800102493487883097

Scan 6409780

duration: 0:00:11.855431

exit_message:

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

id: 6409780

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-06/1775465106/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-06/1775465106",
        "key": "raw/reference_dim_bad_api_site/2026-04-06/1775465106/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11049130848949744609,
        "service_name": "redshift_unloads",
        "span_id": 3966947593666863400,
        "trace_id": 12145982657575350618
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-06 03:45:13
success: True
trace_id: 12145982657575350618

Scan 6409386

duration: 0:00:11.664375

exit_message:

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

id: 6409386

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-05/1775377574/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-05/1775377574",
        "key": "raw/reference_dim_bad_api_site/2026-04-05/1775377574/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6929291391284270580,
        "service_name": "redshift_unloads",
        "span_id": 10202625481110653469,
        "trace_id": 11310228510668922878
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-05 03:26:21
success: True
trace_id: 11310228510668922878

Scan 6409010

duration: 0:00:11.662417

exit_message:

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

id: 6409010

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-04/1775291011/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-04/1775291011",
        "key": "raw/reference_dim_bad_api_site/2026-04-04/1775291011/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15833629946082427890,
        "service_name": "redshift_unloads",
        "span_id": 13077631370901463595,
        "trace_id": 17031357257651569171
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-04 03:23:38
success: True
trace_id: 17031357257651569171

Scan 6408524

duration: 0:00:14.165614

exit_message:

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

id: 6408524

payload:

{
    "datatype_dict": {
        "affected_end_date": "date",
        "affected_start_date": "date",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_bad_api_site/2026-04-03/1775205849/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_bad_api_site/2026-04-03/1775205849",
        "key": "raw/reference_dim_bad_api_site/2026-04-03/1775205849/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17746418117011479432,
        "service_name": "redshift_unloads",
        "span_id": 10997564153557248208,
        "trace_id": 14397832668340364859
    }
}

running: False
schema_name_id: 520
start_time: 2026-04-03 03:44:20
success: True
trace_id: 14397832668340364859

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "affected_end_date": "date",
    "affected_start_date": "date",
    "audit_id": "bigint",
    "site_key": "int"
}

created: 2026-04-17 03:36: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_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-17/1776414989'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
}

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-05-09 10:28:27",
        "disabled": false,
        "format": "raw",
        "id": 520,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_reference_dim_bad_api_site"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "affected_end_date": "date",
            "affected_start_date": "date",
            "audit_id": "bigint",
            "site_key": "int"
        },
        "created": "2026-04-17 03:36: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_reference_dim_bad_api_site`\n(\n `audit_id`  bigint , `site_key`  int , `affected_start_date`  date , `affected_end_date`  date , `_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/reference_dim_bad_api_site/2026-04-17/1776414989'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_bad_api_site`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_bad_api_site"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}