Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r096

D toc

D s ed
editionsawsent,awspro,awspr

Excerpt

D s conntype
typegsheetsuser
 provides a spreadsheet interface for cloud-based data stored in Google Drive. It allows multiple users to edit and format files in real-time . For more information, see https://www.google.com/sheets/about/. 

You can create connections to your 

D s conntype
typegsheetsuser
 instance from 
D s product
rtrue

  • You can create multiple 
    D s conntype
    typegsheetsuser
     connections.
  • During connection creation, you must provide access to Google Drive.

Limitations

  • This is a read-only connection. 
  • Single Sign-On (SSO) is not supported.
  • Custom domains are not supported.
  • Since data must be converted to a native file format, this connection does not support previewing of your data in the source.

  • If you have enabled Google Advanced Protection, this connection type does not work.

Configure

To create this connection, select the 

D s conntype
typegsheetsuser
  card. For more information, see Connections Page.

Modify the following properties as needed:

PropertyDescription
OAuth 2.0 Client

The OAuth 2.0 Client is displayed.

Info

NOTE: When you create the connection in this window, you must click Authenticate, which authenticates to the app. This step is required.

Connection NameDisplay name of the connection.
Connection DescriptionDescription of the connection, which appears in the application.

Test and Use

Steps:

  1. You can import datasets from 
    D s conntype
    typegsheetsuser
     through the Import Data page. For more information, see Import Data Page
  2. Perform a few simple transformations to the data. Run the job. For more information, see Transformer Page.
  3. Verify the results.

D s also
inCQLtrue
label((label = "google_sheets") OR (label = "worksheet"))