You can scan multiple schemas in an Azure SQL Data Warehouse, by specifying schema names in the field in the metadata load settings while creating the resource in Catalog Administrator. Metadata load is successful and you can all schemas.
However, to profile, we need to select a source connection. The source connection is created in Informatica Administrator and one of the required fields is "Schema Name". Profiling is running successfully for one schema, but it is failing for multiple schemas.
It is tedious to create a separate connection in Informatica Administrator and a separate resource in Catalog Administrator for each schema to be able to profile. Is there any way we can profile all the schemas in an Azure SQL DW resource with the same source connection?
As of now, this feature is not possible where we can profile all the schemas in an Azure SQL DW resource with the same source connection. This we can consider as a feature request.