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

KNOWLEDGE BASE

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

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

Question

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?

Environment

Tableau Server
Tableau Desktop
Snowflake

Answer

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.