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.

Important

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.

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

Note

Take into account that you can only deploy those queries created on views. Deploying a query on a web service is not supported.

Dialog to deploy a query as a view in a Virtual DataPort server

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 search 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

    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 edit 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

    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 info icon and you will see the query metadata: its name, its description, the queried view and its database.