Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_integration

created: 2018-02-20 23:55:31
disabled: False
format: raw
id: 377
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906631

created: 2026-04-17 03:43:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-17/1776415414'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-17/1776415414
id: 906631
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6415211
updated: 2026-04-17 03:43:59

Version 906433

created: 2026-04-16 04:01:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-16/1776330074'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-16/1776330074
id: 906433
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6414683
updated: 2026-04-16 04:01:42

Version 906222

created: 2026-04-15 03:58:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-15/1776243526'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-15/1776243526
id: 906222
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6414198
updated: 2026-04-15 03:59:11

Version 906011

created: 2026-04-14 03:56:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-14/1776156975'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-14/1776156975
id: 906011
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6413697
updated: 2026-04-14 03:56:42

Version 905750

created: 2026-04-13 03:22:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-13/1776068514'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-13/1776068514
id: 905750
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6413105
updated: 2026-04-13 03:22:16

Version 905586

created: 2026-04-12 04:02:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-12/1775984534'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-12/1775984534
id: 905586
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6412750
updated: 2026-04-12 04:03:04

Version 905377

created: 2026-04-11 03:45:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-11/1775897100'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-11/1775897100
id: 905377
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6412362
updated: 2026-04-11 03:45:19

Version 905136

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-10/1775809169'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-10/1775809169
id: 905136
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6411840
updated: 2026-04-10 03:19:56

Version 904922

created: 2026-04-09 03:49:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-09/1775724570'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-09/1775724570
id: 904922
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6411324
updated: 2026-04-09 03:50:04

Version 904740

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-08/1775638642'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-08/1775638642
id: 904740
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6410863
updated: 2026-04-08 03:57:55

Version 904532

created: 2026-04-07 03:54:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-07/1775552033'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-07/1775552033
id: 904532
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6410358
updated: 2026-04-07 03:54:36

Version 904296

created: 2026-04-06 03:55:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-06/1775465686'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-06/1775465686
id: 904296
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6409790
updated: 2026-04-06 03:55:17

Version 904121

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-05/1775379886'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-05/1775379886
id: 904121
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6409429
updated: 2026-04-05 04:05:22

Version 903911

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-04/1775292232'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-04/1775292232
id: 903911
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6409040
updated: 2026-04-04 03:44:32

Version 903693

created: 2026-04-03 03:51:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-03/1775206280'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-03/1775206280
id: 903693
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "integration": "2",
    "integration_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

schema_name_id: 377
schema_scan_id: 6408547
updated: 2026-04-03 03:51:44

Schema Scans: 15

Last at 2026-04-17 03:43:48

Scan 6415211

duration: 0:00:11.669451

exit_message:

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

id: 6415211

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-17/1776415414/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-17/1776415414",
        "key": "raw/dwh_dim_integration/2026-04-17/1776415414/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7751045677214954184,
        "service_name": "redshift_unloads",
        "span_id": 3737335745618378153,
        "trace_id": 18056770876425645956
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-17 03:43:48
success: True
trace_id: 18056770876425645956

Scan 6414683

duration: 0:00:11.624279

exit_message:

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

id: 6414683

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-16/1776330074/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-16/1776330074",
        "key": "raw/dwh_dim_integration/2026-04-16/1776330074/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15036085091358953056,
        "service_name": "redshift_unloads",
        "span_id": 8404524618007511980,
        "trace_id": 15078737639789524455
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-16 04:01:31
success: True
trace_id: 15078737639789524455

Scan 6414198

duration: 0:00:14.141080

exit_message:

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

id: 6414198

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-15/1776243526/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-15/1776243526",
        "key": "raw/dwh_dim_integration/2026-04-15/1776243526/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3812018300925080011,
        "service_name": "redshift_unloads",
        "span_id": 1331070907948186309,
        "trace_id": 9363115958941953772
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-15 03:58:57
success: True
trace_id: 9363115958941953772

Scan 6413697

duration: 0:00:11.864278

exit_message:

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

id: 6413697

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-14/1776156975/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-14/1776156975",
        "key": "raw/dwh_dim_integration/2026-04-14/1776156975/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12347497991515242963,
        "service_name": "redshift_unloads",
        "span_id": 11179614506786965259,
        "trace_id": 13022238360695349856
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-14 03:56:30
success: True
trace_id: 13022238360695349856

Scan 6413105

duration: 0:00:14.246671

exit_message:

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

id: 6413105

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-13/1776068514/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-13/1776068514",
        "key": "raw/dwh_dim_integration/2026-04-13/1776068514/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6318221799998319103,
        "service_name": "redshift_unloads",
        "span_id": 13201908514763420676,
        "trace_id": 7315969702304002405
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-13 03:22:02
success: True
trace_id: 7315969702304002405

Scan 6412750

duration: 0:00:14.237824

exit_message:

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

