Fabric & Hub : How to create Hub secret for Azure Storage to use DB Loader node to Fabric Warehouse

Hi,

I was very pleased with the KNIME Hub 1.19 update.
Secret store: Microsoft interactive secrets now support OAuth scope requests during workflow execution, which may be required when working with Microsoft Fabric.

And the documentation is nicely updated.

• Work with Microsoft Fabric Data Warehouse | KNIME Documentation

• Authenticate to Microsoft Fabric | KNIME Documentation

• Fabric Data Warehouse – KNIME Community Hub

I gave the KNIME Template a spin

Trying out the new dynamic scope secret in the Hub

The new Hub secret type with dynamic request mode, nicely solve the requesting access token with 2 different scope resources, which can be seen in the Secrets Retriever.

It’s known, that the DB Writer node is VERY slow for more than 100 rows.
The DB Loader uses another method for fast loading of data, via a temporary file store.

But now I am quite surprise to then realise, that I am not able to make a secret for Azure Storage in the Hub?

That blocks being able to schedule workflows on the KNIME Hub to load data in Fabric Warehouse?

I tried to make a secret with custom scope: https://storage.azure.com/.default

But Azure Storage node never completes, and errors out with message:
Execute failed: java.net.UnknownHostException: No such host is known (storage.azure.com)
(But I also never specified any Azure Storage Account.)

So close…
But still no luck on Fabric Progress