Redshift Integration Error: Unsupported Implicit Cast Issue

·Feb 20, 2025 03:55 PM·

Hey guys! I setup the redshift integration with MP. When trying to query the redshift table I get the following error: Unsupported implicit cast: Column ('properties'), FromType: STRUCT, ToType: VARCHAR but when looking at the schema created my MP it shows properties as a string. The event schema in S3 looks fine. Any help would be greatly appreciated.

Community Questions

Redshift Integration Error: Unsupported Implicit Cast Issue

Heshie B.

·Feb 20, 2025 03:55 PM·

Hey guys! I setup the redshift integration with MP. When trying to query the redshift table I get the following error: Unsupported implicit cast: Column ('properties'), FromType: STRUCT, ToType: VARCHAR but when looking at the schema created my MP it shows properties as a string. The event schema in S3 looks fine. Any help would be greatly appreciated.