Edit a schema

When you connect a data source, Atlassian’s analytics offering 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 the analytics offering.

Any changes to your schema in Atlassian’s analytics offering will not affect your original data source. The analytics offering 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 Analytics 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.

If your data source has multiple schemas, you can select a different schema from the Schemas list on the left.

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.
Make changes as needed.
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.

Hide or show individual columns or tables

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

Hide or show all columns or tables

To hide or show all columns in a schema:

Select the More actions (…) menu.
Select Hide all columns or Show all columns.

To hide or show all tables in a schema:

Select the More actions (…) menu.
Select Hide all tables or Show all tables.

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