Skip to Content

Supported connectors

Connect CSV and spreadsheet files

Upload CSV, XLSX or Parquet files and query them as tables.

Before you start

  • You are an Admin or a Developer, or your role has the datasource Connect permission.
  • Each file has a header row. Databrain reads the first row as column names.
  • CSV files are comma-separated and UTF-8. A semicolon-separated export reads as one column.

Connect

  1. Go to Data Studio > Datasources and select Connect data source.

    Datasources page with the Connect data source button outlined
    Connect data source is at the top right of the Datasources page.
  2. Select CSV. You can type the name in Search connectors.

    Add datasource page with the CSV tile outlined
    The CSV tile on the Add datasource page.
  3. Fill in the form:

    FieldWhat to enter
    Datasource nameHow this datasource appears in lists and pickers, for example Production warehouse.
    FilesDrag files in, or select Choose files. CSV, XLSX or Parquet, up to 5 files. Each file name becomes a table name.
  4. Select Upload and connect.

Connect CSV form with the connect button outlined and the Setup guide on the right
Fill in the form, then select the button at the bottom. The Setup guide on the right lists the grants and where each value comes from.

Databrain checks the connection and reads your schema. You see Step 3 of 3 with Model your data. Next, create a datamart.

Where to find the values

  • Databrain guesses each column type from its rows. One text value in a number column makes the whole column text.
  • Keep the page open until the upload reports that it is done.

If something goes wrong

If the check fails, the datasource stays on the form with Needs credentials. Fix the field the message names and select Upload and connect again.

  • Max 5 files allowed. Upload 5 files or fewer. Create a second CSV datasource for more.

On this page