Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_integration

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

name:

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

type: redshift

Schema Versions: 15

Version 1717874

created: 2026-04-17 03:22:24

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-17/1776414130
id: 1717874
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: 244
schema_scan_id: 162167925
updated: 2026-04-17 03:22:38

Version 1716653

created: 2026-04-16 04:07:00

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-16/1776330404
id: 1716653
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: 244
schema_scan_id: 162113305
updated: 2026-04-16 04:07:14

Version 1715582

created: 2026-04-15 04:02:10

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-15/1776243621
id: 1715582
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: 244
schema_scan_id: 162057582
updated: 2026-04-15 04:02:24

Version 1714290

created: 2026-04-14 04:03:45

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-14/1776157418
id: 1714290
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: 244
schema_scan_id: 162001929
updated: 2026-04-14 04:03:59

Version 1713043

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-13/1776070700
id: 1713043
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: 244
schema_scan_id: 161943850
updated: 2026-04-13 04:00:06

Version 1711817

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-12/1775983608
id: 1711817
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: 244
schema_scan_id: 161893624
updated: 2026-04-12 03:47:09

Version 1710616

created: 2026-04-11 03:41:37

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-11/1775896890
id: 1710616
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: 244
schema_scan_id: 161841459
updated: 2026-04-11 03:41:49

Version 1709440

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-10/1775809675
id: 1709440
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: 244
schema_scan_id: 161786186
updated: 2026-04-10 03:28:28

Version 1708346

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-09/1775724653
id: 1708346
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: 244
schema_scan_id: 161730729
updated: 2026-04-09 03:51:13

Version 1707144

created: 2026-04-08 04:02:57

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-08/1775638857
id: 1707144
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: 244
schema_scan_id: 161676987
updated: 2026-04-08 04:03:08

Version 1705950

created: 2026-04-07 03:53:53

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-07/1775552025
id: 1705950
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: 244
schema_scan_id: 161619843
updated: 2026-04-07 03:54:07

Version 1704699

created: 2026-04-06 03:50:37

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-06/1775465428
id: 1704699
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: 244
schema_scan_id: 161561923
updated: 2026-04-06 03:50:48

Version 1703479

created: 2026-04-05 03:33:55

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-05/1775378024
id: 1703479
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: 244
schema_scan_id: 161515092
updated: 2026-04-05 03:34:09

Version 1702325

created: 2026-04-04 03:32:12

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-04/1775291519
id: 1702325
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: 244
schema_scan_id: 161460696
updated: 2026-04-04 03:32:26

Version 1701168

created: 2026-04-03 03:52:55

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_integration/2026-04-03/1775206335
id: 1701168
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: 244
schema_scan_id: 161402363
updated: 2026-04-03 03:53:09

Schema Scans: 15

Last at 2026-04-17 03:22:24

Scan 162167925

duration: 0:00:14.202820

exit_message:

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

id: 162167925

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

running: False
schema_name_id: 244
start_time: 2026-04-17 03:22:24
success: True
trace_id: 4744283512018907820

Scan 162113305

duration: 0:00:14.141818

exit_message:

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

id: 162113305

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

running: False
schema_name_id: 244
start_time: 2026-04-16 04:07:00
success: True
trace_id: 719402542246137562

Scan 162057582

duration: 0:00:14.260222

exit_message:

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

id: 162057582

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

running: False
schema_name_id: 244
start_time: 2026-04-15 04:02:10
success: True
trace_id: 140300390013323698

Scan 162001929

duration: 0:00:14.483413

exit_message:

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

id: 162001929

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

running: False
schema_name_id: 244
start_time: 2026-04-14 04:03:44
success: True
trace_id: 7774706171305973134

Scan 161943850

duration: 0:00:11.578793

exit_message:

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

id: 161943850

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

running: False
schema_name_id: 244
start_time: 2026-04-13 03:59:55
success: True
trace_id: 1262031103570809835

Scan 161893624

duration: 0:00:14.102806

exit_message:

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

id: 161893624

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

running: False
schema_name_id: 244
start_time: 2026-04-12 03:46:55
success: True
trace_id: 18443406063429778920

Scan 161841459

duration: 0:00:11.623239

exit_message:

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

id: 161841459

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

running: False
schema_name_id: 244
start_time: 2026-04-11 03:41:37
success: True
trace_id: 11029311408139268241

Scan 161786186

duration: 0:00:11.642411

exit_message:

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

id: 161786186

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

running: False
schema_name_id: 244
start_time: 2026-04-10 03:28:17
success: True
trace_id: 15337796813764913290

Scan 161730729

duration: 0:00:11.576628

exit_message:

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

id: 161730729

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

running: False
schema_name_id: 244
start_time: 2026-04-09 03:51:02
success: True
trace_id: 5112341491932110249

Scan 161676987

duration: 0:00:11.673646

exit_message:

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

id: 161676987

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

running: False
schema_name_id: 244
start_time: 2026-04-08 04:02:56
success: True
trace_id: 3745250057271601346

Scan 161619843

duration: 0:00:14.143649

exit_message:

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

id: 161619843

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

running: False
schema_name_id: 244
start_time: 2026-04-07 03:53:52
success: True
trace_id: 2766022027528075308

Scan 161561923

duration: 0:00:11.704447

exit_message:

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

id: 161561923

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

running: False
schema_name_id: 244
start_time: 2026-04-06 03:50:36
success: True
trace_id: 16435414440733273884

Scan 161515092

duration: 0:00:14.128762

exit_message:

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

id: 161515092

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

running: False
schema_name_id: 244
start_time: 2026-04-05 03:33:55
success: True
trace_id: 4637517126943874473

Scan 161460696

duration: 0:00:14.213769

exit_message:

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

id: 161460696

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

running: False
schema_name_id: 244
start_time: 2026-04-04 03:32:12
success: True
trace_id: 210723086754571730

Scan 161402363

duration: 0:00:13.997517

exit_message:

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

id: 161402363

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

running: False
schema_name_id: 244
start_time: 2026-04-03 03:52:55
success: True
trace_id: 12707803807865816163

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:22:24

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-02-28 10:49:59",
        "disabled": false,
        "format": "raw",
        "id": 244,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:22:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_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-prod/raw/dwh_dim_integration/2026-04-17/1776414130'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_integration`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_integration"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}