I’m quite new to dremio, so far I’ve installed it successfully on single node mode on Ubuntu 16.04. I would like to know is there any way by which I can find out all datasets loaded by users, all the columns within each dataset?
Its similar to Oracle/MS SQL Server etc RDBMSs that have system tables which store information about all the tables/columns etc in a table.
Rational is that users want to have some sort of catalogue describing all datasets, columns within each dataset. Right now we’re still evaluating Dremio, there are initial requests, I tried DBeaver, which users find too technical for them.
Hi @Laurent, Is there any to query reflections. I would like to be able to quickly know which tables have reflections, and which columns are included in reflections (both raw and aggregation reflections)
Hi Laurent, Can I understand, Once I update the table/view structure, such as new view created, new column adding, or column data type change, the metadata table INFORMATION_SCHEMA.COLUMNS will get the timely update ASAP? For example, how much time I can see the updated metadata after my structure change of my view? thanks!