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:
- Have the data transformed and combined with other data through Daasity ELT process. Contact Daasity Support if you need this.
- 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.