It is possible to restrict the query mode (Interactive vs. SQL) used to query specific data sources in Chartio. The default in Chartio is that either mode is available to your editors. This default can be adjusted for each of your data sources.
You can make this change on any of the data sources in your organization. You must be an Owner of your Chartio account or Admin of the data source to update the default.
From the main menu in Chartio select ‘Data Sources’ and then select the data source you would like to restrict. In the ‘General’ tab you can then adjust the ‘Query Mode’ as appropriate. Once you’ve made the change, hit ‘Save’ and you will be good to go.