How to display database and schema in a short time in Snowflake

Published: 26 Sep 2023
Last Modified Date: 08 Nov 2023


By default, Tableau displays all the databases and schema that the account has access to. 
As the number of tables in Snowflake increases, it may take longer to display the database and schema in Tableau Desktop upon connecting to the data source.
Are there options to speed up loading the list of database and schema?


  • Tableau Server
  • Tableau Desktop
  • Snowflake


As a possible workaround, use a .tdc file and set "CAP_FAST_METADATA" to false. 

Disabling this option allows searching for specific schemas or tables instead of retrieving all the objects.
It may speed up to display database and schema.
Did this article resolve the issue?