Is there a way to create temporary tables in Teradata using an Excel connection? I would like to run a select query afterwards, which I can run. However, creating the temporary tables is difficulat.
i believe you have data in excel and wanted to load in teradata table for temperory purpose.
You may use csv format and upload it to teradata table through SQL assistant export option or Bteq with vartext mode. And can query the table after load.
Thanks for the reply, I basically have a select query linked to Teradata in Excel. However, that select query contains temporary tables in joins, and therefore I want to create those temporary tables prior to the select query being ran. With that said, is it possible to setup a function to execute the create volatile table query from Excel itself.