nevermind, its working!

Perfect! What turned out to be the issue?

There wasn't actually issue on meltano side. I opened the SQLite in Metabase and it didnt show any tables. But the issue was file access. The tables were actually there.