SQL Lab is a powerful SQL IDE inside Superset. It works with any database that has a SQLAlchemy Python connector. It is great for data exploration. It can query any data sources in the Superset, including the metadata database.
It is a solid playground from which we can slice and dice the dataset in many ways to arrive at a form that needs to be visualized to solve the analytical question that the chart was created to answer.
First, we need to enable SQL Lab use on the superset-bigquery data source. We will explore and visualize the data in the table using SQL queries.
After clicking on the Sources | Databases option on the navigation bar, select the Edit record option for the superset-bigquery data source:
Then, make sure the following three options are enabled. Allow Run Sync should be enabled by default. We are doing this...