Tutorial: How to create a new query

About this Video

• Video Title: Tutorial: How to create a new query
• Channel: Baselight
• Speakers: Trent T
• Duration: 00:06:11

Introduction

This tutorial demonstrates how to create queries in Baselight, specifically recreating a "Wildfire expenditure over time" query. The video showcases Baselight's analytical capabilities, combining multiple datasets (Wildfire data and inflation data) to create new variables and analyze the impact of inflation on wildfire costs.

Key Takeaways

• Creating a new query in Baselight involves naming the query, providing a description, and optionally setting privacy settings.
• Data can be added to a query through the data catalog by searching for relevant datasets and adding them. Alternatively, the command command K (Mac) or control K (PC) can be used to search and add data.
• Basic queries can be constructed using SQL commands like SELECT * FROM [dataset name], or more complex queries can combine multiple datasets and create new variables.
• The query engine allows users to combine datasets, create new variables (like inflation-adjusted costs), and view results directly within the platform.
• Results can be downloaded as .parquet or .csv files.