Data Stream In "Create Temporary Table" option not working with Snowflake

Question

When I try to use the Data Stream In tool with the 'Create Temporary Table' option I get the Error:

Error: Data Stream In (6): No table chosen; Please select a Table from data source.

Is there a way to use "Create Temporary Table' with Snowflake or do you always need to use named tables?

acowpy · Accepted Answer

Hi @TrevorS sorry for the slow reply. Turns out the issue was with Snowflake roles and/or default namespace.

In the ODBC config you need to make sure you set the default namespace and use a role/account that is granted 'CREATE TEMPORARY TABLE' on the namespace/schema