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
  • 40,041
  • 8
  • 39
  • 58
Zack Widdoss
  • 41
  • 4

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-MT
  • 3,427
  • 1
  • 3
  • 14