This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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