Systems | Development | Analytics | API | Testing

Transform messy JSON into a powerful AI recommendation engine, all within BigQuery. This demo showcases a low code workflow, using Data Prep's visual tools to clean raw data, BQML to generate Gemini powered vector embeddings, and a simple SQL query to find similar items. It's a look at how Google Cloud lets data analysts build end-to-end AI pipelines without complex ETL scripts. The entire project is open-source. Build it yourself!

Geospatial data is a powerful tool for gaining insights into everything from customer behavior to environmental patterns. BigQuery allows you to store and analyze this location data using standard SQL, and bringing that data into a Colab notebook gives you the flexibility to combine BigQuery's power with popular Python visualization libraries. This approach is perfect for ad-hoc or iterative analysis. In this video, we'll give you an overview of these capabilities and walk through a demo of how you can analyze and visualize your geospatial data.