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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  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. 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 →
  10. 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

    11 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 →
  11. 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.

    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 →
  12. 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 →
  13. 35 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 →
  14. 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 →
  15. 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 →
  16. 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.

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

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

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

BigQuery

Categories

Feedback and Knowledge Base