OpenMetadata/openmetadata-docs/content/v1.8.x-SNAPSHOT/connectors/database/presto/index.md

title	slug
Presto Connector | OpenMetadata Distributed SQL Guide	/connectors/database/presto

{% connectorDetailsHeader name="Presto" stage="PROD" platform="OpenMetadata" availableFeatures=["Metadata", "Data Profiler", "Data Quality", "dbt", "Sample Data"] unavailableFeatures=["Query Usage", "Owners", "Tags", "Stored Procedures", "Lineage", "Column-level Lineage"] / %}

In this section, we provide guides and references to use the Presto connector.

Configure and schedule Presto metadata and profiler workflows from the OpenMetadata UI:

• Requirements
• Metadata Ingestion
• Data Profiler
• Data Quality
• dbt Integration
• Troubleshooting

{% partial file="/v1.8/connectors/ingestion-modes-tiles.md" variables={yamlPath: "/connectors/database/presto/yaml"} /%}

Requirements

Metadata

To extract metadata, the user needs to be able to perform SHOW CATALOGS, SHOW TABLES, and SHOW COLUMNS FROM on the catalogs/tables you wish to extract metadata from and have SELECT permission on the INFORMATION_SCHEMA. Access to resources will be different based on the connector used. You can find more details in the Presto documentation website here. You can also get more information regarding system access control in Presto here.

Profiler & Data Quality

Executing the profiler workflow or data quality tests, will require the user to have SELECT permission on the tables/schemas where the profiler/tests will be executed. More information on the profiler workflow setup can be found here and data quality tests here.

Metadata Ingestion

{% partial file="/v1.8/connectors/metadata-ingestion-ui.md" variables={ connector: "Presto", selectServicePath: "/images/v1.8/connectors/presto/select-service.png", addNewServicePath: "/images/v1.8/connectors/presto/add-new-service.png", serviceConnectionPath: "/images/v1.8/connectors/presto/service-connection.png", } /%}

{% stepsContainer %} {% extraContent parentTagName="stepsContainer" %}

Connection Options

• Username: Specify the User to connect to Presto. It should have enough privileges to read all the metadata.
• Password: Password to connect to Presto.
• Host and Port: Enter the fully qualified hostname and port number for your Presto deployment in the Host and Port field.
• Catalog: Presto offers a catalog feature where all the databases are stored.
• DatabaseSchema: DatabaseSchema of the data source. This is optional parameter, if you would like to restrict the metadata reading to a single databaseSchema. When left blank, OpenMetadata Ingestion attempts to scan all the databaseSchema.

{% partial file="/v1.8/connectors/database/advanced-configuration.md" /%}

{% /extraContent %}

{% partial file="/v1.8/connectors/test-connection.md" /%}

{% partial file="/v1.8/connectors/database/configure-ingestion.md" /%}

{% partial file="/v1.8/connectors/ingestion-schedule-and-deploy.md" /%}

{% /stepsContainer %}

{% partial file="/v1.8/connectors/database/related.md" /%}