Hi, I am new here. How to connect to any public database so I start doing some querying on it
Hi @shiks, welcome to the community!
Public databases normally came as text files (txt,csv) or sometimes put it into a rest request (http).
So, if came from online files, you can bring it using “CSV reader node” for example or some IO file option node.
If you’ll bring from an Url, you can use “http retriever node”, setting the path to the data/webpage and the result will be the information. Here you maybe transforme it to something practical, manual to transformation as you need.
If you can bring here your need as a dummy example, we can help you more, ok?
So I want to get this dataset from this gov url
what would you do use this dataset directly in KNIME using the URL or API
Well, if you opened the webpage, you can see different kind of files to use it.
They creat links for anyone use it.
IF you’d like to open as CSV file, you need to set the right link:
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.
Which version of knime you works? I’m using 4.7.4 and run at first charge.
If you open the page, you see the link to csv file. Can you download from there directly? maybe you have a proxy/block conditions from your computer to the internet files.
Try deleting this node and add a new one too.
it was some extension blocking it. it works now thanks
OK, so you can set solved for this task, ok?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.