Toad Point Import into Volatile Table for Teradata

Toad Data Point & Toad Intelligence Central
1

Good day all

I'm on Toad Point 6.0 and cannot use some of the Teradata Studio features due to OS compatibility. I cannot create tables in TD but can work with volatile tables. I would want to use the Import Wizard to upload excel spreadsheet into volatile tables. Unfortunately, it seems to be something that is not possible based on Teradata - Import to Volatile Tables .

I want to ask if this is being looked at. This is similar to https://docs.teradata.com/r/Teradata-StudioTM-User-Guide/October-2023/Data-Import-and-Export/Importing-Data-Into-a-Volatile-Table

Apparently this is also a common feature in MySQL Workbench when I used it in the past.

Happy to hear from the team!

2

Hi Adrian,

Toad Data Point does not support work with Teradata temporary tables.

This functionality will probably be part of Toad Data Studio.

For your use case, you can do the following in Toad Data Point:

  • Create a Local Storage table with the same structure as the volatile table you want to use
  • In the Data Compare Wizard, use the Excel spreadsheet as a source and the Local Storage table as a target.
  • Generate a sync script (with insert statement) and use this insert statement in Editor where you will create a volatile table and work with data there

I hope this helps.