Web App: Difference between revisions

From Data Islands
No edit summary
No edit summary
 
Line 24: Line 24:


B. Islands = Tables
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"

Latest revision as of 11:35, 8 July 2024

The web application is available at

https://app.dataislands.com/


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"