Python Forum
Python Teradata Connector - Column Names
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python Teradata Connector - Column Names
#1
Does anyone know how to retrive the column names using Python's Teradata libary..?

Here is a code sample:

import teradata
udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0" logConsole=False)
session = udaExec.connect(method='odbc', system='system_name',authentication='LDAP', username='username', password='REPLACED');
lst_results = []
for row in session.execute("select * from table_name"):
 print(row)
 lst_results.append(row)
The code above will not return the column names. Ultimately, I would like to put the query's results into a Panda's dataframe
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Reshaping a single column in to multiple column using Python sahar 7 1,967 Jun-20-2022, 12:35 PM
Last Post: deanhystad
Question Debian 11 Bullseye | Python 3.9.x | pip install mysql-connector-python-rf problems BrandonKastning 4 6,567 Feb-05-2022, 08:25 PM
Last Post: BrandonKastning
  mysql.connector.errors.ProgrammingError: Failed processing format-parameters; Python ilknurg 3 5,456 Jan-18-2022, 06:25 PM
Last Post: ilknurg
  Program stuck at mysql.connector.connect zazas321 1 2,038 Jul-29-2021, 10:49 AM
Last Post: zazas321
  MYSQL.CONNECTOR ERROR DB1 8 3,774 Jul-23-2021, 03:31 AM
Last Post: DB1
  Data extraction from a table based on column and row names tgottsc1 1 2,356 Jan-09-2021, 10:04 PM
Last Post: buran
  mysql.connector Nobima 1 1,860 Apr-10-2020, 12:00 PM
Last Post: Larz60+
  Import data from excel to Teradata steve87bg 3 4,701 Sep-18-2019, 01:36 PM
Last Post: steve87bg
  Trouble retrieving dictionary from mysql.connector cursor swechsler 2 2,991 Sep-17-2019, 05:21 PM
Last Post: swechsler
  Using VBA to Call a Python script causes error in pyodbc connector pcarra 1 2,775 Jun-11-2019, 04:14 PM
Last Post: pcarra

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020