I understand dremio reflections are similar to materialised views. In hdfs they are stored in parquet files. Can this be queried using spark sql?
I you want Dremio results to be consumed as Parquet files, use the CTAS feature (needs to be enabled in the HDFS source) but you can CTAS any source to PARQUET on HDFS and then Spark can consume