how do I get big query to be a valid data source?

Hi Steve,

Thanks for reaching out to Yellowfin support.

I would like to recommend follow the below link, it contains all the information related to big query.

https://wiki.yellowfinbi.com/display/yfcurrent/Google+BigQuery

Please let me know how it goes.

Regards,

Sri Vamsi

What version of YF do I need to enable the "Big Query" option?  If you look at the picture I included, my option is greyed out.

After installing the jdbc driver jar I found I needed to install each one of the lib jars as well - one by one.  What a pain!

Now I am adding the data source and am getting an error.

    io.grpc.ManagedChannelProvider$ProviderNotFoundException: No functional channel service provider found. Try adding a dependency on the grpc-okhttp, grpc-netty, or grpc-netty-shaded artifact

what do I need to do?

thanks,

Steve

Hi Steve,

Could you please let me know the version you are using currently and please provide info.jsp file as well.

Regards,

Sri Vamsi

Hi Sri,

We are on 9.7.2.  I am not sure how to get the info.jsp file.  Is the sysinfo.xml file ok?

I had a similar issue in the past.

It's related to the version of the bigquery driver you are using. Perhaps something to do with the size of the file

This version uploaded fine for me: https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.1.1001.zip

Thanks

Dean

Hi Steve,

This can be accessed by entering the following address:

http://:/info.jsp.
e.g. http://localhost:8080/info.jsp)

Regards,

Sri Vamsi

Operating Environment

System Properties

Application Version:    9.7.2

java.version:    1.8.0_345

os.name:    Linux

os.arch:    amd64

os.version:    4.18.0-348.el8.0.2.x86_64

[Show All]

Available Processors:    4

Memory in Use:    1.3 GB

JVM current total memory:    2.1 GB

Free memory:    755.7 MB

JVM max memory:    5.3 GB

System memory:    7.6 GB

Application Server:    Apache Tomcat/9.0.62

Servlet API Version:    4.0

JSP API Version:    2.3

Application Details

Current Schema Version:    20220602

Original Code Version:    20150624

Current Code Version:    20220602

Import Version:    4.53

Build Type:    FULLVERSION

Current Session Count:    1

Current Session Timeout:    1800 seconds

Application Server Boot Time:    January 30, 2023 8:19:41 PM UTC

Current Server Time:    February 3, 2023 11:06:48 PM UTC (UTC +0000)

Request Listener:    Initialised

Request Count:    3

Configuration Database:    MySQL 5.5.5-10.3.32-MariaDB

Encryption Functions:    Ok

BIRT Report Engine:    Not available

Task Schedule Enabled:    true

System Task Manager Enabled:    true

Webservices Enabled:    false

Hardware Hash:    AFBWgpnE

Locale Information

JVM Locale:    en_US (en)

Request Locale:    en_US (en)

RefCode languages:    EN_US, EN

Browser interface language:    en-US

[Show all locales]

Licence

Licence Valid:    Yes

Products:    N/A

Feature    Licence    Current

localhost

Licenced Type:    FULLVERSION    FULLVERSION (or DEVELOPMENT)

Licence Issue Date:    2022-06-01    2023-02-03

Expiration Date:    2023-05-30    116 Days Left

Data Sources:    9999    5

Client Data Sources:    9999    0

Consumers:    0 (4)    4

Writers:    10    6

Dashboard:    10    6

Server Cores:    0    4

Multicast:    0    4 (Disabled)

Clients:    0    0

Concurrent Users:    0    1

Concurrent Named Users:    0    -

Concurrent User Mode:    DISABLED

Signals Consumers:    0    0

REST Access for User Licence:    -    -

NLQ Access for Licence:    -    -

Restricted Functions:      MULTICAST

SIGNALSCONSUMER

JDBC Drivers:

[Show Drivers]

com.microsoft.sqlserver.jdbc.SQLServerDriver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/mssql-jdbc-7.2.1.jre8.jar

org.postgresql.Driver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/postgresql-42.3.3.jar

com.simba.googlebigquery.jdbc41.Driver    Plugin: BQ ( c542a0cf-b8e7-4836-97f4-de924332d5ac )

com.hof.mi.database.jdbc.ColumnarDriver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/columnar.jar

