How to bulk import a CSV or a TXT file trough command into a Teradata database

[multipledatabases]

I'm using the following command in SQL Server to create a temporary table, then import values from a CSV file, then consult all those values.

I'm looking for a similar way of doing this exact thing but in Teradata Database. Any import wizard tool is not a possible option for me. I want to be able to do this, only with command as I do with SQL Server.

It's possible to do this in an editor tool like Teradata SQLAssistant or Toad Data Point?

create table #Temporary ( EventID int, EventEnumDays int, EventType int )

BULK INSERT testdb.#temporary FROM 'C:\Users\MyUser\Desktop\bulkinsert.csv' WITH (FIELDTERMINATOR = ',');

Select * from #temporary;

Thanks, any help its really appreciated!

 

[Miguel93]

Hello, I took the liberty of cross posting your question in our teradata community, please follow the link for the answer to your question.

https://support.teradata.com/community?id=community_question&sys_id=5c28c8fedbe490d03dcc93dcd396191c