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

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 "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 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.

Official documentation

Here are some of the main official documentation to link a Snowflake database to BI tools:

Connect to Snowflake with PowerBI

Connect to Snowflake with Tableau

Connect to Snowflake with Sisense

Connect to Snowflake with Qlik

Connect to Snowflake with Metabase

Connect to Snowflake with Domo

Connect to Snowflake with Looker

Connect to Snowflake with Thoughtspot

Connect to Snowflake with Snowflake's Snowsight

Did this answer your question?