...

Supported syntax by datastore

Individual datastores may have differences in the supported syntax. For more information on the supported syntax for your datastore, please see the documentation for the connection type. See Connection Types.your datastore. 

General Examples

Here are some basic SQL examples to get started.

...

SELECT lastName,firstName FROM "DB1"."table2" WHERE invoiceAmt > 10000;

Multi-line statement for imported datasets

The following example uses a multi-line SQL sequence to import a dataset:

The following example inserts values in the TABLE_INVENTORY table and then queries the table. It utilizes Oracle syntax:

INSERT INTO "SALES"."TABLE_INVENTORY" ("ID", "AVAILABILITY") VALUES (1, 10);
SELECT * FROM "SALES"."TABLE_INVENTORY";