Currently the main benefit of BigLake over the current external tables is governance: you get row and column level security over cloud storage data. The governance is uniformly enforced across BigQuery and also the BigQuery storage API. The storage API can be used by any engine and we have pre-built open source connectors available for Spark, Presto/Trino, Dataflow and Tensorflow.
We're constantly working on improving BigQuery performance over open file formats on cloud storage. Some of these features will be specific to BigLake. Please stay tuned.
I work on BigQuery. All of these are great points: just wanted to point out that BigQuery can federate into external data sources as well: e.g. files on cloud storage and BigTable. Relevant feature is BigLake: https://cloud.google.com/bigquery/docs/biglake-intro
Former A9 employee here. A9 was not an acquisition - it was bootstrapped as a Bay Area subsidiary. Initially A9 focused on web search, then pivoted to doing product search for Amazon retail.
They should really dispatched to fix the Google Drive Client program for Mac. It consistently maxes out a CPU even when there is no sync going on. I can consistently reproduce this issue on all Macs I own.
Franco has been described as having "an unusually high metabolism for productivity...a superhuman ability to focus". Dissatisfied with his career's direction, Franco reenrolled at UCLA in the fall of 2006 as an English major with a creative writing concentration. Having received permission to take as many as 62 course credits per quarter compared to the normal limit of 19 while continuing to act, he received his undergraduate degree in June 2008 with a GPA over 3.5.
He moved to New York to simultaneously attend graduate school at Columbia University's MFA writing program, New York University's Tisch School of the Arts for filmmaking,and Brooklyn College for fiction writing, while occasionally commuting to North Carolina's Warren Wilson College for poetry.[1] He received his MFA from Columbia in 2010. Franco is a Ph.D. student in English at Yale University and will also attend the Rhode Island School of Design.
I found Concrete Mathematics to be a bit dense and not very suited for self learners like me. Also it does not cover the basics like proofs, counting etc.
I can relate to this - even though I probably got more rejections than offers from job interviews, I learned a lot from them. However, I wish companies would give some interview feedback to candidates they rejected. Companies don't do this for the fear of getting sued.
BigQuery also supports in-place querying of datasets on GCS (or S3/Azure using Omni) via external/BigLake tables. https://cloud.google.com/bigquery/docs/query-cloud-storage-u...