Google Sheet
Our Enterprise Merchants can add Data to Daasity by using a custom G-Sheet
Was this helpful?
Our Enterprise Merchants can add Data to Daasity by using a custom G-Sheet
Was this helpful?
Was this helpful?
Our Google Sheet integration extracts Data from your Google Sheet and Loads it into your Database. You can either combine it with other Data or expose it directly in Looker.
Follow along with us in this short video to setup your Google Sheet integration
String - this means text or anything you want stored as text
Number - this is a whole number (integer) and cannot have any decimals
Decimal - for any values with a decimal
Currency - if you have value with a currency symbol choose this so we can remove the symbol and store the value as a decimal
Boolean - either Yes/No or True/False
Date - if you want to store the value as a date (if it has a time it gets set to midnight)
Datetime - if you want to store both the time and the date
Percentage - removes the percent and stores as a decimal
Once your Google 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
;