How to Connect to Your Data on Dataiku Online

Supported connections

Dataiku Online allows you to connect to multiple sources of data as read-only sources or read-and-write storage.

Note

A (read-only) Data Source will be used to inform Dataiku how it can access data stored externally: Dataiku remembers the location of the original source datasets. This is read-only, no data is stored or modified in the original system.You typically use these datasets as the entry (left) of your flow.

A (read-and-write) Data Storage will be used not only to allow Dataiku to read the data but also to create new datasets (write) and, in SQL Data Storage, perform in-database computation thus improving performance.

From Dataiku Online, you can connect to the following :

Type

Read / Data Sources

Read and Write / Data Storage

Snowflake

X

X

Amazon S3

X

X

PostgreSQL

X

X

SQL Server

X

MySQL

X

BigQuery

X

Redshift

X

With Data Connector Plugins you can also connect to the following: Salesforce, Zendesk, Google Sheets

Note

Depending on your subscription plan, all the connectors are not available.

How to Add a new Data Connection

First navigate to the Launchpad to get started. In your space, open the Features tab:

../../_images/snowflake-connection-1.jpg

Click on the button Add a Feature:

../../_images/snowflake-connection-2.jpg

Choose your connection type from the Read Only Data Sources or Read/Write Data Storage sections:

../../_images/add-a-feature.png

Fill the connection details, and then click on Test:

../../_images/snowflake-connection-4.jpg

Once the test is OK, you can add the feature. You will get a confirmation message as well as a message letting you know the IP addresses you might need to whitelist to allow connection

../../_images/snowflake-connection-5.jpg