- Newest
- Most votes
- Most comments
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:
- Use
client.list_data_sets()to get all data sets - For each data set ID returned, call
client.describe_data_set() - In the response from
describe_data_set(), examine the physical table mappings to find the data source IDs - 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
Relevant content
asked 4 years ago
