Databricks Community

KristiLogos

Hello, I have a federated connection to BigQuery that has GA events tables for each of our projects. I'm trying to query each daily table which contains about 400,000 each day, and load into another table, but I keep seeig this Simba JDBC exception. ...

KristiLogos · 01-06-2025

I was able to connect our Bigquery account to our Databricks catalog. However, all the keys in the nested dictionary columsn populate as 'v'. For example:{"v":[{"v":{"f":[{"v":"engagement_time_msec"},{"v":{"f":[{"v":null},{"v":"2"},{"v":null},{"v":nu...

KristiLogos · 11-07-2024

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-1and when I run the "Create Catalog..." I see this error, how would I enable salesforc...

KristiLogos · 11-07-2024

I've been followig this documentation to get Salesforce Data Cloud connection setup into Databrickshttps://learn.microsoft.com/en-us/azure/databricks/query-federation/salesforce-data-cloudI've added the client id and secret id and the scope, and it s...

KristiLogos · 09-25-2024

I have done the following, ie. crate a Delta Table where I plan to load the Azure Blob Container files that are .json.gz files: df = spark.read.option("multiline", "true").json(f"{container_location}/*.json.gz") DeltaTable.create(spark) \ .addCol...

KristiLogos · 01-07-2025

@szymon_dybczak No worries, and thanks I'll try that out. Also, was there a reason in particular you went with ADF and not federated connection to BQ? Just curious

KristiLogos · 01-06-2025

@szymon_dybczak I couldn't run select TO_JSON_STRING(event_params) as event_params FROM ...I don't think thats a built-in Databricks. Is there another way you've had success?error:[UNRESOLVED_ROUTINE] Cannot resolve routine `TO_JSON_STRING` on search...

KristiLogos · 01-06-2025

@Walter_C - I've pretty much connected via unity catalog by adding BigQuery as a new connection. I was asked and added my json key from Google Console for the specific BigQuery project when creating the connection:https://docs.databricks.com/en/quer...

KristiLogos · 11-07-2024

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

KristiLogos · 11-07-2024

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 ...

Databricks Community

User Stats

User Activity

Simba JDBC Exception When Querying Tables via BigQuery Databricks Connection

Connection from BigQuery to Databricks populating dictionary keys as "v"

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

Salesforce to Databricks connection

Autoloader not ingesting all file data into Delta Table from Azure Blob Container

Re: Connection from BigQuery to Databricks populating dictionary keys as "v"

Re: Connection from BigQuery to Databricks populating dictionary keys as "v"

Re: Connection from BigQuery to Databricks populating dictionary keys as "v"

Re: 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.