Importing Data

You can import data from a flat file into your Arcadia Instant instance. Arcadia Instant processes this data as a new table, adding it to an existing data repository. You can then use it as a source of supplemental information for existing datasets, by creating new table joins. You can also create a new dataset that references the imported data as a primary table.

Availability Note. Data Import is only available on Arcadia and SQLite connections.
Tip. If you must import data stored in Excel format, see Preparing Excel Files for Data Import.

The following steps demonstrate how to import data from flat files. The files may be comma-delimited, or use other delimiting characters. This exercise uses the data from the downloadable table state-area.csv import data into [data source samples.state_area].

  1. On the main navigation bar, click Data.

    Click DATA on main nav

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. Click the supplemental menu, and then click Import Data in the drop-down.

    Import Data button

    The Import Data from File modal window appears.

  3. In the Import Data from File modal window, click Choose File.

    Import Data from File window
    Import Data from File Modal Window
  4. Using your computer's native browser, find and select the data file.

    Confirm file selection.

  5. In the Import Data from File modal window, note that the name of the file you added. In this example, we are adding state-area.csv.

    Click Get Data.

    Import Data from File window
    Selecting a Data File to Upload
  6. In the main area, under Imported File: sate-area.csv, ensure that your data is configured correctly before confirming its import:

    1. Under Database, specify samples. Alternatively, select another database.
    2. Under Table Name, specify state_area. The system typically assigns a numerical suffix that you can remove.
    3. The Arcadia Instant makes an attempt to detect the Column Delimiter used in the source file. In this case, the column delimiter is Comma, but it can also be Tab, Space, Semicolon, Colon, Pipe, Control A, or Other. Make the necessary adjustments to this field.
    4. Under Locale Setting, which is the default for your system, you can select one of the common options: United States, United Kingdom, Sweden, Norway, or Other. Selecting Other brings up a separate menu where you can select another supported locale. See Changing the Locale Setting of an Imported File.
    5. Under Options, select the data clean-up tasks that Arcadia Instant provides prior to data import. These include File contains headers, Use comma as decimal mark, Fill missing columns, Skip malformed rows, and Use '\' as escape character. Note that Arcadia Instant can detect many items automatically, such as the presence of header rows.
    6. In the Data Table preview, each column of the table appears with its data type and name. Arcadia Instant detects the data type automatically, but you can change it in this interface prior to import. For example, you may wish to store numerical categories as strings. The data types are Boolean, Integer, Real, String, and Timestamp.
    7. [Optional] You may select to change the name of the table column before importing.

      In this example, we could change the column names state to land_area_sq_miles.

    confirming the data OK to import
    Confirming Data Configuration Before Import
  7. Click Apply Changes to ensure that all adjustments you made (file name, data type, name change, and so on) register.

    Applying changes to data file before import
    Applying Changes Before Import
  8. Click Confirm Import.

    Confirming data file import
    Confirming Data Import
  9. Click Confirm Import.

    confirming the data import
    Confirming Data Configuration Before Import
  10. To verify that the data has been imported correctly into your system, check the Connection Explorer interface. Note that the state-area table is visible in our connection.

    confirming data import
    Data File in Connection Explorer

Typically, we use the Import Data functionality to supplement existing datasets; we add this data by creating joins in the data model.

Depending on your business case, you may instead choose to create a new dataset based on the data you just imported.