Data discovery with QuickSight
Amazon QuickSight supports loading data from various data sources, and we can then create visuals in the Analyses tab to understand the data. Data discovery can also be done using Jupyter notebooks with custom visualization libraries, but that might require programming expertise and complex setup before performing data discovery activities. In contrast, business users can perform data discovery in QuickSight with visuals in the Analyses tab.
QuickSight-supported data sources and setup
QuickSight supports a wide variety of data sources. The complete list can be found at https://docs.aws.amazon.com/quicksight/latest/user/supported-data-sources.html.
The sources could be classified into the following broad categories:
- Relational data sources: Covering cloud and on-premises data sources, including popular data engines such as MySQL, Postgres, SQL Server, Oracle, Snowflake, and Redshift. When connecting to on-premises data sources, you need...