Basics

Atomic fields are the sub-set of fields that have been created by loading from file.   These fields will show up in the following ways: As "Imported" in the Data Audit report As "Atomic=true" in the Context Panel property panel As "Impo...

Function fields - also known as "BakedFields" - are inbuilt DataJet functions that can be applied to existing data fields in order rapidly create new fields.  Along with Expressions , DataSetFields  and User-Defined Fields they play a ...

Overview Metadata is descriptive data attached to tables  and fields  in order to provide the user with more detailed information about the underlying record data.   It is also used to enhance searching and grouping of data in the ...

Datasets Query Counts A Dataset is a lightweight data object used to indicate the records that are returned by a query. Inclusion and Exclusion Records that are in the selection are returned as 1, those which are absent are returned as 0: ...

As an analytical database, all data that is loaded into DataJet persists in a fixed structure unless explicitly modified or deleted.  By design it is not possible to change  data that has been loaded into DataJet, but it is possible to tr...

Field Attributes and Properties FieldTypes and Symbols DataType Limits Note: Not much overhead in using a long rather than an integer unless dealing with continuous fields. Supported Date Field Formats •      YYYY-MM-...

The DataView is the DataJet equivalent of "Select Field From Table" in SQL. A DataView is a  Dataset Scratch report with a specific default view mode: Opening the Query Tree shows that all records in the table have been selected: ...

Various different types of history are recorded as the user (analyst, engineering, end-user etc) works in a DataJet Project.  These can be broadly grouped into: Project History - a record of all permanent changes made to the project data ...

A key feature of DataJet is the ability to rapidly profile data on very large datasets without needing to create SQL queries.   This gives Instant insight into the data without the need for complex engineering.   Profiles are used for: ...

Packages are zip files containing instructions for injecting (or sharing) data from a source project with one or more consumer projects. Note: For further information on the sharing of data, see Introduction to Data Injection. Package file ...

The Injected Package Helper  window can be accessed either via Script Editor , or via Admin | Packages To bring up the InjectPackage helper, add an InjectPackage method to script from the Script Editor | Methods | Tools menu: ...

Introduction A realm is a collection of data (consisting of projects , metadata and data objects ) and users that together provide a functional and siloed domain of operation.    Each realm belongs to a single DataJet server, and must ...

The DataJet storage hub allows an organisation to share information across realms and servers. Different classes of information can be pushed into the hub: Scripts Packages {} Scripts Scripts are pushed and pulled into and out of the h...