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.

To deploy a query, click its icon and select the Deploy query option. A dialog will appear to configure the deploy.

Dialog to deploy a query as a view in a Virtual DataPort 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.

  

  Popup with the structure of databases and folders of the target Virtual DataPort¶

• 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.

  Note

  If the query does not contain any derived or aggregation field this option will not be available.

  

  Popup to provide a description to the derived and aggregation fields of the query¶

The dialog to deploy the query has two buttons with information about the query:

• Click the VQL button to see the VQL generated from the query. It will be used to create the view in the target Virtual DataPort server.

• Click the icon and you will see the query metadata: its name, its description, the queried view and its database.