We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to push en Excel file as a temporary table in a database and then use it in an query

matyohan
9 - Comet

Hello, 

I want to push en Excel file as a temporary table in a database (Snowflake for e.g.) and then use in an Input tool. 

My objective is to use this temporary table to limit the scope of a big query. 

Thanks for your help, 

Best regards,

matyohan

 

11 REPLIES 11
anm252
7 - Meteor

I know this is months old but I think it’s similar to what I have been trying and jsut posted about on here. I have 2 different Oracle databases, 1 will query to pull in a certain amount of records and ideally I’d like that to act as my temp table to run my second query/database against to pull in 2 additional fields. I don’t want to query the whole database and a regular dynamic input takes way too long. Could I do this same thing as you guys outlined?

alexnajm
18 - Pollux
18 - Pollux

As long as you can connect to that database through the IN-DB tools, then sure!

Labels
Top Solution Authors