Delete and restore columns, tables, and schemas

You must have permission to manage the data source to delete or restore columns, tables, or schemas.

If there are columns, tables, or schemas that you know you’ll never need to query, you can remove them from your data source.

As a reminder, removing columns, tables, and schemas from your data source in Atlassian Analytics does not affect your original data source.

When deleting a column, table, or schema, you’ll see a list of charts currently using it. If you delete a column, table, or schema that’s in use, the queries of the charts using it will break and show errors. Read more about how to resolve schema difference in your queries.

You can restore any deleted columns, tables, or schemas at any time. Refer to the instructions later in this page for how to restore them.

Delete a column

To delete a column from your Atlassian Analytics schema:

Select Data from the global navigation.
Select the data source containing the column you want to delete.
Go to the Schema tab.
Select the arrow by the name of the table containing the column.
Select anywhere on the column’s row to expand its properties.
Select Delete column.
You’ll see a list of charts currently using the column. Review the list then select Delete to confirm the deletion.

Delete a table

To delete a table:

Select Data from the global navigation.
Select the data source containing the table you want to delete.
Go to the Schema tab.
Select Delete next to the table’s name.
You’ll see a list of charts currently using the table. Review the list then select Delete to confirm the deletion.

Delete a schema

When you have multiple schemas in your data source, you can remove a schema from Atlassian Analytics.

To delete a schema:

Select Data from the global navigation.
Select the data source containing the schema you want to delete.
Go to the Schema tab.
From the sidebar, select the schema you want to delete.
Select More actions (…).
Select Delete schema.
You’ll see a list of charts currently using the schema. Review the list then select Delete to confirm the deletion.

Alternatively, you can:

Go to the Connection tab of the data source’s settings.
Deselect the schema from the schema selector.
Select Save.

Restore deleted columns and tables

To restore deleted columns and tables:

Select Data from the global navigation.
Select the data source containing the columns and tables you want to restore.
Go to the Schema tab.
Select Sync schema.

Restore deleted schemas

To restore deleted schemas:

Select Data from the global navigation.
Select the data source containing the schema you want to restore.
Go to the Connection tab
Re-select the schemas from the schema selector.
Select Save.

Was this helpful?

It wasn't accurate

It wasn't clear

It wasn't relevant