How to execute SQL queries for Teradata on AWS?

Teradata Database on AWS
Enthusiast

How to execute SQL queries for Teradata on AWS?

We have subscribed to Teradata Database Enterprise Edition on AWS marketplace.Now I need to create tables in the database.

  1. Can we do it using SQL assistant like we have in windows?Does TD in AWS come with an interface or client where we can write and execute various SQL commands since it is in Linux?
  2. Say we have SQL assistant installed in windows.Can we connect it to Teradata database installed in AWS?

 

 

Regards,

Indranil Roy

2 REPLIES
Teradata Employee

Re: How to execute SQL queries for Teradata on AWS?

Yes, You can use SQL Assistant to submit queries against Teradata Database on AWS. When configuring the ODBC connection, you need to provide public IP or DSN of AWS instance.

Teradata Employee

Re: How to execute SQL queries for Teradata on AWS?

The packages for TTU can from the Teradata Database instance  at /var/opt/teradata/TTU_pkgs or you can use your existing TTU from your local system.