SPEAKER: In this"BigQuery Spotlight,"we'll be going over allsorts of useful waysto work with data in BigQuery.A great way to learn is bydoing, so in this episode,we'll show you how to getstarted with a BigQuerysandbox.[MUSIC PLAYING]BigQuery sandboxgives you free accessto try out BigQueryand use the UIwithout providing a credit cardor using a billing account.It's a quick way toget started and try outsome of the concepts we'll betalking about in this series.To get started, click on thelink in the description below.If you're a newGoogle Cloud user,you'll need to createan account and a projectby following the prompts.Once a project iscreated, you'llbe redirected to theBigQuery console, whereyou'll see Sandbox inthe top left-hand corner.If you're returningGoogle Cloud user,create a new project byselecting the Project dropdown.Your new project may be createdwith a default billing account.If that's the case, go into theBilling Account Management pageand select Disable Billing byfollowing the instructions alsolinked below.Then use the searchbar within the consoleto head to BigQuery.Make sure your new projectis selected in the Projectdropdown, andthere, you will alsosee Sandbox in thetop left-hand corner.Now that you're inthe BigQuery Sandbox,you're ready to start querying.That's all it takesto get set up.Because you aren't charged forusing the BigQuery Sandbox,there are a few caveats.Mainly, any tables orviews that you createwill expire after 60 days.You're also limited to10 gigabytes of storage,and one terabyte ofdata process each month.Still a lot of roomto play around with.These numbers may change, so besure to check the documentationfor the latest information.Other than that,you can easily startworking with public data sets,loading in your own data,and running some queries.BigQuery provides publiclyavailable data sets for anyoneto analyze covering avariety of data types,from historical weather to taxitrips taken in New York City.To analyze publicdata, just clickon the Add Data buttonon the left-hand sideto see a list of thepublicly available datasets that you alreadyhave available.As a quick example,let's use the projectsunroof public data set, soyou can see how much sunlighthits your roof in a year.In this sample query,we're averagingthe amount ofsunlight per US state,and ordering the top threestates by the highest sunlightpotential.As you can see, thetop three statesare New Mexico,Arizona and Nevada.That's a lot of sunshine.Don't worry if you're notsure how we built this query.In the next episode, we'llexplain this in more detailand break down howto query your data.Look out for the next episodeof "BigQuery Spotlight,"and remember, stay curious.[MUSIC PLAYING]
