Transform data greyed out in ODBC connection to Postgres in dataflow

[Anonymous]

Hi All,

I've been trying to find an answer online without success. I'm creating a dataflow through an ODBC connection to a Postgres Data Warehouse. I'm able to connect and have the necessary permissions, and I'm able to select tables, but when it comes to views the "Transform data" button greys out and it won't let me select the view either for loading in. I primarily want to be using views to pull into the dataflow so I need to find a solution to this. 

Does anybody have any idea of a fix? 

Thank you 

[venal]

@Anonymous 

Hoping that we have "Postgre SQL" connector in Dataflow. (Database- Postgre SQL)

Instead of using the ODBC(Other-ODBC), please try to re-pro the issue with the Postgre SQL.

If you have any concerns, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[Anonymous]

I am deliberately using ODBC connection as it suits our working practice better. I want to understand why views aren't allowed, if this is a bug or if there is a genuine reason behind not being able to select them?