How to create a Presto connection
- Onesait Platform
Available as of version 4.3.0
In order to create Presto Entities, we must first have the Presto connection to the database to be queried.
This type of connection can only be created by a user with the "administrator" role, who can make it public so that any user can create Presto Entities in that catalog, or keep it private, in which case only users with the "administrator" role can have access.
To create a Presto connection, the following steps must be followed:
Access the menu option Development Tools > Presto Connections Management with an "administrator" user role.
A list of existing connections will appear. Click on the "+" button to create a new connection.
Then, the form with the data to be filled in to create the connection will be loaded.
In this form you must fill in the identifier field, which will be the name that the catalog will get, the type of connection, whether you want to make it public or not, and the properties associated with the type of connection.
Depending on the type of connection selected, some properties will be loaded, in some cases mandatory (marked with an asterisk), which must be added in order to create the connection correctly.
Once the data in the form has been completed, click on the "Create" button, and a warning will appear telling the user to contact support to apply the changes and gain access to the registered catalog. Click on the "Confirm" button to create the connection.
The creation of Presto connections can also be accessed from the Presto Entities creation form by clicking on the "Add catalog" button.