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 a name for the table.
    Description
    Optionally, specify a description of the table.
  4. Click Next.
  5. Click Add columns manually.
    If the button is not displayed, click the three dot, 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 OLAPhierarchies. 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 (Float) float
    Boolean bit
    Date datetime
  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.