I have some encrypted columns in BigQuery that I want to decrypt using BigQuery functions.  The mechanic used in encrypting them is AES 256. The vector used is encoded in UTF8. The resulting data is encrypted in Base64.  What I want to do is decrypt...

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'm wondering if it would be possible to make a api call to the google maps geocoding api within a UDF in BigQuery?  I have Google analytics geo fields such as   { "geoNetwork_continent": "Europe", "geoNetwork_subContinent"...

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':...