You can use Query Service in the public cloud or on-premises.
The time zone for the Query Service VM defaults to the database time zone.
- From the Azure portal, note the following information of the Query Service VM:
- The private IP address.
- Either the public IP or public DNS, if applicable.
- Log on to the VM using the authentication type you chose when deploying the VM.
- Obtain an admin password for Query Service.
- Open an SSH client and connect to the Query Service VM:
# ssh azureuser@VM-public-IP-address
where:- azureuser is the user name specified when you deployed the VM.
- VM-public-IP-address is the public IP address of the Query Service VM.
- Switch to the root user environment.
# sudo su -
- Generate the password for the admin user:
/opt/teradata/rest/bin/azure_tdrest-password-generate
Note the resulting password, which you will use to log in to the Query Service user interface.
- Open an SSH client and connect to the Query Service VM:
- From your browser, display the Query Service user interface using either the IP address or DNS name.
- http://VM-public-IP-address:1080
- http://VM-public-DNS:1080
- Log in to the Query Service user interface as admin.
- Create a system.See the Teradata® Query Service Installation, Configuration, and Upgrade Guide for Customers.