Create a Table

Creates a new table from a select query. See CREATE table documentation.

The REST API playground can currently only be used with MindsDB running locally at http://127.0.0.1:47334. Support for MindsDB Cloud is in progress. In the meantime, check out our SQL example for how to use the REST API with MindsDB Cloud.

Path Parameters

databaseName

string

required

Name of the database

Body

application/json

table

object

Show child attributes

table.name

string

table.select

string

SELECT statement to create the table from

table.replace

boolean

Whether or not to delete a pre-existing table before creating it

Response

200 - application/json

name

string

type

string

Type of table (data | view)