List columns in the specified table
tables_list_columns(id, name = NULL, limit = NULL, page_num = NULL, order = NULL, order_dir = NULL)
string optional. Search for columns with the given name, within the specified table.
integer optional. Number of results to return. Defaults to its maximum of 50.
integer optional. Page number of the results to return. Defaults to the first page, 1.
string optional. The field on which to order the result set. Defaults to name. Must be one of: name, order.
string optional. Direction in which to sort, either asc (ascending) or desc (descending) defaulting to asc.
An array containing the following fields:
string, Name of the column.
string, The generic data type of the column (ex. "string"). Since this is database-agnostic, it may be helpful when loading data to R/Python.
string, The database-specific SQL type of the column (ex. "varchar(30)").
array, A sample of values from the column.
string, The compression encoding for this columnSee: http://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html
string, The description of the column, as specified by the table owner
integer, Relative position of the column in the table.
string, Smallest value in the column.
string, Largest value in the column.
number, Average value of the column, where applicable.
number, Stddev of the column, where applicable.
list, A mapping between each value in the column and the percentage of rows with that value.Only present for tables with fewer than approximately 25,000,000 rows and for columns with fewer than twenty distinct values.
integer, Number of non-null values in the column.
integer, Number of null values in the column.
array, Possible dependent variable types the column may be used to model. Null if it may not be used as a dependent variable.
boolean, Whether the column may be used as an independent variable to train a model.
boolean, Whether the column may be used as an primary key to identify table rows.
list, An object mapping distinct values in the column to the number of times they appear in the column
integer, Number of distinct values in the column.