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"
);