com.simba.googlebigquery.jdbc.Driver    Plugin: Google 4.2 ( c24116a5-a5ed-4fa5-b0bf-aaf7bc5f04c8 )

com.simba.googlebigquery.jdbc42.Driver    Plugin: Google 4.2 ( c24116a5-a5ed-4fa5-b0bf-aaf7bc5f04c8 )

org.hsqldb.jdbc.JDBCDriver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/hsqldb.jar

org.apache.derby.jdbc.EmbeddedDriver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/derby.jar

com.mysql.jdbc.Driver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/mysql-connector-java.jar

com.mysql.cj.jdbc.Driver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/mysql-connector-java.jar

net.sourceforge.jtds.jdbc.Driver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jtds-1.2.8_svn.jar

org.hsqldb.jdbcDriver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/hsqldb.jar

org.apache.derby.jdbc.AutoloadedDriver    file:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/derby.jar

Path:

[Show Path]

/usr/java/packages/lib/amd64

/usr/lib64

/lib64

/lib

/usr/lib

JSP Classpath:

[Show Classpath]

/opt/yellowfin/appserver/lib/

/opt/yellowfin/appserver/lib/annotations-api.jar

/opt/yellowfin/appserver/lib/catalina-ant.jar

/opt/yellowfin/appserver/lib/catalina-ha.jar

/opt/yellowfin/appserver/lib/catalina-ssi.jar

/opt/yellowfin/appserver/lib/catalina-storeconfig.jar

/opt/yellowfin/appserver/lib/catalina-tribes.jar

/opt/yellowfin/appserver/lib/catalina.jar

/opt/yellowfin/appserver/lib/ecj-4.20.jar

/opt/yellowfin/appserver/lib/el-api.jar

/opt/yellowfin/appserver/lib/jasper-el.jar

/opt/yellowfin/appserver/lib/jasper.jar

/opt/yellowfin/appserver/lib/jaspic-api.jar

/opt/yellowfin/appserver/lib/jsp-api.jar

/opt/yellowfin/appserver/lib/servlet-api.jar

/opt/yellowfin/appserver/lib/tomcat-api.jar

/opt/yellowfin/appserver/lib/tomcat-coyote.jar

/opt/yellowfin/appserver/lib/tomcat-dbcp.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-cs.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-de.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-es.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-fr.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-ja.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-ko.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-pt-BR.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-ru.jar

/opt/yellowfin/appserver/lib/tomcat-i18n-zh-CN.jar

/opt/yellowfin/appserver/lib/tomcat-jdbc.jar

/opt/yellowfin/appserver/lib/tomcat-jni.jar

/opt/yellowfin/appserver/lib/tomcat-util-scan.jar

/opt/yellowfin/appserver/lib/tomcat-util.jar

/opt/yellowfin/appserver/lib/tomcat-websocket.jar

/opt/yellowfin/appserver/lib/websocket-api.jar

/opt/yellowfin/appserver/bin/bootstrap.jar

/opt/yellowfin/appserver/bin/tomcat-juli.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/dnsns.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/jaccess.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/localedata.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/nashorn.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/sunec.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/sunjce_provider.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/sunpkcs11.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/zipfs.jar

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.345.b01-1.el8_6.x86_64/jre/lib/ext/cldrdata.jar

Library Versions:

[Show Library Versions]

commons-codec-1.6.jar    1.6

i4-adapter.jar    9.7 (20220602)

i4-content.jar    9.7 (20220602)

i4-core.jar    9.7 (20220602)

i4-ip.jar    9.7 (20220602)

i4-jsps.jar    9.7 (20220602)

i4-mi.jar    9.7 (20220602)

iText-rtf-2.1.0.jar    2.1.0

jdbf-1.2.jar    1.2

shapefilereader-1.0.jar    1.0

yfbirt431.jar    5.0 (20131212)

API Information

REST API Version:    2.0

Thanks Dean, That version is indeed smaller.  I will give it a try.

Hi Steve,

Could you please try and let me know how it goes.

Regards,

Sri Vamsi

Hi Steve,

Hope things are good on your end. Just wanted to check in to make sure you had what you needed here.

Regards,

Sri Vamsi

Hi Steve,

I'm going to go ahead and mark this ticket as Completed due to inactivity at this time. Feel welcome to reach out in the future.

Regards,

Sri Vamsi