From your warehouse
Last updated
Last updated
Importing existing tables and views that are already present in your Data Warehouse gives you a great freedom.
It's a great way to:
Expose models created with dbt
Expose your ML/AI datasets (scoring, use of ML capabilities of your Warehouse, etc.)
In some case you already have created some tables in your data warehouse that you would like to use in Whaly to create exploration on top of it. To do so you can import raw tables directly into Whaly. Click on the + button next to Source in the Data Selector and select from warehouse. You'll be prompted to select a name and an icon for your Source. A best practice, is to name your source with the name of the schema that you are importing so your users to feel lost.
When your source is created you have the capability to import raw table. To do so click on your newly created source and then on + import dataset. Your are now prompted with a wizard that will help you select:
The database from which you want to import (in BigQuery it is always set as default as BigQuery doesn't have databases)
The schema from which you want to import the tables
A list of tables available in this schema
You can select as much tables as you want and click on next.
On the next screen you are prompted with a form that ask you to fill the dataset name as well as the primary keys so that the import might be finalized. you can click on save and voilà you have imported data from your own warehouse.