id: 6412750

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-12/1775984534/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-12/1775984534",
        "key": "raw/dwh_dim_integration/2026-04-12/1775984534/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13674883707001733793,
        "service_name": "redshift_unloads",
        "span_id": 10235813377963823638,
        "trace_id": 18332922817038180210
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-12 04:02:50
success: True
trace_id: 18332922817038180210

Scan 6412362

duration: 0:00:11.633443

exit_message:

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

id: 6412362

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-11/1775897100/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-11/1775897100",
        "key": "raw/dwh_dim_integration/2026-04-11/1775897100/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3046526541311633394,
        "service_name": "redshift_unloads",
        "span_id": 5332986497746241484,
        "trace_id": 2727729838960505351
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-11 03:45:07
success: True
trace_id: 2727729838960505351

Scan 6411840

duration: 0:00:11.636732

exit_message:

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

id: 6411840

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-10/1775809169/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-10/1775809169",
        "key": "raw/dwh_dim_integration/2026-04-10/1775809169/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5859546655158934322,
        "service_name": "redshift_unloads",
        "span_id": 13464217961109162098,
        "trace_id": 277150224222672572
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-10 03:19:44
success: True
trace_id: 277150224222672572

Scan 6411324

duration: 0:00:14.256184

exit_message:

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

id: 6411324

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-09/1775724570/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-09/1775724570",
        "key": "raw/dwh_dim_integration/2026-04-09/1775724570/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11562279878495844702,
        "service_name": "redshift_unloads",
        "span_id": 408170439658475101,
        "trace_id": 14238408123851224310
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-09 03:49:50
success: True
trace_id: 14238408123851224310

Scan 6410863

duration: 0:00:14.128654

exit_message:

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

id: 6410863

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-08/1775638642/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-08/1775638642",
        "key": "raw/dwh_dim_integration/2026-04-08/1775638642/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11730583101459064439,
        "service_name": "redshift_unloads",
        "span_id": 14405794420691374918,
        "trace_id": 9883027335347062119
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-08 03:57:41
success: True
trace_id: 9883027335347062119

Scan 6410358

duration: 0:00:14.159160

exit_message:

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

id: 6410358

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-07/1775552033/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-07/1775552033",
        "key": "raw/dwh_dim_integration/2026-04-07/1775552033/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15437744065814936485,
        "service_name": "redshift_unloads",
        "span_id": 15954165969555270382,
        "trace_id": 14457443844039259566
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-07 03:54:22
success: True
trace_id: 14457443844039259566

Scan 6409790

duration: 0:00:11.698918

exit_message:

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

id: 6409790

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-06/1775465686/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-06/1775465686",
        "key": "raw/dwh_dim_integration/2026-04-06/1775465686/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6843674391596790162,
        "service_name": "redshift_unloads",
        "span_id": 16112879880641195686,
        "trace_id": 3723487519841233378
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-06 03:55:05
success: True
trace_id: 3723487519841233378

Scan 6409429

duration: 0:00:11.665841

exit_message:

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

id: 6409429

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-05/1775379886/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-05/1775379886",
        "key": "raw/dwh_dim_integration/2026-04-05/1775379886/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14622573488271422109,
        "service_name": "redshift_unloads",
        "span_id": 1038563564911732740,
        "trace_id": 16475726323400241596
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-05 04:05:11
success: True
trace_id: 16475726323400241596

Scan 6409040

duration: 0:00:11.821637

exit_message:

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

id: 6409040

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-04/1775292232/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-04/1775292232",
        "key": "raw/dwh_dim_integration/2026-04-04/1775292232/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12295101269912008701,
        "service_name": "redshift_unloads",
        "span_id": 15300375381034495488,
        "trace_id": 4788963779236442213
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-04 03:44:20
success: True
trace_id: 4788963779236442213

Scan 6408547

duration: 0:00:14.267572

exit_message:

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

id: 6408547

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "integration": "varchar(100)",
        "integration_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_integration/2026-04-03/1775206280/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-03/1775206280",
        "key": "raw/dwh_dim_integration/2026-04-03/1775206280/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_integration",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16677066272609217038,
        "service_name": "redshift_unloads",
        "span_id": 17973073390348995422,
        "trace_id": 15476318421917439245
    }
}

running: False
schema_name_id: 377
start_time: 2026-04-03 03:51:30
success: True
trace_id: 15476318421917439245

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "integration": "varchar(100)",
    "integration_key": "int"
}

created: 2026-04-17 03:43:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-17/1776415414'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-20 23:55:31",
        "disabled": false,
        "format": "raw",
        "id": 377,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_integration"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "integration": "varchar(100)",
            "integration_key": "int"
        },
        "created": "2026-04-17 03:43:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_integration`\n(\n `audit_id`  bigint , `integration_key`  int , `integration`  varchar(100) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_integration/2026-04-17/1776415414'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_integration`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_integration"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}