Tools → Schema Designer → Tables

About the Schema Designer Tables

The Tables tab in the Schema Designer shows all objects created in the current physical schema if any. You can use the options available in this tab to add and manage all the physical schema objects. In addition, you can also use the options in the + New menu in the Action bar to add different types of objects to the physical schema. Physical schema objects can be physical schema tables, aliases, Incorta Analyzer tables, Incorta SQL tables, or Materialized Views (MV).

The Tables tab includes the following:

• Search box: to search for a physical schema object or a column in the physical schema. The Object list is filtered to show objects whose name matches the search term and objects that have one or more columns that match the search term.
• Show/Hide Columns: to specify the columns you want to show in the Object list. The following are the available columns to select from
  • Type
  • Data Source
  • Performance
  • Columns
  • Joins
  • Rows
  • Data Size
• +: to open the Table Data Source dialog to create a new object in the physical schema
• Object list: shows all objects available in the current physical schema. You can sort or filter this list using one of the available columns.

The following table shows a description of the columns and the options available in the Tables tab.

Schema Designer actions for a physical schema object

Using the Schema Designer, you can perform the following actions for a physical schema object:

• Create one or more physical schema tables using the Schema Wizard
• Create a physical schema object
  • Create a physical schema table
  • Create an alias
  • Create an Incorta Analyzer table
  • Create an Incorta SQL table
  • Create a materialized view
• Search for a physical schema object or column
• View physical schema object details
• Edit a physical schema object
• View the data lineage of a physical schema object
• Delete a physical schema object
• Specify and arrange the columns of the object list
• Sort the object list
• Filter the object list
• Start a load job of an object

Create one or more physical schema tables using the Schema Wizard

• In the Navigation bar, select Schema.
• In the list view of schemas, select a given physical schema.
• In the Schema Designer, in the Action bar, select + New → Schema Wizard.
• In (1) Choose a Source, for Select a Datasource, select the external data source for your new physical schema table(s).
• In the Schema Wizard footer, select Next.
• In (2) Manage Tables, in the Data Panel, specify the table(s) or file(s) you want to use to create the new physical schema tables. You can also select the Select All checkbox.
• In the Schema Wizard footer, select Next.
• In (3) Finalize, in the Schema Wizard footer, select Update Schema.

To learn more about using the Schema Wizard, review Tools → Schema Wizard.

Create a physical schema object

Create a physical schema table

• In the Schema Designer, do one of the following:
  • In the Action bar, select + New → Table.
  • In the Tables tab, select +.
• In the Table Data Source dialog, for Type, select the data source type and specify the properties of the new physical schema table.
• Select Add.
• In the Table Editor, enter the name of the new physical schema table.
• In the Table Editor, in the Action bar, select Done.

To discover more about the properties of different data sources, see Connectors → All, and refer to the suitable connector.

Create an alias

• In the Schema Designer, in the Action bar, select + New → Alias.
• In the Alias Table Source dialog, for Referenced Schema, select the physical schema of the original object that this alias references. This can be the current physical schema or another physical schema. The default is the current physical schema.
• For Referenced Table, select the original object that this alias references.
• Select OK.
• In the Table Editor, enter the name of the new alias.
• In the Action bar, select Done.

Create an Incorta Analyzer table

• In the Schema Designer, do one of the following:
  • In the Action bar, select + New → Derived Table → Incorta Analyzer.
  • In the Tables tab, select +, and then in the Table Data Source dialog, for Type, select Incorta Analyzer.
• In the Table Data Source dialog, select the pen icon.
• In the Analyzer, select the columns in the new Incorta Analyzer table and specify their properties.
• In the Analyzer, select Save.
• In the Table Data Source dialog, review the sample data, and then select Add.
• In the Table Editor, enter the name of the new Incorta Analyzer table.
• In the Table Editor, in the Action bar, select Done.

To learn more about the Analyzer, review Tools → Analyzer.

Create an Incorta SQL table

• In the Schema Designer, do one of the following:
  • In the Action bar, select + New → Derived Table → Incorta SQL.
  • In the Tables tab, select +, and then in the Table Data Source dialog, for Type, select Incorta SQL.
• In the Table Data Source dialog, select the Query box or the pen icon.
• In the Query Editor, enter the SQL code for the new Incorta SQL table, and then select Done.
• In the Table Data Source dialog, select Add.
• In the Table Editor, enter the name of the new Incorta SQL table.
• In the Table Editor, in the Action bar, select Done.

