Views

class mindsdb_sdk.views.View(db, name)

Bases: mindsdb_sdk.tables.Table

class mindsdb_sdk.views.Views(project, api)

Bases: mindsdb_sdk.utils.objects_collection.CollectionBase

Views

Get:

>>> views = views.list()
>>> view = views[0]

By name:

>>> view = views.get('view1')

Create:

>>> view = views.create(
...   'view1',
...   database='example_db',  # optional, can also be database object
...   query='select * from table1'
...)

Create using query object:

>>> view = views.create(
...   'view1',
...   query=database.query('select * from table1')
...)

Getting data:

>>> view = view.filter(a=1, b=2)
>>> view = view.limit(100)
>>> df = view.fetch()

Drop view:

>>> views.drop('view1')

create(name: str, sql: Union[str, mindsdb_sdk.query.Query], database: str = None) → mindsdb_sdk.views.View

Create new view in project and return it

Parameters

• name – name of the view

• sql – sql query as string or query object

• database – datasource of the view (where input sql will be executed)

Returns

View object

drop(name: str)

Drop view from project

Parameters

name – name of the view

get(name: str) → mindsdb_sdk.views.View

Get view by name from project

Parameters

name – name of the view

Returns

View object

list() → List[mindsdb_sdk.views.View]

Show list of views in project

Returns

list of View objects