Is there a way to reuse a materialized reflection

1

Hi,

my raw reflection has expired as the data source was not set to “Never expire”.

In my shared storage on S3, the materialisation still exists.
Is there any way to force using it back.
I’ve tried the command that we see in the Jobs executed by $dremio$
LOAD MATERIALIZATION METADATA

However I got

$LOAD MATERIALIZATION not supported.
as error message.

Would there be a way to use that materialization ?

Thanks

2

@dfleckinger You can see if your materialization still mapped inside dremio’s internals. Try run and see if its id still there:

SELECT * FROM sys.materializations

1 Like
3

@allan.sene thanks.

no it was no more in sys.materializations.

My question was to know if I could put back a materialization that exists in the disk but is no more in Dremio metadata, into this metadata again.