CHANGELOG.md

Change Log

All notable changes to the "BigQuery Runner" extension will be documented in this file.

v1.22.0

Added

• Add "Copy Table ID" and "Copy Field Name" to the context menu of the tree view.
  • #57

v1.21.13

Changed

• Fixed large Int64 not overflowing.
  • #54

v1.21.12

Changed

• Fixed broken JSON in README.
  • #53

v1.21.11

Changed

• Fixed a bug that "Preview Table in VS Code" does not use projectId in bigqueryRunner.tree.projectIds.
  • #48

v1.21.9,v1.21.10

Added

• Add usage of query params to README.
  • #52

v1.21.6, v1.21.7, v1.21.8

Added

• Publish to Open VSX Registry.
  • https://open-vsx.org/extension/minodisk/bigquery-runner

v1.21.4

Added

• Support system variables reference.
  • #41

v1.21.3

Added

• Allow tables in the tree to be previewed in the Google Cloud Console.
  • #43

v1.21.2

Changed

• Displays information about the table being previewed.
  • #45

v1.21.1

Changed

• Don't display Query and QueryWithPosition error.
  • Feedback to the editor, so it shouldn't be necessary.
• Don't mark error when text doesn't exist.

v1.21.0

Added

• Use built-in icons in the tree view.

Changed

• Fix bug that JS could not be loaded from viewer HTML.
  • #36

v1.20.0

Added

• Feedback on success or failure of login or logout to the view
  • #35

v1.19.0

Added

• Add Login/Logout commands.
  • #33

Changed

• Fixed wrong field name.
  • #34

v1.18.0

Changed

• Do not use cache of previous input values if query parameters are changed.
• Changed the query tokenizer from the original implementation to sql-formatter.

v1.17.0

Added

• Added icons to the tree view.

v1.16.0

Added

• Support deep schema with ARRAY and STRUCT in the tree view.

v1.15.0

Added

• Delay the display of the result view until the results are returned successfully.
• Persist query parameters.
• Add commands:
  • bigqueryRunner.clearParams: Clear the stored parameters for active text editor.
  • bigqueryRunner.clearAllParams: Clear all stored parameters.

v1.14.0

Added

• Added some setup guidance.
  • #32

v1.13.0

Added

• When a table in the tree view of resources is opened, the fields are now displayed.
  • The name and type are displayed in the field.
• Right-clicking on a table in the tree view of resources now displays a context menu of preview commands.

v1.12.4

Changed

• Changed to dry-run first when running.
  • This is because there are errors that can only be obtained by dry-run, especially for long queries.
• Changed to correctly display the page in the viewer footer if the result does not exist.
  • Display 0 - 0 of 0 instead of 1 - 0 of 0.

v1.12.3

Changed

• Fixed problem of incorrectly parsing @ and ? in strings to query parameters. #29

v1.12.2

Added

• Added an explanation of how to authenticate using Gcloud Credential to the chapter on authentication methods in the README.

v1.12.1

Changed

• Fixed problem with billing status spinner not stopping in some cases.

v1.12.0

Added

• Display child jobs' result.
• Added tree view of resources.

Changed

• Changed schema table direction from horizontal to vertical.
• Schema tabs eliminated and merged into table tabs.

v1.11.0

Added

• Added implementation to allow specifying a byte string for maximumBytesBilled.

Changed

• Fixed an problem where the following two settings were not reflected.
  • useLegacySQL
  • maximumBytesBilled

v1.10.1

Changed

• Fixed problem of multiple columns with the same name #26
• Fixed problem that tab position would not be retained when moving tab with commands.

v1.10.0

Added

• Added features to improve download UX.
  • Display progress bar during downloading. #19
  • Display a message to open the file, when the download is complete. #25
• Provide commands to move between tabs #18

Changed

• Fixed the problem that the spinner in the viewer does not stop when NoPageTokenError occurs when paging.
• Fixed the problem that the current page exceeding range when performing quick paging.

v1.9.0

Changed

• Fixed bugs around query parameters.
  • Stop asking to commented out query parameters #22
  • Ask the same named parameter only once #23
  • Formally support query parameter functions.

v1.8.0

Added

• Support default dataset

v1.7.0

Added

• Display download progress, errors and completion in the status bar.

Changed

• Fixed a problem in which the number of rows that should be retrieved was not displayed or downloaded when retrieving results with a large amount of data per row.
  • The row information displayed on the page is now correct accordingly.

v1.6.0

