Hologres:Dataiku

Limits

Dataiku allows you to directly use SQL Notebook rather than import tables to datasets to query foreign tables.

Procedure

1. Install Dataiku.

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

2. Connect to Hologres.

   1. Log on to Dataiku. Click Blank project and create a project. In this example, a project named Hologres is created.

   2. On the project details page, click IMPORT YOUR FIRST DATASET to go to the Datasets tab.

   3. On the Datasets tab, select PostgreSQL from the SQL dataset types. On the Connection tab, click create a new connection.

   4. Click NEW CONNECTION in the upper part of the Connections tab, select PostgreSQL from the drop-down list, and then create a connection.

   5. Configure the parameters in the BASIC PARAMS section as required. You can also configure the schema-related parameters if necessary.

      The following table describes the parameters.

      Parameter	Description
      New connection name	The name of the connection to be created.
      Host	The public endpoint of the Hologres instance. You can obtain the endpoint of the Hologres instance from the Network Information section of the instance details page in the Hologres console.
      Port	The port number of the Hologres instance to which you want to connect. You can obtain the port number of the Hologres instance in the Network Information section of the instance details page in the Hologres console.
      Database	The name of the Hologres database.
      User	The AccessKey ID of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey ID, see Create an Alibaba Cloud account.
      Password	The AccessKey secret of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey secret, see Create an Alibaba Cloud account.
      Other parameters	For more information about other parameters, see Dataiku official documentation.

   6. After you configured the required parameters, click TEST in the lower part of the page. After a success message appears, click CREATE to create the connection.

3. Analyze data.

   After settings are complete, click Import tables to datasets in the lower part of the page to import table schemas from the database to the dataset at a time. Then, you can analyze data. For more information about the operations of data analytics, see Dataiku official documentation.