> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Looker Studio

> This page outlines the steps to install and configure the Connect AI connector for Looker Studio. After installation, Looker Studio will be able to pull data from sources that you have connected to your Connect AI account.

## Prerequisites

Connect AI でLooker Studio を設定して使用する前に、データソースをConnect AI アカウントに接続する必要があります。詳細は、[Sources](/ja/Sources) を参照してください。

<Steps>
  <Step>
    Sign in to [Looker Studio](https://datastudio.google.com/) using your Google account.
  </Step>

  <Step>
    [Click here](https://datastudio.google.com/data?search=CData%20Connect%20Cloud) to search for the Connect AI connector.\
    Alternatively, from the Looker Studio dashboard, click **+ Create**, then click **Data Source** and search for *Connect AI*.
  </Step>

  <Step>
    Click **Connect AI** to install the connector.
  </Step>

  <Step>
    When prompted, click **Authorize** to allow Looker Studio to use the connector.
  </Step>

  <Step>
    Another **Authorize** button appears to connect to Connect AI. Click this to open a login window.
  </Step>

  <Step>
    Enter your Connect AI login credentials and click **Continue**.
  </Step>

  <Step>
    Close the authorization window when prompted.
  </Step>

  <Step>
    Open the *Connection* drop-down menu, select a connection, and click **Next**.

    <Frame>
      <img src="https://mintcdn.com/cdata/tJfdD354GT5ojxph/ja/images/google_ds_connectionselect.png?fit=max&auto=format&n=tJfdD354GT5ojxph&q=85&s=5b31b5e03cc95b2b33c5a149d55ecdbb" alt="Google DS Connection Select" width="377" height="367" data-path="ja/images/google_ds_connectionselect.png" />
    </Frame>
  </Step>

  <Step>
    Use the Table drop-down menu to select the table you want to import.
  </Step>

  <Step>
    (Optional) By default, all data in the table will be imported. If you want to use a custom query for the data instead of retrieving all data, check the **Use custom query** box and enter the parameters in the Custom Query box.

    <Frame>
      <img src="https://mintcdn.com/cdata/tJfdD354GT5ojxph/ja/images/google_table.png?fit=max&auto=format&n=tJfdD354GT5ojxph&q=85&s=a870a96f35b45cbfa301c5f2ebbbb8f7" alt="Google Table" width="416" height="539" data-path="ja/images/google_table.png" />
    </Frame>
  </Step>

  <Step>
    (Optional) If you want to use the current user's email within a custom query, use the parameter token `@DS_USER_EMAIL` in the query, as follows:

    ```bash theme={null}
    Select * from Sales WHERE sales-rep-email = @DS_USER_EMAIL;
    ```

    Connect AI replaces the parameter with the current user's email address.
  </Step>

  <Step>
    Click **Connect** in the top-right corner of the page. Looker Studio opens an overview of the imported data.

    <Frame>
      <img src="https://mintcdn.com/cdata/tJfdD354GT5ojxph/ja/images/google_ds_imported.png?fit=max&auto=format&n=tJfdD354GT5ojxph&q=85&s=fc6331ad5486d72d02f17d13bec9d2eb" alt="Google DS Imported" width="1497" height="976" data-path="ja/images/google_ds_imported.png" />
    </Frame>
  </Step>
</Steps>

You can now sort, filter, and explore your data and generate reports. For more information about using Looker Studio, please see [Google’s help topics](https://support.google.com/looker-studio/).