DEV Community

Marcelo Costa
Marcelo Costa

Posted on • Edited on

Using Python to create Teradata tables with random schema

#teradata #database #metadata #python

Having a large amount of test data sometimes take a lot of effort, and to simulate a more realistic scenario, it’s good to have a large number of tables with distinct column types. This script generates random tables schema for Teradata.

Environment

Activate your virtualenv 
pip install --upgrade virtualenv python3 -m virtualenv --python python3 env source ./env/bin/activate
Enter fullscreen mode Exit fullscreen mode
Install the requirements for the metadata generator 
pip install -r requirements.txt
Enter fullscreen mode Exit fullscreen mode

Code

Execution 

export TERADATA_SERVER=127.0.0.1 export TERADATA_USERNAME=my_user export TERADATA_PASSWORD=my_user_pwd export TERADATA_DATABASE=my_db python metadata_generator.py \ --teradata-host=$TERADATA_SERVER \ --teradata-user=$TERADATA_USERNAME \  --teradata-pass=$TERADATA_PASSWORD \ --teradata-database=$TERADATA_DATABASE
Enter fullscreen mode Exit fullscreen mode

And that's it!

If you have difficulties, don’t hesitate reaching out. I would love to help you!

Top comments (1)

Collapse
 
starload profile image
starload •

Hi,

How to extact DDL/DML files from teradata using python ? any approach that you would suggest ?
Also, is there any scripter available for teradata unlike mssql-scripter ? Is so, can please share the link and resources ?