Tray Snowflake Connector: SQL Compilation Error – “ninvalid identifier”

Data

Tray Snowflake Connector: SQL Compilation Error – “ninvalid identifier”

by Gavin Holzworth
//

Tray.io is an easy-to-use low code API Integration tool that’s great at streamlining your workflows and data in the workplace. I recently tried it out!

I wanted to create a basic data flow that pulls Typeform survey data into a Snowflake server for use later in an internal Tableau dashboard.  The flow is “triggered” when a survey is submitted on the Typeform side. I set up my Snowflake database and used the Tray “noodle” in the data mapping tool to match up the appropriate data sets.

Although, upon testing my data flow, I had JSON errors as you can see in the “Logs” section of Tray.

As you can see, the issue explicitly has to do with the Snowflake component of the data flow.

The error is: “SQL compilation error: error line 1 at position 226\ninvalid identifier”

After investigating and communicating with some amazing InterWorkers, we found that the data package sent to Snowflake from Tray isn’t in the syntax format. Frustrating right?! No worries. It’s one simple fix!

First, navigate to your column’s value area in the Snowflake box. You should have the “text” response selected using the noodle to tie it back to the Typeform box. Most of you probably have already done this and are currently getting the error.

Click the “mapping” format box to edit it (where the small red circle is). Edit it to be “string.”

When you click “string” it keep the data embedded from the noodle but it allows you to add text around it. The is where the solution lies. Snowflake needs the data package in a specific format. To achieve this format, simply add one apostrophe to each side of the data embed.

Run your flow and watch the success!

More About the Author

Gavin Holzworth

Data Engineer
Matillion DPC: How to Git Going In this blog, I will guide you through various methods to navigate the Matillion Data Productivity Cloud (DPC) Git functionality. The ...
Custom Join in ThoughtSpot’s SQL Editor To best use ThoughtSpot, we need to have a good understanding of the data structure being used. The best way to work with that data is ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!