Skip to content

LIST

1. LIST Statement

The "LIST" statement allows users to view the lastest pre-built models("THANOSQL MODEL"), provided datasets("THANOSQL DATASET"), data tables("TABLE") and the models("MODEL") created by the users.

2. LIST Syntax

The "LIST MODEL" statement outputs the models you have created.

LIST MODEL

IMAGE

The "LIST THANOSQL MODEL" statement outputs the latest pre-built models.

LIST THANOSQL MODEL

IMAGE

The "LIST THANOSQL DATASET" statement outputs the latest datasets used by the tutorials.

LIST THANOSQL DATASET

IMAGE

The "LIST TABLE" statement outputs the data tables you have created.

LIST TABLE

IMAGE

LIST as a Subquery

  • "LIST" clause can be used as "SELECT" clause's subquery.
  • By using "LIST" clause as a subquery like "SELECT * FROM (LIST THANOSQL MODEL)", you can use SQL clauses like "LIMIT" and "WHERE" with "LIST" clause as well.
Last update: 2023-08-09