Chrome V8 - the JavaScript engine - recently added support for BigInt - arbitrary precision large integers:   https://developers.google.com/web/updates/2018/05/bigint   Can I use these BigInt in BigQuery?...

Now that BigQuery supports async on #standardSQL, how can I convert this #legacySQL function to run on #standardSQL?  #legacySQL SELECT SUM(s) FROM js((   SELECT FLOOR(RAND()*100000) group, NEST(requests) as x   FROM (     SELECT requests, content_si...

Currently looking for an easy way to convert 99999.99 to 9.999,99 format:  This is what I have currently:  CREATE TEMP FUNCTION FORMAT_DE_VALUE(number FLOAT64) RETURNS STRING LANGUAGE js  AS """ return number.toFixed(2) + ' €';...

I having an script in googles app maker:      function runQuery() {   var projectId = 'blalab155512';   var request = {     query: 'SELECT title FROM [bigquery-public-data:samples.wikipedia]  where title contains "olimpic" LIMIT 1...

I have bigquery 'SELECT visitorId , totals.visits FROM [12123333.ga_sessions_20160602]' which return 500k rows in one request.  But I want to fragment data from 1 to 10,000 row in one request and in next request, the next 10,001 to 20,000 wil...

New updates at the end.  We are creating a BigQuery Storage library in JavaScript for browsers.  The problem we are facing is that we obtain a 404 error from https://bigquerystorage.googleapis.com/:    It looks like a CORS problem, but it really is a...

I followed the Node.js example provided on the loading data post request page (near the bottom here: https://cloud.google.com/bigquery/loading-data-post-request), but I’m running into a problem with larger files. The example code works for a .csv o...

I tried sample javascript code to call Google bigQuery API ( https://developers.google.com/bigquery/docs/authorization#client-side-javascript )  Js:  function runQuery() {    var request = gapi.client.bigquery.jobs.query({       'projectId':...

I am attempting to run a paired t-test in bigquery using the JavaScript statistical.js library and I am getting inconsistent numbers.   My code is as follows;   CREATE TEMPORARY FUNCTION ttest(a ARRAY<FLOAT64>, b ARRAY<FLOAT64>)  RETURNS...

I have both sql and udf functions that work fine together.  I want to compare record's date which is an integer and has yyyymmdd format and today's date in my determineText() function.   Is there a method like console.log() or document.write(...