Question structured knowledge from Amazon Q Enterprise utilizing Amazon QuickSight integration

Amazon Q Business is a generative AI-powered assistant that may reply questions, present summaries, generate content material, and securely full duties primarily based on knowledge and knowledge in your enterprise methods. Though generative AI is fueling transformative improvements, enterprises should expertise sharply divided knowledge silos in the case of enterprise information, particularly between unstructured content material (corresponding to PDFs, Phrase paperwork, and HTML pages), and structured knowledge (real-time knowledge and reviews saved in databases or knowledge lakes). Each classes of knowledge are usually queried and accessed utilizing separate instruments, from in-product browse and search performance for unstructured knowledge, to enterprise intelligence (BI) instruments like Amazon QuickSight for structured content material.

Amazon Q Enterprise gives an efficient answer for rapidly constructing conversational functions over unstructured content material, with over 40 knowledge connectors to in style content material and storage administration methods corresponding to Confluence, SharePoint, and Amazon Simple Storage Service (Amazon S3), to mixture enterprise information. Prospects are additionally on the lookout for a unified conversational expertise throughout all their information repositories, whatever the format the content material is saved and arranged as.

On December 3, 2024, Amazon Q Enterprise introduced the launch of its integration with QuickSight, permitting you to rapidly join your structured sources to your Amazon Q Enterprise functions, making a unified conversational expertise to your end-users. The QuickSight integration gives an in depth set of over 20 structured knowledge supply connectors, together with Amazon Redshift, PostgreSQL, MySQL, and Oracle, enabling you to rapidly increase the conversational scope of your Amazon Q Enterprise assistants to cowl a wider vary of data sources. For the end-users, solutions are returned in actual time out of your structured sources, mixed with different related data present in unstructured repositories. Amazon Q Enterprise makes use of the analytics and superior visualization engine in QuickSight to generate correct and simple-to-understand solutions from structured sources.

On this submit, we present you the best way to configure the QuickSight connection from Amazon Q Enterprise after which ask inquiries to get real-time knowledge and visualizations from QuickSight for structured knowledge along with unstructured content material.

Answer overview

The QuickSight function in Amazon Q Enterprise is offered on the Amazon Q Enterprise console in addition to via Amazon Q Enterprise APIs. This function is carried out as a plugin inside Amazon Q Enterprise. After it’s enabled, this plugin will behave otherwise than different Amazon Q Enterprise plugins—it should question QuickSight robotically for each person immediate, on the lookout for related solutions.

For AWS accounts that aren’t subscribed to QuickSight already, the Amazon Q Enterprise admin completes the next steps:

1. Create a QuickSight account.
2. Join your database in QuickSight to create a dataset.
3. Create a subject in QuickSight, which is then used to make it searchable out of your Amazon Q Enterprise utility.

When the function is activated, Amazon Q Enterprise will use your unstructured knowledge sources configured in Amazon Q Enterprise, in addition to your structured content material accessible utilizing QuickSight, to generate a wealthy reply that features narrative and visualizations. Relying on the query and knowledge in QuickSight, Amazon Q Enterprise might generate a number of visualizations as a response.

Stipulations

You must have the next stipulations:

• An AWS account the place you may comply with the directions on this submit.
• AWS IAM Identity Center arrange for use with Amazon Q Enterprise. For extra data, see Configure Amazon Q Business with AWS IAM Identity Center trusted identity propagation.
• A minimum of one Amazon Q Enterprise Professional person that has admin permissions to arrange and configure Amazon Q Enterprise. For pricing data, see Amazon Q Business pricing.
• An IAM Identification Heart group that can be assigned the QuickSight Admin Professional position, for customers who will handle and configure QuickSight.
• If a QuickSight account exists, then it must be in the identical AWS account and AWS Area as Amazon Q Enterprise, and configured with IAM Identification Heart.
• A database that’s put in and may be reached from QuickSight to load structured knowledge (or you might create a dataset by importing a CSV or XLS file). The database additionally wants credentials to create tables and insert knowledge.
• Pattern structured knowledge to load into the database (together with insert statements).

Create an Amazon Q Enterprise utility

To make use of this function, it is advisable have an Amazon Q Enterprise utility. Should you don’t have an present utility, comply with the steps in Discover insights from Amazon S3 with Amazon Q S3 connector to create an utility together with an Amazon S3 knowledge supply. Add the non-structured doc(s) to Amazon S3 and sync the information supply.

Create and configure a brand new QuickSight account

You may skip this part if you have already got an present QuickSight account. To create a QuickSight account, full the next steps:

1. On the Amazon Q Enterprise console, navigate to your utility.
2. Select Amazon QuickSight within the navigation pane.

3. Select Create QuickSight account.

4. Below QuickSight account data, enter your account identify and an electronic mail for account notifications.
5. Below Assign QuickSight Admin Professional roles, select the IAM Identification Heart group you created as a prerequisite.
6. Select Subsequent.

7. Below Service entry, choose Create and use a brand new service position.
8. Select Authorize.

It will create a QuickSight account, assign the IAM Identification Heart group as QuickSight Admin Professional, and authorize Amazon Q Enterprise to entry QuickSight.

