Databricks Community

Brammer88 · 06-10-2024

Dear community,Im trying to setup a connection to get data from a catalog / underlying tables from that catalog and load it directly into MS Access 365 (latest version). Is it possible to do this? What would be the best practice? Thanks,Bram

Brammer88 · 04-17-2024

Hi there,Im trying to run DE 2.1 - Querying Files Directly on my workspace with a default cluster configuration for found below,but I cannot seem to run this file (or any other labs) as it gives me this error message Resetting the learning environme...

Brammer88 · 09-19-2023

Hi all, Im trying to merge two streaming tables together with a left (outer) join, but it seems to somehow return all values from the left table that have matching values from the right table, instead of also appending the NULL values if there is no ...

Brammer88 · 06-26-2024

Hi @jakubk ,Thanks for your response, I have tried to make a connection via spark simba odbc driver and it works. So that is great, thanks. I also have been able to connect via oauth2.0. The only thing I cannot achieve via access is to change to tabl...

Brammer88 · 06-17-2024

Dear community, I am facing the same issue here.My workaround is to just create an azure databricks activity in my ADF pipeline and use code inside a notebook to copy over data from tables inside unity catalog to ADLS gen2, but this is in my opinion ...

Brammer88 · 06-10-2024

Thanks, yes we are using powerbi too, but we have a specific requirement for which we should be able to connect directly to our legacy MS access databases too.

Brammer88 · 04-30-2024

Hi @Kaniz_Fatma and databricks team,Did you already found some other solution for this? Thanks,Bram

Brammer88 · 04-22-2024

Hi @Kaniz,Sorry, I was too fast with this reply, im not sure why, but it seems like its not working after all and I was cheering to soon.I have added a line spark.jvm.class.allowlist org.apache.spark.sql.internal.CatalogImpl.clearCacheto my cluster i...

Databricks Community

User Stats

User Activity

How do I setup a connection to get data from unity catalog into MS Access?

Trying to run databricks academy labs, but execution fails due to method to clearcache not whilelist

Left join with merging two streaming tables returns inner join instead

Re: How do I setup a connection to get data from unity catalog into MS Access?

Re: In Azure Databricks Delta Lake not able to see unity catalog databases or tables in the drop dow

Re: How do I setup a connection to get data from unity catalog into MS Access?

Re: Trying to run databricks academy labs, but execution fails due to method to clearcache not while

Re: Trying to run databricks academy labs, but execution fails due to method to clearcache not while