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