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. Always display/freeze the column name in BQ query result

    For better user experience.
    I selected display 100 rows per page to check a big query result, when I scroll down to view details of data, the column name will be gone. So hard to match what cell is referring to what column name. So suggest to freeze the column name at first row no matter how many rows display in a 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  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.

    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 →
  7. 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 →
  8. 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 →
  9. 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