• Products
  • Documentation
  • Resources

Restricted SQL commands

We place a high level of importance on data integrity. To ensure the integrity of data sources and the data contained in them, we prohibit the use of the certain SQL commands in SQL mode queries to prevent certain use of your data.

Even though many security precautions like these restricted commands are put into place, we still recommend only connecting with a database user that is granted read-only access to your data source.

We also recommend as a best practice to only connect Atlassian Analytics to a replica of a main data source and not a production database, data warehouse, or data lake.

When Atlassian Analytics is set up with a database user who has read-only access, members of your organization in Atlassian Analytics with permissions to query or manage your database can read the data, but cannot do anything to modify the database.

With this extra level of precaution, Atlassian Analytics scans and rejects any malicious keywords such as DELETE and INSERT before executing queries.

We want you to trust the insights you’re gaining from the data you are querying in Atlassian Analytics. We take extra measures to protect your data integrity to give you confidence in the data you are analyzing.

More words we won’t allow queries to send to your database include but are not limited to:

  • ADD

  • ALTER

  • ATTACH

  • BEGIN

  • BREAK

  • CATCH

  • CHANGE

  • CHECKPOINT

  • CLOSE

  • COMMIT

  • CONTINUE

  • CONVERSATION

  • COPY

  • CREATE

  • CREATEDB

  • CREATEUSER

  • CURSOR

  • DBCC

  • DEALLOCATE

  • DECLARE

  • DELETE

  • DENY

  • DESCRIBE

  • DFS

  • DISABLE

  • DROP

  • ENABLE

  • END

  • EXECUTE

  • EXPORT

  • FETCH

  • GET_TRANSMISSION_STAT

  • GO

  • GOTO

  • GRANT

  • IMPORT

  • INSERT

  • INSTALL

  • INTO

  • KILL

  • LOAD

  • LOAD_EXTENSION

  • LOCK

  • MERGE

  • NOTIFY

  • OPEN

  • PRAGMA

  • PRINT

  • PURGE

  • RAISERROR

  • REFRESH

  • RENAME

  • REASSIGN

  • RECEIVE

  • REINDEX

  • RELEASE

  • REPLACE

  • RESET

  • RETURN

  • REVERT

  • REVOKE

  • ROLLBACK

  • SAVE

  • SAVEPOINT

  • SEND

  • SETUSER

  • SHOW

  • SHUTDOWN

  • START

  • STOP

  • THROW

  • TIMER

  • TRUNCATE

  • TRY

  • UPDATE

  • UPDATETEXT

  • UNINSTALL

  • VACUUM

  • WAITFOR

  • WRITETEXT

  • WHILE

Still need help?

The Atlassian Community is here for you.