The invention relates to the technical field of data processing and analysis. The invention discloses a big data exploration and cognition method, device and equipment and a computer storage medium. Therefore, in the aspects of big data application engineering, ETL development, data processing, cleaning, integration, analysis modeling and the like, and massive data of various different data sources, the total collection information containing each data table and even each field can be explored and obtained, and the total collection information is automatically displayed in a visual view and table, so that a user obtains comprehensive cognition on the data. At present, many data warehouses, ETL, BI, data mining, machine learning and big data analysis projects are often informed of tiger heads and snakes or failures. The important reason is that the data universal set is inadequate in cognition, has deviation or is generally complete at the beginning, so that the user can be better helped and guided to plan and develop the projects in a targeted and symptomatic way, and the projects are prevented from being ended by tiger snakes or failures as much as possible.