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.
So with the basic good old input tool I am connecting to an SQL database on my company's server which contains like 200 different tables. Is there a way I can dynamically update the SQL query to pull let's say just the 1st row of every single table in that database and save each table to a different excel tab named after that table? It goes without saying that each table has a different structure (number of columns, etc)
Or, alternatively, an SQL query that will give me the list of all tables in a database, including a list of the column names of each table? I understand that:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
will give me the list of tables, but it doesn't have the column names of each table as well. If I could get the column names as well in a 2nd column that'd be perfect for me.
That's what I thought too, however my experience with alteryx isn't at a high enough level yet to be able to build what I described above with the dynamic tool, which is why I was hoping for something a little more specific.
I did manage to get a list of all tables/column names using a standard SQL query that reads from information_schema.columns
But i'd still like to learn how to do what i described in the first part of the question - read a large number of tables with different schema from a database without specifying all of them in a tailor-made sql query.
Appreciate your time @aguisande , unfortunately I can't open that file on my Alteryx due to my alteryx being a bit older (2019.3.5.17947). And updating is not an option as we only update when the company's server is upgraded.
Which leads me to my next semi-related question, if we've got installed Alteryx server 2019.3 but on my pc i have let's say alteryx designer 2020.4.x.xxxxx are there gonna be compatibility issues when trying to save to and read from the server gallery?