• Products
  • Documentation
  • Resources

Sync schemas

If you make any changes to your original data source’s schema, you’ll want to sync your schema in Atlassian Analytics to make sure we have the latest version.

Keep in mind that Atlassian Analytics cannot automatically detect changes and sync your schemas.

You’ll need to manually sync the schema for any changes. Schema syncs are mandatory to use new tables in visual mode queries, but in SQL mode queries, you can query the new tables directly without having to update the schema if you know their SQL names.

To sync your schema:

You must have permission to manage the data source to sync its schemas.

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

  2. Select either:

    1. Sync schema to sync the currently selected schema.

    2. Sync all schemas if your data source has multiple schemas and you want to sync all of them.

After a successful schema sync, you’ll see a small summary showing how many changes were made to your Analytics schema.

Successfully synced schema to add new table and delete two columns.

Atlassian Analytics brings in all tables and columns it has access to and makes them visible by default. If you’d like to hide new tables and columns brought in from your schema syncs, select the Hide new tables checkbox in your data source’s general settings.

How renamed or removed columns affect visual mode queries

If we detect missing tables or columns in your actual data source are referenced in visual mode queries, you’ll see a warning section appear at the top of the page. Learn more about how to handle schema differences in your Atlassian Analytics queries.

 

Still need help?

The Atlassian Community is here for you.