Google Sheet Integration in Looker

Once you have added your G-Sheet Integration to Daasity - (see link below) you can access the Data in Looker. Here is how.

Add a Google Sheet Integration

READ THESE INSTRUCTIONS FIRST - TO ADD A G-SHEET INTEGRATION TO DAASITY

 

Working with Google Sheets in Looker

Once your G-Sheet integration is complete, a table will be generated in Snowflake, presuming you used Daasity's database structure to implement Looker. 

There are two ways that data from a google sheet can be used in Looker:

  1. Have the data transformed and combined with other data through Daasity ELT process. Contact Daasity Support if you need this.
  2. Access the table directly through Looker. You may use Looker to run analysis on the table, or join the table to other tables in your Looker instance. 

To access a new table that you've created via a Google sheet, first, you must give Looker access to the new table. To do this, run the below script:

-- GRANT PRIVILEGES TO THE LOOKER USER SO THEY CAN ACESS DATA
GRANT ALL ON SCHEMA
calendar,
drp,
drp_staging,
ga,
shopify,
ugd,
uos,
uos_staging
TO yourbrand_looker
;GRANT ALL ON ALL TABLES IN SCHEMA
calendar,
drp,
drp_staging,
ga,
shopify,
ugd,
uos,
uos_staging
TO yourbrand_looker
;

Access the table

HOW TO ACCESS A TABLE - USE AN EXAMPLE.

Join the table to others

HOW TO JOIN A TABLE - USE AN EXAMPLE.