Deploying Teradata Database Developer Tier on Azure

Arsen Vladimirskiy
Nov 5, 2017 · 2 min read

In this video walkthrough, I show how to deploy Teradata Database Developer Tier from Azure Marketplace, access Teradata Viewpoint management UI, install and use Teradata Studio GUI on Windows, and connect to Teradata database using bteq command line via SSH.

Video Walkthrough

Tip: Play the video full screen.

Teradata on Azure

Create Database

Following is a simple script to create a tiny (4MB) database and test table (see syntax reference). Since I didn’t specify FROM database_name option, the database owner of the newly created database is the currently logged in user (e.g. dbc). With option PERMANENT=4000000 we specify that the database should reserve 4,000,000 bytes for permanent storage. This space is taken from unallocated space in the database or user of the immediate owner (in my case “dbc”). With option SPOOL=4000000 we specify the number of bytes allowed for spool and volatile temporary tables in the database. With option FALLBACK PROTECTION we specify whether to create and store a duplicate copy of each table created in the new database. In our case, I have included it just as an example since we are running a single node and having a duplicate copy of each table would not help if the node is down.

Teradata BTEQ

BTEQ (Batch Teradata Query) is a command line utility that can be used for both batch and interactive mode. In this example, I briefly show how to use BTEQ as a query tool. Establish SSH connection to the database node, sudo to become root, and run bteq as follows.

Thank you for watching and reading!

Please leave feedback and questions below or on Twitter https://twitter.com/ArsenVlad


Originally published at blogs.msdn.microsoft.com on November 5, 2017.

Arsen Vladimirskiy

Written by

Azure Cloud Architect & Software Engineer at Microsoft, Commercial Software Engineering (CSE) Team