Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_bad_api_site

created: 2018-05-08 15:06:55
disabled: False
format: raw
id: 427
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717852

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-17/1776413956
id: 1717852
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: 427
schema_scan_id: 162167899
updated: 2026-04-17 03:19:42

Version 1716660

created: 2026-04-16 04:09:31

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-16/1776330555
id: 1716660
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: 427
schema_scan_id: 162113316
updated: 2026-04-16 04:09:42

Version 1715425

created: 2026-04-15 03:32:47

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-15/1776241942
id: 1715425
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: 427
schema_scan_id: 162056275
updated: 2026-04-15 03:32:58

Version 1714238

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-14/1776155890
id: 1714238
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: 427
schema_scan_id: 162000804
updated: 2026-04-14 03:38:31

Version 1712992

created: 2026-04-13 03:36:55

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-13/1776069408
id: 1712992
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: 427
schema_scan_id: 161942920
updated: 2026-04-13 03:37:07

Version 1711814

created: 2026-04-12 03:46:29

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-12/1775983582
id: 1711814
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: 427
schema_scan_id: 161893621
updated: 2026-04-12 03:46:41

Version 1710639

created: 2026-04-11 03:57:42

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-11/1775897824
id: 1710639
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: 427
schema_scan_id: 161841954
updated: 2026-04-11 03:57:53

Version 1709488

created: 2026-04-10 04:06:22

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-10/1775811967
id: 1709488
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: 427
schema_scan_id: 161787377
updated: 2026-04-10 04:06:33

Version 1708299

created: 2026-04-09 03:28:31

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-09/1775723294
id: 1708299
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: 427
schema_scan_id: 161730616
updated: 2026-04-09 03:28:42

Version 1707090

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-08/1775636492
id: 1707090
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: 427
schema_scan_id: 161675787
updated: 2026-04-08 03:21:53

Version 1705932

created: 2026-04-07 03:47:18

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-07/1775551630
id: 1705932
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: 427
schema_scan_id: 161619773
updated: 2026-04-07 03:47:29

Version 1704704

created: 2026-04-06 03:53:02

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-06/1775465574
id: 1704704
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: 427
schema_scan_id: 161561954
updated: 2026-04-06 03:53:15

Version 1703483

created: 2026-04-05 03:42:48

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-05/1775378552
id: 1703483
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: 427
schema_scan_id: 161515101
updated: 2026-04-05 03:43:02

Version 1702367

created: 2026-04-04 04:02:42

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-04/1775293354
id: 1702367
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: 427
schema_scan_id: 161461932
updated: 2026-04-04 04:02:55

Version 1701122

created: 2026-04-03 03:34:15

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-03/1775205247
id: 1701122
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: 427
schema_scan_id: 161402147
updated: 2026-04-03 03:34:26

Schema Scans: 15

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

Scan 162167899

duration: 0:00:14.222203

exit_message:

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

id: 162167899

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-17/1776413956/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-17/1776413956",
        "key": "raw/reference_dim_bad_api_site/2026-04-17/1776413956/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6181178039318859976,
        "service_name": "redshift_unloads",
        "span_id": 17540464212260420052,
        "trace_id": 4421310959593318067
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-17 03:19:28
success: True
trace_id: 4421310959593318067

Scan 162113316

duration: 0:00:11.668295

exit_message:

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

id: 162113316

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-16/1776330555/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-16/1776330555",
        "key": "raw/reference_dim_bad_api_site/2026-04-16/1776330555/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12773190487171733460,
        "service_name": "redshift_unloads",
        "span_id": 12810065828601354863,
        "trace_id": 14385878102758603495
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-16 04:09:30
success: True
trace_id: 14385878102758603495

Scan 162056275

duration: 0:00:11.542955

exit_message:

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

id: 162056275

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-15/1776241942/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-15/1776241942",
        "key": "raw/reference_dim_bad_api_site/2026-04-15/1776241942/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13646110333790005682,
        "service_name": "redshift_unloads",
        "span_id": 7574367211652013620,
        "trace_id": 12598495967514647268
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-15 03:32:46
success: True
trace_id: 12598495967514647268

Scan 162000804

duration: 0:00:11.563606

exit_message:

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

id: 162000804

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-14/1776155890/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-14/1776155890",
        "key": "raw/reference_dim_bad_api_site/2026-04-14/1776155890/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 422919411159932725,
        "service_name": "redshift_unloads",
        "span_id": 6217347345517757074,
        "trace_id": 14764114166305927339
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-14 03:38:19
success: True
trace_id: 14764114166305927339

Scan 161942920

duration: 0:00:11.528219

exit_message:

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

id: 161942920

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-13/1776069408/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-13/1776069408",
        "key": "raw/reference_dim_bad_api_site/2026-04-13/1776069408/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17508087011324571559,
        "service_name": "redshift_unloads",
        "span_id": 16310732974775583272,
        "trace_id": 2673567846193256959
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-13 03:36:55
success: True
trace_id: 2673567846193256959