You will note a dashboard with particulars for QuickSight. At present, it should present zero datasets and subjects.

9. Select Go to QuickSight.

Now you can proceed to the subsequent part to arrange your knowledge.

Configure an present QuickSight account

You may skip this part when you adopted the earlier steps and created a brand new QuickSight account.

In case your present QuickSight account shouldn’t be on IAM Identification Heart, think about using a distinct AWS account with no QuickSight subscription for the aim of testing this function. From that account, you create an Amazon Q Enterprise utility on IAM Identification Heart and undergo the QuickSight integration setup steps on the Amazon Q Enterprise console that may create the QuickSight account for you in IAM Identification Heart. Keep in mind to delete that new QuickSight account and Amazon Q Enterprise utility after your testing is completed to keep away from additional billing.

Full the next steps to arrange the QuickSight connector from Amazon Q Enterprise for an present QuickSight account:

1. On the Amazon Q Enterprise console, navigate to your utility.
2. Select Amazon QuickSight within the navigation pane.

3. Select Authorize QuickSight solutions.

4. Below Assign QuickSight Admin Professional roles, select the IAM Identification Heart group you created as a prerequisite.
5. Below Service Entry, choose Create and use a brand new service position.
6. Select Save.

You will note a dashboard with particulars for QuickSight. If you have already got a dataset and subjects, they’ll present up right here.

You’re now prepared so as to add a dataset and subjects within the subsequent part.

Add knowledge in QuickSight

On this part, we create an Amazon Redshift knowledge supply. You may as an alternative create a knowledge supply from the database of your selection, use information in Amazon S3, or carry out a direct add of CSV information and hook up with it. Consult with Creating a dataset from a database for extra particulars.

To configure your knowledge, full the next steps:

1. Create a brand new dataset with Amazon Redshift as a knowledge supply.

Configuring this connection gives a number of decisions; select the one that most closely fits your wants.

2. Create a subject from the dataset. For extra data, see Creating a topic.

3. Optionally, create dashboards from the subject. If created, Amazon Q Enterprise can use them.

Ask queries to Amazon Q Enterprise

To start out chatting with Amazon Q Enterprise, full the next steps:

1. On the Amazon Q Enterprise console, navigate to your utility.
2. Select Amazon QuickSight within the navigation pane.

You must see the datasets and subjects populated with values.

3. Select the hyperlink underneath Deployed URL.

We uploaded AWS Cost and Usage Reports for a particular AWS account in QuickSight utilizing Amazon Redshift. We additionally uploaded Amazon service documentation into a knowledge supply utilizing Amazon S3 into Amazon Q Enterprise as unstructured knowledge. We’ll ask questions associated to our AWS prices and present how Amazon Q Enterprise solutions questions from each structured and unstructured knowledge.

The next screenshot exhibits an instance query that returns a response from solely unstructured knowledge.

The next screenshot exhibits an instance query that returns a response from solely structured knowledge.

The next screenshot exhibits an instance query that returns a response from each structured and unstructured knowledge.

The next screenshot exhibits an instance query that returns a number of visualizations from each structured and unstructured knowledge.

Clear up

Should you not wish to use this Amazon Q Enterprise function, delete the sources you created to keep away from future prices:

1. Delete the Amazon Q Enterprise utility:
   1. On the Amazon Q Enterprise console, select Functions within the navigation pane.
   2. Choose your utility and on the Actions menu, select Delete.
   3. Enter delete to substantiate and select Delete.

The method can take as much as quarter-hour to finish.

2. Delete the S3 bucket:
   1. Empty your S3 bucket.
   2. Delete the bucket.
3. Delete the QuickSight account:
   1. On the Amazon QuickSight console, select Handle Amazon QuickSight.
   2. Select Account setting and Handle.
   3. Delete the account.
4. Delete your IAM Identity Center instance.

Conclusion

On this submit, we confirmed the best way to embrace solutions out of your structured sources in your Amazon Q Enterprise functions, utilizing the QuickSight integration. This creates a unified conversational expertise to your end-users that saves them time, helps them make higher selections via extra full solutions, and improves their productiveness.

At AWS re:Invent 2024, we additionally introduced the same unified expertise enabling entry to insights from unstructured knowledge sources in Amazon Q in QuickSight powered by Amazon Q Enterprise.

To study in regards to the new capabilities Amazon Q in QuickSight offers, see QuickSight Plugin.

To study extra about Amazon Q Enterprise, consult with the Amazon Q Business User Guide.

To study extra about configuring a QuickSight dataset, see Manage your Amazon QuickSight datasets more efficiently with the new user interface.

QuickSight additionally gives querying unstructured knowledge. For extra particulars, consult with Integrate unstructured data into Amazon QuickSight using Amazon Q Business.

Concerning the authors

Jiten Dedhia is a Sr. AIML Options Architect with over 20 years of expertise within the software program business. He has helped Fortune 500 corporations with their AIML/Generative AI wants.

Jean-Pierre Dodel is a Principal Product Supervisor for Amazon Q Enterprise, accountable for delivering key strategic product capabilities together with structured knowledge assist in Q Enterprise, RAG. and total product accuracy optimizations. He brings intensive AI/ML and Enterprise search expertise to the workforce with over 7 years of product management at AWS.