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 Database Connection dialog box.
Tip:
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 can use either standard authentication or Amazon Web Services (AWS) Identity and Access Management (IAM) credentials when you connect to Amazon Redshift. See the Amazon Redshift ODBC Data Connector Installation and Configuration Guide for information about authentication methods.
When you connect to Snowflake, you can use user authentication, native SSO-Okta authentication, or browser-based SSO authentication. If you will publish web layers using the connection, you must use the user authentication method. You must also specify a role for the user when you create the connection to define the user's privileges to the data to be published.
Server 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).
Additional required and optional settings vary by cloud data warehouse type. For full connection instructions, see the following help pages: