Forum Discussion
ERROR [22P02] [SQLState 22P02] ERROR: invalid input syntax for integer: ""
Hi all, Anybody familiar with this error message and knows how to fix this? data source is a table from Amazon Redshift, and the table is fine in redshift. we can do our queries and ...
I encountered the same issue. In our case, the problem was with the construction of the view on the Redshift side.
The creator of the view added an empty column as a placeholder for later development. The view looked like this
create or replace view nulltest1_v as
select
…,
null as col3
from ...
with no schema binding
I think the error stems from the fact that on this type of view, Power BI connector doesn't know the type (varchar, integer etc.) of the added column, which causes the error.