Upload CSV data

User requirements

The ability to upload CSV data requires the following:

Where's my data stored?

When a CSV file is uploaded to Sigma, its data is automatically written back to your data warehouse as a new warehouse table. If your organization has multiple warehouses with write access enabled, you will be given the option to select a single destination.

CSV data stored in your warehouse is only accessible through the workbook in which it is used. You will not see it listed as a warehouse table in the connection's data catalog.Β 

Create a New Workbook from a CSV

  1. Click the + Create New button in the left navigation panel.
  2. Click Upload CSV.
    Screen_Shot_2021-08-10_at_11.08.08_AM.png
    This will open the Upload CSV page.
  3. Select a Connection from the list provided.
    The connection you select points to the warehouse your file will be uploaded to. If only one data warehouse has write access enabled, it will be selected by default.Β 
    Screen_Shot_2021-08-10_at_11.12.51_AM.png
  4. Upload your CSV file by dropping it in the page, or click Browse.Β 
  5. After adding a CSV, you will be shown a preview of your data.
    • [optional] On the left side of the page, uncheck any columns you wish to exclude from your upload.
    • [optional] Customize your parsing options under Parsing Options.Β 
    • [as needed] Address any warnings or errors.
      Screen_Shot_2021-08-10_at_11.19.12_AM.png
  6. Click Explore in the top right corner of the page.

Add a CSV to an Existing Workbook

Before you start: This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page; see Workbook lifecycle.

  1. Open the workbook'sΒ ADD NEWΒ panel.
    Screen_Shot_2022-02-02_at_3.49.10_PM.png

  2. Under DATA ELEMENTS, click to select your desired element type: TABLE, VIZ, or PIVOT TABLE.

  3. It's time to select a data source.
    Open the NEW tab.

  4. Click UPLOAD CSV.
    Screen_Shot_2022-02-02_at_5.13.48_PM.png

  5. Select a Connection from the list provided.
    Note: The connection you select points to the warehouse your file will be uploaded to. If only one data warehouse has write access enabled, it will be selected by default.
    Screen_Shot_2021-08-10_at_11.31.32_AM.png

  6. Upload your CSV file by dropping it in the page, or click Browse.

  7. You'll see a preview of your data.

    • [optional] Customize your parsing options under Parsing Options.Β 
    • [as needed] Address any warnings or errors.
    Screen_Shot_2021-08-10_at_11.32.41_AM.png
  8. Click Done.
    Your new element will appear on the page, and the editor panel will open up to the specific element’s configuration view.
    You may now interact with your new element using the editor panel, toolbar, or the element itself.


Related resources