SQL Distribution
This documentation references PopMedNet 2021.1 +
PopMedNet User's Guide
Based on version 2021.1 +
SQL Distribution
The SQL Distribution request type allows you to distribute raw SQL from the portal to the network DataMarts. This request type is data model agnostic. Currently, SQL Distribution requests may only be distributed to DataMarts that are connected to data sources in the pgAdmin application.
To compose a SQL Distribution request, click on the New Request button in the request panel, select the SQL Distribution request model and the SQL Distribution request type. This will display the Request Composer page for the SQL Distribution request. The following figure shows the request specific criteria for the SQL Distribution request type. Paste or type the SQL code into the text box.
