1

Using firebase for App Data - what is the best way to ETL this into Azure SQL so we can analyze better? Have tried doing firebase->big query->azure data factory->azure sql and it just seems a bit clunky. Have seen I could export to JSON then import to SQL perhaps. Let me know if anyone has any best practices

jarlh
  • 42,561
  • 8
  • 45
  • 63
Zack Widdoss
  • 69
  • 2
  • 8

1 Answers1

1

I have 3 ways for this :-

WAY - 1: Export JSON from firebase

Like you said we can export JSON and import in our azure SQL Go to the node that you want to export -> Click 3 dots ... -> Export JSON.

WAY - 2: Firebase Export Command

You can use the node.js tool to export your JSON structure and import it to your SQL Database.

WAY -3: Improvado (3rd part app)

Extract your data from Firebase and automatically load it to a Microsoft Azure SQL Database.

SwethaKandikonda
  • 7,513
  • 2
  • 4
  • 18