Hologres:Dataiku

Limits

Due to limitations in Dataiku, you can query foreign tables directly using an SQL Notebook, but you cannot view foreign tables using the Import tables to datasets feature.

Procedure

1. Install Dataiku

   Install Dataiku. For more information, see the Dataiku official documentation.

2. Connect to Hologres

   1. Log on to Dataiku and click Blank project. For this example, name the project Hologres.

   2. On the project details page, click +IMPORT YOUR FIRST DATASET to open the data source page.

   3. On the data source page, under the SQL data source type, select PostgreSQL and click Create a new connection.

   4. At the top of the page, click +NEW CONNECTION and select PostgreSQL from the drop-down list.

   5. Set the parameters in the BASIC PARAMS section. You can also specify a schema if required.

      The following table describes the parameters.

      Parameter	Description
      New connection name	Enter a name for your connection.
      Host	The public endpoint of your Hologres instance. Go to the Hologres Management Console, open the instance details page, and find the endpoint in the Network Information section.
      Port	The port of your Hologres instance. Go to the Hologres Management Console, open the instance details page, and find the port in the Network Information section.
      Database	The name of the Hologres database.
      User	The AccessKey ID of your Alibaba Cloud account. For more information, see Create an AccessKey pair.
      Password	The AccessKey secret of your Alibaba Cloud account. For more information, see Create an AccessKey pair.
      More parameters	For descriptions of additional parameters, see the Dataiku official documentation.

   6. Enter the parameters and click TEST at the bottom of the page. If the test is successful, click CREATE to establish the connection.

3. Analyze data

   After you complete the configuration, click Import tables to datasets at the bottom of the page to batch import table schemas from the database into datasets. After the import is complete, you can analyze the data. For more information about data analytics operations, see the Dataiku official documentation.