Query a CSV

We use SQLite behind the scenes for this feature.

Google Drive

To query a CSV from Google Drive, follow these steps:

  1. Within Google Drive, right-click on the file name and select Share.

    Share from Google Drive

  2. Change sharing permissions to Anyone with the link can view.

    Change sharing permissions

  3. Select Get shareable link in the top right.

    Get shareable link

  4. Add the table to your SELECT with {{csv}} (replace "csv" with a nickname for the source).

  5. Under Parameters, select Value and select CSV.

  6. Under File URL, add the URL from the step above.

    Add URL as File URL

Was this page helpful?