Document toolboxDocument toolbox

Working with a BigQuery Warehouse Connection

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)


Kyvos supports both ROLAP and HOLAP on BigQuery connections. You can use this connection for querying data from your BigQuery data warehouse.

Note

  • If you implement a filter on a date column with >= or <= and explicit type cast, you must add the kyvos.rf.sqlparser.enabled property and set its value to true at the Hadoop connection. 

  • You can create multiple BigQuery connections for raw data querying. The connections are available on the Dataset designer page, where you can select the connection to be used for a particular semantic model. 
    See the Working with non-materialized or raw data semantic models section for more details. 

  • All Spark-supported functions must be mapped according to supported BigQuery functions. You must update the SQL and datasets with supported BigQuery functions. Otherwise, the incompatible functions would fail. 

  • You can connect to your BigQuery data warehouse for reading data from both GCP and EMR-based AWS clusters. 

  • You can create multiple read connections using different BigQuery data warehouse accounts from different projects. You can then use datasets from all these BigQuery warehouses in a single relationship and hence a single semantic model. If you intend to create multiple datasets from different warehouses in different projects, ensure all the Materialization Datasets specified when configuring the Connections belong to the same region.

To set up or view a BigQuery warehouse connection, perform the following steps. 

  1. From the Toolbox, click Connections.

  2. From the Actions menu ( ) click Add Connection.

  3. Enter a name or select it from the Connection list.

  4. After you have entered the parameters described in the table below, click the Test button from the top left to validate the connection settings.

  5. If the connection is valid, click the Save button.

  6. To refresh connections, click the Actions menu ( ) at the top of the Connections column and select Refresh.



 

Copyright Kyvos, Inc. All rights reserved.