Dataiku connection

Prerequisites

• Ensure an AnalyticDB for PostgreSQL data source is available.

• Ensure Dataiku is installed. For details, see the official Dataiku documentation.

Limitations

Due to a limitation in Dataiku, you can query an external table directly with a SQL Notebook, but you cannot view it using Import tables to datasets.

Procedure

1. In Dataiku, click Blank project to create a project. For this example, name the project AnalyticDB for PostgreSQL.

2. On the project details page, click +IMPORT YOUR FIRST DATASET.

3. On the Data Source page, in the SQL Statement data source type section, select PostgreSQL. Click create a new connection.

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

5. On the NEW PostgreSQL connection page, configure the following parameters.

   Parameter	Description
   New connection name	Enter a name for the connection.
   Host	The internal endpoint of your AnalyticDB for PostgreSQL instance. You can obtain this endpoint from the Database Connection page in the AnalyticDB for PostgreSQL console.
   Port	The port number for your AnalyticDB for PostgreSQL instance. The default is 5432.
   Database	The database name for your AnalyticDB for PostgreSQL instance.
   User	The database account for your AnalyticDB for PostgreSQL instance.
   Password	AnalyticDB for PostgreSQL instance password.
   Other parameters	For details on other parameters, see the official Dataiku documentation.

6. After you configure the parameters, click TEST at the bottom of the page. If the connection test is successful, click CREATE.

7. After creating the connection, click Import tables to datasets at the bottom of the page to batch-import tables from the database as datasets. You can then analyze the data. For more information about data analysis, see the official Dataiku documentation.