so quick recap on GCP Vertex AI:
- gemini 1.0 is horse shit
- gemini 1.5 is expensive af for mid quality
- they refuse to let you do more than 60RPM with claude haiku

what in the ever living fuck am i meant to spend 100k in credits on? DO NOT say bigquery

SQL書く時にこうゆうクエリ集があるのはかなり助かる。プラットフォームごとに微妙に書き方違ったりもするし、よく使うクエリがすぐ探せる状況にあるのはSQL書く上でもとても大切。

・BigQuery クエリ
scrapbox.io/pokutuna/BigQu…

Here is how you can format dates in #GA4 BigQuery export tables so that they finally make sense.

Let us suppose you want to query the data which meets the following requirements:

1) You want to query data from a particular date, say Jan 15, 2023.

2) You want to retrieve the

I'm debuting a very rare first talk. Come learn how to integrate Google BigQuery and Snowflake with Salesforce Data Cloud.

📊 #GoogleCloudNext では、AI を生かしてデータをフル活用できる #BigQuery と #Looker の新しいイノベーションが発表されました。 #Gemini モデルとのインテグレーションで、マルチモーダル分析やベクトル エンベディングを BigQuery 内から企業データに実施できます。goo.gle/3Jz4hGW #gcpja

In 2024, my favorite technologies to learn are:

- NextJS
- Apache Spark
- Snowflake
- BigQuery
- Apache Iceberg
- Apache Airflow
- Spring Boot

Any that I’m missing?
#softwareengineering
#dataengineering

Gemini in BigQuery enables greater productivity, improves query performance, and optimizes costs throughout the analytics lifecycle.

And now it has even more #AI -powered assistive and collaboration features! Take a look → goo.gle/3JyI5Ng

Here's my submission for this week's The Data Initiative SQL assignment.
Tried working with BigQuery

Your feedback is welcomed.
1. Annie🦋
2.Jonathan Chris
#TDI

Cronos historical data are permanently stored on Arweave Ecosystem accessible for everyone and for free!

To access the data you can use our ELT Pipeline that supports more than 60 destinations including #BigQuery or Snowflake, PostgreSQL, MongoDB, and many others.

Do you know what’s hiding in your business’ data?

Companies of all sizes use BigQuery.

😂

Here is how you can calculate new and returning users in #GA4 BigQuery...

Understand that ‘user type’ (new user or returning user) is not a default dimension in GA4 BigQuery Export data. So, you will have to calculate it manually.

Before you can write a text prompt, you need to

#bq_sushi やり〼！本当に久しぶりでごめんなさい。
#BigQuery とは？からやりますので、今から触ろうとしている人も、ゴリゴリな達人もお待ちしております。
bq-sushi.connpass.com/event/317348/

Starting now, core chain data from the Injective 🥷 network will be accessible in BigQuery through the Analytics Hub, Google Cloud's exclusive data sharing platform.

$INJ #Injective

需要あるか知らんけど、JSONLファイルからBigQueryのスキーマをシュッと推定できるCLIを作ってみた

github.com/m-mizutani/bqs

🆕 Introducing BigQuery as a data source!

BigQuery is a data warehouse that centralizes customer behavior, marketing metrics, payment data, and more. But accessing it can be challenging without tech skills.

🔌 Enter Softr! We connect directly to BigQuery, allowing your team to

4. Data is stored in BigQuery tables. However, there's no mention of whether the tables are optimized (partitioned, clustered, etc.). This is another area that could be clarified for a complete understanding of the project. #BigQuery #DataWarehouse

Updates from Google Cloud's #cloudcomputing division 🚀 BigQuery and AlloyDB are blurring the lines between data and #AI . Explore the possibilities and maximise these advancements with Lumify Work: ow.ly/ROov50QQVtG From @SiliconAngle: ow.ly/VoWJ50QQVtu

Updates from Google Cloud's #cloudcomputing division 🚀 BigQuery and AlloyDB are blurring the lines between data and #AI . Explore the possibilities and maximise these advancements with Lumify Work: ow.ly/awvQ50QQVAg From @SiliconAngle: ow.ly/jYl650QQVAa

4. In the data warehouse, data is streamed to BigQuery tables, where it is partitioned and clustered to optimize upstream queries. This design enhances the performance of time-based queries and aligns well with GROUP BY clauses. #BigQuery #DataWarehouse