No views visible via foreign catalog

[benno]

Hello,

I have created a connection to a SQL Server. I have created a foreign catalog using this connection.
When I show the catalog in the catalog explorer I can see the schemas and I can also see the tables and views in one schema.  In another schema, which contains 74699 views I do not get the views in the catalog.

Is this an issue because there are so many views? How can I get this catalog populated completely?

Kind regards
Benno 

[dipudot]

@benno , just wondering, does the account which you used to create foreign catalog connection to the SQL server has the right permission to access those missing view ?

[benno]

@dipudot, yes the permission are OK. I can see them in SQL Serber Management using the same account.

I have read somewhere that the some characters might not be supported. The views have all the pattern <tenant>$<table_name>.

I will retest with a smaller set of views.