Activities

activities

latest

false

Integration Service activities

Activities included in the Databricks connector.

The following tables list the activities included in this package, grouped by the Databricks area they automate.

Activity	Description
Execute a SQL Query	Run a SQL statement on a Databricks SQL warehouse.
Get SQL Statement Result	Fetch the status and rows of a previously submitted Databricks SQL statement by statement_id.

Activity	Description
Create a Job	Create a persisted Databricks job.
Delete a Job	Permanently delete a Databricks job by job_id.
Cancel a Job Run	Cancel a running Databricks job run by run_id.
Run a Job Now	Trigger an existing Databricks job by job_id and return the new run_id.
Run a Notebook	Submit a one-time Databricks job run that executes a notebook.
Get a Job	Retrieve a single Databricks job definition by job_id, including its tasks and schedule.
List Jobs	List the jobs defined in the Databricks workspace, each with its job_id, name, tasks and schedule.
Get a Job Run	Retrieve the status of a Databricks job run by run_id.
Get a Job Run Output	Fetch the output of a completed Databricks job run: the value passed to dbutils.notebook.exit(), the last 5 MB of driver logs, and any error message.
List Job Runs	List Databricks job runs with their run_id and state.

Activity	Description
Import a Notebook	Import base64-encoded content into the Databricks workspace as a notebook at the given path.
Export a Notebook	Export a Databricks notebook as base64-encoded content in SOURCE, HTML, JUPYTER, DBC or R_MARKDOWN format.
List a Workspace Folder	List the notebooks, folders and files under a Databricks workspace path such as /Users/me or /Shared.
Get Workspace Object Status	Retrieve the type, language and object id of a single Databricks workspace object by path.

Activity	Description
Delete a Catalog	Delete a Unity Catalog catalog by name.
List Catalogs	List the Unity Catalog catalogs in the Databricks workspace, each with its name, comment, owner and storage root.

Activity	Description
Delete a Directory	Delete a Directory from a Databricks Unity Catalog volume.
Delete a File	Delete a single file from a Databricks Unity Catalog volume.
List a Directory	List the files and subdirectories under a Databricks Unity Catalog volume path.
Download a File	Read the contents of a file stored on a Databricks Unity Catalog volume.
Get File Info	Retrieve the metadata of a single file in a Databricks Unity Catalog volume, without downloading its contents.
Create a Directory	Create a Directory on a Databricks Unity Catalog volume.
Upload a File	Write a file to a Databricks Unity Catalog volume.

Activity	Description
Start a Conversation	Ask a natural-language question to open a new Genie conversation.
Execute a Message SQL Query	Run the SQL that Genie generated for a message and return the result set under statement_response.
Create a Conversation Message	Send a follow-up question to an existing Genie conversation.
Get a Conversation Message	Retrieve a Databricks Genie message by space_id, conversation_id and message_id.
Get Genie Query Results	Fetch the result set of a Databricks Genie message's SQL query.
List Genie Spaces	List the Databricks Genie spaces available to the connection, each with its space_id, title and description.
Get a Genie Space	Retrieve one Genie space by space_id, including its title, description and the SQL warehouse it queries.

Activity	Description
Create a Vector Search Index	Create a Vector Search index.
Query a Vector Search Index	Run a similarity search against a Databricks Vector Search index and return the matching rows.
List Vector Search Indexes	List the Vector Search indexes on a Databricks Vector Search endpoint.
Get a Vector Search Index	Retrieve one Vector Search index by its three-level name, including index_type, primary_key and sync status.

Activity	Description
Delete Record	Delete a record in Databricks.
Get Record	Retrieve a specific record from Databricks.
Insert Record	Insert a new record into Databricks.
List Records	Retrieve and list records from Databricks.
Update Record	Update a record in Databricks.

Activity	Description
Databricks HTTP Request	Perform HTTP requests to interact with Databricks using existing connector and connection configuration.

On this page

PREVIOUSProject compatibility

NEXTExecute a SQL Query