Creating a Column Family

This topic describes creating a column family.

Prerequisites

  • A table must be available for you to create a column family.
  • You must have the permissions to create column families on the table.

About this task

Follow the steps given below to create a column family on a table.

Procedure

  1. Log on to the Data Fabric UI.
  2. Select Fabric user on the Home page.
  3. Click the Table View icon on the Resources card. In the tabular list of fabrics, click the down arrow for the fabric that contains the table on which you want to create a column family.
  4. Click the table name seen under Resource Name.
  5. Click Add column family on the Column families tab.
    The Add column family wizard opens on the Column family details screen.
  6. Enter the Column family name.
  7. Enter the Max version and Min version for your column family. This is the the maximum and minimum number of versions that are retained upon revision to the column family.
  8. Click the toggle to enable Read optimization. Read optimzation enables in-memory caching for read workloads, greatly improving the speed of read operation for large workloads.
  9. (Optional) Create user access controls for your column family.
    The wizard automatically creates a default column family Access control entry. You can edit the default entry, or delete it with the action button (trash can).
    1. Select the user Type.
    2. Enter the user Name.
    3. Select the permissions you want the user to have:
      • Read: The user has read permissions on the column family.
      • Write: The user has write permissions on the column family.
      • Append: The user has append permissions on the column family.
      • Version: The user can roll the column family back to a previous version.
    4. (Optional) Click Add to create another user access control for the column family.
  10. Click Manage column permissions.
    The Add column family wizard opens the Manage column permissions window. From this window, you can create columns and column-specific access controls.
  11. (Optional) To create a column in the column family, enter the column name.
  12. (Optional) Create user access controls for your column.
    The wizard automatically creates a default column Access control entry. You can edit the default entry, or delete it with the action button (trash can).
    1. Select the user Type.
    2. Enter the user Name.
    3. Select the permissions you want the user to have:
      • Read: The user can read the entries in the column.
      • Write: The user can alter the existing column entries.
      • Append: The user can add new records to the column.
    4. (Optional) Click Add to create another user column in the column family.
  13. Click Apply.

Results

The column family is created on the table with the defined access controls and columns.