We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Make Snowflake's Views discoverable in Visual Query Builder

Matt_Curtis
9 - Comet

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.

3 REPLIES 3
ivoller
12 - Quasar

I agree. It would make life a lot easier

KylieF
Alteryx Community Team
Alteryx Community Team

Hi all!

 

Our support team has actually reported that this is an unexpected behavior that we're classifying as a defect. To help properly escalate this for product visibility I've moved this post to our Designer Discussions.

 

The defect number for this issue is DE17676 and we'll do our best to insure this topic is updated once the defect is fixed.

 

Thank you for your feedback and patience!

________________________________________________________
Program Manager - Community Platform, Alteryx
LuisKahn
6 - Meteoroid

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

thanks

Labels