You can translate the question and the replies:

Issue with source refresh in base views

Hi I had a source which was then updated with the connection details and credentials. After updating the connection details when i am trying to refresh base views i am getting the following error: **ERROR WHILE REFRESHING BASE VIEW Unable to load information of view : view_name: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database.****
29-06-2022 04:52:09 -0400

1 Answer

Hello, There could be a number of reasons for this error. For example, if you are using an Azure SQL database, to change databases, you must directly connect to the database, using the **USE** statement does not switch between databases. Since you updated the connection details and credentials of the data source, the error could also be related to the schema or credentials of the underlying data source. You can try to create the base view again from the updated data source and test if the view executes. In case you need any further assistance and If you have a valid support account, we recommend opening a support case on the [Denodo Support Site]( Hope this helps!
Denodo Team
29-06-2022 13:21:47 -0400
You must sign in to add an answer. If you do not have an account, you can register here