Query across a Google Sheet and a CSV file


When working with data it's likely that you will have the need to query across a couple of different sources. In this example, we will show you how to do this with a Google Sheet and a CSV file.
SELECT d.Symbol, c.Security, c.Executive, d.Price FROM (SELECT a.Symbol as Symbol, a.Security as Security, b.Executive as Executive
FROM "" a
JOIN "" b ON a.Security = b.Company) c
JOIN "" d ON c.Symbol = d.Symbol
A sample Query using public example datasets that can be tested in the demo interface here or the OpenAPI documentation here.
To See a more complex example with a more simple query please see the tutorial linked below.