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.
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
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?.
Add a data source.
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.
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
Once the structure and table settings are finalized, select
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.