Hi Team I added my first experiment but the data cannot be p

Question

Hi Team I added my first experiment but the data cannot be pulled `Query unsupported due to an internal error ` Unfortunately this is all the information I received from the system How to overcome this issue

future-teacher-7046 · Answer

What data source are you using

incalculable-tent-31021 · Answer

Amplitude from Redshift

future-teacher-7046 · Answer

Are you able to share the full query You can change any sensitive table names or DM me if you want

future-teacher-7046 · Answer

From what I can tell it looks like that error is related to pivoting in redshift

future-teacher-7046 · Answer

If that s the case there are usually ways to rewrite your query to not use `PIVOT`