Added

• Added a tab for table schema.
• More queries supported.
  • Changed the implementation of data fetching as follows; instead of assuming that it is unlikely to be able to fetch the data necessary for the tab to be displayed and not fetching it, if it is not possible to display the tab as a result of fetching it, it is not displayed.
• Added commands for download.

Changed

• Reduced the time it takes to change pages.
  • Avoided fetching extraneous data.

v1.5.0

Added

• Display type and mode tooltips, when moused over in the column header.

v1.4.0

Added

• Added support for setting Array/Struct/Timestamp as parameters.

v1.3.0

Added

• Added the feature to display query errors in the viewer.

v1.2.0

Added

• Added the feature to allow quick fixes for query errors.

v1.1.1

Changed

• Fixed problem with downloading files in Windows.

v1.1.0

Added

• Added parameter support experimentally.
  • This feature could be removed in the future.
  • References:
    • Named parameters
    • Positional parameters

v1.0.0

Added

• Added a download button to the bottom right corner of the Results tab in the viewer.
  • Click it and select the save format and destination to save the results to a file.
• Added a preview button next to the table ID in the viewer.
  • Click it, another viewer will open and display the results of SELECTing that table.
• Added config:
  • bigqueryRunner.downloader.rowsPerPage
    • The number of rows to fetch per page of paging when downloading.

Changed

• Rename config:
  • queryValidation.enabled -> validation.enabled
  • queryValidation.debounceInterval -> validation.debounceInterval
  • bigqueryRunner.format.csv.header -> bigqueryRunner.downloader.csv.header
  • bigqueryRunner.format.csv.delimiter -> bigqueryRunner.downloader.csv.delimiter
  • bigqueryRunner.pagination.results -> bigqueryRunner.viewer.rowsPerPage
  • bigqueryRunner.output.viewer.column -> bigqueryRunner.viewer.column
• Detailed log output to output panel.
• Viewer tabs are now rendered sequentially as data becomes available.
• Fixed a problem that results were not displayed when DECLARE.
  • #14

Removed

• Removed config:
  • bigqueryRunner.output.type
    • Removed option to output results to output panel
      • Instead, you can see the results in a nice table that is output to the viewer.
  • bigqueryRunner.output.file.path
    • Removed option to output results to file
      • Instead, when you select an output format from the Download button in the Viewer, a dialog box will appear asking you to specify the path where you want to save the file. Once the path is specified in that dialog, output to a file will begin.

v0.0.53

Added

• Support routine.

Changed

• Wait for the HTML to finish loading in the Webview and for the JavaScript to complete initialization.

v0.0.52

Changed

• Fixed a problem where results are not displayed in the viewer after a query is executed.

v0.0.51

Changed

• Fixed problem with validation on files that are not query files.

v0.0.50

Changed

• Fixed a problem with incorrect error mark positions.

v0.0.49

Changed

• Fixed the problem of the header and footer showing through when scrolling a horizontal table.

v0.0.48

Added

• Notify when text has been copied to the clipboard.

v0.0.47

Added

• Added a pane of job information to the viewer.
• Added a pane of table information to the viewer.

v0.0.46

Added

• Support multi-select.

v0.0.45

Added

• Added GUI buttons to the viewer for paging.
• Added job information pane to the viewer.

Changed

• Fixed file output directories are automatically created.

v0.0.44

Added

• Added a GUI button to run the query on the editor title menu bar.
• Supported MERGE statement.
  • Added process to display all records as results after creating the table.

v0.0.43

Added

• Open one viewer per query file. Now open as many viewers as the number of queries.
• The position of the column to open the viewer can be set as relative or absolute value: bigqueryRunner.output.viewer.column.
• Run / Prev Page / Next Page commands can be executed on the viewer.

v0.0.42

Added

• Display the icon on the tab of the webview panel.

v0.0.41

Added

• Supported Query Drive data.

v0.0.40

Changed

• Fixed error when expanding nullable structs.

v0.0.39

Changed

• Fixed to mark the position of errors correctly when executing selected text as a query.

v0.0.38

Changed

• Upgraded dependent packages

v0.0.37

Changed

• Fixed syntax error if data source name contains hyphens.

v0.0.36

Added

• Supported CREATE TABLE AS SELECT statement.
  • Added process to display all records as results after creating the table.

v0.0.35

Changed

• Fixed a bug where the loading display would not stop even though it was in error.

v0.0.34

Changed

• Fixed a bug that panel is created on every run.

v0.0.33

Changed

• Fixed an irreproducible bug that could cause the viewer instance of the output destination to be disposed during processing.

v0.0.32

Changed

• Fixed the bug that boolean is not correctly output to CSV.

v0.0.31

Changed

• Fixed a bug where undefined was displayed in empty cells when output.type is set to viewer.
• Added extension setting to README to automatic validation.

v0.0.30

Changed

• Fixed a bug that certain types cannot be rendered when output.type is set to viewer.
  • BIGNUMERIC
  • NUMERIC
  • BOOL
  • BYTES

v0.0.29

Added

• Enabling the setting of status bar items position.
  • bigqueryRunner.statusBarItem.align: The alignment of the status bar item
  • bigqueryRunner.statusBarItem.priority: The priority of status bar item. Higher value means the item should be shown more to the left.

Changed

• Display the previous status in the status bar even while loading.

v0.0.28

Added

• Display the amount of data to be processed or billed in the status bar.

v0.0.27

Changed

• Styled the padding around the table.
• Renamed the value of settings bigqueryRunner.output.type from output to log.
• Update descriptions for commands and configurations.

v0.0.26

Added

• Display the skeleton from the initialization of the viewer until the data loading and rendering is complete.
• Added links to each version in the change log.

Changed

• Rewroted the README.

v0.0.25

Added

• Added a spinner to show the loading status.

Changed

• Optimized data messaging for fast rendering.
• Changed the rendering engine to use React v18β for asynchronous rendering.
• Changed the table header to stick to the top of the panel.
• Changed the table footer to stick to the bottom of the panel.

v0.0.24

Added

• Added pagination.
• Added an option for pagination.
  • bigqueryRunner.pagination.results: number of rows per page
• Added commands for pagination
  • bigqueryRunner.prevPage: display previous page
  • bigqueryRunner.nextPage: display next page
• Added a row number column to the viewer.
• Added page information to viewer.

v0.0.23

Added

• Show an authentication error message.

v0.0.22

Changed

• Fixed issue where viewer resources could not be loaded.

v0.0.21

Added

• Add the viewer options to bigqueryRunner.output.type
  • Rendering a well-formed table to a webview

v0.0.20

Added

• Validate already opened files when the extension is activated.

v0.0.19

Added

• Validate that the query is correct when editing it.
• Added support for relative paths in keyFilename option.
  • Convert the relative path to an absolute path from the root folder.

Changed

• Changed to validate queries by default.
• Renamed verifyOnSave option to queryValidation.
• Shortened the property in config.
  • bigqueryRunner.output.format -> bigqueryRunner.format
  • bigqueryRunner.output.destination -> bigqueryRunner.output

v0.0.18

Changed

• Changed the message to correctly state that the amount of data to be read by dry run has been estimated.

v0.0.17

Added

• Added JSON format
• Added JSON Lines format

Changed

• Renamed validateOnSave option to verifyOnSave

Removed

• Removed support for json space

v0.0.16

Added

• Added markdown table format.

v0.0.15

Changed

• Rename option checkErrorOnSave to validateOnSave.
• Changed to put a new line in the Output Channel for each execution.

v0.0.14

Changed

• Changed screenshot for checkErrorOnSave option in README.

v0.0.13

Added

• Added option to check for query errors when saving files.

Changed

• Changed to add units to bytes output in logs.

v0.0.12

Added

• Mark the location of errors encountered during the execution of a query job in the editor.

v0.0.11

Changed

• Added a new line to the last line of output.

v0.0.10

Changed

• Show output window when outputting error log.

v0.0.9

Added

• Added file export as an option.
• Added header and delimiter options to CSV format.
• Added space option to JSON format.

Changed

• Changed the format of the option settings.
• Changed CSV format to express deep structure.

Removed

• Removed JSON pretty option.

v0.0.8

Added

• Add a screenshot to the README.
• Add the recommended settings to the README.

v0.0.7

Added

• Runs the selected text as query, if the text is selected.

Removed

• Removed the command dedicated to the selected text.

v0.0.6

Bug

• Capture errors that were not captured and printed in the output window.

v0.0.5

Changed

• Unify the signature of the extension with bigqueryRunner.

v0.0.4

Changed

• Update repository URL.

v0.0.3

Added

• Add option to preserve focus.
• Enabled table format to represent deep structures.
• Add an icon.

Changed

• Print error to output window.

v0.0.2

Changed

• Don't focus to the output window on every output.