How to work out multi valued attributes view in Generic SQL Connector in MIM?

Question

Hello

We have a multi valued view that we are trying to integrate in the generic sql connector. We are getting a few issues:

1. It does detect the schema but doesn't change the attribute names in the "select attributes" or "configure attribute flow" resulting in us having only 1 attribute called "Value" which is the name of the column.
2. The addition of a reference object doesn't add a new schema 5 sectionas per the tutorial
   https://learn.microsoft.com/en-us/microsoft-identity-manager/reference/microsoft-identity-manager-2016-connector-genericsql

3. When trying to configure the run profile, we configured the join condition like this (the column names are correct).

4. When the import task is run, we get into a few errors:

"Microsoft.MetadirectoryServices.ExtensibleExtensionException: Error occurred while creating the connection for run profile.System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary."

"Microsoft.MetadirectoryServices.ExtensibleExtensionException: Exception occurred while closing the import connectionSystem.NullReferenceException: Object reference not set to an instance of an object."

So the questions here are: How do we get this query right to get the attribute name associated with the value ? (the column name in the view MultiValue is "AttributeName"
How do we associate each different attribute names to an attribute for the user object?

How do we get the schema 5 ?

How do we configure the import task (note this is a view and not a table).

Thank you in advance