Skip to main content
Last updated on

Create a Google Analytics Raw Data connection

Create a Google Analytics Raw Data connection in Catalog Explorer to store authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create Google Analytics ingestion pipelines without needing direct access to the credentials.

Alternatively, admin users can create a connection and a pipeline at the same time in the data ingestion UI. See Create an ingestion pipeline.

For privilege requirements, see Connect to managed ingestion sources.

The following authentication methods are supported:

  • U2M OAuth (recommended)
  • Service account authentication using a JSON key (in the UI, this is called Username and password)

Prerequisites​

For service account authentication, complete the source setup. Use the authentication details you obtain to create the connection.

Create a connection​

  1. In the Databricks workspace, click Catalog > External locations > Connections > Create connection.
  2. On the Connection basics page of the Set up connection wizard, specify a unique Connection name.
  3. In the Connection type drop-down menu, select Google Analytics Raw Data.
  4. In the Auth type drop-down menu, select OAuth.
  5. (Optional) Add a comment.
  6. Click Next.
  7. On the Authentication page, click Sign in to Google and sign in with your Google account credentials.
  8. At the prompt to allow Lakeflow Connect to access your Google account, click Allow.
  9. After you're redirected back to the Databricks workspace, click Create connection.

Next steps​

Create an ingestion pipeline.

On this page