Data Analytics Studio Operations
Also available as:
PDF

Creating tables

You can create a new table or upload an existing table to add it to the selected database.

  1. On the Database Explorer tab, click the + icon in the Tables section.

    The Create Table screen appears.

  2. Enter the name of the table.
  3. Click Add New Column to add columns to the table.
  4. For each column, specify the following details:
    1. Enter the name of the column.
    2. Select the data type of the column from the drop down list.
    3. Click Advanced to add advanced details of each column.
  5. Click Advanced tab of the Create Table page.
    1. Select Transactional if you want the table to be a transactional table.
    2. Click Add Location if you want to specify a location for the table.
    3. Select a file format from the drop down list of Add File Format section.
    4. Click Add Row Format to specify details for the rows.
  6. Click Properties to add key-value properties of the table.
  7. Click Create.