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':...
©2020 All rights reserved.