Editing columns of a staging database table

If a table is empty, you can rename and delete columns, or change their data types. If a table is not empty, you can only add columns.

  1. Select Dashboards > Data Integrations > Relational Modeling..
  2. From the Target Connection list, select Staging.
  3. Select the table to edit and click the Schema tab.
  4. Click Edit Columns.
    You can delete, rename, and add columns.
    Note: Spaces, and these characters, cannot be used in column names: []\/|:*!@#%^&()"<>.

    You cannot delete or rename columns that have values.

    The Dimension View tab for a table is enabled only if the table has a column named ID. The ID column typically maps to element names in OLAP hierarchies. In addition, to enable full functionality of the dimension view, the table must have columns with these names:
    • ParentID
    • ElementType
    • Weight
    • OrderPosition
  5. Click Add Column and specify this information:
    Name
    Specify a name for the column.
    Type
    Select the data type of the column.

    This table shows the available data types and their SQL equivalents.

    Data type SQL equivalent
    Small Text: Max width=255 chars nvarchar(255)
    Big Text: No max width nvarchar(MAX)
    Number (Integer) bigint
    Number (Float) float
    Boolean bit
    Date datetime
    Primary key
    Select the check box to designate a column as the primary key.
  6. Add further columns as you require.
  7. Click Finish.