Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ----------------------------------------- udaexec.inc
- # Application Configuration
- [CONFIG]
- appName=StatisticsMacrosFactory
- version=0.1
- logConsole=False
- dataSourceName=vmtest
- # Default Data Source Configuration
- [DEFAULT]
- method=odbc
- charset=UTF8
- # Data Source Definition
- [TDPROD]
- system=dbc
- username=dbc
- password=dbc
- ----------------------------------------- execute commands:
- pip install teradata
- ----------------------------------------- app.py
- import teradata
- udaExec = teradata.UdaExec ()
- with udaExec.connect("${dataSourceName}") as session:
- table_columns = {}
- for row in session.execute("SELECT TableName, ColumnName, ColumntType FROM dbc.columns WHERE DatabaseName = '${dataSourceName}';"):
- table_columns[row[0]] = table_columns[row[0]].append((row[1], row[2]))
- print(table_columns)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement