Data Warehouse

15 articles

Google BigQuery V2

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 Daniel Odrinski

Snowflake Schema V3

Load data from Data Platform to Snowflake. From AWS S3 V2 Pre-requisites. Have Dreamdata's data platform AWS S3 destination enabled (go to this blog to enable it if you haven't!). From now on, <S3_BU…

Updated by Daniel Odrinski

AWS S3 V2

Destination AWS S3. Destination AWS S3 is a secure way to get a dump of the data platform sent to an S3 bucket in your own organization that uses a dedicated IAM Role. The Data Platform gives you acc…

Updated by Patrick Madsen

Data Warehouse Schema

This document gives you an overview of the different table schemas used for the various Data Warehouse Solutions. Descriptions and links for Schema v1, Schema v2, and Schema v3 are included below. Sc…

Updated

Connect your Dreamdata data to Snowflake

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

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

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

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

Free Datasets

At Dreamdata, we use many different datasets to build our services. We have decided to make some of those datasets freely available to everyone as they might be helpful for others. Tables. Table Desc…

Updated

Snowflake

Load data from Data Platform to Snowflake. From Destination AWS S3 Pre-requisits. Have Dreamdata's data platform AWS S3 destination enabled (go to this blog to enable it if you haven't!). From now on…

Updated

Google BigQuery Legacy

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

AWS S3 Legacy

Destination AWS S3 Legacy is a secure way to get a dump of the data platform sent to an S3 bucket in your own AWS organization using a dedicated IAM Role. The Data Platform gives you access to a raw…

Updated by Patrick Madsen

Migrating from Google BigQuery Legacy to Google BigQuery V2

How to move from Google BigQuery Legacy to Google BigQuery V2: set up access, rewrite your queries, and check that your numbers match.

Updated by James Dietrich

Microsoft Azure Storage

This feature is available as an add-on for the following plans: Business. Enterprise. Data Warehouse Microsoft Azure Storage is a secure way to get a dump of the data platform sent to an Azure Storag…

Updated by Daniel Odrinski