Hi Team, I added my first experiment but the data...
# ask-questions
i
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?
f
What data source are you using?
i
Amplitude from Redshift.
f
Are you able to share the full query? You can change any sensitive table names or DM me if you want.
From what I can tell, it looks like that error is related to pivoting in redshift
If that's the case, there are usually ways to rewrite your query to not use
PIVOT