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 and click Blank project to create a project. For this example, name the project Hologres.

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

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

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

   5. Configure the BASIC PARAMS with your Hologres instance information. The BASIC PARAMS include Host, Database, Port, User, and Password. If needed, specify a schema in the Advanced JDBC properties section, or select Use custom JDBC URL to provide a custom connection URL.

      The following table describes the parameters.

      Parameter	Description
      New connection name	The name of the connection to be created.
      Host	The public endpoint of your Hologres instance. You can find this endpoint on the instance details page on the Hologres console under the Network Information section.
      Port	The port number of your Hologres instance. You can find the port number on the instance details page on the Hologres console under the Network Information section.
      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 configure the parameters, click TEST at the bottom of the page. If the connection is successful, click CREATE.

3. Analyze data.

   After the configuration is complete, click Import tables to datasets at the bottom of the page to bulk import table schemas from the database into a dataset. For more information about data analysis, see the Dataiku official documentation. To generate a grouped bar chart that shows the average quantity by ship mode and ship instruction, open the lineitem dataset in the DSS platform and select the Charts tab. Set Show Y to l_quantity (AVG), By X to l_shipmode, and And to l_shipinstruct.