Sets (deprecated)

Sets in SeekWell allow you to create clean datasets for the rest of your team to use, and allow them to analyze data in your database without having to write code.

Let’s walk through a demonstration of how to create a set, explore the set within SeekWell, and send the results to an external business app.

Create a SeekWell Set

To create a Set within SeekWell, follow these steps:

  1. Connect to your database. The Source dropdown displays all previously connected databases. If you do not see In this example, we connect to the demo database, sw-replica.

  2. Write your SQL query, for example:

    select u.*
    from dummy.users as u
    where 1=1
  3. Test that you see the desired results by running your query.

  4. In the bottom right corner, select the Edit set schema icon, which looks like two curly brackets. SeekWell automatically generates a schema for your SQL query.

  5. Using the Edit set schema window, you can add measures to your query, such as a count of paid users, by injecting a SQL attribute defining a `"sum(case when plan != 'basic' then 1 else 0 end)".

  6. Select Run to test your updated query schema displays the desired results.

Explore sets in SeekWell

To explore a set within SeekWell, follow these steps:

  1. Type command / control + k, then search for Explore Sets.

  2. Enter the name of your set in the Sets search bar.

  3. Search for the relevant measures to suit your business use case. In this example, to find the total number of plans, contrast by the number of paid plans, and group the results by week, you would search for: DemoUsers.created_on_week DemoUsers.count DemoUsers.paid.

  4. Type command + enter, or select the Run icon to see your results. SeekWell displays your results as a table by default. To see your results as a chart, select the chart icon.

  5. [Optional] Title the chart view of your search to save.

Send your results to an external app

To send the results of your exploration in Sets to an external app, follow these steps:

  1. Open the side-menu and select Click to edit destination.

  2. Fill in the details of your destination. For example, when sending to Google Sheets, you must enter the destination Spreadsheet, Sheet name, and cell number in A1 format.

  3. Run the query again. Your results appear in your destination app within seconds.