Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0682

...

Tip

Tip: Where possible, you should make selections in the data grid to build transform steps. These selections prompt a series of cards to be displayed. You can select different cards to specify a basic transform for your selected data, choose a variant of that transform, and then modify the underlying

D s lang
recipe as necessary. For more information, see Overview of Predictive Transformation.

For more information on the suggestion cards, see Selection Details Panel.

Some complex transforms, such as joins and unions, must be created through dedicated screens. See Transformer Page.

D s lang

...

Info

NOTE:

D s lang
is not SQL. It is a proprietary language of data transformation, purpose-built for
D s product
.

While there are some overlaps between 

D s lang
 and SQL, here are the key distinctions:

  • D s lang
     is a proprietary language designed for data transformation. Every supported transformation is designed to make changes to a dataset. It cannot be used to read from or write to a datastore. 
    • Users interact with 
      D s lang
       exclusively through the 
      D s webapp
      . There is no direct interaction with the language.
  • SQL (Structured Query Language) is designed for querying, transforming, and writing for relational datasources. It cannot be applied to file-based datasets.
    • SQL cannot be used to transform data in 
      D s product
      .
Tip

Tip: Optionally, you can enable and use SQL to perform custom queries of your relational datasources. These read-only queries can be used only to import data into the product. For more information, see Enable Custom SQL Query.

D s lang
 Syntax

D s lang
 transforms follow this general syntax:

...