Connections to cloud data warehouses in ArcGIS Pro

Create a database connection in the Catalog pane in ArcGIS Pro to authenticate access to a cloud data warehouse. To use data in a cloud data warehouse, create a query layer in a map and, optionally, publish a web layer that you can share in your ArcGIS Enterprise organization.

Before you can create a connection, you must have a data warehouse client installed and configured on the ArcGIS Pro machine.

Right-click Databases in the Catalog pane and click New Database Connection to create a connection to a cloud data warehouse using the New Database Connection dialog box. You cannot use the Create Database Connection geoprocessing tool or CreateDatabaseConnection ArcPy function to create a connection file that accesses a cloud data warehouse.

Database platform

When you create a database connection file in ArcGIS Pro, choose the name of the supported cloud data warehouse from the Database Platform drop-down list. The option you choose affects all subsequent properties you must provide to create a connection.

Authentication

When you connect to Google BigQuery, you have two authentication options: user and service. See Google BigQuery documentation about authentication for information on each type.

You must use standard authentication when you connect to Amazon Redshift. See the Amazon Redshift ODBC Data Connector Installation and Configuration Guide for information about standard authentication.

When connecting to Snowflake, use an authentication method that requires a user name and password. You must specify a role for the user when you create the connection to define the user's privileges.

Instance and data

Each platform requires different information to identify the data warehouse instance and set of data to which you will connect.

  • BigQuery—You must provide a project ID and default dataset.
  • Redshift—Provide the name of the Redshift cluster and the database.
  • Snowflake—Provide the name of the Snowflake account, database, and compute resources (warehouse).

For full connection instructions, see the following help pages: