Skip to content

Using boto3, how can I determine which QuickSight data sets are linked to which data sources.

0

I can use client.list_data_source & client.describe_data_source to get information about data sources. I can use client.list_data_sets and client.describe_data_sets to get information about data sets. But how can I get information about which data_sets are linked to a data_source?

Thanks,

Peter

asked a year ago186 views

1 Answer
0
Accepted Answer

To determine which QuickSight data sets are linked to which data sources using boto3, you'll need to use a combination of the QuickSight API methods you mentioned.

First, you can get a list of all data sets using the list_data_sets method, which returns all datasets belonging to your AWS account in a specific region. Then, for each data set, you'll need to call the describe_data_set method to get detailed information about that specific data set.

The describe_data_set response will contain information about the physical table mappings for the data set, which includes references to the data source IDs that the data set is linked to. By examining these physical table mappings, you can determine which data sources are being used by each data set.

Here's a general approach:

  1. Use client.list_data_sets() to get all data sets
  2. For each data set ID returned, call client.describe_data_set()
  3. In the response from describe_data_set(), examine the physical table mappings to find the data source IDs
  4. Use client.describe_data_source() to get details about each linked data source if needed

This approach will allow you to build a mapping between your data sets and their associated data sources.
Sources
list_data_sets - Boto3 1.37.32 documentation
QuickSight - Boto3 1.37.32 documentation
DescribeDataSource - Amazon QuickSight

answered a year ago

EXPERT

reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.