You can translate the question and the replies:

Promotion of view with same datasource

Hello, We have a datasource as Snowflake. QA and Prod Databases are in the same login. We have created the same jdbc datasource(ds_snowflake in both env) for this in both QA and prod. Lets say the QA database is named db_qa and prod database is named db_prod . We have created the view in denodo QA from the ds_snowflake datasource using db_qa database. When we promote this to Prod using solution manager, the view in Denodo prod points to db_qa database and not db_prod database since the datasource is the same. Can you please help on how to solve this?

1 Answer

Hi, I would download the revision VQL and edit the database name in the VQL to db_prod and create [New Revision From VQL]( using the modified VQL to make the promotion in the Solution Manager. Also, if you have a valid support account, you can raise a support case on the Support Site for more detailed help. Hope this helps!
Denodo Team
09-12-2020 04:21:13 -0500
You must sign in to add an answer. If you do not have an account, you can register here