Hello @mateoleon210 - Happy New Year! It is always recommended in BI tools (including QuickSight) to select specific columns instead of using the * wildcard. As you mentioned, it could be a cumbersome process to write down the SQL; however you can use simple Excel formulas or leverage database internal system/metadata tables to easily create the column structure automatically and then build your SQL. That will perhaps help you to save the time and effort (that you are trying to save) as well as follow the best practices of specifying columns rather than doing “SELECT *”. I have tried to provide a sample of the same for your reference. Hope this helps!
SELECT
– Creates the list of column names in tablename_columnname format
– and appended with a comma
t.name + ‘_’ + c.name + ‘,’ as columnname
FROM sys.tables t
LEFT JOIN sys.columns c
on t.object_id = c.object_id
– change the table name to obtain the list of columns for that table
where t.name = ‘DimCustomer’
