Add or remove columns

To pull data using a visual mode query, you’ll need to select columns from the schemas of your connected data sources.

Add a column

To add a column, select +Add column in the “Columns” section of your query. To find and add a column from the list, you can do any of the following options:

1. Search for it using the search bar.

2. Navigate through the schema browser.

3. Select a column from the table preview of the schema browser when you select a table.

After adding a column, you might see some schemas, tables, or columns become disabled in the schema browser when you try to add another column. This means the currently selected columns aren’t connected to those disabled items. You may need to update your data source’s foreign keys to connect the tables or add another "Query" step to query and merge additional columns.

Aggregation menu

When you add a column to the query, you can specify how to group or aggregate its values. Each column has the following:

1. Applied group or aggregation: Selecting it opens the column’s aggregation menu. Each column has a default aggregation, which you can change in its column properties.

2. Aggregation menu: A set of group or aggregation options available for the column. The available options depend on the column’s data type. Learn more about the available group and aggregation options.

If you don’t want to group or aggregate a column, select Unaggregated from the menu.

Remove a column

To remove a column from your query, hover over the column in the query and select the X that appears within its block.