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.
Is it possible to enhance just the text editor of the Input Tool, especially when connecting to databases?
My team uses a variety of databases - some familiar, some not-so-familiar - and before we could rely on IntelliSense in MSSQL to help guide us for what we are looking for. Now, if we want to input a query (AKA Copy/paste from an old MSSQL query), we have to make a lot of adjustments to get it to work. With IntelliSense, we can tell which part of the query is off and what needs to adjust. However, with Alteryx's text editor, it feels like a bit like a guessing game. Sometimes it is such a bother, that we scrap the query altogether and try to rebuild from the visual table layout, which can be quite tedious if you have multiple schemas.
The other issue with the text editor is that if you do have a best practice to comment out your SQL query and make the code readable, switching between SQL Editor to Visual Query Builder and then back to SQL Editor causes your SQL query to be "blocked", making it unreadable, and also deletes out comments! As we want to share our code with each other, this makes it quite bothersome for those that are proficient in SQL. I have posted a simple example below where I typed in the code, switched to VQB and then back to SQL Editor to get the 2nd picture's results. This is minor for this example, but can be quite annoying when you have many, many lines of codes and comments!