Create Usable Tables From DB Connection

[dkoris]

I’m relatively new to KNIME. I have a connection to a DataBricks environment (Dbase) where there are 30+ tables. Using SQL, I want to filter and join many of these tables to create 3 to 4 simple usable tables that novice users can query from in a KNIME workflow. I’m using the DB SQL Executor node with SQL code to ‘build’ the tables I want (select * INTO from…where…)). I’m trying to use a DB Query Reader from the DB SQL Executor but how do I actually expose the tables and make them usable for other folks to query? I know I must be missing something really simple. Any suggestions will help.
Thanks!

[josegallardo]

Hi @dkoris and welcome to the KNIME Forum.

If you are using DB SQL Executor to create the new table as in the following image:

You can use directly after this node the DB Table Selector and select the New Table (sometimes you have to use the refresh next to “Fetched x minutes ago”).

Note that in my example, I am using SQLite but it should work similarly in any database.

I hope this helps.

All the best,

Jose.

[mlauber71]

@dkoris if you want to read much more about KNIME and SQL and databases I can offer you this article (also with a lot of examples and further readings):

KNIME, Databases and SQL

[dkoris]

Hi @josegallardo,
Thanks for the welcome…AND the response. It works! I have to put in code to delete the table I’m creating if it exists, but IT WORKS!

Thanks so much!