• 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.

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. This is also useful if your data source exceeds the maximum number of columns and tables. You can remove the unnecessary ones then sync your schema to bring in the essential ones.

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 remove a column, table, or schema that’s in use, the queries of the charts using it will change to SQL mode and will not break.

You can always restore any deleted columns, tables, or schemas. However, restoring them won’t revert the queries of the charts that were changed to SQL mode back to visual mode. See below for instructions on how to restore them.

Delete a column

To delete a column from your Atlassian Analytics schema:

  1. Select Data from the global navigation.

  2. Select the data source containing the column you want to delete.

  3. Go to the Schema tab.

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

  5. Select anywhere on the column’s row to expand its properties.

  6. Select Delete column.

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

  1. Select Data from the global navigation.

  2. Select the data source containing the table you want to delete.

  3. Go to the Schema tab.

  4. Select Delete next to the table’s name.

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

  1. Select Data from the global navigation.

  2. Select the data source containing the schema you want to delete.

  3. Go to the Schema tab.

  4. From the sidebar, select the schema you want to delete.

  5. Select More actions ().

  6. Select Delete schema.

  7. You’ll see a list of charts currently using the schema. Review the list then select Delete to confirm the deletion.

Alternatively, you can:

  1. Go to the Connection tab of the data source’s settings.

  2. Deselect the schema from the schema selector.

  3. Select Save.

Restore deleted columns and tables

To restore deleted columns and tables:

  1. Select Data from the global navigation.

  2. Select the data source containing the columns and tables you want to restore.

  3. Go to the Schema tab.

  4. Select Sync schema.

Restore deleted schemas

To restore deleted schemas:

  1. Select Data from the global navigation.

  2. Select the data source containing the schema you want to restore.

  3. Go to the Connection tab

  4. Re-select the schemas from the schema selector.

  5. Select Save.

Additional Help