👩‍💻Code mode and single mode

Only for connectors which support nativeSQL

When working with a datasource supporting NativeSQL, you have two modes for writing your queries.

After connecting to your database, when you click on "create a dataset", you land on a new page where, on the right, you have three modals: "Configuration", "Query", and "Review" which will lead you to the creation of a dataset.

Single mode

In Single mode, (which is the default mode for all connectors which support NativeSQL), you can query your database without the hassle of writing a SQL query, and look at your database model constantly to avoid errors.

After choosing the database you want to query and clicking on "Validate configuration", you switch to the "Query" tab

Edit datasource - configuration

you switch to the "Query" tab where you can select the table to query

Edit datasource - Query - Table selection

You can navigate through the database schema to choose the table you want to query.

Edit datasource - Query - Table selection

Then you can choose the columns you want to keep in your dataset by clicking/un-clicking on the tick box.

You can choose to select all columns by clicking on "Select all" or unselect all columns by clicking on "Clear All".

You can click on the "Preview" button to display on the right the columns of your selection.

Edit datasource - Query - Table selection -> Columns selection

Once you are satisfied with your query, you can click on the "Apply Data Selection" button. You are redirected to the "Review" tab, where you can review the query you will send to your database.

On the right of each field, you have an Edit icon for each field which will redirect you to the designated section when clicked.

Edit datasource - Review

By clicking on the "Preview" button, you can view the data.

By clicking on "Save query" you will be redirected to the dataset creation where you will be able to apply data transformation.

New dataset from source

Code mode

In the configure datasource interface, once you have chosen the database in the configuration tab, in the query mode, at the bottom right, there's an icon (burger menu). You can click on the message "Switch to code mode" that is displayed.

PostgreSQL - Edit datasource - Query -Columns selection - switch to code mode

You can switch to code mode since table selection and after: And the current SQL request will be displayed. You can insert a variable using the '/' key or by clicking on insert a variable at the top right of the input box. Learn more about variables in the dedicated section.

Edit datasource - Query - Columns selection - code mode

This field is a playground SQL where you can write the query you desire to get data from your database. You can erase the current query to write your own.

Edit datasource - Query -Columns selection - code mode