View SQL for Passthrough Tables

Most databases have one or more passthrough tables - these are tables that are not changed as part of building the database but are instead passed through in their current schema. One of the things we've heard from operators is that you want to be able to view the input SQL for these tables as part of inspecting the database. This is particularly helpful when referencing Customer Domain Tables (CDTs) and Core Tables.

Today we're introducing a new feature that allows you to view the SQL for these tables right in the database. By examining the source tables, you can not only improve data accuracy but also find and fix errors, ensuring consistent data reliability. Additionally, it enables you to make well-informed decisions by helping you choose the right fields for tables, streamlining data management, and optimizing data utilization.

This is part of a series of updates we are making to streamline the experience for creating, managing and updating databases.