The first thing you’ll need to do to get set up with DWH is connect your work email to a google account. If you already use Google you’re good to get going.
When you open BigQuery you will find the DWH by searching for ravelin-client-COMPANYNAME It’s a good idea to make sure you have this project pinned for easy access.
On the left under pinned projects you will see a list of all of the different tables within the DWH. Clicking on them will open them in the blank window.
At the bottom of the screen you will be able to see:
Personal History - This will show you a list of any previous queries you have personally run. Clicking on the query will open it in a pop up window where you will be able to see the SQL used and open the table of results.
Project History - This will show you a list of all queries run and by whom. You will be able to view the SQL written by somebody else but may not have access to the tables they created.
Saved Queries - A list of all queries saved by the team.
Once you click on a table from the pinned list, you will see the following open in the widow on the right. This control bar allows you to perform the following functions:
These two options are useful context to the data described in the table
Schema - provides a list of all of the columns that are contained in that specific table. It’s also useful to check which type of data a column contains, i.e., string, boolean or float.
Details - is useful if you need to check when the table was created or when the last update was.
To run your first query, click the query button. You can run a query in a split tab or new tab. A split tab allows you to refer back to the schema, so it’s ideal when you’re starting out.
At the top right, you will find a way to gauge the cost of a query. The more columns you add the larger the cost.
By clicking on the three dots next to the cost estimate, you will find options to save and schedule your queries. To save the query, just give it an appropriate name and set the permissions to private, project or public.
