No views visible via foreign catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2025 12:20 AM - edited 04-01-2025 12:20 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-06-2025 06:23 PM
@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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-06-2025 08:05 PM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2026 09:43 PM
@benno did you got this solved? In the documentation there is no clear mention about support for views.
