google.datalab CommandsΒΆ

%bq
usage: %bq [-h]
           {datasets,tables,query,execute,extract,sample,dryrun,udf,datasource,load}
           ...

Execute various BigQuery-related operations. Use "%bq <command> -h" for help
on a specific command.

positional arguments:
  {datasets,tables,query,execute,extract,sample,dryrun,udf,datasource,load}
                        commands
    datasets            Operations on BigQuery datasets
    tables              Operations on BigQuery tables
    query               Create or execute a BigQuery SQL query object,
                        optionally using other SQL objects, UDFs, or external
                        datasources. If a query name is not specified, the
                        query is executed.
    execute             Execute a BigQuery SQL query and optionally send the
                        results to a named table. The cell can optionally
                        contain arguments for expanding variables in the
                        query.
    extract             Extract a query or table into file (local or GCS)
    sample              Display a sample of the results of a BigQuery SQL
                        query. The cell can optionally contain arguments for
                        expanding variables in the query, if -q/--query was
                        used, or it can contain SQL for a query.
    dryrun              Execute a dry run of a BigQuery query and display
                        approximate usage statistics
    udf                 Create a named Javascript BigQuery UDF
    datasource          Create a named Javascript BigQuery external data
                        source
    load                Load data from GCS into a BigQuery table. If creating
                        a new table, a schema should be specified in YAML or
                        JSON in the cell body, otherwise the schema is
                        inferred from existing table.

optional arguments:
  -h, --help            show this help message and exit
None
%chart
usage: %chart [-h]
              {annotation,area,bars,bubbles,calendar,candlestick,columns,combo,gauge,geo,heatmap,histogram,line,map,org,paged_table,pie,sankey,scatter,stepped_area,table,timeline,treemap}
              ...

Generate an inline chart using Google Charts using the data in a Table, Query,
dataframe, or list. Numerous types of charts are supported. Options for the
charts can be specified in the cell body using YAML or JSON.

positional arguments:
  {annotation,area,bars,bubbles,calendar,candlestick,columns,combo,gauge,geo,heatmap,histogram,line,map,org,paged_table,pie,sankey,scatter,stepped_area,table,timeline,treemap}
                        commands
    annotation          Generate a annotation chart.
    area                Generate a area chart.
    bars                Generate a bars chart.
    bubbles             Generate a bubbles chart.
    calendar            Generate a calendar chart.
    candlestick         Generate a candlestick chart.
    columns             Generate a columns chart.
    combo               Generate a combo chart.
    gauge               Generate a gauge chart.
    geo                 Generate a geo chart.
    heatmap             Generate a heatmap chart.
    histogram           Generate a histogram chart.
    line                Generate a line chart.
    map                 Generate a map chart.
    org                 Generate a org chart.
    paged_table         Generate a paged_table chart.
    pie                 Generate a pie chart.
    sankey              Generate a sankey chart.
    scatter             Generate a scatter chart.
    stepped_area        Generate a stepped_area chart.
    table               Generate a table chart.
    timeline            Generate a timeline chart.
    treemap             Generate a treemap chart.

optional arguments:
  -h, --help            show this help message and exit
None
%csv
usage: csv [-h] {view} ...

positional arguments:
  {view}      commands
    view      Browse CSV files without providing a schema. Each value is
              considered string type.

optional arguments:
  -h, --help  show this help message and exit
None
%datalab
usage: %datalab [-h] {config,project} ...

Execute operations that apply to multiple Datalab APIs. Use "%datalab
<command> -h" for help on a specific command.

positional arguments:
  {config,project}  commands
    config          List or set API-specific configurations.
    project         Get or set the default project ID

optional arguments:
  -h, --help        show this help message and exit
None
%gcs
usage: %gcs [-h] {copy,create,delete,list,read,view,write} ...

Execute various Google Cloud Storage related operations. Use "%gcs <command>
-h" for help on a specific command.

positional arguments:
  {copy,create,delete,list,read,view,write}
                        commands
    copy                Copy one or more Google Cloud Storage objects to a
                        different location.
    create              Create one or more Google Cloud Storage buckets.
    delete              Delete one or more Google Cloud Storage buckets or
                        objects.
    list                List buckets in a project, or contents of a bucket.
    read                Read the contents of a Google Cloud Storage object
                        into a Python variable.
    view                View the contents of a Google Cloud Storage object.
    write               Write the value of a Python variable to a Google Cloud
                        Storage object.

optional arguments:
  -h, --help            show this help message and exit
None
%sd
usage: %sd [-h] {monitoring} ...

Execute various Stackdriver related operations. Use "%sd <stackdriver_product>
-h" for help on a specific Stackdriver product.

positional arguments:
  {monitoring}  commands
    monitoring  Execute Stackdriver monitoring related operations. Use "sd
                monitoring <command> -h" for help on a specific command

optional arguments:
  -h, --help    show this help message and exit
None