Atlassian Support

/

Atlassian Analytics (beta)

/

/

Query and transform data with Visual SQL

Atlassian Analytics is in open beta

Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.

Use SQL mode to create a query in Visual SQL

What is SQL mode?
Learn more about SQL mode queries.
Preview your schema in SQL mode
Browse your schemas and add columns to your SQL mode query from the schema browser.
Use and edit variables
Use variables in your SQL mode query and modify their values to test them.
What is the executed query for SQL mode?
Get a preview of the literal SQL query sent to your data source.
Use SQL history for version control
Track and reverts changes to your SQL mode query.
SQL editor settings
Customize your SQL mode editor by changing the theme and its default settings.
Restricted SQL commands
Your data is safe. View a handful of SQL commands we block in queries.

Was this helpful?

It wasn't accurate

It wasn't clear

It wasn't relevant

Additional Help