5 Replies Latest reply on Jun 27, 2019 9:10 AM by Ramesh Reddy

    Bigquery connection taking too much time while deploying vdb

    Pranita Gurav Newbie

      Bigquery connection taking too much time while deploying vdb:

       

      We are using 10.2.1 version of teiid and to connect to Big Query we are using Simba driver and successfully able to connect to Bigquery:

      Using jdbc-ansi translator.

      We are using org.teiid.adminapi.jboss.AdminFactory.AdminImpl to deploy VDB.

       

      Datasource details:

        <datasource jndi-name="java:/DSBIGQUERY20190510143305716" pool-name="DSBIGQUERY20190510143305716">

                          <connection-url>jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=abc;OAuthType=0;OAuthServiceAcctEmail=abc@project.iam.gserviceaccount.com;;OAuthPvtKeyPath=C:\Softwares\BigQueryChangesTeiid\teiid-10.2.1\standalone\abc.json;datasetId=abc_dataset;OAuthServiceAcctEmail=abc@project.iam.gserviceaccount.com;;OAuthPvtKeyPath=C:\Softwares\BigQueryChangesTeiid\teiid-10.2.1\standalone\abc.json;datasetId=abc_dataset;</connection-url>

                          <driver>simba</driver>

                          <pool>

                              <max-pool-size>20</max-pool-size>

                          </pool>

                      </datasource>

       

      If there is large amount of data present on bigquery it is taking more than 10 minutes to deploy the VDB.

       

      And even if we are providing 'datasetId' in connection url it is fetching metadata of all datasets present under given projectID and service account email.I think which might causing delay while deploying VDB

       

      Could you please help me with this. As it is taking too much time and very annoying every time.