Does Chartio restrict the functions and keywords that can be used in SQL Mode?

Yes, Chartio prohibits the use of the following commands in SQL mode to prevent malicious use of your data.  However, we still recommend only connecting with a user that is granted read-only access to your database.

  • add
  • alter
  • analyze
  • attach
  • begin
  • break
  • catch
  • change
  • checkpoint
  • close
  • commit
  • continue
  • conversation
  • copy
  • create
  • cursor
  • dbcc
  • deallocate
  • declare
  • delete
  • deny
  • disable
  • drop
  • enable
  • end
  • execute
  • fetch
  • grant
  • gettransmissionstat
  • go
  • goto
  • insert
  • install
  • kill
  • load
  • load_extension
  • merge
  • notify
  • open
  • pragma
  • print
  • purge
  • raiserror
  • rename
  • reassign
  • receive
  • reindex
  • release
  • replace
  • reset
  • return
  • revert
  • revoke
  • rollback
  • save
  • savepoint
  • send
  • setuser
  • show
  • shutdown
  • start
  • stop
  • shutdown
  • throw
  • timer
  • truncate
  • try
  • update
  • updatetext
  • uninstall
  • vacuum
  • waitfor
  • writetext
  • while