Creating an Amazon QuickSight data source connection to Snowflake with login credentials
Use this section to learn how to create a connection between Amazon QuickSight and Snowflake with your Snowflake login credentials. All traffic between QuickSight and Snowflake is enabled by SSL.
To create a connection between Amazon QuickSight and Snowflake
-
Open the QuickSight console
. -
From the left navigation pane, choose Datasets, then choose New Dataset.
-
Choose the Snowflake data source card.
-
In the pop up that appears, enter the following information:
-
For Data source name, enter a descriptive name for your Snowflake data source connection. Because you can create many datasets from a connection to Snowflake, it's bets to keep the name simple.
-
For Connection type, choose the type of network that you're using. Choose Public network if your data is shared publicly. Choose VPC if your data is located inside a VPC. To configure a VPC connection in Amazon QuickSight, see Configuring the VPC connection in Amazon QuickSight.
-
For Database server enter the hostname specified in your Snowflake connection details.
-
-
For Database name and Warehouse, enter the respective Snowflake database and wearehouse that you want to connect.
-
For Username and Password, enter your Snowflake credentials.
After you have successfully created a data source connection between your QuickSight and Snowflake accounts, you can begin creating QuickSight datasets that contain Snowflake data.