Connected Sheets (BigQuery) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to connect BigQuery data in Google Sheets.

Google Sheets

=BIGQUERY([1])

Drag options to blanks, or click blank then click option'

A"SELECT * FROM dataset.table"

B"=SUM(A1:A10)"

C"NOW()"

D"=IMPORTRANGE()"

Attempts:

3 left

💡 Hint

Common Mistakes

Using spreadsheet formulas like SUM or NOW inside BIGQUERY.

Using IMPORTRANGE instead of a SQL query.

The BIGQUERY formula requires a valid SQL query string to fetch data from BigQuery.

2fill in blank

medium

Complete the formula to specify the project ID in the BigQuery connection.

Google Sheets

=BIGQUERY("SELECT * FROM dataset.table", [1])

Drag options to blanks, or click blank then click option'

A"2023-01-01"

B"my-project-id"

C"sheet1"

D"region-us"

Attempts:

3 left

💡 Hint

Common Mistakes

Using region or sheet names instead of project ID.

Using dates or other unrelated strings.

The second argument in BIGQUERY specifies the project ID as a string.

3fill in blank

hard

Fix the error in the formula to refresh BigQuery data in Connected Sheets.

Google Sheets

=BIGQUERY("SELECT * FROM dataset.table", [1])

Drag options to blanks, or click blank then click option'

A"FALSE"

BTRUE

C"TRUE"

Dtrue

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted TRUE or true which causes errors.

Using "FALSE" disables refresh.

The refresh parameter must be a string "TRUE" to enable data refresh.

4fill in blank

hard

Fill both blanks to create a filter in the BigQuery SQL query inside Connected Sheets.

Google Sheets

=BIGQUERY("SELECT * FROM dataset.table WHERE [1] [2] 100")

Drag options to blanks, or click blank then click option'

Asales

B>

C<

Ddate

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'date' column with numeric comparison.

Using wrong comparison operators.

The filter compares the 'sales' column with 100 using the greater than operator.

5fill in blank

hard

Fill all three blanks to create a query with aggregation and filtering in Connected Sheets.

Google Sheets

=BIGQUERY("SELECT [1], COUNT(*) FROM dataset.table WHERE [2] [3] 50 GROUP BY [1]")

Drag options to blanks, or click blank then click option'

Acategory

Bprice

C>

Dsales

Attempts:

3 left

💡 Hint

Common Mistakes

Using different columns for SELECT and GROUP BY.

Using wrong comparison operators or columns in WHERE.

The query selects 'category', counts rows, filters where 'price' > 50, and groups by 'category'.