Importing data in CSV format

Learn how to add data to Cloudera Data Visualization from flat CSV files.

You can use comma-delimited files or files with other delimiting characters. If you want to import data stored in Excel format, see Preparing Excel files for data import.

This feature is available on the following connections:
Enabled by default: Disabled by default:
  • SQLite
  • Hive
  • Impala
  • Snowflake [Technical Preview]
  • Solr [Technical Preview]
  • Spark SQL
  • DuckDB
  • MS SQL
  • Teradata
  1. On the main navigation bar, click DATA.

    The Data view appears, opening on the Datasets tab.

  2. Click ADD DATA.
    The Add Data modal window appears.
  3. Select the CSV option and click Choose file.
  4. Using your computer's native browser, locate and select the data file, and confirm the file selection.
  5. In the Add Data modal window, verify the name of the file you added and click GET DATA.
  6. Ensure that your data is configured correctly before confirming the import:
    1. Under Database, specify samples. Alternatively, you can select another database.
    2. Under Table Name, specify a table. The system usually assigns a numerical suffix, which you can remove.
    3. Under Upon Import, select whether you only want to import data or create a dataset and a dashboard based on the data.
      • If you select Create Dataset, you are directed to the Detail page of the dataset you have created after the import is completed.
      • If you select Create Dataset and Dashboard, you are directed to the newly created dashboard when the import is completed.
    4. For Column Delimiter, define the 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.
    5. Under Locale Setting, you can select one of the common options: United States, United Kingdom, Sweden, Norway, or Other. Selecting Other adds a separate field next to the locale setting where you can specify the supported locale. For more information, see Changing the locale setting of an imported file.
    6. Under Options, select the data clean-up tasks that Data Visualization provides prior to data import. These include File contains headers, Fill missing columns, Skip malformed rows, and Use '\' as escape character.
    7. In the Data Table preview, each column of the table appears with its data type and name. Data Visualization detects the data type automatically, but you can modify it in this interface before importing. For example, you may want to store numerical categories as strings. The data types are Boolean, Integer, Real, String, and Timestamp.
    8. You can change the name of the table column before importing.
  7. Click APPLY CHANGES to save all the adjustments you have made.
    The Confirm File Import modal window appears, where you have to click CONFIRM IMPORT once more3.
  9. To verify that the data has been imported correctly into your system, check the Connection Explorer interface.