Loading Data
Flare Dashboard provides two ways of loading data. A graphical ETL product called FlareBI Dataflow
as well as a comprehensive data load language that is similar to SQL making it easy for dashboard creators
to master.
Load Script 3 Easy Steps
| Step | Example |
|---|---|
| Create Tables | CREATE TABLE Customers(ID integer HIDDEN, Name String, Address String, State String); |
| Insert Into Table |
INSERT INTO Customers(ID,Name,Address,State) USING SQL(MyConnection1) SELECT * FROM Customers; |
| Create Joins | CREATE JOIN(Customers.ID, Orders.CustomerID); |