Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_twilio_event

created: 2018-11-14 12:52:35
disabled: False
format: raw
id: 575
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717893

created: 2026-04-17 03:40:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-17/1776415193'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-17/1776415193
id: 1717893
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 162168010
updated: 2026-04-17 03:40:15

Version 1716673

created: 2026-04-16 04:10:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-16/1776330592'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-16/1776330592
id: 1716673
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 162113330
updated: 2026-04-16 04:10:25

Version 1715588

created: 2026-04-15 04:02:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-15/1776243679'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-15/1776243679
id: 1715588
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 162057613
updated: 2026-04-15 04:02:45

Version 1714270

created: 2026-04-14 03:58:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-14/1776157085'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-14/1776157085
id: 1714270
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 162001479
updated: 2026-04-14 03:59:08

Version 1713026

created: 2026-04-13 03:54:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-13/1776070467'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-13/1776070467
id: 1713026
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161943094
updated: 2026-04-13 03:54:55

Version 1711841

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-12/1775984121'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-12/1775984121
id: 1711841
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161893809
updated: 2026-04-12 03:55:49

Version 1710608

created: 2026-04-11 03:40:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-11/1775896809'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-11/1775896809
id: 1710608
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161841443
updated: 2026-04-11 03:40:44

Version 1709461

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-10/1775811724'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-10/1775811724
id: 1709461
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161787345
updated: 2026-04-10 04:02:28

Version 1708333

created: 2026-04-09 03:46:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-09/1775724373'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-09/1775724373
id: 1708333
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161730696
updated: 2026-04-09 03:46:33

Version 1707085

created: 2026-04-08 03:20:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-08/1775636431'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-08/1775636431
id: 1707085
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161675782
updated: 2026-04-08 03:20:59

Version 1705908

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-07/1775550696'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-07/1775550696
id: 1705908
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161619673
updated: 2026-04-07 03:32:07

Version 1704736

created: 2026-04-06 04:02:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-06/1775466127'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-06/1775466127
id: 1704736
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161562942
updated: 2026-04-06 04:02:27

Version 1703513

created: 2026-04-05 03:59:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-05/1775379465'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-05/1775379465
id: 1703513
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161515928
updated: 2026-04-05 03:59:22

Version 1702309

created: 2026-04-04 03:24:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-04/1775291041'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-04/1775291041
id: 1702309
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161460668
updated: 2026-04-04 03:24:29

Version 1701115

created: 2026-04-03 03:33:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-03/1775205206'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_twilio_event/2026-04-03/1775205206
id: 1701115
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "call_event_key": "1",
    "call_event_name": "2",
    "call_event_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

schema_name_id: 575
schema_scan_id: 161402140
updated: 2026-04-03 03:34:03

Schema Scans: 15

Last at 2026-04-17 03:40:01

Scan 162168010

duration: 0:00:14.448964

exit_message:

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

id: 162168010

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-17/1776415193/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_twilio_event/2026-04-17/1776415193",
        "key": "raw/reference_dim_twilio_event/2026-04-17/1776415193/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6394031634397431114,
        "service_name": "redshift_unloads",
        "span_id": 9351302350678200185,
        "trace_id": 11089579715405581698
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-17 03:40:01
success: True
trace_id: 11089579715405581698

Scan 162113330

duration: 0:00:14.270714

exit_message:

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

id: 162113330

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-16/1776330592/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_twilio_event/2026-04-16/1776330592",
        "key": "raw/reference_dim_twilio_event/2026-04-16/1776330592/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 426176871541625434,
        "service_name": "redshift_unloads",
        "span_id": 16361162939834612125,
        "trace_id": 6885128292666168875
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-16 04:10:11
success: True
trace_id: 6885128292666168875

Scan 162057613

duration: 0:00:14.235836

exit_message:

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

id: 162057613

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-15/1776243679/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_twilio_event/2026-04-15/1776243679",
        "key": "raw/reference_dim_twilio_event/2026-04-15/1776243679/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5714483674708551168,
        "service_name": "redshift_unloads",
        "span_id": 12681624046589569394,
        "trace_id": 6004284790716026018
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-15 04:02:31
success: True
trace_id: 6004284790716026018

Scan 162001479

duration: 0:00:14.202976

exit_message:

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

id: 162001479

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-14/1776157085/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_twilio_event/2026-04-14/1776157085",
        "key": "raw/reference_dim_twilio_event/2026-04-14/1776157085/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3094080678033471233,
        "service_name": "redshift_unloads",
        "span_id": 15723237999415659513,
        "trace_id": 11273147007028627411
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-14 03:58:54
success: True
trace_id: 11273147007028627411

Scan 161943094

duration: 0:00:14.214057

exit_message:

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

id: 161943094

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-13/1776070467/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_twilio_event/2026-04-13/1776070467",
        "key": "raw/reference_dim_twilio_event/2026-04-13/1776070467/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10991509455316241587,
        "service_name": "redshift_unloads",
        "span_id": 8425166658988139582,
        "trace_id": 8639267578353049756
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-13 03:54:41
success: True
trace_id: 8639267578353049756

Scan 161893809

duration: 0:00:11.551415

exit_message:

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

