Query

The Query feature allows you to work directly with the tables in Aleph using SQL. To do so, follow these steps:

1. Open the add-in

2. Click "Add" and then click "Query".

3. Select the warehouse that you would like to query data from. Integration tables and Aleph tables can be found in the Aleph Warehouse option, while data warehouse tables will be found in their respective options (e.g. Snowflake Connection).

4. You can start writing the SQL query from scratch, or you can click on the ellipsis and select "Start from table".

   • Select the desired table from the list, and Aleph will populate a basic query to use as a starting point.

5. Next, add the SQL code that you need for your query in the code block. You can also click on "Edit in large window" to open up a modal making it easier to edit.

6. Once your query is complete, you can click on the ellipsis and select "Format SQL" to clean up the format query to improve readibility.

7. Click on "Pull Data" and Aleph will open a new tab with the output of the query.

8. Any time you want to update the data or modify the query, just click on "Pull Data" to update the output.

You can also create variables in your spreadsheet and then feed that variable into a SQL query. You need to use to select the cells this way:

SELECT * 
FROM public.countries 
WHERE continent = {{range('E14')}} 
LIMIT 100

Or this way, with more than one cell:

SELECT * 
FROM public.countries 
WHERE continent in {{range('E14:E15')}} 
LIMIT 100