Question structured knowledge from Amazon Q Enterprise utilizing Amazon QuickSight integration

Amazon Q Enterprise is a generative AI-powered assistant that may reply questions, present summaries, generate content material, and securely full duties based mostly on knowledge and data in your enterprise programs. Though generative AI is fueling transformative improvements, enterprises should still expertise sharply divided knowledge silos on the subject of enterprise information, particularly between unstructured content material (similar to PDFs, Phrase paperwork, and HTML pages), and structured knowledge (real-time knowledge and studies saved in databases or knowledge lakes). Each classes of information 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 purposes over unstructured content material, with over 40 knowledge connectors to widespread content material and storage administration programs similar to Confluence, SharePoint, and Amazon Easy Storage Service (Amazon S3), to combination enterprise information. Prospects are additionally in search of 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 purposes, making a unified conversational expertise in 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 develop 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 how one can 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.

Resolution overview

The QuickSight function in Amazon Q Enterprise is out there on the Amazon Q Enterprise console in addition to by way of Amazon Q Enterprise APIs. This function is carried out as a plugin inside Amazon Q Enterprise. After it’s enabled, this plugin will behave in a different way than different Amazon Q Enterprise plugins—it should question QuickSight mechanically for each consumer immediate, in search of 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 obtainable utilizing QuickSight, to generate a wealthy reply that features narrative and visualizations. Relying on the query and knowledge in QuickSight, Amazon Q Enterprise could generate a number of visualizations as a response.

Stipulations

You must have the next conditions:

• An AWS account the place you possibly can observe the directions on this submit.
• AWS IAM Id Middle arrange for use with Amazon Q Enterprise. For extra data, see Configure Amazon Q Enterprise with AWS IAM Id Middle trusted identification propagation.
• No less than one Amazon Q Enterprise Professional consumer that has admin permissions to arrange and configure Amazon Q Enterprise. For pricing data, see Amazon Q Enterprise pricing.
• An IAM Id Middle group that might be assigned the QuickSight Admin Professional function, 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 Id Middle.
• A database that’s put in and will be reached from QuickSight to load structured knowledge (or you may 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’s worthwhile to have an Amazon Q Enterprise utility. In case you don’t have an current utility, observe the steps in Uncover 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 info supply.

Create and configure a brand new QuickSight account

You possibly can skip this part if you have already got an current 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. Beneath QuickSight account data, enter your account title and an e-mail for account notifications.
5. Beneath Assign QuickSight Admin Professional roles, select the IAM Id Middle group you created as a prerequisite.
6. Select Subsequent.

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

This may create a QuickSight account, assign the IAM Id Middle group as QuickSight Admin Professional, and authorize Amazon Q Enterprise to entry QuickSight.

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

9. Select Go to QuickSight.

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

Configure an current QuickSight account

You possibly can skip this part if you happen to adopted the earlier steps and created a brand new QuickSight account.

In case your present QuickSight account isn’t on IAM Id Middle, think about using a unique AWS account with out a QuickSight subscription for the aim of testing this function. From that account, you create an Amazon Q Enterprise utility on IAM Id Middle and undergo the QuickSight integration setup steps on the Amazon Q Enterprise console that may create the QuickSight account for you in IAM Id Middle. Bear 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 current 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. Beneath Assign QuickSight Admin Professional roles, select the IAM Id Middle group you created as a prerequisite.
5. Beneath Service Entry, choose Create and use a brand new service function.
6. Select Save.

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

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

Add knowledge in QuickSight

On this part, we create an Amazon Redshift knowledge supply. You possibly can as an alternative create an information supply from the database of your selection, use recordsdata in Amazon S3, or carry out a direct add of CSV recordsdata and connect with it. Consult with Making 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 an information 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 subject.

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

Ask queries to Amazon Q Enterprise

To begin 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 matters populated with values.

3. Select the hyperlink beneath Deployed URL.

We uploaded AWS Value and Utilization Reviews for a selected AWS account in QuickSight utilizing Amazon Redshift. We additionally uploaded Amazon service documentation into an information supply utilizing Amazon S3 into Amazon Q Enterprise as unstructured knowledge. We are going to 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

In case you now not wish to use this Amazon Q Enterprise function, delete the assets you created to keep away from future expenses:

1. Delete the Amazon Q Enterprise utility:
   1. On the Amazon Q Enterprise console, select Purposes 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 Id Middle occasion.

Conclusion

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

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

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

To study extra about Amazon Q Enterprise, consult with the Amazon Q Enterprise Consumer Information.

To study extra about configuring a QuickSight dataset, see Handle your Amazon QuickSight datasets extra effectively with the brand new consumer interface.

QuickSight additionally gives querying unstructured knowledge. For extra particulars, consult with Combine unstructured knowledge into Amazon QuickSight utilizing Amazon Q Enterprise.

Concerning the authors

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

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