KNOWLEDGE BASE

Snowflake Error: Maximum Number of Expressions in a List Exceeded


Published: 04 Sep 2019
Last Modified Date: 06 Sep 2019

Issue

When connected to Snowflake data, an error may occur:

SQL compilation error: error line X at position Y maximum number of expressions in a list exceeded, expected at most 16,384, got Z

Environment

  • Tableau Desktop 2019.2
  • Windows 10
  • Snowflake

Resolution

Work with your Snowflake Administrator to grant permission for creating temporary tables to the account being used for the Snowflake connection.

Cause

The user account for the Snowflake connection must have permission to create temp tables in the Snowflake schema.
Did this article resolve the issue?