Reflection error

1

HI im new to Dremio and wanted to test reflections.
I do always get the error massage “Reflection cannot accelerate. refresh job attempts failed […]”

I am using dremio community version with Docker

is there something i am missing or doing wrong?

  • I’ve tried reflections on the Dremio sample Data and on Data from MS SQL Server, but with noch success

image
image2488×636 51.2 KB

2

You can click on the history link and find the REFRESH REFLECTION job. This is the job that creates the materialization. If you are using CE Docker, then most likely you haven’t setup a distributed filesystem to store the actual Parquet files and Iceberg metadata.

See Configuring Distributed Storage | Dremio Documentation

If you are just playing around with Dremio, setting up NAS storage is a good way to start.

3

HI, thanks for the quick response.
Is there any other option? Maybe store the data locally on my pc?
I dont really have the setup for NAS storage.
The sample Database i work with is relative small in size (around 200k data entries)

4

The filesystem on your local PC can be the NAS storage. There’s no setup involved.

In dremio.conf, do something like this:

paths: {
  # the local path for dremio to store data.
  local: "/Users/bennychow/dev/dremioData/data"

  # the distributed path Dremio data including job results, downloads, uploads, etc
  dist: "file:///Users/bennychow/dev/dremioData/pdfs"}
5

Thanks Benny, it works perfectly!