id: 161893809

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-12/1775984121/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_twilio_event/2026-04-12/1775984121",
        "key": "raw/reference_dim_twilio_event/2026-04-12/1775984121/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2647421297763241436,
        "service_name": "redshift_unloads",
        "span_id": 2706541664970558340,
        "trace_id": 14360959168827140708
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-12 03:55:37
success: True
trace_id: 14360959168827140708

Scan 161841443

duration: 0:00:11.555635

exit_message:

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

id: 161841443

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-11/1775896809/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_twilio_event/2026-04-11/1775896809",
        "key": "raw/reference_dim_twilio_event/2026-04-11/1775896809/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16976767931451083970,
        "service_name": "redshift_unloads",
        "span_id": 3899459151776321069,
        "trace_id": 12157372074669450846
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-11 03:40:33
success: True
trace_id: 12157372074669450846

Scan 161787345

duration: 0:00:14.341381

exit_message:

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

id: 161787345

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-10/1775811724/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_twilio_event/2026-04-10/1775811724",
        "key": "raw/reference_dim_twilio_event/2026-04-10/1775811724/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10556062873760865666,
        "service_name": "redshift_unloads",
        "span_id": 2110199518461460342,
        "trace_id": 1915098158507912690
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-10 04:02:14
success: True
trace_id: 1915098158507912690

Scan 161730696

duration: 0:00:11.573477

exit_message:

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

id: 161730696

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-09/1775724373/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_twilio_event/2026-04-09/1775724373",
        "key": "raw/reference_dim_twilio_event/2026-04-09/1775724373/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18108072620684320966,
        "service_name": "redshift_unloads",
        "span_id": 8167851322111044139,
        "trace_id": 16695939250658172466
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-09 03:46:21
success: True
trace_id: 16695939250658172466

Scan 161675782

duration: 0:00:14.245576

exit_message:

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

id: 161675782

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-08/1775636431/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_twilio_event/2026-04-08/1775636431",
        "key": "raw/reference_dim_twilio_event/2026-04-08/1775636431/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15510493393163718630,
        "service_name": "redshift_unloads",
        "span_id": 3104703251373934895,
        "trace_id": 6923799674604563587
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-08 03:20:45
success: True
trace_id: 6923799674604563587

Scan 161619673

duration: 0:00:14.214071

exit_message:

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

id: 161619673

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-07/1775550696/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_twilio_event/2026-04-07/1775550696",
        "key": "raw/reference_dim_twilio_event/2026-04-07/1775550696/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8689619874833506076,
        "service_name": "redshift_unloads",
        "span_id": 15323611675510121877,
        "trace_id": 1309702021661068517
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-07 03:31:53
success: True
trace_id: 1309702021661068517

Scan 161562942

duration: 0:00:11.541058

exit_message:

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

id: 161562942

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-06/1775466127/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_twilio_event/2026-04-06/1775466127",
        "key": "raw/reference_dim_twilio_event/2026-04-06/1775466127/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1408297228161029102,
        "service_name": "redshift_unloads",
        "span_id": 3771842597982701593,
        "trace_id": 3349131687250064602
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-06 04:02:15
success: True
trace_id: 3349131687250064602

Scan 161515928

duration: 0:00:11.676884

exit_message:

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

id: 161515928

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-05/1775379465/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_twilio_event/2026-04-05/1775379465",
        "key": "raw/reference_dim_twilio_event/2026-04-05/1775379465/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7693479088430878826,
        "service_name": "redshift_unloads",
        "span_id": 13848953865007735058,
        "trace_id": 15887871421259272449
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-05 03:59:11
success: True
trace_id: 15887871421259272449

Scan 161460668

duration: 0:00:14.294736

exit_message:

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

id: 161460668

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-04/1775291041/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_twilio_event/2026-04-04/1775291041",
        "key": "raw/reference_dim_twilio_event/2026-04-04/1775291041/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4484077311477335766,
        "service_name": "redshift_unloads",
        "span_id": 9813637220516678148,
        "trace_id": 9510227372279720085
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-04 03:24:15
success: True
trace_id: 9510227372279720085

Scan 161402140

duration: 0:00:14.188757

exit_message:

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

id: 161402140

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "call_event_key": "int",
        "call_event_name": "varchar(45)",
        "call_event_type": "varchar(200)",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_twilio_event/2026-04-03/1775205206/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_twilio_event/2026-04-03/1775205206",
        "key": "raw/reference_dim_twilio_event/2026-04-03/1775205206/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_twilio_event",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5719261083417223002,
        "service_name": "redshift_unloads",
        "span_id": 16102876194333334168,
        "trace_id": 11043360899028829087
    }
}

running: False
schema_name_id: 575
start_time: 2026-04-03 03:33:49
success: True
trace_id: 11043360899028829087

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "call_event_key": "int",
    "call_event_name": "varchar(45)",
    "call_event_type": "varchar(200)"
}

created: 2026-04-17 03:40:01

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_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-17/1776415193'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
}

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-11-14 12:52:35",
        "disabled": false,
        "format": "raw",
        "id": 575,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_dim_twilio_event"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "call_event_key": "int",
            "call_event_name": "varchar(45)",
            "call_event_type": "varchar(200)"
        },
        "created": "2026-04-17 03:40:01",
        "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_twilio_event`\n(\n `audit_id`  bigint , `call_event_key`  int , `call_event_name`  varchar(45) , `call_event_type`  varchar(200) , `_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_twilio_event/2026-04-17/1776415193'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_twilio_event`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_twilio_event"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}