Hi team, I am posting this question for a customer:
"Hi,
I am new to Quicksight and exploring. I am trying to create a dashboard in QS to show a Snowflake table. I have to mention every column name explicitly to show in the dashboard. If I add/remove a column in future I have to update the dashboard as well. Is there a way all the columns of the table are selected by default in QS. This is possible in Tableau. Any help would be appreciated. Thanks in advance."
Hi @Kristin
Snowflake tables can be connected to Quick either directly or through a custom SQL query using SELECT * FROM your_table to bring in all columns initially. In the dataset editor, the All option at the top of the fields pane lets you quickly select or deselect every field during preparation.
After importing all the columns into the dataset, create an analysis and drag desired fields from the Fields list to your visuals, such as tables, to display them.
Note: Each dataset supports up to 2000 columns maximum. For more details, please see the data source limits.
Please refer to the following documentation this might be helpful.
Hi @Kristin,
Hope everything is well! Just wanted to check in to make sure Xclipse’s reply was able to provide a solution to the customer or if they are still facing issues. If not, please feel free to specify (if there is any) other questions/information from the initial post within the next 3 business days.
Thank you!
Hi @Kristin,
Since we haven’t received any further updates from the customer, I’ll treat this inquiry as complete for now. However if they have any additional questions, please feel free to create a new post in the community and link this discussion for context.
Thank you!