Insert picture from google drive

[GenDemo]

Hi All

How can I insert a picture from google drive into a Looker Dashboard. We have done this with other pics that are hosted on our devlopment environment (I think this is AWS?).

In understand that Looker does not have the ability to insert a picture, but I was hoping one would be able to it in a similar way we did with the others.

view: dim_variant_test_pics {
  derived_table: {
                  sql: select 1 as variant_test_pic ;;
  }


  dimension: variant_test_pay_later_selector {
    html: <img src="https://drive.google.com/file/d/1VuXZZDIoQ1TSh-M3aPHQyD9TM-hiFd-B/view?usp=sharing"> ;;
    sql: ${TABLE}.variant_test_pic ;;
  }

  dimension: variant_test_pay_later_selector_w_most_popular_sash {
    html: <img src="https://drive.google.com/file/d/11Hwpux0WDSbYxuxhkHv2puVoq2bTkzda/view?usp=sharing"> ;;
    sql: ${TABLE}.variant_test_pic ;;
  }

}

Any tips or advise?

[Teresa_Kovich]

Hi! Two things:

a) Your image needs to be public, since Looker wouldn’t have a way to authenticate to it

https://community.looker.com/knowledge-drops-1021/how-do-i-render-a-local-image-in-looker-23395

b) … but even if you made your images publicly viewable from Drive, a lot of times a Google drive link isn’t actually linking to the image… Izzy explains it better than I can here:

https://community.looker.com/dashboards-looks-7/tabbed-dashboard-14990?postid=30111#post30111

You might be able to use Google Cloud Storage:

https://community.looker.com/knowledge-drops-1021/rendering-images-and-hosting-custom-visualizations...