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

[matyohan]

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

[anm252]

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]

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