Overview
Imagine you are a data analyst and have been with Data Beans for a few months. You have worked on a few successful projects with your teammates and have been assigned your first solo project. You are starting to create more complex queries with little help, but you have been asked to write more complex queries to retrieve deeper insights. Everyone on the team is helpful, but you need to start showing that you are more self-sufficient in your work.
You have read that BigQuery SQL code generation, explanation, and transformation may help you to write more complex queries using natural language. And, if you get stuck with writing a new query, you have also learned you could use Gemini to help review and debug your code. It could even help you with suggestions to resolve issues. Using these features will help you to be more independent in your work and, perhaps, even more efficient. However, you are not sure how to get started.
Objectives
In this lab, you learn how to:
- Generate a SQL query using a natural language prompt.
- Use the code explanation feature of BigQuery.
- Modify SQL code with the transform feature of BigQuery.
- Prompt Gemini to review and debug SQL code in BigQuery.
- Ask Gemini for suggestions to fix a SQL code issue.
#gcp #googlecloud #qwiklabs #learntoearn
