13 support issues
For additional help, check out the developer's support site.
- All
- Questions
- Suggestions
- Problems
Malcolm Grant
Feb 9, 2021
Query Cost Estimation Missing
Hi the cost estimation is missing, it was there earlier today
Preeti Mohapatra
Jan 18, 2021
Can't see the cost estimate in the new console
Can't see the cost estimate in the new BQ console. Was working earlier
Denys Lamanov
Jan 13, 2021
Can't see price anymore (new UI)
Recently Google updated UI and I can't see price anymore
Stephen Jackson
Mar 23, 2020
No more multiple tabs in BigQuery
I used this extension for the multiple tabs it could provide in BigQuery. Now that seems to no longer be the case. I uinstalled/reinstalled BigQuery Mate and still no option for multiple tabs - has something changed with the extension?
Frank Tiex
Oct 23, 2019
User/Data Profiling
Again:
Does Big Query Mate log any (meta) data about the user or processed content? If so, which information and for what purpose?
Without a response I cannot approve the usage.
Frank Tiex
Oct 10, 2019
User/Data Profiling
Does Big Query Mate log any (meta) data about the user or processed content? If so, which information and for what purpose?
A Chrome Web Store user
Apr 24, 2018
Schemas
Would it be possible to add an option to copy the schema from a table in the text/JSON format?
Krutika Parab
Dec 21, 2017
Pivot
Can I download the results generated from pivot??
D B
Aug 31, 2017
Does it support Standard SQL ?
Does it support Standard SQL ?
A Chrome Web Store user
Jun 1, 2017
BQ mate parameter replacement breaks UDFs
There seems to be an issue with BQ Mate parameter replacement when a query includes a UDF.
Below I use an example similar to the one in the BQ UDF documentation (https://cloud.google.com/bigquery/docs/reference/standard-sql/user-defined-functions).
Steps to reproduce error:
1) Copy paste the following code into BQ Web UI
CREATE TEMPORARY FUNCTION multiplyInputs(x FLOAT64, y FLOAT64)
RETURNS FLOAT64
LANGUAGE js AS """
RETURN x*y;
""";
WITH numbers AS
(SELECT 1 AS x, 5 AS y
UNION ALL
SELECT 2 AS x, 10 AS y
UNION ALL
SELECT @parameter AS x, 15 AS y)
SELECT x, y, multiplyInputs(x, y) AS product
FROM numbers;
2) Use BQ Mate to set @parameter to a FLOAT64 value (e.g. “3”)
3) Observe Syntax error
The error seems to be due to the fact that the BQ mate capitalises “return” inside the UDF upon parameter replacement, although the UDF body is case sensitive.
This is possibly due to the fact that BQ web UI shows the keyword “return” in capitals although the underlying code is lowercased.
CURRENT SOLUTION:
Replace “RETURN” with “return” after BQ Mate parameter replacement