added
June 12, 2025: Data mart users can now create tables, views, and schemas in Snowflake reader accounts
13 days ago by Nicolas Luzarraga
For users accessing data marts from a Zus-provided Snowflake reader accounts, customers can now create new tables, views, and schemas directly in their reader account.
This new capability will enable customers to:
- More easily define re-usable analytics concepts
- For example, a data analyst might create a view that lists all patients with a recent HbA1c measure, which they then can refer to in future queries.
- More efficiently migrate data out of Snowflake
- For example, a user might query five Zus data mart tables to create a custom view. The user can then use a data migration tool (e.g. Fivetran, Airbyte) to migrate just the new view, rather than all five source tables.
To create new tables/views/schemas, customers must use the database [CUSTOMER_NAME], which includes the schema SCRATCH. New schemas can be created in the [CUSTOMER_NAME] database and new tables/views can be created in the SCRATCH schema.
To instructions on how create new tables/views/schemas in Snowflake, please refer to the Snowflake documentation here, here, and here.