Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Atlassian Analytics is able to pull multiple schemas for new Redshift, BigQuery, Snowflake, Amazon Athena, and PostgreSQL data sources. For other data sources, you can only have one schema per data source connection in Atlassian Analytics, so you’d need to create separate data source connections to add more schemas.
If your data source can’t pull in multiple schemas, you can create custom tables that pull from tables in your other schemas. Custom tables allow you to write SQL that Atlassian Analytics inserts directly into visual mode queries. So, you can create a custom table with the following SQL (replacing schema_name and table_name with relevant information from your database):
For reference, you can run the following command for MySQL and PostgreSQL data sources to view all available tables and views in all schemas:
Reflect multiple schemas
You must have permission to manage the data source to add more schemas.
If Atlassian Analytics supports multiple schemas for your data source, you can reflect them into one data source by doing the following:
Go to the Data tab.
Select the data source in which you’d like to reflect multiple schemas.
Go to the Connection tab.
From the schema selector, select the schemas you’d like to add to Atlassian Analytics.
Select Save. This will take you to another screen.
Select the schemas and tables to include in Atlassian Analytics.
Atlassian Analytics automatically applies your changes then takes you to the Schema tab, where you can edit your schemas as needed.
Get a list of available schemas
Most schemas are defaulted to public unless a specific schema is used. To find out which schema to reflect for your data source, you can run the following query on your data source to list all available schemas; however, not all data sources have this functionality.
Microsoft SQL Server
You can leave the schema blank since for MySQL, physically a schema is synonymous with a database.