For AI agents: the complete documentation index is available at https://docs.dataplatform.ovh.net/llms.txt, the full documentation bundle is available at https://docs.dataplatform.ovh.net/llms-full.txt, and this page is available as Markdown at https://docs.dataplatform.ovh.net/connectors-sources-trino.md.
  • 🇬🇧 English

    • Query external data sources with the Trino connector

    Trino is an open-source distributed SQL query engine for adhoc and batch ETL queries against multiple types of data sources

    Objective

    Trino is an open-source distributed SQL query engine for adhoc and batch ETL queries against multiple types of data sources. The Platform allows you to use Trino to access the sources for your application.

    Trino

    Add a Trino source on the Platform

    Configure your connection

    When creating the source, you will be required to input the following information :

    • Host: the Host name of the Trino server.
    • Port: the Port address of the Trino server (8080 by default).
    • Catalog: the name of the catalog from the Trino server.
    • Schema: the name of the Schema from the Trino server.
    • Username: the Username for the Trino server.
    • Password: the Password for the Username you are using.
    • SSL: if activated, encrypts the information exchanged between the Data Platform and the database.
    Trino

    Select the tables you want

    After establishing a connection with your Trino Server your tables will be fetched and displayed :

    Trino

    Select which tables you want to be included in the source by checking the boxes to the left of the table name, as indicated in the image above.

    Info

    If the state of the database changes, you can use the Fetch button to refresh the tables displayed and include them in your source.

    Once you follow the steps above, click on the Save button on the top right-hand corner.

    Warning

    Don't forget to name your source before creating it. The technical name cannot be changed after creating the source and will be used when trying to open the source using the SDK.

    Connect Trino to an existing Platform Project

    You can use Trino as a connector to an existing project on the Platform. This will be useful in the scenario where there is a need to extract data from one project to another. The tutorial can be found here.

    Go further

    If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

    Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated Discord channel.

    If you need support with your OVHcloud services, create a request in our Help Centre.

    Join our community of users.