Looker into Snowflake. Using the Looker Data Platform to query Snowflake

Looker into Snowflake

Setting up Snowflake

Image for post
Image for post

Start Exploring

Image for post
Image for post

Query Snowflake and Looker

select monthname(starttime) as "month", count(*) as "num trips" from trips group by 1 order by 2 desc ;
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Similar results, although the Month Name is calculated differently. This can be explained by the below generated query.SELECT EXTRACT(MONTH FROM trips."STARTTIME" )::integer AS "trips.starttime_month_num", DECODE(EXTRACT('month', trips."STARTTIME" ), 1, 'January', 2, 'February', 3, 'March', 4, 'April', 5, 'May', 6, 'June', 7, 'July', 8, 'August', 9, 'September', 10, 'October', 11, 'November', 12, 'December') AS "trips.starttime_month_name", COUNT(*) AS "trips.count" FROM PUBLIC.TRIPS AS trips GROUP BY 1,2 ORDER BY 3 DESC LIMIT 500

Data & Analytics 📊 Consultant @daanalytics_nl & Partner @pongprof & Board Member @nl_OUG | Modern ☁️ Analytics #Oracle #Snowflake #Looker #Matillion #Fivetran

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store