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. 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 →
  2. 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 →
  3. specify output format for Save Results > CSV

    The BigQuery UI currently does not allow you to specify the layout of .csv export files. Would be great if there's some extra options, specifically:

    * choose the delimiter (comma, semicolon, tab, pipe, other/specify)
    * choose the enclosing character (double quote, none)
    * include/exclude headers
    * include/exclude leading rownumber column

    5 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. 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 →
  5. 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 →
  6. 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 →
  7. add shorthand for cast(), like table.column::INT64

    we used the shorthand for cast (::) extensively in postgres and redshift, would be great to retain the increased readability

    8 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 →
  8. Add a "Refresh Tables" option in the new web UI, just like we had in the old one.

    It is so annoying to have to fully refresh each open web UI as you add new tables.

    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 →
  9. 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 →
  10. 26 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 →
  11. Create a PDO Connector

    Provide connection through PDO so PHP clients can use standard software that supports this connection method. This would be a great addition to the StandardSQL support and would enable a ton of software to use BigQuery as their DB backend.

    6 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 →
  12. 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 →
  13. Allow us to use Multi-byte characters for table name and column name!!

    Most countries are not common for English. In such a country, most datasets which users want to store in BigQuery are written by Non-English, for instance, columns and table names. Ex, Japanese, Chinese, Spanish, German etc...

    Currently, users have to translate or remember each English columns to their mother language for composing sql queries and exploring entire datasets on BigQuery windows.

    These annoying experience is NOT smart and we believe Google Cloud will save such ignored users in very near future.

    67 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 →
  14. Paid Plan for Extending Upper Quotas of daily "create-table".

    Currently, users can create a table 1,000 times a day in one GCP-project.
    However, sometimes we need more than its limits.
    Please prepare extending option for upper limit with paid plan such as like NLP api charging.

    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 →
  15. Multiple Query Editor tabs

    It would be useful to be able to have multiple query editor tabs open in the web UI

    28 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 →
  16. We need to push and pull capability between every GCP datasource (and external parties) and Bigquery

    Right now, it is a little big of a hodge podge of what can easily talk to what. For example, you can't easily get from BigQuery into CloudSQL or vice versa. It generally takes 2 steps instead of 1 (Export to GCS, then import into Postgres). Part of this task is to make sure GCP has robust ODBC/JDBC drivers for BigQuery that can allow most any database on the planet to connect into BigQuery

    4 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 →
  17. Ability to download/view query history as BigQuery table

    So far I have to use the rest API to get query history and do some usage analytics on it. It would be much easier to expose the usage history as special table or provide ability to export query history as csv or BQ table

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. A way to automatically migrate schema description and table details to other tables.

    Right now, when you create a copy of a table, it takes the existing schema but does not carry over any of the descriptions or table details. For large numbers of columns it is slow and annoying to have to re-enter all those details. A copy schema function or tool would be great.

    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 →
  19. 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 →
  20. Have option to grant access for Views at a Dataset Level rather per view.

    Currently the options to give access to BQ Datasets via views is rather limited. It also requires a lot of maintenance if you want to create new views looking at the same dataset(s) / table(s). I propose a kind of "WITH GRANT OPTION" permissions which allows you to set read access on a dataset that will allow any views created in that dataset to view data in the dataset which access was granted for.

    Example:

    DS1 has tables only.
    DS2 has views that point at tables in DS1.
    I would grant read access ON DS1 TO DS2 WITH GRANT OPTION.

    16 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 →
← Previous 1
  • Don't see your idea?

BigQuery

Feedback and Knowledge Base