search

minodisk / bigquery-runner

An extension to query BigQuery directly and view the results in VSCode.
https://marketplace.visualstudio.com/items?itemName=minodisk.bigquery-runner
Apache License 2.0
44 stars 8 forks source link

Some new feature suggestions #55

Open GaryLiuTelus opened 6 months ago

GaryLiuTelus commented 6 months ago

Thank you very much for creating this amazing extension. Would you mind adding features?

  1. Table search function Web console provide table search functions I have to work with multiple projects, each contains tens or hundreds or even thousands of tables/views, the search function can help me find the tables I am looking for very quickly. image

  2. Enhanced right click menu Currently, when right click the table name, there are only 2 items, i.e. preview table in vscode or remotely. It will be great if you can add additional items, like Copy table ID or Query this table/view. For the columns, items such as Copy column name will also very helpful.

  3. Displaying resources other than tables/views in the side panel The last one, I don't know this is even possible. Currently the panel only show tables/views, if it can display Saved queries, Stored Procedures etc. that will be great. I can make some changes in on laptop, save my query in the "saved queries", and then the query can be retrieved/edited/executed in web console as well.

Even without this functions, this extension also is awesome, but adding these features will make it even great.

Thank you!

minodisk commented 6 months ago

@GaryLiuTelus

Enhanced right click menu

I've published this as v1.22.0, so give it a try! image image

minodisk commented 6 months ago

As for the other requests, I'll check to see if there is an API I can use for BQ when I have time.

GaryLiuTelus commented 6 months ago

Thank you very much!