Enterprise free trial

Prerequisites

In order to create a virtual connection to :

  • Azure Synapse

  • Denodo

  • PostgreSQL

  • Redshift

  • Snowflake

  • SQL Server

you need to have the following:

  • Display name - This is the name everyone in your organization will see for the connection

  • Host/IP - the url for your database

  • Port (optional) - use if you connect through a special port

  • Database (optional) - You can specify it here or you can choose from a dropdown list when you create a dataset

  • Connection username - Your username for your data source

  • Connection password - Your password for your data source

If you are connecting to a BigQuery database you will need the following information :

  • Display name - This is the name everyone in your organization will see for the connection

  • Project ID - The unique identifier for your BigQuery project

  • Service account username - A Google account that is associated with your Google project, as opposed to a specific user

  • Service account key file - Provides the authentication information used in the connection configuration