Creating a Destination in DataHawk
Once ready, open the DataHawk app and navigate to the Connections module via the sidebar. Once there, you will find the option to set up "Other 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 is "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 accessing your newly created database from your BI tool.
Accessing your database from your BI Tool, such as PowerBI desktop
Continuing Power 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 "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. DirectQuery is a great option to keep things automatically refreshed if you're using PowerBI Desktop.
Once loaded, you will have access to all your DataHawk data from your Power BI. Now you can start dashboarding and analyzing!
We provide a library of ready-to-use templates based on best practices from hundreds of top brands and agencies. With these powerful, theme-based dashboards, you can analyze your data in just a few minutes. Know more about them here.
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.
Official documentation
Here are some of the main official documentation to link a Snowflake database to BI tools: