首页 扩展程序 Streak BigQuery Developer Tools

Streak BigQuery Developer Tools

提供方: Streak CRM
19
开发者工具 1,000+ 位用户

插件简介

Development tools used internally at Streak.
Streak Developer Tools (for BigQuery)
-------------------------------------------------------

The Streak BigQuery Developer Tools (SBDT) is a chrome extension that currently adds functionality to BigQuery (see features below) and in the future will add other tools used internally at Streak.com

BigQuery Tools
----------------------

1. Graph Results of a Query

The SBDT extension lets you graph the results of a query. The button appears next to the download as csv button. It currently only graphs the current results on screen, in a future release it will graph all results. It expects the first column to be a date and every other column after that to be a number.

2. Query Across Datasets

Simply select "Query Dataset" and the query box will be filled in for you with all the tables in the dataset.

3.Show Cost of Each Query

Added the ability to see how much each query that you ran costs. Once the query completes, we added the cost (in US cents) next to the summary status of the query. The cost is calculated based on $0.035/GB processed.


4. Expand Multi-line Results

The SDT allows you to click on any result row and expand it to show multi-line strings. Simply click on the row number in the results table to toggle multi-line on and off.

In order to put multi-line strings into BigQuery, make sure that your line endings are '\r' and not '\n' as those aren't supported by BigQuery.


5. Automatically Convert Timestamps to Human Readable Format

AppEngine and BigQuery store timestamps as epoch time which is great for computers and computation, but not so good for a human to read. The extension automatically finds, parses and replaces epoch timestamps with a human friendly date/time rendering.

6. Insert All Columns into SELECT Statements


Sometimes you want to select every column in your query but typing each of them out manually takes time especially for tables with a large number of columns. In the schema description for a table, you'll see a new yellow field called "Add All Columns" which you can press to insert all of the column names into your query.

其他信息

ID lfmljmpmipdibdhbmmaadmhpaldcihgd 版本 3.6 上次更新日期 2016年8月4日 大小 51.13KiB 语言 支持1 种语言 开发者

support@streak.com

160 Pine St 250 San Francisco, CA 94111 United States

隐私权政策

适用浏览器

谷歌浏览器、其他Chromium内核的浏览器

相关插件

Streak BigQuery Developer Tools Chrome插件下载

为打击盗链困扰,本站已启用人机验证
微信扫码关注左侧公众号,发送“插件”二字获得验证码,验证码5分钟全站有效