Create a Smartsheet connection
Create a Smartsheet 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 Smartsheet 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.
Prerequisites
Complete the source setup. Use the authentication details you obtain to create the connection.
Create a connection
-
In the Databricks workspace, click
Catalog > Create > Create a connection.
-
On the Connection basics page of the Set up connection wizard, specify a Connection name.
-
In the Connection type drop-down menu, select Smartsheet.
-
(Optional) Add a comment.
-
Click Next.
-
On the Authentication page, enter the Client ID, Client Secret, and Region from the source setup.
-
Click Sign in with Smartsheet.
A new window opens. Review the permissions and click Allow to authorize Databricks.
-
Click Create connection.