Make Snowflake's Views discoverable in Visual Query Builder

Question

I love the Visual Query Builder, it helped me learn SQL!  I use it to build queries, simple and complex, often.

When connecting to Snowflake via the standard Input Data tool, Views are not discoverable in the Visual Query Builder mode.  What I mean is that when you expand your options on the pane on the right, from database to schema to object, Tables show up in the tree, but Views do not.

You can go to the Tables mode, select a View, then go to Visual Query Builder and modify that View.  However, when I build queries sometimes I need to reference, for example, 3 tables plus 1 view.  I build the query with the tables, but then go to add the view to the builder canvas, and it's not there and switching to Table mode clears the query.

I've used the Visual Query Builder with Redshift and MySQL instances and the Views were there, so I know it's possible in other DB's and think that this would be a simple add for Snowflake as well.

Thanks!  Let me know if you have any questions.

srvas17 · Answer

Hi, has there been any resolution to this issue?  I am seeing it currently in Alteryx, do I need to update to a new version?

esmosis · Answer

2022 checking in - is defect DE17676 going to be fixed?  Would really appreciate being able to see Snowflake Views in the Visual Query Builder!  Thank you.

LuisKahn · Answer

10 months later and the Defect is still there. Was DE17676 closed or is still open ? Should we still keep hoping ?

thanks