Skip to content

GET

1. GET Statement

The "GET" statement allows users to download the lastest ThanoSQL pre-built models and tutorial datasets.

2. GET Syntax

The "GET THANOSQL MODEL" statement downloads the ThanoSQL pre-built models to the user's workspace.

GET THANOSQL MODEL (ThanoSQL_model_name_expression)
OPTIONS (
    expression [ , ...]
    )

Tip

  • You can use the LIST THANOSQL MODEL statement to view a list of the ThanoSQL pre-built models.

Query Details

  • The "OPTIONS" clause allows you to change the value of a parameter. The definition of each parameter is as follows:
    • "model_name": the model name to store a given model in the ThanoSQL workspace. If not specified, pre-built models will be saved with their default names (str, optional)
    • "overwrite": determines whether to overwrite a model if it already exists. If set as True, the old model is replaced with the new model (bool, optional, True|False, default: False)

The "GET THANOSQL DATASET" statement downloads the tutorial datasets to the user's workspace.

GET THANOSQL DATASET (ThanoSQL_dataset_name_expression)
OPTIONS (overwrite=True)

Tip

  • You can use the LIST THANOSQL DATASET statement to view a list of the ThanoSQL datasets.
  • Datasets cannot be renamed.

Query Details

  • The "OPTIONS" clause allows you to change the value of a parameter. The definition of each parameter is as follows:
    • "overwrite": determines whether to overwrite a dataset if it already exists. If set as True, the old dataset is replaced with the new dataset (bool, optional, True|False, default: False)

3. GET Example

3-1. GET THANOSQL MODEL Example

%%thanosql
GET THANOSQL MODEL clip
OPTIONS (
    model_name='tutorial_search_clip',
    overwrite=True
    )

3-2. GET THANOSQL DATASET Example

%%thanosql
GET THANOSQL DATASET unsplash_data
OPTIONS (overwrite=True)
Last update: 2023-01-05