SQL is a powerful tool when you need something very specific from your data. Our SQL transform uses PostgreSQL.
To write SQL, first click the Add Transforms button, then select SQL.
The following window will pull up, where you can write your SQL statement and click Run when you are finished.
On the right you'll notice Grow lists out the different reports you are working with and the column names within each report that could be used in your SQL statement. You can hover over any of the column names and you'll notice a small blue 'copy' pop up.
You can click this copy button on a specific column name and then simply paste it into the SQL statement. You can also double-click the column name to insert it into the SQL statement. This is especially helpful if you have long column names since you no longer have to type out the full name and eliminates potential typos.
Here are some other SQL resources: