is it possible to get DB query metadata as per the DB table spec tab into a knime table?
I guess you don’t want or can’t simply read the table into KNIME first and then use the default table spec node?
yup, as a workaround that’s what I am doing. I limit (filter) to get one 1 row and then use the standard spec node. Two drawbacks with this method:
thanks for the suggestion.
@ajc a database system typically has some sort of meta data information you can query. In the case of H2 it is INFORMATION_SCHEMA.
With big data it can be DESCRIBE (EXTENDED)
So if you know how to access the structure you can extract the information.
Thanks @mlauber71, in my use case I am looking to get this table spec from a query, not an existing table.
What you can do is extract the query from the query (which might be complicated), then materialize it as an empty table and then extract the structure from there. Not very elegant but it might get you the final structure of a sequence of queries. You might have to play around with it.
I use it with big data tables. I might construct a scaled down example.
Hello @ajc ,
great idea. I have created a ticket (internal number AP-18075) for a new node that has a DB Data input port and a KNIME table as output which contains the information from the DB Spec tab.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.