Practical lab
In this practical lab, we will explore adding the tool DBT and creating several dashboards.
Loading problem data
We will use the following three datasets for our labs – error_codes.json, factory.json, and factory_errors.json. For this lab, we will use the web GUI to load the data; in a production environment, we would have a pipeline to handle this process:
- First, click Create on the toolbar to load data using the web GUI.
Figure 7.22: Create
- Now, we will click the Create table button, and then we must select the cluster to use; any available cluster is acceptable.
Figure 7.23: Selecting a cluster
- We will use the GUI to load the table and not use a notebook this time. You will be presented with the following menu. Be sure to name your tables consistently, use the default database/schema, and select the JSON file type, Infer schema, and Multi-line.
...
