Hi everyone,
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.
Awesome, thank you very much Laurent for precise reply. Do you know whether similar information is there on Dremio official site etc, I didn’t manage to find it in documentation.
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!