Skip to main content
Question

Warning reading Snowflake Spatial Data

  • November 12, 2024
  • 2 replies
  • 27 views
pmcpherson
Contributor
Forum|alt.badge.img+9

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.

2 replies

steveatsafe
Safer
Forum|alt.badge.img+12

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. 

SteveatSafe
pmcpherson
Contributor
Forum|alt.badge.img+9
  • pmcphersonContributor
  • Author
  • Contributor
  • March 11, 2025

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


Most helpful members this week

Community Stats

30,846
Posts
116,935
Replies
38,669
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.