I have now uploaded the workflow from the previous page to my KNIME Pro space, by first adding the mount point to my space and then uploading the workflow (see images below)
I will now access KNIME Hub via the browser and execute my workflow from there:
Ok, this (successfully) ends my proof of concept. We have been able to move our Workflow to the KNIME hub and access the Postgres database from the aiven cloud.
What I want to do as a next step, is reproduce the 'Airlines with most passengers' graph (which I introduced here ) on the KNIME hub.
In preparation for this, I first want to duplicate all the tables of my local Data Warehouse database to the database in the aiven cloud Postgres instance. I did this with the workflow below, which is just a 'table copy' for each table involved.
Below you can see the workflow that generates tie Airlines with most passengers' pie chart. I have modified its Postgres Connector so it now connects to the aiven cloud instance of the database.
Next, I have wrapped my pie chart into a Component by right-clicking it and selecting 'create component'. I have then uploaded my workflow to my KNIME Pro space.
When I now access my Hub space with the browser and run my workflow from there, I will see my Pie chart appear.
One more thing I can do is to convert this deployed workflow into a data app. To do so, first I have to create a first (non-draft) version of it by clicking on the Versions button. Then I can click on the Deploy button and from there 'deploy as a data app'
From now on my data app will appear on the portal (apps.hub.knime.com) as seen below.
To show how to add some interactivity , I have modified the previous Workflow a bit (actually just the Component). I have added a String Widget and a Refresh Button Widget. This will allow the user to select the Origin airport to see the biggest airlines operating from there. i have named this Dashboard 1 and deployed it to the KNIME Pro hub. Below you can see the result.