Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Edit a schema
You must have permission to manage the data source to edit its schemas.
When you connect a data source, Atlassian Analytics automatically extracts the data source’s schemas. It basically creates a copy of the schemas in your original data source, and you can then edit those schema copies for use in Atlassian Analytics.
Any changes to your schema in Atlassian Analytics will not affect your original data source. Atlassian Analytics has read-only access to your original data sources, so we cannot push any changes to them.
Editing actions include:
Renaming tables or columns to make them more reader-friendly
Removing or hiding tables and columns to simplify your data source for users
Adding foreign keys, if needed, and setting custom join types
Changing dimension and measure grouping
Setting default aggregations for measures
Creating custom columns or tables
To edit a schema:
Go to Data from the global navigation.
Select your data source from the list.
Select Schema.
If you have more than one schema, select the schema to edit from the sidebar.
Edit a table name
You can change the display name of a table in your schema, and it won’t break any existing charts using that table because the table’s SQL name won’t change. You can see the table’s SQL name in parentheses under the table’s display name.
To change the display name of a table in your schema:
Select the Pencil icon by the table’s name.
Provide the new name.
Select Save.
Edit column properties
Each column has properties that you can edit. To view and edit a column’s properties:
Select the arrow by the name of the table containing the column.
Select anywhere on the column’s row to expand its properties. Learn more about column properties.
Make changes as needed.
Select Save.
Hide or show columns and tables
When you have a lot of tables and columns, it’s helpful to surface the ones that you and your teams use most often and hide the ones you use least often so they’re only available in the full schema view. This can make your schema easier to navigate when you’re creating charts.
Keep in mind that you’ll only get the option to view the full schema in the schema browser of visual mode queries. In SQL mode, you’ll always see all the available tables and columns in the schema browser.
If you don’t want a specific table or column to be queried at all, you can delete it from the schema in Atlassian Analytics.
To only show an individual table or column in the full schema view, deselect the Visible checkbox next to the table or column name.
To always show all columns in a schema:
Select More actions (…).
Select Show all columns.
To only show all columns in the full schema view:
Select More actions (…).
Select Hide all columns.
To always show all tables in a schema:
Select More actions (…).
Select Show all tables.
To only show all tables in the full schema view:
Select More actions (…).
Select Hide all tables.
Was this helpful?
Still need help?
The Atlassian Community is here for you.