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

[KristiLogos]

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_redirect_uri "https://login.salesforce.com/services/oauth2/success",

  oauth_scope "cdp_api api cdp_query_api refresh_token offline access",

  is_sandbox "false"

  );

[Alberto_Umana]

Hi @KristiLogos,

Greetings from Databricks! 

Could you please share the error you have received? 

[KristiLogos]

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.

[Alberto_Umana]

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]

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