Uploading data

The Workbench supports the upload of custom CSVs that act like tables within a managed database. Managed databases are PostgreSQL databases that Contiamo manages on your behalf. A single managed database can support multiple tables, which are essentially multiple uploaded CSV files.
Creating a new managed database
In order to upload and query a CSV file, you must first create a managed database. 
To do this, you must navigate to the Add resources section in the sidebar.
Under resource type, select Managed. 
Fill out your chosen name, description and whether or not you want to make the data source visible to other team members by toggling Visible in catalog?. 
Finally, select Add a data source.
Uploading data to an existing managed database
The CSV file that you upload will form a table within a managed database. 
To upload a CSV to a managed data source, you must navigate to the Workbench section in the sidebar.
Once in the Workbench, click the three-dot icon next to the managed database that you would like to upload data to. 
Select Add Table.
Before uploading your data, you must set the table structure. You can choose to let the system automatically recognize the structure of your CSV or you can set the structure manually.
To automatically generate the structure, drag your file to the upload box or click the box to open your file browser. Once the file is uploaded, the system will detect the data type for each column. If the system has miscategorized any of your columns, you can manually change it by clicking the dropdown menu where the data type is written. In this section, you can also tell our system to ignore the first row; you can select whether or not your uploaded table has a header; and set your Delimiter, Date format, Encoding, and Decimal separator.
Once the structure and table settings are finalized, select Continue. 
In the next screen, you must set your table name and have the option to add a description.
Finally, to upload your CSV, click Yes, create a Table and import data I uploaded. Your CSV will now upload and be consumable as part of your managed database.

Workbench: Data virtualization - Previous

Introduction

Next - Workbench: Data virtualization

Querying data

Last modified 2yr ago

Copy link

Outline

Creating a new managed database

Uploading data to an existing managed database