• Products
  • Documentation
  • Resources

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.

Preview your schema in SQL mode

By default, SQL mode queries show the schema browser pane on the left side of the query. Just like the visual mode schema browser, you can see and search through all the schemas, tables, and columns available from your selected data source.

Select a column from the schema browser to add the column name to your SQL query.

The schema, table, and column names shown in the schema browser are the SQL names, not the nicknames provided in the data source’s schema settings.

Searching for 'summary' in the schema browser of a SQL mode query.

Column data types

Each column in the schema browser has an icon corresponding to the column’s data type.

Array

A comma-separated list of values contained within square brackets ([ ])

Icon for the array data type

Boolean

Either a true or false value, where true is 1 and false is 0

Because boolean columns shows true values to 1 and false values to 0 in the result table, boolean columns become number data types after the query.

Icon for the boolean data type

Date

A date value with the following format: YYYY-MM-DD

An example date value is 2022-05-23.

Icon for the date data type.

Datetime

A timestamp value with the following format: YYYY-MM-DD HH:MM:SS.SSS

An example datetime value is 2022-05-23 01:45:09.303.

Icon for the datetime data type.

Number

A numeric value

Icon for the number data type.

String

A text value

Icon for the string data type.

Additional Help