how to connect to any public database so I can do some basic querying

Hi again!

Well, if you opened the webpage, you can see different kind of files to use it.

Original URL: https://catalog.data.gov/dataset/louisville-metro-ky-animal-tag-data-2010-to-2015-historical

They creat links for anyone use it.

IF you’d like to open as CSV file, you need to set the right link:

https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-animal-tag-data-2010-to-2015-historical.csv

With csv reader node, you can use it setting the file as custom/Kinme URL path as the image below:

For others from this community, you can see that the page offers json file and other sources to be imported as you need, knime have other options to it too.

SO, it works for me, I hope that it helps you too.

BR, Denis

3 Likes