make_table

Type of operation: Metadata

Description

Creates a Table dataset from an input Event, Interval, or Resource dataset.

make_table clears the verb input’s Valid From, Valid To, primary key, and candidate key metadata, producing non-temporal output rows. The output of this verb is not accelerable.

Usage

make_table 

Accelerable

make_table is never accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

make_table

From the input Event dataset, creates a Table dataset. The output Table dataset will have no primary key and no candidate keys, regardless of the input dataset’s keys. All columns from the input dataset will exist in the output, including the column which was previously designated as Valid From.

make_table

From the input Resource dataset, creates a Table dataset. The output Table dataset will have no primary key and no candidate keys, regardless of the input dataset’s keys. All columns from the input dataset will exist in the output, including the columns which were previously designated as Valid From and Valid To.

Aliases

• droptime (deprecated)