Hello!
All our database connections work with .indbc files. Now I never have a problem with this, but for this workflow I need to have a dynamic SQL query.
Where normally inputs look like this:
I now want to use a dynamic SQL query using the dynamic input tool. The problem is, is that it does not recognize the .indbc files.
Any suggestions?
@Pingu - In-Database connection can be create and stored as .indbc file. You cannot use In-DB with Dynamic Input. Instead you may want to learn and use Dynamic Input In-DB and Dynamic Output In-DB:
- https://help.alteryx.com/20223/designer/connect-db-tool
- https://help.alteryx.com/20223/designer/dynamic-input-db-tool
Thanks very much ArtApa. I managed to do it with the Dynamic Input In-BD tool... turns out I was using the wrong tool, oops.
Do you have updated URLs for these links? I am getting 404 errors on them.
Dynamic Input In-DB Tool: https://help.alteryx.com/current/en/designer/tools/in-database/dynamic-input-in-db-tool.html
Connect In-DB Tool: https://help.alteryx.com/current/en/designer/tools/in-database/connect-in-db-tool.html