Docs

Appearance

Design - DB (Database) Definitions ​

Clicking Design, opens the DB Definition designer canvas.

The first time this is opened for your DB Definition, this canvas will be blank.

This area creates, maintains, and displays dataviews belonging to your DB Definition - regardless of whether they apply to Source or Destination datasets.

These dataviews tell Statelake what datasets and fields are to be used, and how they are to be used.

image-20240317-215332.png

Existing DB Definition Dataview ​

If a DB Dataview already exists, it will display here, as illustrated below.

image-20240319-210004.png

Dataview Tabs ​

Tab NameDescription
PreviewDisplays a Preview of the data from the dataview query.
image-20240502-234218.png
TablesOpens the Tables tab for the dataview.
image-20240502-234313.png
FieldsOpens the Fields tab for the dataview.
image-20240502-234356.png
CalcsOpens the Calcs tab for the dataview.
image-20240502-234428.png
SearchOpens the Search tab for the dataview.
image-20240502-234513.png
GroupOpens the Group tab for the dataview.
image-20240502-234558.png
Group SearchOpens the Group Search tab for the dataview.
image-20240502-234652.png
SortOpens the Sort tab for the dataview.
image-20240502-234734.png
LinkWhen activated, edits an existing relationship Link, or creates a new Link.
image-20240502-234812.png
SQLOpens the SQL tab for the dataview.
image-20240502-234854.png

New DB Definition Dataview ​

However, for a new DB Definition or to add another dataview, select File and New (or Ctrl-N) to create a new dataview to configure.

image-20240317-215610.png

Selecting DB Dataview is the only option to continue.

image-20240317-215717.png

Buttons ​

Button NameDescription
OKClick to save any changes you have made. All changes will be lost if you do not click the OK button.
CancelClick to Cancel any changes you have made.

DB Dataview ​

A DB Dataview does exactly what the name suggests - it allows you to perform a query on the specified database, and view the data.

DB Dataview will open the database that was specified on the initial screen, and display all of the data held within that database, in a convenient multi-tabulated query designer window.

image-20240318-001441.png

Tabs ​

Tab NameDescription
TablesDisplays all of the Tables contained within the selected database that are available to be accessed for this query.
FieldsDisplays all of the Fields that are contained within the tables that were selected for the query.
Calcs
SearchEnter any Search criteria here.
Group
Group Search
Sort
SQLDisplays the SQL code that has been generated by the selections made in this query, This code updates in live time.