Query structured data from Amazon Q Business using Amazon QuickSight integration

Amazon Q Enterprise is an AI-based generative assistant that solutions questions, gives summaries, generates content material, and securely completes duties based mostly on information and data from enterprise techniques. Though generative synthetic intelligence is driving transformative innovation, corporations should still encounter severely fragmented information silos relating to enterprise data, particularly between unstructured content material (corresponding to PDFs, Phrase recordsdata, and HTML pages) and structured information (instantaneous data and data). Each varieties of information are sometimes queried and accessed utilizing separate instruments, starting from in-product shopping and search capabilities for unstructured information to enterprise intelligence (BI) instruments like Amazon QuickSight for structured content material.

Amazon Q Enterprise gives an efficient answer for shortly constructing conversational purposes from unstructured content material, with greater than 40 connections to common content material and storage administration techniques corresponding to Confluence, SharePoint, and Amazon Easy Storage Service (Amazon S3 )) information connectors to mixture enterprise data. Prospects additionally need a unified conversational expertise throughout all data repositories, whatever the format during which the content material is saved and arranged.

On December 3, 2024, Amazon Q Enterprise introduced the launch of integration with QuickSight, permitting you to shortly join structured sources to Amazon Q Enterprise purposes to create a unified conversational expertise for finish customers. QuickSight integration gives greater than 20 structured information supply connectors, together with Amazon Redshift, PostgreSQL, MySQL, and Oracle, permitting you to shortly broaden the scope of Amazon Q Enterprise Assistant conversations to cowl a wider vary of information sources. For the top consumer, solutions are returned immediately from 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 supply correct, easy-to-understand solutions from structured sources.

On this article, we’ll present you how you can configure a QuickSight connection from Amazon Q Enterprise, after which ask inquiries to get instantaneous information and visualizations of structured and unstructured content material from QuickSight.

Resolution overview

QuickSight performance in Amazon Q Enterprise is accessible on the Amazon Q Enterprise console in addition to the Amazon Q Enterprise API. This performance is applied as a plug-in in Amazon Q Enterprise. When enabled, the plug-in will behave in another way than different Amazon Q Enterprise plug-ins—it can routinely question QuickSight for related solutions for every consumer immediate.

Amazon Q Enterprise directors who do not need an AWS account subscribed to QuickSight want to finish the next steps:

1. Create a QuickSight account.
2. Connect with the database in QuickSight to create a knowledge set.
3. Create a subject in QuickSight after which use the subject to make it searchable out of your Amazon Q Enterprise utility.

When the characteristic is enabled, Amazon Q Enterprise makes use of the unstructured information sources you configure in Amazon Q Enterprise and the structured content material offered by QuickSight to generate wealthy solutions that embody narratives and visualizations. Based mostly on the query and information in QuickSight, Amazon Q Enterprise could reply by producing a number of visualizations.

Conditions

You need to have the next conditions:

• You possibly can observe the directions on this article for an AWS account.
• AWS IAM Id Heart is configured to be used with Amazon Q Enterprise. For extra data, see Configuring Amazon Q Enterprise with AWS IAM Id Heart Trusted Id Propagation.
• Not less than one Amazon Q Enterprise Professional consumer with administrator permissions to arrange and configure Amazon Q Enterprise. For pricing data, see Amazon Q Enterprise Pricing.
• An IAM identification heart group that will likely be assigned the QuickSight Admin Professional function for customers who handle and configure QuickSight.
• If a QuickSight account exists, it must be in the identical AWS account and AWS Area as Amazon Q Enterprise, and arrange utilizing IAM Id Heart.
• A database put in and accessible from QuickSight to load structured information (or you may create a dataset by importing a CSV or XLS file). The database additionally requires credentials to create tables and insert information.
• Pattern structured information (and insert statements) to be loaded into the database.

Construct an Amazon Q Enterprise utility

To make use of this characteristic, you want the Amazon Q Enterprise app. If you do not have an current utility, observe the steps in Uncover insights from Amazon S3 utilizing the Amazon Q S3 connector to create an utility and an Amazon S3 information supply. Add unstructured recordsdata to Amazon S3 and sync sources.

Create and configure a brand new QuickSight account

If you have already got a QuickSight account, you may skip this part. 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 a QuickSight account.

4. under QuickSight account dataenter your account title and e-mail for account notifications.
5. under Assign the QuickSight Admin Professional functionchoose the IAM Id Heart group you created as a prerequisite.
6. select Subsequent.

7. under Service entryselect Create and use new service roles.
8. select Authorize.

