From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Simple queries

Simple queries

- [Instructor] Let me show you how to use the query editor to create and run queries in BigQuery. To start writing queries go to the Google BigQuery Dashboard. On the left, click on compose query. This will open the new query window. I will write a simple query to select all rules from the normal ranges table. In general, the SQL dialect used conforms to standard legacy SQL syntax, with a few deviations. The query is going to be this: Select star from patient data dot normal ranges. The key element to note is how the table name has been specified. It should always have the data set name in its prefix. The square brackets are optional. Let us now run the query and see the results. Take a look at some of the options available. Save query allows you to save the query with the name so that it can be used again. When you click on query history, it will also give you an option to view saved queries, edit them, and run them. The query can be saved as a database view. Format query formats the…

Contents