<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Google BigQuery Geography type not recognised in Connectivity &amp; Data Prep</title>
    <link>https://community.qlik.com/t5/Connectivity-Data-Prep/Google-BigQuery-Geography-type-not-recognised/m-p/1549051#M7504</link>
    <description>&lt;P&gt;My Qlik Sense account loads data from BigQuery and the set contains a field GEOGRAPHY. This is valid GeoJSON and it works great within BigQuery. But Qlik Sense does not recognise it as GEO data. The documentation states it will automagically transform and index the GEO data. It seems to be handling it as STRING type.&amp;nbsp;&lt;/P&gt;&lt;P&gt;If I convert the string POLYGON object in the GEOGRAPHY field using rename functions so it looks like an array of points then Qlik will show the polygon correctly on the map. But I think it should work with the GEOGRAPHY field provided by Google BigQuery as is. Right?&lt;/P&gt;</description>
    <pubDate>Thu, 23 Dec 2021 13:53:21 GMT</pubDate>
    <dc:creator>tvanulden</dc:creator>
    <dc:date>2021-12-23T13:53:21Z</dc:date>
    <item>
      <title>Google BigQuery Geography type not recognised</title>
      <link>https://community.qlik.com/t5/Connectivity-Data-Prep/Google-BigQuery-Geography-type-not-recognised/m-p/1549051#M7504</link>
      <description>&lt;P&gt;My Qlik Sense account loads data from BigQuery and the set contains a field GEOGRAPHY. This is valid GeoJSON and it works great within BigQuery. But Qlik Sense does not recognise it as GEO data. The documentation states it will automagically transform and index the GEO data. It seems to be handling it as STRING type.&amp;nbsp;&lt;/P&gt;&lt;P&gt;If I convert the string POLYGON object in the GEOGRAPHY field using rename functions so it looks like an array of points then Qlik will show the polygon correctly on the map. But I think it should work with the GEOGRAPHY field provided by Google BigQuery as is. Right?&lt;/P&gt;</description>
      <pubDate>Thu, 23 Dec 2021 13:53:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Connectivity-Data-Prep/Google-BigQuery-Geography-type-not-recognised/m-p/1549051#M7504</guid>
      <dc:creator>tvanulden</dc:creator>
      <dc:date>2021-12-23T13:53:21Z</dc:date>
    </item>
  </channel>
</rss>

