3 of 11Image
BigQuery data is stored in tables, much as in a relational database. Tables, in turn, are stored within datasets. Datasets serve as a unit of security, allowing for sharing with specific users or the overall public. Google supplies the publicdata:samples dataset which is added to every BigQuery project. This allows you to examine and query tables right away.
At the left side of the screen, you can drill down on a dataset to see the tables it contains. Select one of those tables and its schema will appear on the right-hand side of the console. The github_timeline table’s schema is displayed in this figure. Notice that its label on the left side of the screen appears in bold text with a red bar beside it. The “Click to preview table data” link does what it says, but you can also write your own SQL queries.