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!

How can we improve BigQuery?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Have an option to automatically backups tables that are in BigQuery.

    Instead of having to do it manually, it would be good to have an option that automatically backups tables that are in BigQuery (it could be done on a daily basis or monthly basis). The backups could be stored on Cloud Storage or another place.

    11 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Have a better documentation on api clients

      I wanted to connect my NodeJS server to BigQuery, but the NodeJS client api seems quite sparse with indication of how to connect an app or server to BigQuery. The tutorials are also not linear or straight forward, they seem to have random bits of examples but no concrete example.

      The stack-overflow channel and BidQuery forum doesn't answer that.

      In my case I have a NodejJS server running in a container engine and have no clue how to map it to BigQuery. There's also Cloud SQL but it doesn't scale to my needs.

      9 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Transfer Dataset across projects

        Ability to transfer an entire dataset to a different project.

        Possible Solutions:

        1. An option saying transfer dataset to a specific email address where the new owner decides to which project the dataset needs to be added.

        2. A "Copy Dataset" option which copies all tables in a dataset to a different project. In this case, the current user needs to have the associated required permissions for both the projects to do the same.

        4 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Query Google Storage objects from BigQuery

          Be able to select attributes from Google Storage, like folder or file size, etc.

          4 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • 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
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • 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.

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Ability to use Cloud Spanner as import datasource

                Cloud Spanner have high availability performance, but storage cost is high than bigquery.
                I want to save data after ETL processing to BigQuery storage.

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to use Cloud SQL (postgres and mysql) as External Tables

                  Currently we push many tables from relational stores, which hold dimension data, into BigQuery. Being able to push a subquery out to these databases on demand eliminates lag and a whole lot of ETL work.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Don't see your idea?

                  BigQuery

                  Feedback and Knowledge Base