when the destination is Snowflake there is no error log

  • 34Views
  • Last Post 4 weeks ago
0
votes
Gabriel Longarai posted this 25 May 2022

Hi,

What is the error breakdown (Run Id 93160897)?

And why when the destination is Snowflake there is no error log?

https://app.skyvia.com/#/76069/packages/165123/debug

Run Id 93160897

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 5 weeks ago

Hello Gabriel,

 

Sorry for the delay with this case.

This is related to Snowflake's peculiarities and the way how the data is imported to it. Please refer to the Advanced Settings section, Use Bulk Import: https://docs.skyvia.com/connectors/databases/snowflake_connections.html

 

We have checked our internal logs:

SnowflakeReplicationTask | quote | String 'ANALISE PREVIA Juliano Zerbinato, favorável com ressalvas Garantia casa 2 *Pelo imóvel ser foreiro 0xC3' is too long and would be truncated File 'f30601fc-bd83-40b6-8f61-74b377eea14d_c69ddb45-001e-473e-bd22-6fb8f1589318.csv', line 1503, character 4 Row 34 starts at line 1456, column ""quote_03a75dec_841f_45e9_a231_5d23817b9caf""["csh_resumojuridico"44]

 

As we can see the last package runs are successful.

 

If you encounter any further issues, please let us know. 

 

Best regards,

Mariia

 

0
votes
Gabriel Longarai posted this 4 weeks ago

This field is at maximum text size in Snowflake

It's some error in Skyvia as without making any adjustments the next load worked.

Please check.

0
votes
Mariia Zaharova posted this 4 weeks ago

Hello Gabriel,

Thank you for your reply.

 

We will check possible reasons for this issue.

 

Bets regards,

Mariia

Close