bigfunctions > get_table_columns

get_table_columns

Signature

get_table_columns(fully_qualified_table)

Description

Get the column information of the given table from INFORMATION_SCHEMA.COLUMNS and put them in a temporary table called bigfunction_result.

Examples

call bigfunctions.eu._get_columns("bigfunctions.samples.natality"); select column_name, data_type from bigfunction_result ;

EUUSeurope-west1

call bigfunctions.eu.get_table_columns("eu.natality");

call bigfunctions.us.get_table_columns("us.natality");

call bigfunctions.europe_west1.get_table_columns("europe_west1.natality");