6. View materialized assets in your warehouse

View materialized assets in your warehouse


Y42 simplifies the intricacies of managing targets and materialization logic, allowing you to concentrate on the essentials. This article will guide you through the process of viewing how data is materialized in your warehouse through published views.


Manage your environments

  • Navigate to Space Settings: Begin by accessing the space settings in your Y42 dashboard.
  • Access the General Tab: Once in the space settings, click on the general tab to view more options.

Understanding your warehouse setup

  • Here, you'll observe several options:
    • Redirect to Warehouse, Storage, and Git Repository: Y42 hosts your data in the warehouse that was initially used to establish the space. Additionally, all your code is version-controlled in Gitlab.
    • Access the Data Warehouse: Click on the data warehouse redirect. Note: This action is only functional if you have access rights to the underlying data warehouse.
    • Sign into Your Cloud Data Warehouse: Authenticate yourself to access the data in the respective warehouse.

Explore the Y42 managed dataset

  • Once inside, you'll identify your warehouse and the dataset managed by Y42, labeled as y42_{space_name}_{RANDOM_STRING}.
    • Access the Dataset: Click into this dataset to check out the Y42 managed tables.
    • Observing the Tables: Within, you'll find tables for your source tables and your first model, each having random strings as their names. For regular development tasks, there's no need to interact with these datasets. Y42 fully oversees them and employs its Virtual Data Build technology to intelligently manage your environments.

Discover the published dataset

  • Apart from the aforementioned dataset, there's another one named y42__{space_name}__main.
    • Access the Main Dataset: Click into this dataset to explore tables that can be used downstream.
    • Views and Tables: Here, you'll see various views. These views reference the tables you observed in the prior dataset but bear the names provided in Y42. These tables can be integrated with downstream applications, including BI tools like Tableau, PowerBI, Looker, etc.
    • Materialization in Main: Whenever you opt to materialize a table on main, it will be displayed here.

Up next

With Y42's intuitive interface and robust backend management, viewing and understanding materialized data in your warehouse becomes a seamless experience. By following the steps above, you can efficiently navigate and comprehend the structure and organization of your data.