Use this connection to communicate between Google BigQueryTM and Minitab Connect.

Set up a new connection

Complete the following steps to set up a connection in Minitab Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter Google BigQuery and select the connector from the results.
  3. Enter a Name that identifies the connection.
  4. On the Setup tab, select Authorize Google. Enter the Google credentials for the account that you want to use. When connected, the button updates to Authorization Successful.

    Alternatively, you can sign in to your account with a service account key. For more information on how to create a service account key, go to Create and delete service account keys.

  5. Select Save .

After you save the connection, Connect displays options to import data into a new table. Start at step 4 of the following section for more information on importing data to create a table.

Create a table with data from a connection

Complete the following steps to import data from a file on Google Drive and create a new table in Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter Google BigQuery and select the connector from the results.
  3. Under Connection, select the connection that you previously set up. If you have not previously set up a connection, select New Connection and follow the steps in the previous section.
  4. On the left panel, enter a Name that identifies the table and select a Folder to save the table.
  5. Under Projects, select that project that contains the dataset that you want to import. Then select Next.
  6. Under Dataset, select that dataset that contains the table that you want to import. Then select Next.
  7. Under Table, select that table that contains the data that you want to import. Then select Next.
  8. Select the columns from the table that you want to import. You can filter the results based on text that you enter in Available Fields.
  9. Select Next. Connect displays the SQL statement in Query. From SQL Version, you can choose to display the Standard SQL or Legacy SQL.
  10. Select Next. Minitab Connect displays a message whether the import is successful or whether there is an error with the import. If the import is successful, select Save . If you go to the Prep Tool and select Run , Minitab Connect displays the imported data.
    Note

    If no data appears after you select Run, select Reset Config .

When you save the import, Connect creates a flow with the settings that you selected. For more information on how to schedule a flow and add more data processes to clean data, go to Overview of the Flow Tool .

Export a file

Complete the following steps to export data from a Minitab Connect table.
  1. Open the Outputs tab of the Flow Tool .
  2. Select the plus sign beside Export to add a new export.
  3. Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
  4. Enter a Name for the export.
  5. Under View, select a saved view of the table. If you select None, Connect exports all the data from the table. For more information on saved views, go to Example of creating a data view.
  6. Under Delivery, select Connection.
  7. Under Connection, select the connection that you previously set up.
  8. Select the Project, Dataset, and Table that you want to use for the export.
  9. For File Type, you must select CSV.

You can specify the file name along with other options. Select Save to add the export to the list of exports in the Outputs tab. Select Run to run the export.