I am attempting to execute a CLI command the outputs a simple table with three columns – Data Set ID, Data Source ID, and Data Source Name. The one row would contain the column’s values. I was able to come up with a command that outputs these fields, but the formatting is not ideal. I have attached a screenshot of how it looks in table form. Is there a way to edit the query to produce my desired format?
Hi @Ramon_Lopez,
Thanks for agreeing to help with this! We share QS data sets and data sources across our enterprise and need to know how everything connects.
@Ramon_Lopez not sure to post here or start a new topic, but finding a related issue to these results. It seems as if the value populating in the ‘DataSourceName’ field is outputting the Data Set Name, not the data source name. This is confusing because in the “Name” field is nested under the data source’s id according to the response syntax (DescribeDataSet - Amazon QuickSight).
Should the syntax be revised? Or is this field meant to represent the data set name? If so, wouldn’t that be redundant given the fact that the data set name field already appears in this action nested under “dataset”? DescribeDataSet - Amazon QuickSight
Dataset.name and DataSourceName:PhysicalTableMap.[].[]|[0].Name are two separate values.
Dataset.name is the final result and one dataset could have multiple datasources.
The datasource listed under physiscal table map seems to be the first table added to the dataset/model.
The logical table map contains Join logic as well as the source datasources. For example my dataset has 2 tables. This creates 3 entries under logicaltablemap. One for the join, one for the 2nd table, and one for the transform/renaming of the 2nd table(as i changed the alias name).