topic Re: Connection type 'SALESFORCE' is not enabled. Please enable the connection to use it. in Get Started Discussions

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

KristiLogos — Thu, 07 Nov 2024 19:07:07 GMT

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"

);

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

Alberto_Umana — Thu, 07 Nov 2024 19:48:34 GMT

Hi @KristiLogos,

Greetings from Databricks!

Could you please share the error you have received?

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

KristiLogos — Thu, 07 Nov 2024 20:53:33 GMT

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.

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

Alberto_Umana — Thu, 07 Nov 2024 21:07:10 GMT

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

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

KristiLogos — Thu, 07 Nov 2024 21:39:50 GMT

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