You can translate the question and the replies:

Shared Views

Hello, I have couple of virtual database called "db-A" and "db-B". I have created some baseviews and derived views on "db-A". I am currently on "db-B". I would like to access those derived views which are available on "db-A" and would like to use it on "db-B" How can I achieve this
17-11-2022 03:28:00 -0500

1 Answer

Hi, I was able to access the derived views from db-A database and make use of it in the db-B by adding the database name in the prefix of the view. For instance, you could add the database name in the **prefix with dot (.)** as follows, > Select * from db-A.<view_name_from_db-A> Also, when performing operations like Union, Join, I was able to directly access the views from db-A in db-B without adding the database name in the prefix. Hope this helps!
Denodo Team
17-11-2022 08:24:42 -0500
You must sign in to add an answer. If you do not have an account, you can register here