About Physical Tables

A physical table is an object that represents a data source's table. You can configure tables as physical tables, select tables, or stored procedure tables.

You can drag and drop tables from the data source into the physical layer's database. These imported tables contain metadata and joins from the data source. This metadata enables the Oracle Analytics query engine to use a SQL request to access the corresponding data source table.

You can also create virtual physical tables. Virtual tables provide the Oracle Analytics query engine and the underlying data sources with the proper metadata to perform advanced query requests.

You can store a virtual physical table as a stored procedure or a SELECT statement. You can define a table from a select statement and deploy it in the data source to create a deployed view.

For more information about the table source types you assign to physical tables, see What Are a Physical Table's General Properties?