Spark connect: Table caching for global use?

2025-02-16 Thread Tim Robertson
Hi folks Is it possible to cache a table for shared use across sessions with spark connect? I'd like to load a read only table once that many sessions will then query to improve performance. This is an example of the kind of thing that I have been trying, but have not succeeded with. SparkSess

Re: Spark connect: Table caching for global use?

2025-02-16 Thread Tim Robertson
occurrence_svampe"); On Sun, Feb 16, 2025 at 10:05 AM Tim Robertson wrote: > Hi folks > > Is it possible to cache a table for shared use across sessions with spark > connect? > I'd like to load a read only table once that many sessions will then > query to improve per

Re: Spark connect: Table caching for global use?

2025-02-16 Thread Tim Robertson
ebzadeh-ph-d-5205b2/> > > > > > > On Sun, 16 Feb 2025 at 09:16, Tim Robertson > wrote: > >> Answering my own question. Global temp views get created in the >> global_temp database, so can be accessed thusly. >> >> Thanks >> >> Da