Unfortunately, there is a one drawback with Data Connectors: Subfolders!
How to access the right file?
First-level subfolders can be interpreted as schemas, but deeper levels are not accessible.
The current workaround:
save a dummy data connector once.
Don't use Connect to use the Data Connector, instead click on Edit, enter the current folder manually, then click Connect.
(don't save with the new settings)
-> Connection will be opened for the specific folder
This approach feel complicated - compared to a standard Windows/Mac file dialogue to select an arbitrary file/folder
[Discovery Summit Europe 2026]: there are plans to work on this issue