Introduction

Do you ever find yourself writing a routine SQL code because you’re that one person who “knows SQL”? Even if all it takes is joining multiple tables, it still takes your time. Did you ever wish the code would write itself?

OWOX BI provides the SQL Copilot for BigQuery (ChatGPT plugin) that automatically enables you to generate SQL queries based on your projects!

Benefits you may find useful

• Direct integration with BigQuery: automatically share your tables' schema with GPT via BigQuery OAuth.
• Custom instructions for BigQuery: we utilize our 10-year expertise with BigQuery to provide GPT with instructions focused on improving the use cases related to BigQuery.
• Validation: The plugin validates the correctness of the SQL code automatically and detects and fixes the errors in SQL with AI.
• Get the working SQL code within a single interface: thanks to the direct integration with BigQuery, you can manage the whole flow with GPT from the start to working SQL code without the need to constantly switch the tabs.
• Context retention within chat conversation: set up once, save time, and conveniently generate the code relevant to the same tables in minutes.
• Secure: OWOX BI is an established company that uses enterprise-grade security measures.

Getting started requirements

• You are using the Google Cloud Platform and have an active project (how to set up GCP).
• The data you will work with is stored in Google BigQuery.
• You have IAM roles such as BigQuery Metadata Viewer or BigQuery Data Viewer (minimum to view table and dataset metadata). If you want to run queries and dry runs, then you need to have BigQuery Job User or BigQuery Admin roles.
• You have a ChatGPT account.

In the next article read how to start chatting with OWOX BI SQL Copilot.