Web App

From Data Islands

The web application is available at


Advanced SQL help

The backend of Data Islands is Postgres SQL servers.

A. Column Names

Column Names are case-sensitive and should be enclosed in double Quotes.

If not you may see the error text

    "Query Failed: column "vendorname" does not exist 31"

Example of working SQL

  select * from apvendors where "VendorName" ilike '%ma%'

B. Islands = Tables

An Island is a Table in Postgres

If we run the SQL

    select * from apVendorsX where "VendorName" ilike '%ma%'

where apVendorsX is not a valid Island you will see

    "Query Failed: island "apvendorsx" does not exist 15"