Skip to main content

WASM Model

The WASM Model uses WASM technology to run the analytical database within the browser, allowing for the analysis of online data. The WASM model supports the following data source types:

  • CSV
  • JSON
  • Parquet
  • Excel

Creating a WASM Model​

On the model list page, click on Create WASM Model in the more menu, enter the model name in the popup, and click apply to create. Open the newly created model.

Adding Data Files​

Before modeling, you need to add a data table.

  1. Click the add button in the data table area to create a data table.
  2. Enter table name: CsseCovid19Daily
  3. Select type: csv
  4. Delimiter: Default is empty or ,
  5. Enter link https://app.mtda.cloud/assets/data/CsseCovid19Daily.csv You can also upload data files to network storage, and the link address of the network storage will automatically fill in the link address:
  6. Click next to preview the data (if the file data volume is large, the page may lag), (adjust the Last_Update field type to Date)
  7. After confirming everything is correct, click apply to add the file (table) to the model.
info

Enterprise tenants can customize network storage configurations.

Detailed file configuration:

AttributeDescriptionValue
NameTable nameAny valid table name (refer to PostgreSQL)
TypeOnline file typeCSV, JSON, Parquet, Excel
First row is headerWhether the first row of the file is the column header when the file type is CSV
DelimiterColumn delimiter when the file type is CSV
LinkLink address of the online file

After successfully adding the data table, you can verify the data correctness through the query interface. Enter and execute SQL in the query interface to see if you can get the data from the CSV file.

The query statement is