Creating and managing views

About views

Fabricate views allow you compose virtual tables from data in other tables. They are particularly use for:

• Denormalization

• Aggregation

• Subsetting

• JSON objects and arrays

When you export a database, views are exported as concrete tables. They do not create or replace the views in the target database.

Adding a view

To add a view to a database:

1. In the database heading, click Add View.

2. On the Add View panel, in the name field, provide a name for the view.

3. Click Create View.

The view is added to the tables list for the database.

The details page for the view is displayed.

Configuring a view

Defining the view

To define the view, in the query text area, provide the SQLite query to use. The view definition accepts any valid SQLite query.

Configuring other view settings

To display the settings panel for the view, in the view heading, click the settings icon.

The view settings contain most of the same options as regular tables, including:

• Constraints - For more information, go to Configuring constraints for the table.

• Whether to include the view in the export - For more information, go to Indicating whether to include the table in the export.

• A seed to use for the view - For more information, go to Setting a table-wide seed value.

Regenerating data for a view

To regenerate the view data based on the current view definition, in the view heading, click the regenerate icon.

Deleting a view

To delete a view, in the view header, click the delete icon.