Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Transform data greyed out in ODBC connection to Postgres in dataflow

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 

Need Help

2 Replies

  • venal's avatar
    venal
    Icon for Memorable Member rankMemorable Member
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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?