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

Data Sources

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
  • get_transmission_stat
  • 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

Related Data Sources Help Articles

See more