What is a BigQuery table and how does it work? In this episode of BigQuery Spotlight, we’ll review the different types of tables in BigQuery, including managed tables, external tables, and virtual tables with logical and materialized views. We’ll also walk you through the use of views, which are virtual tables defined by a SQL query.

The ETL process involves moving data from a source, transforming the data in some way, and loading the information to the same or a different source. You may feel a little confused the first time you encounter an ETL process. With the right platform, though, you can adjust quickly and learn how to manipulate data to make it more valuable.

What are folders, projects, and datasets and how do they come together to support warehousing fundamentals like security and cost management? In this episode of BigQuery Spotlight, we’ll review the BigQuery resource model and how this resource hierarchy is reflected in the Cloud Console, where you’ll interact with and analyze your BigQuery data. Moreover, we’ll give you some helpful tips when it comes to structuring your own BigQuery resources. Watch to learn the best way to structure your BigQuery deployments!

Calculating the return on your marketing investment can be challenging and time-consuming. As there are various marketing sources and channels that create new sales opportunities, it’s important to know which ones are working best to help you meet your business goals.

Learn how to write a simple sign-up test using Rainforest's no-code Visual Test Editor. With no code required and nothing to install, anyone can write a test.