This creates a QuickSight account, assigns the IAM Id Heart group as QuickSight Admin Professional, and authorizes Amazon Q Enterprise to entry QuickSight.

You will notice a dashboard with QuickSight particulars. At present, it can show zero datasets and subjects.

9. select Go to fast view.

Now you may transfer on to the following part to organize your supplies.

Arrange an current QuickSight account

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

In case your present QuickSight account isn’t on IAM Id Heart, think about using a distinct AWS account and not using a QuickSight subscription to check this characteristic. From this account, you may create an Amazon Q Enterprise utility on IAM Id Heart and carry out the QuickSight integration setup steps on the Amazon Q Enterprise console to create a QuickSight account for you in IAM Id Heart. Bear in mind to delete your new QuickSight account and Amazon Q Enterprise utility after testing is full to keep away from additional billing.

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

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

3. select Authorizing QuickSight Solutions.

4. under Assign the QuickSight Admin Professional functionchoose the IAM Id Heart group you created as a prerequisite.
5. under Service entryselect Create and use new service roles.
6. select save.

You will notice a dashboard with QuickSight particulars. If you have already got units and subjects, they’ll seem right here.

Now you might be prepared so as to add new datasets and subjects within the subsequent part.

Add new information in QuickSight

On this part, we arrange an Amazon Redshift information supply. You possibly can as a substitute create a supply from a repository of your alternative, use a file in Amazon S3, or add a CSV file immediately and hook up with it. For extra particulars, see Constructing a dataset from a database.

To arrange your information, full the next steps:

1. Create a brand new information set utilizing Amazon Redshift as the information supply.

A number of choices can be found for configuring this connection; select the one which most closely fits your wants.

2. Create subjects from information units. For extra data, see Making a Subject.

3. (Non-obligatory) Construct a dashboard from a theme. If created, Amazon Q Enterprise can use them.

Ask Amazon Q Enterprise a query

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 need to see the dataset and subject populated with values.

3. Choose the hyperlink under Deployed URL.

We uploaded AWS value and utilization stories for particular AWS accounts in QuickSight utilizing Amazon Redshift. We additionally use Amazon S3 to add Amazon service recordsdata as unstructured information into the information supply of Amazon Q Enterprise. We’ll ask questions associated to AWS prices and present how Amazon Q Enterprise solutions questions from structured and unstructured information.

The screenshot under exhibits a pattern query that returns a response from unstructured information solely.

The next screenshot exhibits a pattern query that solely returns responses from structured information.

The next screenshot exhibits an instance query that returns responses with structured and unstructured information.

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

clear up

When you not need to use this Amazon Q Enterprise characteristic, delete the useful resource you created to keep away from future expenses:

1. Take away the Amazon Q Enterprise app:
   1. On the Amazon Q Enterprise console, select Software areas Within the navigation pane.
   2. Choose your app and open motion menu, choose delete.
   3. Enter delete to substantiate and choose delete.

This course of could take as much as quarter-hour to finish.

2. Delete S3 bucket:
   1. Empty your S3 bucket.
   2. Delete the bucket.
3. Delete QuickSight account:
   1. On the Amazon QuickSight console, select Handle Amazon QuickSight.
   2. select Account settings and handle.
   3. Delete account.
4. Delete your IAM identification heart occasion.

in conclusion

On this article, we present how you can use QuickSight integration to incorporate solutions from structured sources into the Amazon Q Enterprise utility. This creates a unified conversational expertise on your finish customers, saving them time, serving to them make higher selections with extra full solutions, and making them extra productive.

At AWS re:Invent 2024, we introduced the same unified expertise for accessing insights from unstructured information sources in Amazon Q in QuickSight powered by Amazon Q Enterprise.

To study concerning the new options offered by Amazon Q in QuickSight, see QuickSight Plug-ins.

To study extra about Amazon Q Enterprise, see the Amazon Q Enterprise Person Information.

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

QuickSight additionally gives the power to question unstructured information. For extra particulars, see Consolidating Unstructured Knowledge into Amazon QuickSight Utilizing Amazon Q Enterprise.

Concerning the creator

Jiten Dedia It is a gentleman. AIML options architect with greater than 20 years of expertise within the software program trade. He helps Fortune 500 corporations with their AIML/generative AI wants.

Jean-Pierre Dowdel He’s the lead product supervisor of Amazon Q Enterprise, chargeable for offering key strategic product options, together with structured information help in Q Enterprise and RAG. and general product accuracy optimization. He has over 7 years of product management expertise at AWS and brings intensive AI/ML and enterprise search expertise to the staff.