Deploying Saved Queries¶
From the My queries page you can deploy a query as a view in the Virtual DataPort server that you want. The purpose of this feature is to foster a collaborative environment in which business users suggest the views they would like to have available in the production environment. They can deploy their queries on a Denodo development server. Afterwards, the IT department can review these new views, and decide to promote them from the development server to the testing and/or production environment, following the regular procedures.
This feature is not intended to allow users of the Data Catalog to create views on the production servers. We discourage this use, even if the user has creation privileges on the production server.
Fill in the following information in the dialog:
Server URL. Connection URL of the Virtual DataPort server where you want to deploy the query as a view.
User and Password. Credentials to connect to the Virtual DataPort server. These fields are required only if you logged in the Data Catalog using user and password. If you logged in using Kerberos or an external Identity Provider, your current credentials will be reused to connect to Virtual DataPort.
Target folder: The database and folder where the view is going to be created. Click the icon next to the field. You will access the current structure of databases and folders of the target Virtual DataPort server. Select the desired location and the field will be properly filled.
View name. The name of the view that is going to be created.
View description. A description for the view. This field is optional.
Replace if exists. Enable to indicate that a view with the same name in Virtual DataPort should be replaced by the one you are deploying. Otherwise, the deployment will fail.
Edit calculated fields description. Click the icon and a new popup will appear with all the derived and aggregation fields that the query has defined in its output schema. You can type a description for each one and it will be persisted in the deployed view.
If the query does not contain any derived or aggregation field this option will not be available.
The dialog to deploy the query has two buttons with information about the query: