• Products
  • Documentation
  • Resources

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:

  1. Go to Data from the global navigation.

  2. Select your data source from the list.

  3. Select Schema.

  4. 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:

  1. Select the Pencil icon by the table’s name.

  2. Provide the new name.

  3. Select Save.

Edit column properties

Each column has properties that you can edit. To view and edit a column’s properties:

  1. Select the arrow by the name of the table containing the column.

  2. Select anywhere on the column’s row to expand its properties. Learn more about column properties.

  3. Make changes as needed.

  4. 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:

  1. Select More actions ().

  2. Select Show all columns.

To only show all columns in the full schema view:

  1. Select More actions ().

  2. Select Hide all columns.

To always show all tables in a schema:

  1. Select More actions ().

  2. Select Show all tables.

To only show all tables in the full schema view:

  1. Select More actions ().

  2. Select Hide all tables.

More actions menu in Schema tab to hide or show columns and tables.

Still need help?

The Atlassian Community is here for you.