Scan 161893621

duration: 0:00:11.770741

exit_message:

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

id: 161893621

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-12/1775983582/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-12/1775983582",
        "key": "raw/reference_dim_bad_api_site/2026-04-12/1775983582/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6339671327075066657,
        "service_name": "redshift_unloads",
        "span_id": 2301303103398395651,
        "trace_id": 345831376761088131
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-12 03:46:29
success: True
trace_id: 345831376761088131

Scan 161841954

duration: 0:00:11.608798

exit_message:

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

id: 161841954

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-11/1775897824/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-11/1775897824",
        "key": "raw/reference_dim_bad_api_site/2026-04-11/1775897824/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14023500944845447649,
        "service_name": "redshift_unloads",
        "span_id": 6932762982830161659,
        "trace_id": 8078614410218564467
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-11 03:57:41
success: True
trace_id: 8078614410218564467

Scan 161787377

duration: 0:00:11.745681

exit_message:

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

id: 161787377

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-10/1775811967/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-10/1775811967",
        "key": "raw/reference_dim_bad_api_site/2026-04-10/1775811967/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7514352382252311812,
        "service_name": "redshift_unloads",
        "span_id": 1659697580498902158,
        "trace_id": 9736100116491389546
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-10 04:06:22
success: True
trace_id: 9736100116491389546

Scan 161730616

duration: 0:00:11.587541

exit_message:

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

id: 161730616

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-09/1775723294/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-09/1775723294",
        "key": "raw/reference_dim_bad_api_site/2026-04-09/1775723294/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16837193853098018809,
        "service_name": "redshift_unloads",
        "span_id": 7596831463801619028,
        "trace_id": 572359205444877978
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-09 03:28:30
success: True
trace_id: 572359205444877978

Scan 161675787

duration: 0:00:11.659247

exit_message:

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

id: 161675787

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-08/1775636492/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-08/1775636492",
        "key": "raw/reference_dim_bad_api_site/2026-04-08/1775636492/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14201626339357607535,
        "service_name": "redshift_unloads",
        "span_id": 854119095862090264,
        "trace_id": 7091984440822254204
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-08 03:21:41
success: True
trace_id: 7091984440822254204

Scan 161619773

duration: 0:00:11.672715

exit_message:

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

id: 161619773

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-07/1775551630/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-07/1775551630",
        "key": "raw/reference_dim_bad_api_site/2026-04-07/1775551630/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1052390423080837202,
        "service_name": "redshift_unloads",
        "span_id": 7320436464385696461,
        "trace_id": 10197326127164798795
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-07 03:47:18
success: True
trace_id: 10197326127164798795

Scan 161561954

duration: 0:00:14.154188

exit_message:

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

id: 161561954

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-06/1775465574/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-06/1775465574",
        "key": "raw/reference_dim_bad_api_site/2026-04-06/1775465574/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18167250895807834926,
        "service_name": "redshift_unloads",
        "span_id": 17582905729048275904,
        "trace_id": 17917460943939333978
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-06 03:53:01
success: True
trace_id: 17917460943939333978

Scan 161515101

duration: 0:00:14.209410

exit_message:

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

id: 161515101

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-05/1775378552/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-05/1775378552",
        "key": "raw/reference_dim_bad_api_site/2026-04-05/1775378552/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 981500374114989076,
        "service_name": "redshift_unloads",
        "span_id": 2857126151323248742,
        "trace_id": 13091658997211386103
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-05 03:42:48
success: True
trace_id: 13091658997211386103

Scan 161461932

duration: 0:00:14.160279

exit_message:

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

id: 161461932

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-04/1775293354/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-04/1775293354",
        "key": "raw/reference_dim_bad_api_site/2026-04-04/1775293354/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4893120470106728543,
        "service_name": "redshift_unloads",
        "span_id": 6871761088718382428,
        "trace_id": 1077644587846149951
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-04 04:02:41
success: True
trace_id: 1077644587846149951

Scan 161402147

duration: 0:00:11.729704

exit_message:

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

id: 161402147

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-prod",
            "key": "meta/reference_dim_bad_api_site/2026-04-03/1775205247/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_bad_api_site/2026-04-03/1775205247",
        "key": "raw/reference_dim_bad_api_site/2026-04-03/1775205247/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_bad_api_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4095514657943065565,
        "service_name": "redshift_unloads",
        "span_id": 12166659097071426615,
        "trace_id": 5548729765376816511
    }
}

running: False
schema_name_id: 427
start_time: 2026-04-03 03:34:14
success: True
trace_id: 5548729765376816511

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/reference_dim_bad_api_site/2026-04-17/1776413956'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_bad_api_site`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_bad_api_site"
}

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-05-08 15:06:55",
        "disabled": false,
        "format": "raw",
        "id": 427,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:19:28",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/reference_dim_bad_api_site/2026-04-17/1776413956'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_bad_api_site`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_bad_api_site"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}