How to connect Looker with google sheets and how to execute external dataset csv file to Looker?

[C_Kiran_Kumar]

Help me with below questions:

1. How to connect looker with google spread sheets?

2. How to connect external dataset which is in csv file to looker?

[ruthc]

If you want to use a Google Sheet as a data source, you cannot connect Looker Original directly to the sheet (Looker can only connect to SQL databases). Therefore you need to create a table in your SQL database that references the Google Sheet as the data source for the table. The steps to achieve this are as follows:

1. In the Google Sheet, give your Looker service account 'View' access to the sheet (otherwise users will see a permission error when they query the data in Looker).

2. If you are using BigQuery, for example, create a table from 'Drive', copy and paste the sharing link from the Google Sheet as the the 'Drive URI', and select 'Google Sheet' as the 'File format'.

3. Create a new view in Looker based on the table you have created, and then create a new Explore / join to an existing Explore in order to expose the data.