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...
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...
This is supposed to read in a CSV and then write it to bigquery. When it runs, however, nothing is written, and there are no errors logged. I read that I need to write a csv and then turn it into an Octet Stream. I am not sure whether or not this is...
I am new to BigQuery and need more functions in BiogQuery + Javascript so i can get total execution time and how much GB of data processed by that query.  How can i know total exe time and processed data size in javascript api.  Eg. Query complete (1...
So I have these columns, col1 thru colx are all of type STRING/TEXT:  id   |   col1   |    col2   | col3     | ... -----|----------|-----------|----------|------ 1    |[{"a":1}] | [{"b":2}] | [{"c":3}]| ... -----|----------|--...
I created a Google Cloud Function with a Pub/Sub trigger (Triggered by a Stackdriver sink). Then it change the format of this data and save it to the BigQuery.   const {BigQuery} = require('@google-cloud/bigquery'); const bigquery = new BigQu...
I have some problems with a query that I'm trying to do in BigQuery. The task is the next: I have a set of measurements with its timestamps, and I need to get those measures within a certain temporal window, lets say start_date=2019-01-01 00:00:0...
I have built a nodejs app that enables users to run some CRUD operations on bigquery through rest APIs. This is build on top of bigQuery NodeJs Client  This app fails to connect to bigquery from a centos machine where this is deployed. I have tried s...
exports.date = functions.https.onRequest((req, res) => {  const bigQuery = bigquery({ projectId: 'project' });         var someVar = [];         var someVar1 =[];         bigQuery.query({        query:'Select email from(inner_query)&#...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.