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 [...]
If you’re looking to modernize your data, there’s no avoiding the lake analogies. So we figured we’d jump right into the Data Lake, Data Warehouse, and the brew of both: Data Lakehouse. Join us as we explain what they mean for the uninitiated. What is a data lake? Simplified, it’s the storage where data [...]
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 [...]
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. [...]
If there’s one thing we’re tired of this year, it’s canned marketing campaigns filled with false sentiment. We know what they really mean: “We’re in This Together” Please continue to buy our stuff. "Now, more than ever.. " What we’re selling is still important. And the worst offender: “In these unprecedented times..” I will get [...]
OAC has a nice button for a person to unsubscribe within an Agent itself. But this required a person to navigate to the catalog to find the agent and look inside the details of the agent. Seems like a lot of steps to me. But what if you want to enable this capability for an [...]
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 [...]
Moving your data warehouse from on-prem to the cloud? Our experts discuss data lake and data warehouse building in AWS. Prefer to listen? Watch the Stump The Experts webinar on our Youtube channel. Our data warehouse is on-prem at the moment, but we are starting to evaluate moving it to the cloud. We are already [...]
Yeah. Yep. Big hero moment. (Captain Marvel 59:58) Good news is hard to come by these days, so it's nice when we have something to celebrate. The world, despite the doom, does go on. So when we got the news that Stewart Bryson (CEO of Red Pill Analytics) had been given the title of Data [...]
Here we have created a Dynamic Visualization based on the Dimensional Hierarchies of Country -> State -> City. When Country is selected in the Filter, the Visualization shows the States for the specified Country. When State is selected in the Filter, the Visualization shows the Cities for the specified State. Here is how it works. [...]