If you're using Unity Catalog, you can now query columns easily with:

SELECT table_schema, table_name, ordinal_position, column_name, data_type, full_data_type
FROM main.information_schema.columns
ORDER BY 1,2,3;

Where main is the name of your catalog. You can read more about it here.