Go to SQL Server Management Studio and configure it in a similar way: To read the data in SQL Server the first thing you have to do is create a Linked Server. Read data in SQL Server from the ZappySys Data Gateway data source Select the Preview tab and use settings similar to the following to preview data:Ĭlick OK to finish creating the data source. Once the data source has been configured, you can preview data. Juse share with Service Account (use Service Account Email found on previous section) Here is how to share file(s) with specific people. Click on the Share button in the top right, and add the email address of the service account as an editor.Navigate to Google Docs File for which you like to give read/write access to Service Account. Copy the email address of your service account we created in previous step (its usually like this Create or select an existing Google Docs File.Basically you can create or open Google Sheet and add the Service Account as an editor to it as below. Now last thing is give read/write permission to Service Account. Now you may use downloaded *.p12 key file as secret file and Service Account Email as Client ID (e.g.We will use this file in our API connection. A P12 key file is downloaded to your computer. Click Add key, then click Create new key.In the Cloud Console, click the email address for the service account that you created.Once service account is created we need to create key file (i.e. For Role, do not select anything for now and Click Continue and then click Done.Enter Service account name and Service account description.Service account has its ID which looks like some email ID (not to confuse with Google /Gmail email ID) Once Project is created and APIs are enabled we can now create a service account under that project. Now we need to Enable two APIs one by one (Drive API).Skip this section if you already have Project (Go to next section) Learn more about service account hereīasically to call Google API as Service account we need to perform following steps listed in 3 sections (Detailed steps found in the help link at the end)įirst thing is create a Project so we can call Google API. Use these steps to authenticate as service account rather than Google / GSuite User. You can use this information now to configure Connection with UseCustomApp=true.įill in all required parameters and set optional parameters if needed: When prompted Select Application Type as Desktop App and click Create to receive your ClientID and Secret.Click CREATE CREDENTIALS (some where in topbar) and select OAuth Client ID option.Go to back to main screen of Google API Console.Now we need to enable Google Drive API.Once project is created you can click Select Project to switch the context (You can click on Notification link or Choose from Top Dropdown).From the Project Dropdown (usually found at the top bar) click Select Project.To register an App, perform the following steps (Detailed steps found in the help link at the end): Google provider 2.To make this work you will have to create an OAuth application. In other words, creating a view that reads a table with external configuration is returning an OAuth error. This works for tables but it is not possible to create a view that reads such table. To create a BigQuery table with external configuration, the "drive.readonly" scope needs to be added as per the documentation (see ) If an issue is assigned to hashibot, a community member has claimed the issue already. If an issue is assigned to a user, that user is claiming responsibility for the issue. If an issue is assigned to the modular-magician user, it is either in the process of being autogenerated, or is planned to be autogenerated soon.If you are interested in working on this issue or have submitted a pull request, please leave a comment.Please do not leave +1 or me too comments, they generate extra noise for issue followers and do not help prioritize the request.Please vote on this issue by adding a □ reaction to the original issue to help the community and maintainers prioritize this request.
0 Comments
Leave a Reply. |