bigfunctions > explore_table

explore_table

Signature

explore_table(fully_qualified_table)

Description

Show table infos and column statistics

See the result as a data visualization in BigQuery Console!

The result of this function can be vizualized as an html report directly in BigQuery Console!

1. Install this bookmarklet: bigfunctions (it has to be done only once)
2. Open BigQuery console
3. Click on the installed bookmarklet.
   • From now on, the bookmarklet code will observe the BigQuery console page.
   • If a BigQuery result appears with a unique cell containing html content, it will be rendered.
4. You will have to click on the bookmarklet again:
   • If you refresh the Bigquery console page,
   • If you open the BigQuery console in a new tab of your browser.
5. Run the query of the example and open the result of the latest subquery. The result will be shown as a nice html content.

Examples

EUUSeurope-west1

call bigfunctions.eu.explore_table("eu.natality");
select html from bigfunction_result;

call bigfunctions.us.explore_table("us.natality");
select html from bigfunction_result;

call bigfunctions.europe_west1.explore_table("europe_west1.natality");
select html from bigfunction_result;