Ariel Balter

Vercel app JSON query returning empty record.

1

This may not be the correct place to post this. I navigated here: https://thesession.vercel.app/thesession?sql=select+*+from+tunes+where+name+like+%22%25wise+maid%25%22%0D%0A The query in the box shows `select * from tunes where name like "%wise maid%"` and...

How to get the actual records after search?

1

Here is some code I'm trying out: ``` var data = [ {"id":1, "color":"green", "size": 23}, {"id":2, "color":"blue", "size": 345}, {"id":3, "color":"blue", "size": 7} ]; console.log(data); var idx = lunr(function...

How to replace chord names with custom symbols?

2

I would like to be able to use small chord charts instead of names (e.g. "Em"). There are some javascript packages for generating them. Where would be the hook in...

Is there a way to save snapshots?

Can't build new SQL string without dataset in connection

5

I want to write custom functions to generate queries. In general usage, I have had no problems setting up connections with only the project and then accessing a table with...

I can no longer get `bigrquery` to authenticate me. I have limited options through my organization. For instance, I cannot create a service account token. In the past, I have...

JSON error with valid JSON in REPEATED variable.

1

REPREX is pretty self-explanatory. Create a tibble with an array column. Change the values to JSON using `jsonlite::toJSON`, validate the JSON using `jsonlite::validate`, make list of `bq_field` objects, upload. >>Error:...

I'm not including a reprex because this may be specific to my data and I need help debugging. **EDIT:** I did create a reprex (below), and it "works." So I...

I was able to create my own `unnest` function, but now I need something the equivalent of `dplyr::nest` or `array_agg` in bigquery. The the reprex below, I show what I...

Is there a way to provide the Details > Description when uploading a table?