• Products
  • Documentation
  • Resources

Atlassian Analytics is in an early access program

Only people who are part of this invite-only early access program have access to Atlassian Analytics.

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

If you have a lot of tables and columns, it’s often helpful to hide some of the ones you and your team aren’t using. This can make your schema easier to navigate when you’re creating charts.

To hide an individual table or column, select the Visible checkbox next to the table or column name.

To hide or show all columns in a schema:

  1. Select More actions ().

  2. Select Hide all columns or Show all columns.

To hide or show all tables in a schema:

  1. Select More actions ().

  2. Select Hide all tables or Show all tables.

Hidden columns and tables won’t appear in the schema browser when building Visual SQL queries.

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

Additional Help