Creating a Destination in DataHawk
Once ready, have the DataHawk app open and navigate to the Connections module via the sidebar. Once there, you will find the option to “Setup” Advanced Destinations.
You will be redirected to a destination selection page titled "Add Destination," wherein a list of all available Destinations will be displayed. Simply click on the destination you are interested in. To know more about all available destinations, click here.
For this example, we will step into the shoes of a PowerBI user.
This will bring you back to the Destinations page, with a Microsoft PowerBI connection added showing an “Initializing” status. The connection typically takes less than a few minutes to initialize.
Once the status shows as “Enabled,” click on the connection to access the credentials page. On this page, you will see all the information regarding the newly created database we built, filled with your DataHawk data.
These credentials give you access to your newly created DataHawk database.
This next section will serve as a step-by-step guide on how to access your newly created database from your BI tool.
Accessing Your Database from Your BI Tool such as PowerBI Desktop
ContinuingPower BI user's perspective, to add this data as a source, go to the PowerBI interface and click on “Get data,” and select Snowflake as a source.
Here, you can enter the server and the warehouse name. Once done, click on “OK” and insert your username and password. All of this information is available in your credentials.
You can select everything within the database and “Load” it. Please select “Import” in the “Connections Settings” window (DirectQuery won't work).
Once loaded, you will have access to all your DataHawk data from your PowerBI. Now you can start dashboarding and analyzing!
NB: Unfortunately, PowerBI does not support the schemas/folders we modelized on Snowflake, it shows all the tables as a list of fields. To help PowerBI users and bring clarity to our model, we added the schema name as a prefix to all the table names.
For more information on the content of these fields, read the For BI Users article.
Here are some of the main official documentation to link a Snowflake database to BI tools: