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.
The Connect In-DB and Dynamic Output In-DB will add a "SELECT * FROM" to a Common Table Expression (CTE) query. There is no error, but eventually, if they use a tool that pulls the query, it will have the incorrect syntax "SELECT * FROM WITH..."
In the Connect In-DB using an INDB file with the query:
WITH employee AS (SELECT * FROM Employees)
SELECT * FROM employee WHERE ID < 20
SELECT * FROM employee WHERE Sex = 'M'
When putting in a Dynamic Output In-DB to show the query and it's seen that the SELECT * FROM is added to the original query.
CTE queries are not supported within the In-DB tools.
Use the Input Data tool where possible in the workflow as CTE queries are read as is to pull in data.
An idea to support CTE queries for the In-DB tools has been created. Click here to up-vote for this idea to be implemented in a future release of Designer.