Create a materialized view

• In the Schema Designer, do one of the following:
  • In the Action bar, select + New → Materialized View.
  • In the Tables tab, select +, and then in the Table Data Source dialog, for Type, select Materialized View.
• In the Table Data Source dialog, for Language, select the script language of the new materialized view.
• In the Script section, do one of the following:
  • To add the script code using the Query Builder, select the Edit Query.
  • To add the script code using the Notebook Editor, select Edit in Notebook.
• Specify the MV properties as appropriate, and then select Add.
• In the Table Editor, enter the name of the new materialized view.
• In the Table Editor, in the Action bar, select Done.

To discover more about the properties of a materialized view, see Concepts → Materialized View.

Search for a physical schema object or column

• In the Schema Designer, in the Tables tab, in the Search box, enter a search term.
• The object list is filtered to show objects whose name matches the search term and objects that have one or more columns that match the search term.

View physical schema object details

• In the Schema Designer, in the Tables tab, for a given physical schema object, do one of the following:
  • Select the physical schema object.
  • Select More Options (⋮ vertical ellipsis), and then select Table Details.
• In the Table Editor, review the object properties.
• To exit the Table Editor without saving updates, if any, in the Action bar, select Cancel.

Edit a physical schema object

• In the Schema Designer, in the Tables tab, for a given physical schema object, do one of the following:
  • Select the physical schema object.
  • Select More Options (⋮ vertical ellipsis), and then select Table Details.
• In the Table Editor, make the necessary updates.
• To save updates, in the Table Editor, in the Action bar, select Done.

To learn more about using the Table Editor, review Tools → Table Editor.

View the data lineage of a physical schema object

This feature is available starting with 2023.7.0. You can view the upstream data lineage, which are the entities that this object references, whether other schema objects, variables, or business schema objects. Additionally, you can view the downstream data lineage, which are the entities that reference this object, whether other schema objects, variables, business schema objects, or dashboards.

Here are the steps to view the data lineage of an object.

• In the Schema Designer, in the Tables tab, for a given physical schema object, select More Options (⋮ vertical ellipsis).
• Select Open Lineage.
• In the Data Lineage Viewer v2, review the upstream and downstream lineage of the respective object.

Delete a physical schema object

• In the Schema Designer, in the Tables tab, for a given physical schema object, select More Options (⋮ vertical ellipsis), and then select Remove Table.
• In the dialog, clear or keep selected the Remove all joins related to this table checkbox, as appropriate, and then select Delete.

Specify and arrange the columns of the object list

• In the Schema Designer, in the Tables tab, select Show/Hide Columns.
• By default, all columns are selected. Clear the selection of the respective checkbox or keep it to specify the columns you want to show in the object list.
• Drag or move the columns to specify their order.
• To restore the default column order and select to show all columns, select Reset.

Sort the object list

By default, the physical schema objects are sorted in ascending order by the object name. You can sort the object list in ascending or descending order by any of the following columns:

• Table Name: alphabetical order
• Data Source: alphabetical order
• Columns: the number of columns
• Joins: the number of joins
• Rows: the number of rows
• Data Size: the data size on disk

Here are the steps to sort the object list.

• In the Schema Designer, in the Tables tab, in the object list, select the header of the column you want to sort by. The default is to sort in ascending order.
• Select the same column header to sort the list in descending order by the respective column.

Filter the object list

You can filter the object list by the object type and the performance optimization status.

• In the Schema Designer, in the Tables tab, in the object list, select the filter icon next to the header of the column you want to filter by.
• Select the appropriate filter options, and then select OK. For example, select the filter icon in the Type column header, and then select the types of objects you want to show. Select OK to apply the filter.
• To remove an applied filter, select the filter icon of the applied filter, and then select Reset.

Start a load job of an object

You can start a full load or a load from staging of a specific physical schema object instead of loading all objects in the physical schema. This option is not available for an alias.

Here are the steps to start a load job of an object.

• In the Schema Designer, in the Tables tab, for a given physical schema object, select More Options (⋮ vertical ellipsis).
• Do one of the following:
  • Select Load Table to start a full load job.
  • Select Load from Staging to start a load from staging job.
• In the dialog, select Load.

For information about how to check the load job status, refer to Review the status of a load job.