![]() ![]() Some MacOSX users have reported that their anti-virus blocks Java from connecting to BigQuery or may otherwise interfere with the connection. Note: It may be the case that no tables will appear after you click Connect. Once you have selected the data set of interest, click the OK button. If the data set of interest is not present, go to your BigQuery Console in Google Cloud Platform and copy the data set into your own project. Choose your dataset of interest and click the check boxes next to “Tables”. Once the connection is made all of the datasets within the project will be displayed. If necessary, create a new Service Account, grant all of the necessary permissions and then try again with the new Service Account Key File. Note: If DbSchema displays an error such as Connectivity Error: EXEC_JOB_EXECUTION_ERR, make sure you have granted the permission to the Google Cloud Platform Service Account. ![]() When the fields are all filled in, click the Connect button. If you are using a Mac operating system, your Service Account Key File is likely to be found in the /Users/username/Documents folder or /Users/username/Downloads folder. If you are using the Windows operating system, your Service Account Key File is likely to be found in the C:\Users\username\Documents folder. If you do not have a Service Account Key File, follow this tutorial and then return to this step. When the GoogleBigQuery Connect dialog box appears, change the JDBC URL to “Simba Driver with Service Account Authentication”.įill in your Google Cloud Platform ProjectId, your Google E-mail and the path to your Service Account Key File (do not use what is shown below – use your own project and Gmail information!). When the opening screen appears (as shown below) click on the blue Start button under the Connect to Database prompt.Ĭhoose the GoogleBigQuery database from list and check the “Database is in the cloud” check box as shown below. To get started, run the DbSchema software on your computer. Running DbSchema and Connecting to a BigQuery dataset ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |