Getting started with SeekWell

Use SeekWell to write SQL and send the results to apps like Google Sheets, MS Teams, Salesforce, Slack, and more. Blocks are the fundamental framework for working with SeekWell. The four primary components of your block are the SQL that you write, the data source, the destination for your output, and the parameter mapping.

Blocks

Blocks can operate on the results of other blocks, so you can build complex processes to move data across databases and applications.

Create a Block

To create a block, follow these steps:

  1. Log in to SeekWell.

  2. Select the plus icon in the top-right of the screen and choose New SQL.

  3. Select Untitled and enter the title of your new Block.

Connect to a source

To connect to a new source, follow these steps:

  1. Open your Block.

  2. Under Source in the top right corner, select Add new source. If you have a previous connection, select the connection nickname under Source and scroll down to select Add new source.

  3. In the pop-up New source window, complete the following fields:

    1. Flavor

    2. Nickname

    3. Account Name (exclusive to Snowflake connections)

    4. Service Account Information in JSON (exclusive to BigQuery)

    5. Host

    6. Port

    7. Username

    8. Password

    9. Warehouse (exclusive to Snowflake connections)

    10. Database

    11. Use SSL / Use SSH

      You must safelist the SeekWell IP addresses (35.193.207.79 and 35.239.74.213) for the connection to work. For more information, see Safelisting our IP address.

  4. Select Save.

Write your SQL statement

To input a SQL statement, follow these steps:

  1. Select Write SQL here…​ and enter your statement. Select the Play icon to run your query.

  2. In the section below the SQL statement, verify that your statement produces the desired results. Note that you can view your results in both chart and table form.

Connect to a destination

To connect to a new destination, follow these steps:

  1. Under Destination, select Add destination. If you have previously selected destinations, select the destination name and scroll down to select Add destination.
    SeekWell selects Sheets as the default destination. To send your results to a different destination, select Sheets and scroll down to select your new destination.

  2. Fill out the fields below your selected destination. For Sheets, fill out the following fields:

    1. Spreadsheet: Select a spreadsheet or select Create new Sheet. If you do not see the desired spreadsheet destination, begin typing to search, or select Refresh Sheets.

    2. Sheet1: Enter the page of the Spreadsheet to input your results. SeekWell defaults to Sheet1.

    3. A1: Enter the beginning cell to input your results. SeekWell defaults to cell A1.

    4. Replace rows / Append rows: If your selected Sheet has existing data, decide whether to replace rows with your results, or append your results.

    5. Include column names / Omit column names: Decide whether to include or omit column names.

  3. Select Save.

  4. Select the Play icon to run your query and send the results to your chosen destination. The results appear in your destination within a few seconds.

Set parameters [optional]

With parameters, you can inject data into your SQL statement. You can input plain text or numbers, or inject data from Sheets or another block.

In this example, we demonstrate how to use parameters to add data to your block from Sheets. To set parameters for your block, follow these steps:

  1. Within your SQL statement, add a parameter.

    select e.*
from dummy.events AS e
where 1=1
and e.email like '%{{email}}%'
limit 200

  2. As soon as you add a parameter to your SQL, the Parameters section appears in SeekWell. Select Sheets as the Type.

  3. Select the Spreadsheet you want to grab the parameter value from and the cell using A1 notation (for example, Sheet1!A1). You can only use a single cell, except in the case of Postgres and Snowflake. If you need to reference multiple cells, use and / or statements.

  4. Run the query and results appear based on your parameters.

Related information

Was this page helpful?
×