Create Tables

Starting in Strategy (November 2026), you can modify the name and data type in the Physical Table view.

Starting in Strategy One (October 2025), optionally enter a description of your change when saving a table and you can also trigger Merge Duplicate Columns manually in the schema editor.

You can create tables from data sources to a project using the Schema Editor. Using these tables as schema objects, you can create attributes and facts within the same project.

Before you begin using the Schema Editor, you need to be familiar with your schema, so you know how the information in your data sources should be brought into Strategy.

Check out the video below to learn more!

The Schema Editor used in this procedure uses the Modeling service infrastructure. Make sure the service is properly configured and running before creating tables.

  1. Open the Workstation window with the Navigation pane in smart mode.
  2. In the Navigation pane, click Schemas.
  3. Select an Environment from the upper-left drop-down list.
  4. Right-click a schema and select Edit Schema. The schema is locked while being edited.
  5. Select an environment and project.
  6. In the Schema Editor, use the Data Catalog on the left to connect to data sources and retrieve warehouse tables. Add tables to the right to create tables for the project.
  7. In the Data Catalog, click on a data source name to connect to it. Choose one namespace and click Connect. Expand the namespace to locate warehouse tables or use the search
  8. Hover over the connected data source to filter other namespaces by clicking filter icon or disconnect the data source by clicking the disconnect icon.
  9. Double-click the tables to add. For each selection, a logical table based on its warehouse table is created.

  10. Starting in Strategy (October 2026), to merge duplicate columns between warehouse tables, select the check box next to the warehouse tables, right-click a table, and choose Merge Duplicate Columns.

  11. On the right, click the warehouse or logical table to preview the warehouse data or table definition. For newly created tables, the table preview displays recommendations to create facts. Click Map to map the column to an existing fact.

  12. To rename a warehouse table, right-click it and choose Rename. You can also change the name prefix, primary data source, or secondary data source.

  13. To create another logical table alias based on the same warehouse table, right-click the logical table and choose Create new. After creating multiple logical tables, the total number of logical tables based on this warehouse table appears. To delete a logical table, right-click it and choose Delete.

  14. To delete a warehouse table, right-click it and choose Delete. All logical tables are deleted when the base warehouse table is deleted.

  15. If you add a table with the same namespace and table structure as one existing table in the schema, but it has a different data source, click Merge to add secondary data source for the existing table or Keep separate to create a new table.

  16. Starting in Strategy (November 2026), in the Physical Table View, hover next to a column and click Edit to modify the Name and Data Type.

  17. Click Save.
  18. Starting in Strategy One (October 2025), optionally type a description in User Comments and click OK.