Hi Team,
Is there capability in Dremio to search for a column? When joining 2 tables together with many columns (20+), it can be difficult to find the column needed.
If no search function, how about a ‘list’ view of the columns? Instead of having to scroll right to find what is needed, we can just view a list of column headers.
Thanks!
Mat
Hi @mathew.lee,
If in the query editor, you can bring up a list of datasets, mouse over a particular one, and then click the “i”; this will display a list of columns for the dataset you can drag and drop into your query.
Additionally, if you’re a Dremio admin, you can query the metadata catalog:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'your_table'
This will list the columns for ‘your_table’ and information about them.
Hi,
If you use the Dremio UI you can use our Custom Join feature that shows the column and allows you to filter them:
