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 have a workflow which uses a dynamic input In-DB tool to accept the query and the connection supplied to to it. I am making a dynamic query in a formula tool and that works perfectly. The connection that I am supplying to it also works perfectly on my laptop. This connection was created in accordance with the instructions supplied here. I save the indbc file on my laptop, give the file path to the formula tool which eventually feeds the dynamic input In-DB tool and everything works. The issue comes when:
I try to generalise the in-db connection path. eg. make it something like "File:\in_db_connection.indbc" or various versions of that as instructed here.
This is when in-db tool gives up.
It is very important for me to generalize it as I want to publish on the gallery where I don't really know the path where the indbc file will be saved.
I'm having this same issue where my workflow is working fine if i run it from laptop but when i publish it to gallery its not able to find the connection. I'm using gallery connection that was created by admin on the gallery. i'm connecting to Redshift database.
@kpiyush88 can you share the screenshots of your solution?