Skip to main content
Version: 0.22.2

Mark

Mark lets you create foreign and primary keys for your datasets.

Format

Mark uses two utterances:

  • Mark as foreign key on the dataset <source dataset> referencing <target dataset> <column names>
  • Mark as primary key on the dataset <source dataset> the column <column names>

Parameters

Mark uses three parameters:

  • source dataset (required). The name of the source dataset.
  • target dataset (required). The name of the target dataset.
  • column names (required). The name of the columns to mark as a key.

Output

If a column is successfully marked, a success message appears in the chat history. Otherwise, an error message appears.

Examples

To mark the column relativeHumidity from the dataset BikeShare as a primary key, enter Mark as primary key on the dataset BikeShare the column relativeHumidity.

To mark the column weatherSituation from the dataset WeatherDecode as a foreign key for the dataset BikeShare, enter Mark as foreign key on the dataset BikeShare referencing WeatherDecode weatherSituation.