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?
Solution Manager Solution Manager API Deployment using Solution Manager Best Practice
user
25-11-2020 09:18:41 -0500
code

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](https://community.denodo.com/docs/html/browse/7.0/solution_manager/administration/promotions/revisions_from_vql/revisions_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
code
You must sign in to add an answer. If you do not have an account, you can register here