Creating tables by importing CSV files from ABFS

You can create tables in Hue by importing CSV files stored in ABFS. Hue automatically detects the schema and the column types, thus helping you to create tables without using the CREATE TABLE syntax.

Only Hue Superusers can access ABFS and import files to create tables.

The maximum file size supported is three gigabytes.

  1. In the CDW service Overview page, select the Virtual Warehouse in which you want to create the table, click the options menu in the upper right corner and click Open Hue.
  2. From the left assist panel, click on Importer.
  3. On the Importer screen, click .. at the end of the Path field:

    Choose a file pop-up is displayed.
  4. Type abfs://[***CONTAINER-NAME***] in the address text box and press enter.
    The ABFS containers created under the Azure storage account are displayed.
    You can narrow down the list of results using the search option.
    If the file is present on your computer, then you can upload it to ABFS by clicking Upload a file.
  5. Select the CSV file that you want to import into Hue.
    Hue displays the preview of the table along with the format.
    Hue automatically detects the field separator, record separator, and the quote character from the CSV file. If you want to override a specific setting, then you can change it by selecting a different value from the drop-down menu.
  6. Click Next.
    On this page, you can set the table destination, partitions, and change the column data types.
  7. Verify the settings and click Submit to create the table.
    The CREATE TABLE query is triggered.
    Hue displays the logs and opens the Table Browser from which you can view the newly created table when the operation completes successfully.