Ahana data sources are connection definitions to your data from Presto through the Ahana product stack.
Adding an Ahana data source creates a definition of the connection between Ahana and the data source you want Ahana to connect to. Ahana data source definitions do not move or create database objects or data, and do not require the data source to exist when the definition is created.
After adding the data source to an Ahana cluster, you can validate the data source connection definition using Presto from the CLI or access Apache Superset through the Ahana UI.
After you connect to your data source, you can create queries and view results.
For example, if you have existing Hive Metastore data, and you want to access that data through your Presto cluster, you can define the connection information in Ahana. There will be no data or database structures created by Ahana. Attach your HMS to your Ahana Presto cluster, and use Superset through Ahana to select the linked database and schema to query and view the data in your Hive Metastore.
The Ahana UI includes connectors for some of the most commonly used data sources accessed with Presto. They optimize establishing access to the data you want to analyze through Presto. You can also connect to any of the other supported Presto connectors by defining a connector configuration file.
Summary of adding a data source connection
To add an Ahana data source:
- Navigate to the Data Sources tab.
- Select Add a Data Source.
- Select a specific Data Source connector type and configure it.
- After the data source is configured, you can attach it to one or more clusters. A list of all configured Data Sources is available on the Data Sources tab of the console.