Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for SurveyMonkey from the Previews page. See Manage Azure Databricks previews.
The managed SurveyMonkey connector in Lakeflow Connect ingests surveys, survey structure, collectors, survey responses, and contacts from SurveyMonkey into Azure Databricks.
Feature availability
| Feature | Availability |
|---|---|
| UI-based pipeline authoring |  Supported |
| API-based pipeline authoring | Supported |
| Declarative Automation Bundles | Supported |
| Incremental ingestion | Supported |
| Unity Catalog governance | Supported |
| Orchestration using Lakeflow Jobs | Supported |
| API-based column selection and deselection | Supported |
| API-based row filtering |  Not supported |
| Slowly changing dimension (SCD) type 2 | Supported Tables with VARIANT columns ( surveys, collectors, survey_responses, contact_list_contacts, collector_recipients) do not support SCD type 2. |
| Automated schema evolution: New and deleted columns | Supported |
| Automated schema evolution: Data type changes | Not supported |
| Automated schema evolution: Column renames | Not supported Requires a full refresh. |
Authentication methods
| Authentication method | Availability |
|---|---|
| OAuth user-to-machine (U2M) | Supported |
| OAuth machine-to-machine (M2M) | Not supported |
| Basic authentication (username/password) | Not supported |
| Basic authentication (API key) | Not supported |
Ingest from SurveyMonkey in 3 steps
Note
Before starting, review the Azure Databricks user persona, supported interfaces, ingestion frequency, and common patterns.
- Configure SurveyMonkey for ingestion (Admins): Set up SurveyMonkey to authenticate with Azure Databricks.
- Create a Unity Catalog connection (Admins): Create a connection in Catalog Explorer to store credentials for Azure Databricks to authenticate with SurveyMonkey.
- Create an ingestion pipeline (Admins or non-admins): Select any supported interface and create a pipeline from an existing connection.