Import your data into your Google BigQuery data warehouse
Google BigQuery is a serverless, highly scalable, and cost-effective multi-cloud data warehouse designed to help companies achieve business agility.
With this serverless data warehousing, Google does all the resource provisioning behind the scenes so companies can focus on their data and analysis without worrying about infrastructure. This means companies have their latest business data immediately available for analysis without the cost of upgrading, securing, or managing their infrastructure.
Benefits of Integration
- It allows companies to gain valuable insights into their business and marketing processes with real-time and predictive analytics because they get to see data in real time.
- It allows companies to securely access and share their data and analytical insights quickly by integrating with popular business intelligence tools, or by creating reports and dashboards.
- It keeps companies’ data safe because the platform features robust security, governance, and reliability controls which means data is always safe and available.
How to connect
To work with your GBQ storage imporvado needs only a JSON-file with your GBQ credentials. You can obtain this file by following this instruction on your Google Cloud account. This process is simple and is described well on the GBQ website. Don't forget to set up the jobUser & dataEditor/dataOwner roles given to service account or custom role with needed permissions. Detailed list of needed permissions should look as follows:
Learn more about roles and permissions in GBQ documentation system.
Data formats and breakdowns
Improvado stores data GBQ in "sharding" format, in tables named like "TABLE_NAME_YYYYMMDD".
Typically we break the data down by platform, account, dimension and month, but there are some alternatives. We can implement day-by-day division if you need it.
If you want to have your accounts divided into groups and load those groups into different datasets (and even different GBQ accounts), we can handle this. Don't hesitate to reach our support for additional details.