Viewing, querying, and editing the data

Fabricate provides multiple views for a database. You can also run queries against the data and make direct updates to values in data cells.

Available views of a database

For a Data Agent database, you can choose from the following types of views:

• Table view - The default view. Displays the data for the current table in a table.

• JSON view - Displays the data for the current table as a set of JSON documents. Each row is a separate document.

• Findings view - Provides an analysis of the table structure and data. Findings view is populated when the Data Agent profiles the database.

Table view is the default.

Table view icon

To switch to JSON view, click the JSON view icon.

JSON view for a Data Agent database

To switch to Findings view, click the magnifying glass icon.

Findings view for a Data Agent database

Asking the Data Agent about the data

In addition to using the Data Agent to create and make changes to the data, you can also request information about the data.

For example, you might ask something like:

• How many customers have more than 2 items in an order?

• How many customers are from each state?

If applicable, the Data Agent generates a pie chart or bar chart to illustrate the results. You can also prompt the Data Agent to generate a specific type of chart.

Running SQL queries against the data

You can run SQL queries against a database to:

• Retrieve information about the data

• Retrieve a subset of the data

• Add records to the data

• Update records in the data

• Remove records from the data

To run a SQL query against the database:

1. In the heading, click SQL.

Option to run a SQL query against a database

1. On the SQL Editor panel, in the SQL field, provide the SQL query. The SQL can include SELECT, INSERT, UPDATE, and DELETE.

2. Click Execute Query.

Editing individual local database cells

To get the exact value that you want, you can manually edit the values in individual cells.

You cannot edit individual cells in database connection.

To edit an individual cell value:

1. Click the cell value.

Clicking a cell value to manually edit it

1. On the edit panel, enter the new value.

Edit Cell Value panel to edit the value in a cell

1. Click Save.