Creating a staging database table manually

You can create tables and add their columns manually, or you can add columns from the result set of a query against a data source.

  1. Select Dashboards > Data Integrations > Relational Modeling.
  2. From the Target Connection list, select Staging.
  3. Click New Table and specify this information:
    Name
    Specify the name of the table.
    Description
    Optionally, specify the description of the table.
  4. Click Next.
  5. Click Add columns manually.
    If the button is not displayed, click the three dots, More, icon and select from the menu.
    Note: Spaces, and these characters, cannot be used in column names: []\/|:*!@#%^&()"<>.
    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
  6. Specify this information.
    Name
    Specify a name for the column.
    Type
    Select the data type for 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 (Auto Increment) bigint
    Number (Float) float
    Boolean bit
    Date datetime
    Dimension View doesn't show auto-increment columns. These columns are managed by the database and do not support user-defined values.
  7. To add further columns, repeat steps 6 and 7.
  8. Click Finish.
    General Properties or Application Properties icons of the table to view the table's properties, click the table in the Relational Database Structure, or click the Tables of Staging panel.