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.
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 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.
Note:
For authentication types that provide the option to save credentials, do not uncheck Save user name and password if you will register the connection file with an ArcGIS Server site or ArcGIS Enterprise organization, if you need to use the Catalog pane search to locate data accessed through this connection file, or if you will use the connection file in geoprocessing models or scripts.
ArcGIS Pro caches credentials for the first successful database connection for which you do not save the username and password. If you create a second connection to the same cloud data warehouse instance in the same ArcGIS Pro session and do not save credentials, the cached credentials from the first connection are used even if you provide different credentials in the second connection file. To connect with different credentials without saving the username and password, start a new ArcGIS Pro session.
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: