Adding data in CSV format

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

The files may be comma-delimited, or use 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
  • Spark SQL
  • DuckDB
  • MS SQL
  • Teradata
  1. On the main navigation bar, click DATA.

    The Data view appears, open 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, find and select the data file and confirm file selection.
  5. In the Add Data modal window, check 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 typically assigns a numerical suffix that you can remove.
    3. 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.
    4. 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.
    5. 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.
    6. 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 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. You can change the name of the table column before importing.
  7. Click APPLY CHANGES to ensure that all adjustments you made are saved.
  8. Click CONFIRM IMPORT.
    The Confirm File Import modal window appears, where you have to click CONFIRM IMPORT again.
  9. To verify that the data has been imported correctly into your system, check the Connection Explorer interface.