Dataset ColumnsΒΆ

https://colab.research.google.com/assets/colab-badge.svg https://mybinder.org/badge_logo.svg
columns(table)

Returns the column names of a given dataset.


Parameters:
tableName: string

The name of table associated with the dataset. A full list of table names can be found in the Data Catalog or Datasets method.

Example

Column names associated with the AMT 13 Cruise dataset.

#!pip install pycmap -q     #uncomment to install pycmap, if necessary

import pycmap

api = pycmap.API(token='<YOUR_API_KEY>')
api.columns('tblAMT13_Chisholm')
../../../../_images/sql.png

SQL Statement

Here is how to achieve the same results using a direct SQL statement. Please refer to Query for more information.

EXEC uspColumns 'tableName'

Example:

Column names associated with the AMT 13 Cruise dataset.

EXEC uspColumns 'tblAMT13_Chisholm'