Visual Query Builder

Learn how to query your data without writing SQL statements

Query Builder

Just because you are new to the SQL syntax, does not mean that you should be deprived of the power of SQL to query your data.

Atlan includes a simple visual query builder that lets you explore petabytes of data without writing SQL statements.

✨ Spotlight: The intuitive interface allows non-SQL users to comfortable query large amounts of data.

Excited to learn more about it? Keep reading to check out the details of each query option.

πŸ› οΈ Learn how to use various operations in the query builder

Using the query build to find when Americans order coffee

ACTION 1: FILTER BY

You can filter your data based on different conditions, which can be applied to columns of several data types.

  1. Click on "+".

  2. Select the column whose values you want to use to filter data.

  3. Select the operator.

  4. Add a value.

  5. Click "Run Query" (the bright green button).

For example, imagine you want to filter to show only beverages ordered on Sunday. You can easily choose the column "day_of_week", the type of operator "is", and select the value "Sunday" from the drop-down.

🌟 Pro Tip: In case you want to filter a string column on a bunch of values, you can copy and paste them with the "Paste Bulk Values" option.

ACTION 2: GROUP BY

You can aggregate your data by grouping it on specific columns.

  1. Click on "+".

  2. Select the column or columns at which you want to group your data

  3. Click "Run Query". (You can also create your entire query and then hit "Run", or you can keep running it after each step like filter, group by, etc.)

For example, imagine you want to see the number of orders picked up from each unique aisle or category. Just group your table at the "aisle" column.

ACTION 3: AGGREGATE BY

You can choose different functions like "Sum", "Count", "Average", and "Unique" to aggregate columns.

  1. Click on "+".

  2. Select the column or columns that you want to aggregate.

  3. Select the function you want to use to aggregate, like "Sum" or "Count".

In our previous example, we wanted to check the count of orders in each category/aisle. After grouping the data at the "aisle" column, we will now aggregate the "order_id" column and choose the "Count" function to calculate the count of orders under each aisle.

ACTION 4: SORT BY

Rank your results in increasing or decreasing order using the Sort By action.

  1. Click on "+".

  2. Select the column that you want to sort the table by.

  3. Select whether you want to sort it in ascending or descending order.

To continue our previous example, if we want to look at the aisles with the most orders, we'll sort the order count in descending order.

Sort table

🎊 You will get all your aisles/categories ranked from top to bottom based on their order counts. We can clearly see that refrigerated water🚰, most essential to humans, is ordered the most πŸ˜„

ACTION 5: ROW LIMIT

This action can be used to limit the number of results displayed in the table.

  1. Enter the number of rows you want to see in the display table.

If you only want to see the top 5 ordered categories in the display table, enter 5 as the row limit.

Row Limit

✨ Spotlight: The "Convert to SQL" option can be used to convert your build query to SQL and save it for later. This can also help non-SQL users learn the SQL syntax.

Want to save πŸ’Ύ your query for future use? Refer to the article below to learn how to do that in just a few clicks.