Data Source
2️⃣

Data Source

💡

Check out this video for a tutorial on KAWA’s new interface:

Playlist of Tutorials here: https://www.youtube.com/playlist?list=PL-glwHeQFKj4jEWqXz16I_RjzslAn2GO-

1) CSV file import

Let’s integrate the following CSV into KAWA:

Sample WINES.csv509.0KB

Step 1: Go to data source section, click on + Data source button and select Upload a file.

image

Step 2: Browse files and select the dataset CSV.

Step 3: A preview of the data appears on the left. If needed, you can modify the import configuration, and click on Preview data button, to update the import.

image

Step 4: Click on Next button at the bottom right to start configuring the data.

Step 5: KAWA automatically detects the types of the columns, but if needed, you can still change it by clicking on the type icon next to the column name.

image
📌
You can also select the keys of your data source by toggling on the correct ones (this is optional, it becomes mandatory only if the feed type is incremental). Keys guarantee the unicity of the rows of your data source. If none is selected, all rows are taken into account when importing the data.

Step 6: Finally click on Save and run button at the bottom right. Give a name to your data source and click on Create. Wait for the run to finish loading and click on Create sheet button to start exploring your data.

image

2) Connecting to an external system

KAWA allows you to connect to an external system. You may choose your connector from the existing list or request to add one. Please refer to the Connectors documentation here:

ConnectorsConnectors
image

3) Use Data Samples to start

To help you get started, KAWA has made available some pre-made data samples: E-Commerce, Wines and Events.

📌
“E-Commerce” and “Events” can be used for linked views as they have values in common.

Go to your Data Section > Home page to create a sheet with these samples:

image
image
  • Step 1: Simply click on Start.
image
  • Step 2: A data source and a sheet have been created. Click on Go to sheet to start exploring and analysing the data.
    • image

image