Data Stream In "Create Temporary Table" option not working with Snowflake
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- In Database
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @acowpy
Thanks for posting to the Community!
Can you please explain what it is you are trying to accomplish? There is likely a way with Alteryx, but there is not enough information to troubleshoot.
Please include any additional supporting documentation you can, including a copy of your workflow if necessary!
As for your questions regarding the Data Stream In tool, I found the below for you.
The Data Stream In tool does require being connected to an existing dataset. From the help doc it states the following:
"Use the Data Stream In tool to bring data from Designer into the In-DB workflow.
In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods."
And:
Create Temporary Table: Writes to a temporary table that is available until the end of the session. This option is useful for building In-DB predictive macros because it holds the metadata in place temporarily. If this option is selected, the Table Name field is disabled and displays “[a unique temporary table name is generated on each run]".
Thanks!
TrevorS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
