Skip to main content
Version: v3.3 print this page

Data Management

Data Management in Amorphic BI is designed to be largely automated, ensuring that the underlying infrastructure required for your analytics is managed seamlessly behind the scenes. While the application handles the creation and lifecycle of core data entities, this section outlines how Data Sources (QuickSight Data Sources) and Data Sets (QuickSight Data Sets) function within the ecosystem and how to maintain the necessary permissions via IAM Role updates.

Data Sources​

In Amorphic BI, a Data Source serves as the secure connection between the BI application and your physical data stored in AWS.

  • Automated Lifecycle: When a user is registered with an Admin or Author role, a dedicated data source is automatically created for them.
  • Cleanup: To maintain security and environment hygiene, this data source is automatically deleted if the user is removed from the BI application.
  • Restrictions: To ensure system stability and security, users are restricted from manually creating additional data sources directly within the BI application or the Amazon Quick console.

Data Sets​

Data Sets represent the logical layer where your raw data is formatted, joined, and prepared for visualization.

  • On-Demand Creation: A data set is automatically generated whenever a user creates a new asset within the application.
  • Intelligent SPICE Ingestion: Upon reaching the data set selection page, the system performs a real-time check to see if an equivalent SPICE (Super-fast, Parallel, In-memory Calculation Engine) data set already exists in QuickSight. If one does not exist, the system will create it "on the go" to ensure high-performance data retrieval.
  • External Management: While the BI app handles initial creation, users can view and modify these data sets—including editing logic, deleting, sharing, or creating new ones—directly via the Amazon Quick console.

Update IAM Role Deprecated​

If a user is registered in Amorphic and has access to new datasets, they can select the Update IAM Role button from the BI App Center to synchronize dataset access. This action updates the permissions on the custom IAM Role associated with the registered user to ensure all accessible datasets are correctly reflected in the BI application.

Info

Legacy Feature: Previously, this button was used to manually update the custom IAM Role permissions when the application could not automatically reflect dataset access changes. While the button remains visible for backward compatibility, it is now deprecated as the system handles permission synchronization automatically in the current version.

Next Steps​