Data Warehouse

9 articles

BigQuery Export: Table Schema

Table schema. To see details of the tables, column descriptions, and example use cases. Visit here.

Updated by Jing Lin

Google BigQuery

Using BigQuery opens up some additional services in connection with using Dreamdata. We can expose your Dreamdata Data within your BigQuery. We can retrieve your Data from your BigQuery. Dreamdata Bi…

Updated by Mikkel Settnes

Connect to AWS Redshift using AWS Glue

This document describes how to integrate your Dreamdata data with your AWS Redshift cluster. Once connected, you can run your own queries on our data models, as well as copy, manipulate, join and use…

Updated

Connect your Dreamdata data to Snowflake

By default, at Dreamdata we build your database on Google BigQuery. However, through our Google Cloud Storage Integration you can connect the raw dataset of your Dreamdata database and easily connect…

Updated by Steen Voersaa

Connect your Dreamdata data to Amazon Redshift

Migrate your Dreamdata data to Amazon Redshift. By default, at Dreamdata we build your database on Google BigQuery. However, through our Google Cloud Storage Integration you can access the raw data…

Updated by Steen Voersaa

Setting up Data Export to BigQuery of CRM Properties

Dreamdata pulls information from your CRMs to build stage models. These can be custom dates that define your funnel or an amount field that sets up how much value a contact or deal generated. From no…

Updated by Mikkel Settnes

Build your own Revenue Attribution report in BigQuery

By the end of this guide, you will be able to: Build a report that provides a granular view of your revenue attribution by channel, offering insights into the performance of each channel across diffe…

Updated by Vitoria

Streamline Your Revenue Analysis: Visualize all your revenue data in one place by using BigQuery Export

By the end of this guide, you'll be able to: retrieve a table with the number of deals and stage amounts for all stage models. visualize the data in one simple report using Bigquery Data connected to…

Updated by Vitoria

Google Bigquery Export - Why can't I see or query the data?

If you've followed our documentation but are still encountering challenges in utilizing the exported data, the video below will help you. In this video, we delve into: Granting Access to the Data. Lo…

Updated by Vitoria