Web App: Difference between revisions

From Data Islands
No edit summary
No edit summary
Line 1: Line 1:
The web application is available at
The web application is available at


https://app.dataislands.com/
----
Advanced SQL help
The backend of Data Islands is Postgres SQL servers.


https://app.dataislands.com/
 
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%'

Revision as of 11:32, 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%'