Snowflake is one of the most popular Software-as-a-Service (SaaS) solutions to store and process the data of your whole organization. It’s a pioneer in data management, which is why Snowflake places a high value on security. Imagine  you are pulling data from different databases and sources in your organization, and you are centralizing all this [...]
Security is crucial for data consolidation, especially in data warehouses where reporting tools are connected to show different dashboards. Snowflake provides two main features to help with these requirements: Row Access Policy: Allows a filter to be applied to the result of a query and return only those rows that a role is authorized to [...]

January 12, 2021

|

by: Greg.suk

|

Categories: Code, Coding, dbt

Anyone who has worked with dbt knows that one of the most powerful features is packages. Packages allow you to reuse code across multiple projects in an organization. Packages can be installed from other projects in your organization, or by using the dbt hub you can install packages from the open-source community and Fishtown Analytics. [...]

September 28, 2020

|

by: Renee Miller

|

Categories: AWS, Databases, Redshift, Snowflake, Tips

Are you considering a cloud-native data warehouse? Our experts debate the differences between Snowflake, Redshift, and BigQuery. Prefer to listen? Watch the Stump The Experts webinar on our Youtube channel. We are new to cloud data warehousing. We are considering Snowflake, Redshift, and BigQuery. What are some things to consider? Neal Achord Red Pill Consultant [...]