topic Re: No views visible via foreign catalog in Get Started Discussions

No views visible via foreign catalog

benno — Tue, 01 Apr 2025 07:20:42 GMT

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

Re: No views visible via foreign catalog

dipudot — Mon, 07 Apr 2025 01:23:32 GMT

@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 ?

Re: No views visible via foreign catalog

benno — Mon, 07 Apr 2025 03:05:34 GMT

@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.

Re: No views visible via foreign catalog

curiousfinland1 — Wed, 15 Apr 2026 04:43:09 GMT

@benno did you got this solved? In the documentation there is no clear mention about support for views.