Connection type 'SALESFORCE' is not enabled. Please enable the connection to use it.

KristiLogos
Contributor

‎11-07-2024 11:07 AM

I'm trying to connect to Salesforce in databricks, I'm following this:
https://learn.microsoft.com/en-us/azure/databricks/query-federation/salesforce-data-cloud#sql-1

and when I run the "Create Catalog..." I see this error, how would I enable salesforce in Databricks? Also, there is no type salesforce_data_cloud as it shows in the documentation, but SALESFORCE is an option so I'm trying that.


CREATE CONNECTION sf_test TYPE SALESFORCE
OPTIONS (
  client_id 'blahblahblah,
  client_secret 'blahblahblah',
  pkce_verifier 'blahblahblah',
  authorization_code 'blahblahblah',
  oauth_scope "cdp_api api cdp_query_api refresh_token offline access",
  is_sandbox "false"
  );
0 Kudos

Alberto_Umana
Databricks Employee
Databricks Employee

‎11-07-2024 11:48 AM

Hi @KristiLogos,

Greetings from Databricks! 

Could you please share the error you have received? 

0 Kudos

KristiLogos
Contributor
In response to Alberto_Umana

‎11-07-2024 12:53 PM

Apologies! I thought I had that in the original question, please see below:

[RequestId=5eb278b1-681a-4a04-840d-864d3fe9449e ErrorClass=INVALID_PARAMETER_VALUE.CONNECTION_TYPE_NOT_ENABLED] Connection type 'SALESFORCE' is not enabled. Please enable the connection to use it.

0 Kudos

Alberto_Umana
Databricks Employee
Databricks Employee

‎11-07-2024 01:07 PM

The reason they're getting this error is because workspace is not enabled for the LakeFlow Connect preview. 

Could you please file a ticket with us, as we might required additional details.

Please refer to: https://docs.databricks.com/en/resources/support.html

KristiLogos
Contributor
In response to Alberto_Umana

‎11-07-2024 01:39 PM

@Alberto_Umana - we are in WEST US 3 and i'm not sure what lakeflow connect is? But I'll open a ticket

0 Kudos