Skip to main content
  • EN

When using a FeatureReader transformer to read Snowflake spatial data, the following warning is posted into the log.

Snowflake Spatial Reader: Skipping data in column '.GEOG' due to error (JDBC Type = VARCHAR, Vendor Type Name = GEOGRAPHY, Error: class java.lang.String cannot be cast to class [B (java.lang.String and [B are in module java.base of loader 'bootstrap'))

The process does complete normally, but the geometry is not read automatically. Has anyone else encountered a problem like this? I’m using FME Form 2024.0.1.0, Build 24202.

Hi ​@pmcpherson, Sorry that no one has replied to your question.  Did you find a resolution? 
To understand more about what is happening what does the table definition look like (describe <table> in Snowflake Snowsite (or Classic Console))?  


What’s odd here is that the column name has that period in the name? Or at least that is what FME is returning. And this, for some reason is being seen as a VARCHAR vs GEOGRAPHY. 

Let us know if there is more we can help you with on this.  Or maybe create a ticket at www.safe.com/support if you are still fighting with this. 

Hi ​@steveatsafe. Since the data is points, I was able to work around the issue by reading the lat/lon values and creating geometry separately. As to the table definition, please see the following screenshot.

Thanks.

Reply


Community Stats

31,813
Posts
120,830
Replies
39,443
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.