Recommended maximum amount of columns in a table?

When designing tables I am always wondering how many columns are too much.

I commonly have tables that act as an overview of all the items, which can then be opened to show all the details.

On one hand I want to provide the user with an informative overview, but I don't want the UI to get cluttered or the user to get overwhelmed with all the information and visual noise.

Another downside of adding columns is responsiveness. It doesn't scale well to smaller devices.

So this led to the question: Are there any (official) recommendations/guidelines/resources regarding table design to base these decisions on?