BigQuery

Welcome to the Google BigQuery idea forum. You can submit and vote on ideas here to tell the Google BigQuery team which features you’d like to see.

This forum is for feature suggestions. If you’re looking for help forums, look here:

We can’t wait to hear from you!

  1. Ability to export the table to datastore

    It would be great to have ability to transfer BQ database to Datastore.
    Example use case: we have a table which was used for mostly write-only audit logging with rare analytics queries. But now we need to read from it quite often, so Datastore is more suitable for the task

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Expand Dataset Copy to Copy All Resources in Dataset

    Copy everything within a dataset, not just the tables. This includes UDF's, views, etc.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. When saving result tables, remember where last table was saved

    I had an exercise where I needed to query one table multiple times describing more specific data sets based on certain values. Every time i save my resulting query table, I have to go back and respecify the destination project that I am saving it to, which is tedious; especially when I save it to the wrong predetermined spot by accident and need to delete it. Please add a small feature that remembers the last project a dataset was saved to.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. View Schema and Query Results Simultaneously

    Like most SQL implementations, allow user to view table schema on the left-hand side of the screen while viewing query results on the main page.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Instance tables should have expiration time independent from the template

    It is not currently possible to set expiration time for the instance table different from the template table.
    But it is a common use case to create a template table to last "forever" but your instance/suffixed tables must expire in a month due to PII requirements.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Improve Functionality of Geo Viz to support more than 2K rows

    I would actually prefer Geo Viz to be integrated into Data Studio and support all Spatial Formats (MultiLineString, MultiPolygon, etc) so that it can be used as a reporting tool.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Put big WARNING in documentation that format_date '%w' is [0-6], but extract(DayOfWeek) is [1-7]

    select
    format_date('%w', DATE('2019-09-22')) as format,
    extract(DAYOFWEEK FROM DATE('2019-09-22')) as extract

    -- Result
    format extract
    0 1

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Cache queries to boost performance if entities were not modified

    Many companies use to have periods of the day to run ETL's and load data to Big Query. By having a timestamp parameter in Big Query Entities of last update, Big Query could query last few hours queries outputs by queries strings and return the same results if the query is the same and the entity was not modified.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow editing while the query is running

    When debugging it is often the case that the query we run takes some time to complete. In the meantime would be useful to allow editing the query while it is running, to speed up the manual debugging.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Ability to query dataset access control as BigQuery table

    Use case: normally we use Active Directory to manage access groups. For GCP we haven't found a satisfactory integration solution so are currently managing access control manually (with the help of some scripts). It would be nice to be able to query BQ dataset access (e.g. similar to a dataset schema option) joining to our employee department data (already in BQ) so inappropriate granting of permissions can be quickly flagged.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. UI: Straighten out schema datatype naming in StandardSQL mode

    BigQuery UI (both legacy and new version)
    display Table Schema with columns of type INTEGER,
    but if in #standardSQL I try to append a row with value CAST(NULL as INTEGER) into that column, it fails with
    Type not found: INTEGER

    (I need to cast as INT64)

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add parameters values to query logs

    When a parametrized query is logged in the query history, parameters values are not stored in the log. It makes it hard to debug and replay parametrized queries.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. INFORMATION_SCHEMA returns data for all objects in all projects by default

    Instead of only showing the content of the current project, it is useful to be able to dive into enterprise wide data assets in a single location, particularly for new starters to identify potential sources of data before they have a feel for data models, assisting with semi automated data mining, sense checking regression testing has identified all downstream sources e.t.c (if this can already be done via another view please email me to let me know where it is)

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Sort query output in results window without re-running the query

    Sometimes you just want to run a quick check across your table, like:

    select year, sum(sales) from sales.table where calendar_year >= 2016 group by 1

    The output will look something like this:

    year | f0_
    2019 | 20000
    2016 | 10000
    2017 | 25000
    2018 | 40000

    And then there's no way to sort these in the UI without having to run a new query. Or, you have to export to another tool to sort it there.

    It would be great if we could get an option to sort the output after running the query, with simple sort asc/desc buttons…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
2 Next →
  • Don't see your idea?

BigQuery

Categories

Feedback and Knowledge Base