What is Import?
Import brings a data file into your Indicate warehouse by hand, without an integration. Use it for a one-off dataset. It also fits data that a system produces on a schedule but does not offer through an API, for example a monthly accounting export.
Supported format: CSV. Parquet and JSON are marked Soon.
Every import only adds rows. Nothing already in the target table is replaced.
Imported tables land in
Data Studioin the schema uploads and can be queried and used in KPI collections.
Before you start
You need the Admin role. For other roles the entry
Importis locked.Import is part of the Pro plan.
The file has to be a CSV of at most 200 MB.
How do I import a file?
You import a file on the page Import, which you open under Data sources in the left rail.
Imports cannot be undone. Once rows are written, Import cannot delete or change them. Before you upload, check the target table, the column names and types, and the file itself.
Open
Data sources→Import. Schema is fixed to uploads, and every imported table lives there.
Under Target table, click Select a table… and pick an existing table. For a new table, click Create new table and enter a Table name with only letters, numbers and underscores, for example customer_data.
Under CSV options, pick the Separator your file uses: Comma, Semicolon, Tab or Pipe. Comma is the default.
Leave First row contains headers on if the first row holds the column names. If your file has no header row, turn it off and enter a Column name and a Type for every column under Column definitions.
Under File, drop your CSV into the box or click the box to browse.
Set the Null threshold: The largest share of empty values a column may have. A column with more empty cells makes the import fail, so a broken file does not slip in. Raise it for data that legitimately has many empty cells.
Click Import file. The page shows Uploading and processing… and then a toast such as Imported 1,204 rows into customer_data.
The table is available right away. Open Data Studio in the left rail and look in the schema uploads to check the rows.
Null is not zero. An empty cell stays empty and is left out of averages. A 0 counts as a measured value and pulls averages down. Leave a cell empty when the value is unknown, and write 0 only when zero really happened.
How do I add data to the same table again?
Every import only adds rows, so you can upload a new file into the same table every day, week or month. Pick the existing table under Target table, and the new rows are appended. Dashboards, KPI collections and Resi use the new rows as soon as the import is through. You do not have to reconfigure anything.
Include a date column in the file, for example report_month, so you can group and filter by period later.
Indicate does not remove duplicates. If you upload the same file twice, every row is in the table twice, so upload each file once.
What happens when the structure of my file changes?
If a new file does not match the existing table exactly, the table is extended automatically:
A column is missing in the new file: The new rows get an empty value in that column. The import does not fail.
A new column appears: It is added to the table on the right. Older rows get an empty value in it.
A column is renamed, for example revenue to Revenue: Indicate treats it as a new column. Both columns exist side by side.
A column changes its type, for example from whole numbers to decimals: Indicate adds a second column for the new type instead of converting.
Keep column names and types the same across uploads to the same table. Otherwise the table fills up with duplicate columns.
Troubleshooting
Why can't I open Import?
- The entry needs the Admin role and the Pro plan. Hover over the locked entry to see which one is missing. Then ask a space admin or open
Settings→Plan.
Why is my import rejected?
The Separator does not match the file, for example semicolon instead of comma.
A column has more empty cells than the Null threshold allows. Raise the threshold or fill the column.
Dates or numbers are written in different formats across rows. Examples are 01/02/2024 next to 2024-02-01 and 1.234,56 next to 1234.56. Use one format, ideally YYYY-MM-DD and a dot as decimal separator.
A value does not fit the column type of the existing table, for example text in a number column.
The file has unescaped quotes, line breaks inside cells or rows with extra columns.
What can I do if I imported the wrong file?
Import cannot remove rows. If the table only holds this one upload, drop the whole table in
Data Studioand import the corrected file into a new table.If the table already holds many good uploads, dropping it loses those too. Test the structure with the first upload before you start adding to a table regularly.
What can I do if my file is larger than 200 MB?
- Split it into several files and import them one after the other into the same table.