👩💻Code mode and single mode
Only for connectors which support nativeSQL
Last updated
Was this helpful?
Only for connectors which support nativeSQL
Last updated
Was this helpful?
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.
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
you switch to the "Query" tab where you can select the table to query
You can navigate through the database schema to choose the table you want to query.
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.
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.
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.
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.
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.
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.
