Skip to main content
Solved

Time-based sync for Snowflake has no jobs started

  • February 7, 2023
  • 8 replies
  • 341 views
I
Novice
Forum|alt.badge.img
  • Ian
  • Novice
  • 3 replies

I am currently ingesting data from Snowflake, using a valid SQL query.​​​​​

The sync job does not even start for the time-based sync. How long would I have to wait before the data is synced?

Best answer by belinda.chiu

Hi @Ian and @karthika88 ! Jeremie has escalated this issue to the Technical Support team. I have come to notice that both of you have email address with the same domain name. Are you both part of the same company? 

If so, can you clarify if the Snowflake integration is working now? I checked your org and I see that there are a lot of Snowflake destinations that are connected and are ingesting data. If you are working on different Snowflake ingestions but one of them is working while the other is not, is there a way for you to compare between the two set-ups to see if there are any differences? 

@karthika88 Regarding the question about lag, can you provide more context? Is it that you created an import but the first ingestion job did not start running until some time after? Or did it start running but perhaps not complete until sometime later? Are you still seeing the data timestamped from when you first created the import or are you seeing data timestamped after the time value you have set?

https://www.docs.developers.amplitude.com/data/sources/snowflake/?h=time+based#time-based-import

View original
Amplitude Admin
Jeremie Gluckman
2 people like this
  • Amplitude Admin
    Amplitude Admin
  • Jeremie Gluckman
    Jeremie Gluckman
Did this topic help you find an answer to your question?

8 replies

K
Helpful Hero
Forum|alt.badge.img
  • karthika88
  • Helpful Hero
  • 7 replies
  • February 9, 2023

I am running into the same issue.

Jeremie Gluckman
1 person likes this
  • Jeremie Gluckman
    Jeremie Gluckman
I
Novice
Forum|alt.badge.img
  • Ian
  • Author
  • Novice
  • 3 replies
  • February 10, 2023

Hi @Jeremie Gluckman, is there any support on this? I have not resolved the issue. Thank you.

Jeremie Gluckman
1 person likes this
  • Jeremie Gluckman
    Jeremie Gluckman
Jeremie Gluckman
Team Member
Forum|alt.badge.img+9

Thanks for following up @karthika88 and @Ian. This totally slipped thought the cracks. I’m escalating it to the team now. 

I
1 person likes this
K
Helpful Hero
Forum|alt.badge.img
  • karthika88
  • Helpful Hero
  • 7 replies
  • February 10, 2023

Thank you! It worked on our end, but there was a lag - that is the jobs did not start immediately according to the value that I had set.

Can you look into why there was a lag ? We did not get any details from the progress dashboard

Jeremie Gluckman
1 person likes this
  • Jeremie Gluckman
    Jeremie Gluckman
I
Novice
Forum|alt.badge.img
  • Ian
  • Author
  • Novice
  • 3 replies
  • February 10, 2023
Jeremie Gluckman wrote:

Thanks for following up @karthika88 and @Ian. This totally slipped thought the cracks. I’m escalating it to the team now. 

Great, thanks

Jeremie Gluckman
1 person likes this
  • Jeremie Gluckman
    Jeremie Gluckman
belinda.chiu
Team Member
Forum|alt.badge.img+8
  • belinda.chiu
  • Amplitude Support
  • 189 replies
  • Answer
  • February 16, 2023

Hi @Ian and @karthika88 ! Jeremie has escalated this issue to the Technical Support team. I have come to notice that both of you have email address with the same domain name. Are you both part of the same company? 

If so, can you clarify if the Snowflake integration is working now? I checked your org and I see that there are a lot of Snowflake destinations that are connected and are ingesting data. If you are working on different Snowflake ingestions but one of them is working while the other is not, is there a way for you to compare between the two set-ups to see if there are any differences? 

@karthika88 Regarding the question about lag, can you provide more context? Is it that you created an import but the first ingestion job did not start running until some time after? Or did it start running but perhaps not complete until sometime later? Are you still seeing the data timestamped from when you first created the import or are you seeing data timestamped after the time value you have set?

https://www.docs.developers.amplitude.com/data/sources/snowflake/?h=time+based#time-based-import

Jeremie Gluckman
1 person likes this
  • Jeremie Gluckman
    Jeremie Gluckman
K
Helpful Hero
Forum|alt.badge.img
  • karthika88
  • Helpful Hero
  • 7 replies
  • February 19, 2023

Is it possible to delete jobs which have been in “processing” state for a while ?

belinda.chiu
Team Member
Forum|alt.badge.img+8
  • belinda.chiu
  • Amplitude Support
  • 189 replies
  • February 24, 2023

Hi @karthika88! In the UI, there is no way to delete jobs. Can you share with me your use case for why you would want to delete these jobs? 

Reply


Helpful Members this Week

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